Skip to content

Instantly share code, notes, and snippets.

@ruckus

ruckus/gist:5ac1ae7d11facd72913f Secret

Created November 15, 2011 00:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ruckus/5ac1ae7d11facd72913f to your computer and use it in GitHub Desktop.
Save ruckus/5ac1ae7d11facd72913f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
relid | schemaname | relname | seq_scan | seq_tup_read | idx_scan | idx_tup_fetch | n_tup_ins | n_tup_upd | n_tup_del | n_tup_hot_upd | n_live_tup | n_dead_tup | last_vacuum | last_autovacuum | last_analyze | last_autoanalyze | vacuum_count | autovacuum_count | analyze_count | autoanalyze_count
-------+------------+-----------------------------+----------+--------------+-----------+---------------+-----------+-----------+-----------+---------------+------------+------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------+------------------+---------------+-------------------
17084 | public | album_photo_likes | 7755 | 1865113 | 846912 | 593647 | 11219 | 0 | 875 | 0 | 10344 | 875 | | | | 2011-11-13 03:47:09.067221+00 | 0 | 0 | 0 | 36
17096 | public | album_share_tweets | 145661 | 33356623 | 407224 | 405871 | 1707 | 1698 | 46 | 1677 | 1661 | 73 | | | | 2011-11-14 03:25:38.848453+00 | 0 | 0 | 0 | 30
17089 | public | album_photos | 4318 | 10982161 | 2830345 | 16774862 | 260053 | 20923 | 19302 | 19704 | 240773 | 2134 | 2011-11-12 21:43:45.459599+00 | | 2011-11-12 21:43:45.539052+00 | 2011-11-14 04:16:41.920971+00 | 1 | 0 | 1 | 75
17116 | public | external_users | 578 | 516826789 | 260496634 | 237803017 | 11405841 | 11 | 49 | 0 | 10686619 | 0 | 2011-11-12 21:42:03.837864+00 | | 2011-11-14 22:47:19.922981+00 | 2011-11-10 06:33:03.799299+00 | 1 | 0 | 3 | 84
17198 | public | user_avatars | 51 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | | 0 | 0 | 0 | 0
17122 | public | facebook_friends | 73 | 1148896650 | 129987145 | 1348928248 | 27340438 | 0 | 36 | 0 | 25536568 | 3259 | 2011-11-12 21:39:37.539552+00 | | 2011-11-14 22:16:13.874986+00 | 2011-11-10 05:29:06.206433+00 | 1 | 0 | 4 | 87
17182 | public | roles | 1349 | 1338 | 145 | 145 | 2 | 0 | 1 | 0 | 1 | 1 | | | | | 0 | 0 | 0 | 0
17206 | public | user_devices | 20634 | 10194462 | 13649616 | 972360 | 36684 | 127687 | 0 | 122810 | 36663 | 1429 | 2011-11-12 21:45:36.088267+00 | 2011-11-11 23:17:32.221232+00 | 2011-11-12 21:45:36.818356+00 | 2011-11-14 17:19:14.856858+00 | 1 | 7 | 1 | 213
17108 | public | email_notification_settings | 3089 | 1912552 | 57156 | 42007 | 32327 | 41 | 6 | 18 | 32321 | 29 | | | | 2011-11-13 11:48:19.070139+00 | 0 | 0 | 0 | 43
17187 | public | schema_migrations | 3148 | 230028 | 0 | 0 | 79 | 0 | 3 | 0 | 76 | 3 | | | | 2011-10-24 18:13:05.716354+00 | 0 | 0 | 0 | 1
17143 | public | photo_exifs | 52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | | 0 | 0 | 0 | 0
17076 | public | album_photo_comments | 15172 | 4673718 | 975692 | 688696 | 8949 | 221 | 328 | 0 | 8621 | 319 | | 2011-10-25 18:43:35.876917+00 | | 2011-11-13 18:40:28.566138+00 | 0 | 1 | 0 | 33
19858 | public | notices | 3 | 4 | 9 | 9 | 2 | 2 | 0 | 2 | 2 | 2 | | | | | 0 | 0 | 0 | 0
17221 | public | user_roles | 2625 | 4630 | 11 | 11 | 16 | 0 | 11 | 0 | 5 | 11 | | | | | 0 | 0 | 0 | 0
19806 | public | pg_stat_bgwriter_snapshot | 49 | 270 | | | 13 | 0 | 0 | 0 | 13 | 0 | | | | | 0 | 0 | 0 | 0
19869 | public | user_notices | 5 | 2 | 22807 | 386 | 2 | 12 | 0 | 9 | 2 | 12 | | | | | 0 | 0 | 0 | 0
17383 | public | facebook_links | 381 | 1397761 | 86489 | 99596 | 30410 | 14686 | 437 | 14165 | 29973 | 1212 | | 2011-10-26 00:52:42.812251+00 | | 2011-11-13 11:19:19.925594+00 | 0 | 1 | 0 | 57
17169 | public | photos | 8033 | 32725646 | 43113177 | 43185987 | 259862 | 474475 | 4013 | 416692 | 255209 | 836 | 2011-11-14 22:58:44.622787+00 | 2011-10-31 00:14:20.255407+00 | 2011-11-14 22:58:47.085216+00 | 2011-11-14 01:38:44.676571+00 | 2 | 4 | 4 | 167
17135 | public | oauths | 761 | 1432940 | 348080 | 277564 | 34447 | 5385 | 838 | 4829 | 33609 | 279 | 2011-11-12 21:45:12.35013+00 | | 2011-11-14 22:47:35.171375+00 | 2011-11-14 22:03:24.572283+00 | 1 | 0 | 2 | 50
17226 | public | user_sessions | 23913 | 5347984 | 1701267 | 1701604 | 36733 | 0 | 424 | 0 | 36309 | 69 | 2011-11-12 21:45:44.044099+00 | | 2011-11-12 21:45:44.131374+00 | 2011-11-12 16:41:51.658173+00 | 1 | 0 | 1 | 44
17231 | public | users | 1082 | 1958568677 | 351917458 | 2169068437 | 11404150 | 142887791 | 16 | 137762494 | 11402871 | 60648 | 2011-11-14 22:55:11.548238+00 | 2011-11-10 03:57:30.092095+00 | 2011-11-14 22:55:12.813835+00 | 2011-11-14 20:49:28.037827+00 | 2 | 4 | 5 | 438
17066 | public | album_links | 192 | 815553 | 45063 | 45032 | 20038 | 1197 | 1246 | 1134 | 18799 | 1840 | | | | 2011-11-13 03:09:13.922528+00 | 0 | 0 | 0 | 44
17190 | public | social_connections | 52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | | 0 | 0 | 0 | 0
17151 | public | photo_metadata | 52 | 8607086 | 714840 | 233013 | 222423 | 224086 | 3554 | 176875 | 218654 | 340 | 2011-11-14 22:57:28.621083+00 | 2011-11-02 02:09:56.414766+00 | 2011-11-14 22:57:42.205065+00 | 2011-11-13 22:44:03.756127+00 | 1 | 7 | 1 | 118
17101 | public | albums | 52262 | 14055130 | 3636010 | 3762515 | 19634 | 304773 | 1211 | 301323 | 18423 | 1266 | 2011-11-12 21:44:34.267335+00 | 2011-11-09 18:12:44.046529+00 | 2011-11-14 22:15:31.589529+00 | 2011-11-14 20:42:18.233586+00 | 1 | 8 | 2 | 597
17071 | public | album_members | 3234 | 1782426 | 238519 | 204447 | 18608 | 0 | 851 | 0 | 17757 | 851 | | | | 2011-11-13 17:12:26.32995+00 | 0 | 0 | 0 | 39
17162 | public | photo_tags | 70 | 0 | 24505 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2011-11-09 00:32:23.214324+00 | | 2011-11-09 00:32:23.215538+00 | | 2 | 0 | 1 | 0
17370 | public | facebook_wall_posts | 2377 | 636706 | 47122 | 41742 | 6052 | 5928 | 159 | 5834 | 5893 | 264 | | | | 2011-11-14 03:19:43.879001+00 | 0 | 0 | 0 | 52
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment