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)