Pikastat is broken :(
If you want to deploy your own instance or to play with the database, here are the sources:
https://github.com/DevAlone/parse_pikabu
https://github.com/DevAlone/pikagraphs_frontend
And here is the latest backup:
https://k.d3d.info/pikastat.2020.09.10.dump
https://k.d3d.info/pikastat.2020.09.10.dump.torrent
> md5sum pikastat.2020.09.10.dump 147bc96ecacc4e205e9676e40c10d0c5
The dump is compressed and after loading it's gonna take 295 Gb, but it's a size with indices including a gin index for the comments. If your hardware is weak and you don't want to wait forever or don't have that much space, you can restore the dump without indices(just google it).
Don't hesitate to write here if you have any questions:
admin@d3d.info
Some info about the tables
WITH RECURSIVE pg_inherit(inhrelid, inhparent) AS
(select inhrelid, inhparent
FROM pg_inherits
UNION
SELECT child.inhrelid, parent.inhparent
FROM pg_inherit child, pg_inherits parent
WHERE child.inhparent = parent.inhrelid),
pg_inherit_short AS (SELECT * FROM pg_inherit WHERE inhparent NOT IN (SELECT inhrelid FROM pg_inherit))
SELECT table_schema
, TABLE_NAME
, row_estimate
, pg_size_pretty(total_bytes) AS total
, pg_size_pretty(index_bytes) AS INDEX
, pg_size_pretty(toast_bytes) AS toast
, pg_size_pretty(table_bytes) AS TABLE
FROM (
SELECT *, total_bytes-index_bytes-COALESCE(toast_bytes,0) AS table_bytes
FROM (
SELECT c.oid
, nspname AS table_schema
, relname AS TABLE_NAME
, SUM(c.reltuples) OVER (partition BY parent) AS row_estimate
, SUM(pg_total_relation_size(c.oid)) OVER (partition BY parent) AS total_bytes
, SUM(pg_indexes_size(c.oid)) OVER (partition BY parent) AS index_bytes
, SUM(pg_total_relation_size(reltoastrelid)) OVER (partition BY parent) AS toast_bytes
, parent
FROM (
SELECT pg_class.oid
, reltuples
, relname
, relnamespace
, pg_class.reltoastrelid
, COALESCE(inhparent, pg_class.oid) parent
FROM pg_class
LEFT JOIN pg_inherit_short ON inhrelid = oid
WHERE relkind IN ('r', 'p')
) c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
) a
WHERE oid = parent
) a
ORDER BY total_bytes DESC;
table_schema | table_name | row_estimate | total | index | toast | table
--------------------+-----------------------------------------------------------------+---------------+------------+------------+------------+----------
public | pikabu_comments | 1.5308042e+08 | 241 GB | 152 GB | 889 MB | 87 GB
public | pikabu_stories | 6.904493e+06 | 27 GB | 17 GB | 3449 MB | 6557 MB
public | pikabu_users | 2.997974e+06 | 6622 MB | 5896 MB | 8192 bytes | 726 MB
public | pikabu_user_number_of_pluses_versions | 3.8672996e+07 | 3601 MB | 1646 MB | | 1955 MB
public | pikabu_comment_text_versions | 4.036758e+06 | 1919 MB | 160 MB | 60 MB | 1699 MB
public | pikabu_comment_author_avatar_url_versions | 1.1968727e+07 | 1657 MB | 520 MB | 8192 bytes | 1137 MB
public | pikabu_user_rating_versions | 1.7711888e+07 | 1601 MB | 686 MB | | 915 MB
public | pikabu_story_content_blocks_versions | 1.227507e+06 | 1211 MB | 53 MB | 526 MB | 632 MB
public | pikabu_story_author_profile_url_versions | 9.602446e+06 | 1167 MB | 407 MB | 8192 bytes | 760 MB
public | pikabu_user_number_of_minuses_versions | 1.2137698e+07 | 1143 MB | 506 MB | | 638 MB
public | pikabu_comment_rating_versions | 1.2492637e+07 | 1131 MB | 483 MB | | 649 MB
public | pikabu_user_number_of_comments_versions | 1.1764314e+07 | 1105 MB | 487 MB | | 619 MB
public | pikabu_comment_number_of_pluses_versions | 1.2033925e+07 | 1076 MB | 457 MB | | 620 MB
public | parse_user_tasks | 2.746855e+06 | 572 MB | 400 MB | 8192 bytes | 172 MB
public | pikabu_comment_number_of_minuses_versions | 6.271236e+06 | 567 MB | 240 MB | | 326 MB
public | pikabu_deleted_or_never_existed_stories | 554087 | 453 MB | 410 MB | | 43 MB
public | pikabu_story_tags_versions | 2.158258e+06 | 392 MB | 93 MB | 8192 bytes | 298 MB
public | pikabu_user_community_ids_versions | 2.124785e+06 | 344 MB | 97 MB | 8192 bytes | 247 MB
public | pikabu_story_rating_versions | 3.427871e+06 | 320 MB | 139 MB | | 181 MB
public | pikabu_story_number_of_pluses_versions | 2.74867e+06 | 268 MB | 112 MB | | 156 MB
public | pikabu_comment_is_rating_hidden_versions | 2.802184e+06 | 257 MB | 103 MB | | 154 MB
public | pikabu_comment_author_username_versions | 2.278492e+06 | 229 MB | 98 MB | 8192 bytes | 130 MB
public | pikabu_story_number_of_minuses_versions | 2.334654e+06 | 224 MB | 89 MB | | 135 MB
public | pikabu_user_awards | 844963 | 209 MB | 20 MB | 8192 bytes | 189 MB
public | pikabu_user_number_of_subscribers_versions | 1.703626e+06 | 164 MB | 65 MB | | 99 MB
public | pikabu_user_number_of_stories_versions | 1.580345e+06 | 160 MB | 64 MB | | 96 MB
public | pikabu_comment_is_author_profile_deleted_versions | 1.577951e+06 | 148 MB | 66 MB | | 82 MB
public | pikabu_story_number_of_comments_versions | 1.398286e+06 | 143 MB | 53 MB | | 90 MB
public | pikabu_community_number_of_subscribers_versions | 1.501292e+06 | 125 MB | 48 MB | | 77 MB
public | pikabu_user_award_ids_versions | 1.217524e+06 | 124 MB | 44 MB | 8192 bytes | 80 MB
public | pikabu_story_community_id_versions | 977619 | 113 MB | 46 MB | | 68 MB
public | pikabu_user_number_of_hot_stories_versions | 1.218462e+06 | 109 MB | 40 MB | | 69 MB
public | pikabu_story_is_rating_hidden_versions | 1.02082e+06 | 98 MB | 37 MB | | 61 MB
public | pikabu_story_author_avatar_url_versions | 640994 | 94 MB | 30 MB | 8192 bytes | 65 MB
public | pikabu_community_number_of_stories_versions | 930798 | 77 MB | 29 MB | | 47 MB
public | pikabu_deleted_or_never_existed_users | 225571 | 58 MB | 43 MB | | 15 MB
public | number_of_users_to_process_entries | 668017 | 46 MB | 14 MB | | 31 MB
public | number_of_items_in_channel_parse_deleted_or_never_existed_story | 595889 | 42 MB | 13 MB | | 29 MB
public | number_of_items_in_channel_update_user_tasks | 595939 | 42 MB | 13 MB | | 29 MB
public | number_of_items_in_channel_parse_new_story_tasks | 595867 | 42 MB | 13 MB | | 28 MB
public | number_of_items_in_channel_update_story_tasks | 595911 | 42 MB | 13 MB | | 28 MB
public | number_of_items_in_channel_parse_all_communities_tasks | 595948 | 41 MB | 13 MB | | 28 MB
public | number_of_items_in_channel_parser_results | 595903 | 41 MB | 13 MB | | 28 MB
public | number_of_items_in_channel_parse_deleted_or_never_existed_user_ | 595875 | 41 MB | 13 MB | | 28 MB
public | number_of_items_in_channel_parse_new_user_tasks | 595957 | 41 MB | 13 MB | | 28 MB
public | pikabu_comment_story_url_versions | 233840 | 35 MB | 8200 kB | 8192 bytes | 27 MB
public | pikabu_user_avatar_url_versions | 215787 | 32 MB | 11 MB | 8192 bytes | 22 MB
public | pikabu_user_is_banned_versions | 372666 | 31 MB | 12 MB | | 19 MB
public | pikabu_user_is_permanently_banned_versions | 309873 | 25 MB | 9808 kB | | 16 MB
public | pikabu_comment_images_versions | 76781 | 23 MB | 3552 kB | 8192 bytes | 19 MB
public | pikabu_user_ban_end_timestamp_versions | 215455 | 18 MB | 6928 kB | | 11 MB
public | pikabu_story_author_username_versions | 97224 | 15 MB | 4920 kB | 8192 bytes | 10184 kB
public | pikabu_user_gender_versions | 103731 | 12 MB | 5512 kB | 8192 bytes | 7272 kB
public | pikabu_user_communities | 787 | 9472 kB | 1776 kB | 8192 bytes | 7688 kB
public | pikabu_story_community_name_versions | 71397 | 8960 kB | 2848 kB | 8192 bytes | 6104 kB
public | pikabu_comment_story_title_versions | 46122 | 8328 kB | 1672 kB | 8192 bytes | 6648 kB
public | pikabu_story_community_link_versions | 61801 | 6672 kB | 2472 kB | 8192 bytes | 4192 kB
public | number_of_stories_to_process_entries | 79768 | 5896 kB | 1944 kB | | 3952 kB
public | pikabu_story_story_url_versions | 29819 | 4640 kB | 1048 kB | 8192 bytes | 3584 kB
public | pikabu_story_title_versions | 19946 | 3224 kB | 712 kB | 8192 bytes | 2504 kB
public | pikabu_communities | 725 | 3000 kB | 64 kB | 224 kB | 2712 kB
pg_catalog | pg_statistic | 816 | 2256 kB | 72 kB | 688 kB | 1496 kB
pg_catalog | pg_attribute | 7298 | 1600 kB | 448 kB | | 1152 kB
public | pikabu_user_username_versions | 12275 | 1552 kB | 696 kB | 8192 bytes | 848 kB
pg_catalog | pg_depend | 9509 | 1528 kB | 824 kB | | 704 kB
public | pikabu_story_is_deleted_versions | 14568 | 1328 kB | 536 kB | | 792 kB
pg_catalog | pg_proc | 2960 | 1000 kB | 328 kB | 8192 bytes | 664 kB
public | pikabu_community_rules_versions | 846 | 976 kB | 56 kB | 112 kB | 808 kB
public | pikabu_comment_ignored_by_versions | 10515 | 976 kB | 344 kB | 8192 bytes | 624 kB
public | pikabu_comment_is_ignored_by_someone_versions | 10258 | 920 kB | 344 kB | | 576 kB
public | pikabu_story_is_longpost_versions | 7642 | 904 kB | 360 kB | | 544 kB
public | pikabu_community_description_versions | 646 | 816 kB | 48 kB | 240 kB | 528 kB
public | pikabu_story_has_mine_tag_versions | 8443 | 792 kB | 312 kB | | 480 kB
pg_catalog | pg_rewrite | 127 | 664 kB | 32 kB | 504 kB | 128 kB
public | pikabu_comment_created_at_timestamp_distribution_86400 | 3985 | 664 kB | 280 kB | | 384 kB
public | pikabu_story_created_at_timestamp_distribution_86400 | 3982 | 656 kB | 272 kB | | 384 kB
public | pikabu_user_signup_timestamp_distribution_86400 | 3957 | 648 kB | 272 kB | | 376 kB
public | pikabu_comment_is_deleted_versions | 6075 | 632 kB | 264 kB | | 368 kB
pg_catalog | pg_class | 1051 | 568 kB | 248 kB | | 320 kB
pg_catalog | pg_description | 4499 | 552 kB | 184 kB | 8192 bytes | 360 kB
public | pikabu_community_avatar_url_versions | 2472 | 456 kB | 112 kB | 8192 bytes | 336 kB
pg_catalog | pg_type | 979 | 368 kB | 144 kB | 8192 bytes | 216 kB
pg_catalog | pg_index | 438 | 368 kB | 64 kB | | 304 kB
pg_catalog | pg_collation | 736 | 304 kB | 80 kB | 8192 bytes | 216 kB
public | pikabu_user_award_award_image_url_versions | 1634 | 296 kB | 72 kB | 8192 bytes | 216 kB
public | pikabu_users_signup_timestamp_distribution_86400 | 3265 | 296 kB | 120 kB | | 176 kB
public | pikabu_community_tags_versions | 957 | 264 kB | 56 kB | 8192 bytes | 200 kB
public | pikabu_comment_is_author_pikabu_team_versions | 2209 | 264 kB | 104 kB | | 160 kB
pg_catalog | pg_constraint | 141 | 232 kB | 120 kB | 8192 bytes | 104 kB
pg_catalog | pg_operator | 780 | 224 kB | 80 kB | | 144 kB
public | pikabu_user_award_link_versions | 1172 | 216 kB | 64 kB | 8192 bytes | 144 kB
pg_catalog | pg_amop | 732 | 192 kB | 112 kB | | 80 kB
public | pikabu_community_moderator_ids_versions | 775 | 168 kB | 48 kB | 8192 bytes | 112 kB
pg_catalog | pg_attrdef | 254 | 160 kB | 32 kB | 8192 bytes | 120 kB
public | pikabu_user_award_award_title_versions | 641 | 144 kB | 48 kB | 8192 bytes | 88 kB
public | simple_tasks | 1 | 144 kB | 96 kB | 8192 bytes | 40 kB
public | pikabu_user_award_story_id_versions | 647 | 128 kB | 48 kB | | 80 kB
pg_catalog | pg_amproc | 460 | 120 kB | 64 kB | | 56 kB
public | pikabu_community_background_image_url_versions | 365 | 112 kB | 32 kB | 8192 bytes | 72 kB
pg_catalog | pg_shdepend | 388 | 112 kB | 56 kB | | 56 kB
information_schema | sql_features | 716 | 104 kB | 0 bytes | 8192 bytes | 96 kB
pg_catalog | pg_conversion | 132 | 104 kB | 48 kB | | 56 kB
pg_catalog | pg_ts_config_map | 418 | 88 kB | 32 kB | | 56 kB
public | pikabu_user_approved_text_versions | 265 | 80 kB | 16 kB | 8192 bytes | 56 kB
pg_catalog | pg_tablespace | 2 | 80 kB | 32 kB | 8192 bytes | 40 kB
pg_catalog | pg_authid | 10 | 80 kB | 32 kB | 8192 bytes | 40 kB
pg_catalog | pg_database | 4 | 80 kB | 32 kB | 8192 bytes | 40 kB
pg_catalog | pg_cast | 216 | 80 kB | 32 kB | | 48 kB
pg_catalog | pg_language | 4 | 80 kB | 32 kB | 8192 bytes | 40 kB
pg_catalog | pg_namespace | 6 | 80 kB | 32 kB | 8192 bytes | 40 kB
pg_catalog | pg_opclass | 130 | 80 kB | 32 kB | | 48 kB
pg_catalog | pg_opfamily | 109 | 80 kB | 32 kB | | 48 kB
pg_catalog | pg_extension | 3 | 80 kB | 32 kB | 8192 bytes | 40 kB
pg_catalog | pg_ts_dict | 22 | 80 kB | 32 kB | 8192 bytes | 40 kB
pg_catalog | pg_ts_config | 22 | 72 kB | 32 kB | | 40 kB
pg_catalog | pg_ts_parser | 1 | 72 kB | 32 kB | | 40 kB
pg_catalog | pg_auth_members | 3 | 72 kB | 32 kB | | 40 kB
public | pikabu_community_restrictions_versions | 108 | 72 kB | 16 kB | 8192 bytes | 48 kB
pg_catalog | pg_sequence | 240 | 72 kB | 16 kB | | 56 kB
pg_catalog | pg_aggregate | 136 | 72 kB | 16 kB | 8192 bytes | 48 kB
pg_catalog | pg_am | 7 | 72 kB | 32 kB | | 40 kB
public | pikabu_user_next_update_timestamp_distribution_86400 | 105 | 72 kB | 16 kB | | 56 kB
pg_catalog | pg_init_privs | 173 | 72 kB | 16 kB | 8192 bytes | 48 kB
pg_catalog | pg_ts_template | 5 | 72 kB | 32 kB | | 40 kB
public | pikabu_user_last_update_timestamp_distribution_86400 | 91 | 64 kB | 16 kB | | 48 kB
public | pikabu_community_admin_id_versions | 201 | 64 kB | 16 kB | | 48 kB
pg_catalog | pg_shdescription | 3 | 64 kB | 16 kB | 8192 bytes | 40 kB
public | pikabu_community_url_versions | 9 | 64 kB | 16 kB | 8192 bytes | 40 kB
pg_catalog | pg_pltemplate | 8 | 64 kB | 16 kB | 8192 bytes | 40 kB
public | pikabu_community_link_name_versions | 9 | 64 kB | 16 kB | 8192 bytes | 40 kB
public | pikabu_community_name_versions | 51 | 64 kB | 16 kB | 8192 bytes | 40 kB
public | number_of_tasks_in_channel_parse_deleted_or_never_existed_story | 73 | 56 kB | 16 kB | | 40 kB
public | number_of_tasks_in_channel_parse_all_communities_tasks | 73 | 56 kB | 16 kB | | 40 kB
public | number_of_comments_to_process_entries | 171 | 56 kB | 16 kB | | 40 kB
public | pikabu_user_updating_period_distribution_3600 | 17 | 56 kB | 16 kB | | 40 kB
public | number_of_tasks_in_channel_update_user_tasks | 73 | 56 kB | 16 kB | | 40 kB
public | number_of_tasks_in_channel_update_story_tasks | 73 | 56 kB | 16 kB | | 40 kB
public | number_of_tasks_in_channel_parse_new_user_tasks | 73 | 56 kB | 16 kB | | 40 kB
public | number_of_tasks_in_channel_parse_new_story_tasks | 73 | 56 kB | 16 kB | | 40 kB
public | number_of_tasks_in_channel_parse_deleted_or_never_existed_user_ | 73 | 56 kB | 16 kB | | 40 kB
public | pikabu_user_is_rating_hidden_versions | 111 | 56 kB | 16 kB | | 40 kB
public | pikabu_comment_is_author_official_versions | 5 | 56 kB | 16 kB | | 40 kB
public | pikabu_user_award_award_id_versions | 6 | 56 kB | 16 kB | | 40 kB
pg_catalog | pg_range | 6 | 56 kB | 16 kB | | 40 kB
information_schema | sql_implementation_info | 12 | 48 kB | 0 bytes | 8192 bytes | 40 kB
information_schema | sql_sizing | 23 | 48 kB | 0 bytes | 8192 bytes | 40 kB
information_schema | sql_packages | 10 | 48 kB | 0 bytes | 8192 bytes | 40 kB
information_schema | sql_parts | 9 | 48 kB | 0 bytes | 8192 bytes | 40 kB
information_schema | sql_languages | 4 | 48 kB | 0 bytes | 8192 bytes | 40 kB
pg_catalog | pg_statistic_ext | 0 | 32 kB | 24 kB | 8192 bytes | 0 bytes
pg_catalog | pg_trigger | 0 | 32 kB | 24 kB | 8192 bytes | 0 bytes
public | pikabu_deleted_or_never_existed_comments | 0 | 32 kB | 32 kB | | 0 bytes
pg_catalog | pg_default_acl | 0 | 24 kB | 16 kB | 8192 bytes | 0 bytes
pg_catalog | pg_foreign_server | 0 | 24 kB | 16 kB | 8192 bytes | 0 bytes
pg_catalog | pg_event_trigger | 0 | 24 kB | 16 kB | 8192 bytes | 0 bytes
pg_catalog | pg_user_mapping | 0 | 24 kB | 16 kB | 8192 bytes | 0 bytes
pg_catalog | pg_policy | 0 | 24 kB | 16 kB | 8192 bytes | 0 bytes
pg_catalog | pg_foreign_data_wrapper | 0 | 24 kB | 16 kB | 8192 bytes | 0 bytes
pg_catalog | pg_subscription | 0 | 24 kB | 16 kB | 8192 bytes | 0 bytes
pg_catalog | pg_replication_origin | 0 | 24 kB | 16 kB | 8192 bytes | 0 bytes
pg_catalog | pg_enum | 0 | 24 kB | 24 kB | | 0 bytes
pg_catalog | pg_inherits | 0 | 16 kB | 16 kB | | 0 bytes
pg_catalog | pg_publication_rel | 0 | 16 kB | 16 kB | | 0 bytes
pg_catalog | pg_publication | 0 | 16 kB | 16 kB | | 0 bytes
pg_catalog | pg_seclabel | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
pg_catalog | pg_shseclabel | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
pg_catalog | pg_transform | 0 | 16 kB | 16 kB | | 0 bytes
public | pikabu_user_award_issuing_date_versions | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
pg_catalog | pg_statistic_ext_data | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
public | pikabu_user_award_story_title_versions | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
public | pikabu_user_ban_history_item_ban_reason_versions | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
public | pikabu_user_ban_history_item_comment_html_delete_reason_version | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
public | pikabu_user_ban_history_item_ids_versions | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
public | pikabu_user_ban_history_item_moderator_avatar_versions | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
public | pikabu_user_ban_history_item_moderator_name_versions | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
public | pikabu_user_ban_history_item_reason_title_versions | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
public | pikabu_user_ban_history_item_story_url_versions | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
public | pikabu_user_ban_history_items | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
pg_catalog | pg_partitioned_table | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
pg_catalog | pg_foreign_table | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
pg_catalog | pg_db_role_setting | 0 | 16 kB | 8192 bytes | 8192 bytes | 0 bytes
public | pikabu_user_ban_history_item_reasons_limit_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_user_ban_history_item_story_id_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_comment_author_id_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_user_ban_history_item_user_id_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_comment_created_at_timestamp_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_comment_ignore_code_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_user_award_user_id_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_comment_is_author_community_moderator_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
pg_catalog | pg_largeobject_metadata | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_comment_parent_id_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_user_award_is_hidden_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_user_award_comment_id_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
pg_catalog | pg_subscription_rel | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_story_has_adult_tag_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
pg_catalog | pg_largeobject | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_comment_story_id_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_user_ban_history_item_ban_reason_id_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_story_created_at_timestamp_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_user_ban_history_item_ban_start_timestamp_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
information_schema | sql_sizing_profiles | 0 | 8192 bytes | 0 bytes | 8192 bytes | 0 bytes
public | pikabu_user_ban_history_item_comment_id_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_story_comments_are_hot_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_story_author_id_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_user_ban_history_item_moderator_id_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_comment_author_gender_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_user_ban_history_item_reason_count_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
public | pikabu_user_signup_timestamp_versions | 0 | 8192 bytes | 8192 bytes | | 0 bytes
(208 rows)