File: 8d21738b589503a2e8c9892f1(...).png (1.47 MB, 2048x2048)

1.47 MB PNG

magnet:?xt=urn:btmh:1220b45acddd6ac1a3685184174e80f3496cb6c8bb2e314beaea1d78d4fc24ee5d05

date: 2025-10-26
by: Avery

May contain deleted posts.
Negative IDs on the tags table mean the tag was listed in the post response, but its details aren't available through the gelbooru tags api.

Count of posts by Rating:
rating_name |post_count|
------------+----------+
Sensitive | 5595742|
General | 2682397|
Explicit | 2377926|
Questionable| 1571064|
Safe | 29|

Count of tags by type:
tag_type |total_tags|total_tag_usage|
----------+----------+---------------+
Artist | 506011| 11207081|
General | 323206| 351580251|
Character | 226270| 18247000|
Copyright | 49205| 18156724|
Deprecated| 2990| 33548549|
Metadata | 501| 20854199|

Explicit/Questionable to General ratio:
explicit_like_posts|general_posts|explicit_like_to_general_ratio|
-------------------+-------------+------------------------------+
3948990| 2682397| 1.47|

Schema:
CREATE TABLE posts (
id BIGSERIAL PRIMARY KEY,
...
);

CREATE TABLE tags (
id BIGSERIAL PRIMARY KEY,
name VARCHAR(255) NOT NULL,
count BIGINT NOT NULL DEFAULT 0,
type BIGINT NOT NULL DEFAULT 0,
ambiguous BIGINT NOT NULL DEFAULT 0,
CONSTRAINT unique_tag_name UNIQUE (name)
);

CREATE TABLE post_tags (
post_id BIGINT NOT NULL,
tag_id BIGINT NOT NULL,
);

Tag types:
General = 0
Artist = 1
Unknown = 2
Copyright = 3
Character = 4
Metadata = 5
Deprecated = 6

Tag rating:
Explicit = 0
General = 1
Questionable = 2
Safe = 3
Sensitive = 4