Skip to content

Instantly share code, notes, and snippets.

@Veraticus
Created June 27, 2014 01:12
Show Gist options
  • Save Veraticus/0b809e069af881b8f4c3 to your computer and use it in GitHub Desktop.
Save Veraticus/0b809e069af881b8f4c3 to your computer and use it in GitHub Desktop.
Staging:
relation | size
----------------------------------------------------+---------
public.resources | 16 GB
public.index_feed_keys_on_type | 3392 MB
public.index_feed_keys_on_priority | 2113 MB
public.index_feed_keys_on_feed_id | 1311 MB
public.index_feed_keys_on_searched_at_int | 1138 MB
public.index_resources_on_tracking_id | 1126 MB
public.resources_unique_by_remote_key_and_feed_key | 910 MB
public.index_resources_on_remote_key | 795 MB
public.feed_keys | 779 MB
public.mod_attempts | 524 MB
public.index_resources_on_reply_to_id | 377 MB
public.resources_pkey | 373 MB
public.index_resources_on_feed_id | 372 MB
public.index_feed_keys_remote_and_feed | 328 MB
pg_toast.pg_toast_1590042 | 282 MB
public.feed_key_stats | 279 MB
public.feed_keys_pkey | 176 MB
public.index_feed_key_stats_on_feed_id | 112 MB
public.index_feed_key_stats_on_latest_resource_at | 107 MB
public.index_feed_key_stats_on_feed_key_id | 101 MB
(20 rows)
Production:
relation | size
----------------------------------------------------+---------
public.feed_keys | 19 GB
public.resources | 17 GB
public.index_feed_keys_on_type | 10 GB
public.index_feed_keys_on_priority | 5739 MB
public.index_feed_keys_on_feed_id | 5518 MB
public.index_feed_keys_remote_and_feed | 5061 MB
public.index_feed_keys_on_searched_at_int | 3625 MB
public.feed_keys_pkey | 2744 MB
public.index_resources_on_tracking_id | 1779 MB
public.index_resources_on_remote_key | 1548 MB
public.resources_unique_by_remote_key_and_feed_key | 1352 MB
public.mod_attempts | 993 MB
public.index_resources_on_reply_to_id | 635 MB
pg_toast.pg_toast_782582 | 583 MB
public.index_resources_on_feed_id | 540 MB
public.resources_pkey | 500 MB
public.index_feed_key_stats_on_latest_resource_at | 427 MB
public.feed_key_stats | 343 MB
public.index_feed_key_stats_on_feed_id | 317 MB
public.index_feed_key_stats_on_feed_key_id | 223 MB
(20 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment