Skip to content

Instantly share code, notes, and snippets.

@francois

francois/iostat.txt Secret

Created March 14, 2012 17:27
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 francois/07bbf8a5b05b1c37a7f2 to your computer and use it in GitHub Desktop.
Save francois/07bbf8a5b05b1c37a7f2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
iostat.txt
# iostat -d -m 2 30
Linux 3.0.0-12-virtual (db02) 03/14/2012 _x86_64_ (4 CPU)
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 353.53 4.70 2.35 25116615 12530993
xvdc 1.51 0.01 0.00 33036 17773
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 912.50 9.02 5.32 18 10
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 795.00 6.63 4.75 13 9
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 661.50 2.04 5.03 4 10
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 707.00 6.41 4.37 12 8
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 1077.00 3.68 11.13 7 22
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 545.00 6.36 2.61 12 5
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 995.50 7.30 6.26 14 12
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 628.50 3.49 4.30 6 8
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 704.00 7.95 3.83 15 7
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 1235.50 4.16 9.22 8 18
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 235.00 2.92 1.31 5 2
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 517.50 5.26 2.38 10 4
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 1371.50 3.55 16.39 7 32
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 630.00 7.08 2.46 14 4
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 438.00 5.05 1.68 10 3
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 686.00 2.77 4.71 5 9
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 606.00 3.04 4.24 6 8
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 522.00 3.78 2.75 7 5
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 710.50 2.44 5.00 4 10
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 497.00 4.74 2.32 9 4
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 643.00 2.04 4.66 4 9
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 730.00 6.05 3.70 12 7
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 994.00 6.27 4.99 12 9
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 714.00 2.03 12.08 4 24
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 861.50 6.74 4.19 13 8
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 902.50 4.72 6.01 9 12
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 416.00 4.44 1.87 8 3
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 964.18 4.88 5.61 9 11
xvdc 0.00 0.00 0.00 0 0
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
xvda 578.50 6.82 2.00 13 4
xvdc 0.00 0.00 0.00 0 0
Raw
pg_stat_database.txt
# while sleep 2 ; do psql --tuples-only -h localhost -U postgres -c "select * from pg_stat_database where datname = 'svanalytics_staging'" >> pg_stat_database.txt ; done
datid | datname | numbackends | xact_commit | xact_rollback | blks_read | blks_hit | tup_returned | tup_fetched | tup_inserted | tup_updated | tup_deleted | conflicts | stats_reset
-------+---------------------+-------------+-------------+---------------+-----------+-------------+--------------+-------------+--------------+-------------+-------------+-----------+-------------------------------
18332 | svanalytics_staging | 62 | 299754935 | 840047 | 289145885 | 10120697113 | 14934607525 | 5831170927 | 82012931 | 37405495 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299755435 | 840052 | 289146331 | 10120722580 | 14934614808 | 5831178196 | 82013149 | 37405625 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299755831 | 840052 | 289146665 | 10120743762 | 14934620911 | 5831184292 | 82013328 | 37405718 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299756573 | 840059 | 289147494 | 10120778361 | 14934630682 | 5831194037 | 82013615 | 37405958 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299757019 | 840060 | 289147860 | 10120803496 | 14934737084 | 5831203870 | 82013796 | 37406061 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299757702 | 840063 | 289148559 | 10120985898 | 14937802870 | 5833924484 | 82014147 | 37406220 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299758406 | 840065 | 289149172 | 10121022362 | 14937813394 | 5833934966 | 82014459 | 37406399 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299758871 | 840068 | 289149612 | 10121045765 | 14937820100 | 5833941665 | 82014663 | 37406520 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299759453 | 840071 | 289150108 | 10121075293 | 14937828531 | 5833950075 | 82014918 | 37406674 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299759949 | 840071 | 289150576 | 10121100516 | 14937835692 | 5833957227 | 82015138 | 37406811 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299760573 | 840072 | 289151203 | 10121129964 | 14937843915 | 5833965430 | 82015427 | 37406994 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299761272 | 840075 | 289151835 | 10121164735 | 14937853910 | 5833975406 | 82015718 | 37407178 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299761744 | 840078 | 289152301 | 10121187570 | 14937860361 | 5833981831 | 82015914 | 37407314 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299762375 | 840078 | 289152890 | 10121218422 | 14937871397 | 5833990607 | 82016177 | 37407478 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299762836 | 840081 | 289153332 | 10121242391 | 14937878273 | 5833997472 | 82016386 | 37407594 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299763394 | 840086 | 289153905 | 10121269632 | 14937886022 | 5834005215 | 82016632 | 37407740 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299764102 | 840090 | 289154659 | 10121303378 | 14937895519 | 5834014686 | 82016915 | 37407965 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299764673 | 840093 | 289155205 | 10121328449 | 14937902380 | 5834021453 | 82017119 | 37408194 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299765330 | 840094 | 289155826 | 10121357710 | 14937910335 | 5834029338 | 82017373 | 37408434 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299765891 | 840096 | 289156317 | 10121385965 | 14937981466 | 5834039291 | 82017586 | 37408607 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299766520 | 840101 | 289157098 | 10121417653 | 14937990144 | 5834047817 | 82018013 | 37408788 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299767051 | 840104 | 289157610 | 10121443625 | 14937997567 | 5834055228 | 82018234 | 37408946 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299767624 | 840107 | 289158165 | 10121470225 | 14938005086 | 5834062729 | 82018468 | 37409113 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299768263 | 840112 | 289158795 | 10121501214 | 14938013869 | 5834071479 | 82018732 | 37409287 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299768695 | 840114 | 289159206 | 10121523080 | 14938020130 | 5834077732 | 82018916 | 37409401 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299769314 | 840116 | 289159828 | 10121552859 | 14938028660 | 5834086255 | 82019166 | 37409572 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
18332 | svanalytics_staging | 62 | 299769903 | 840119 | 289160400 | 10121582159 | 14938037070 | 5834094641 | 82019401 | 37409733 | 9218630 | 0 | 2012-03-06 09:53:55.437488+00
Raw
pg_statio_user_indexes.txt
# while sleep 2 ; do ( psql -h localhost -U svanalytics svanalytics_staging -c "select * from pg_statio_user_indexes order by idx_blks_read desc limit 10" | head -n 12 ; echo ) >> pg_statio_user_indexes.txt ; done
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20361943 | 142078861
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546720 | 222651588
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11273991 | 215361298
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719362 | 31110492
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587839 | 58662538
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553630 | 412442854
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20361943 | 142078861
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546720 | 222651588
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11273991 | 215361298
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719362 | 31110492
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587839 | 58662538
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553632 | 412442868
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20361943 | 142078861
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546720 | 222651588
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11273991 | 215361298
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719362 | 31110492
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587839 | 58662538
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553633 | 412442875
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20361943 | 142078861
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546720 | 222651588
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11273991 | 215361298
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719362 | 31110492
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587839 | 58662538
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553635 | 412442889
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20361943 | 142078861
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546720 | 222651588
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11273991 | 215361298
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719362 | 31110492
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587839 | 58662538
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553641 | 412442907
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20361943 | 142078861
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546720 | 222651588
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11273991 | 215361298
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719362 | 31110492
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587839 | 58662538
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553643 | 412442917
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20361943 | 142078861
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546720 | 222651588
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11273991 | 215361298
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719362 | 31110492
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587839 | 58662538
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553645 | 412442931
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20361943 | 142078861
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546720 | 222651588
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11273991 | 215361298
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719362 | 31110492
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587839 | 58662538
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553649 | 412442947
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20361943 | 142078861
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546720 | 222651588
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11273991 | 215361298
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719362 | 31110492
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587839 | 58662538
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553652 | 412442956
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20361943 | 142078861
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546720 | 222651588
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11273991 | 215361298
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719362 | 31110492
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587839 | 58662538
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553654 | 412442970
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20361943 | 142078861
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546720 | 222651588
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11273991 | 215361298
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719362 | 31110492
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587839 | 58662538
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553656 | 412442984
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20361943 | 142078861
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546720 | 222651588
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11273991 | 215361298
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719362 | 31110492
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587839 | 58662538
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553658 | 412442998
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20361967 | 142078982
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546743 | 222651701
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11274007 | 215361903
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719367 | 31110507
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587853 | 58662716
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553659 | 412443005
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20362049 | 142079426
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546824 | 222652200
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11274098 | 215365742
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719383 | 31110563
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3587933 | 58663382
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553660 | 412443028
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20362161 | 142080056
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18546928 | 222652849
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11274196 | 215368414
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719414 | 31110656
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3588033 | 58664171
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103292 | 1419820
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553663 | 412443041
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit
--------+------------+------------+---------------------------------+--------------------------------------------------------+---------------+--------------
18808 | 83651 | public | twitter_personas | twitter_personas_pkey | 20362270 | 142080677
18808 | 51593 | public | twitter_personas | index_twitter_personas_on_screen_name | 18547018 | 222653540
18808 | 146925 | public | twitter_personas | index_twitter_personas_twitter_user_id | 11274249 | 215368938
18808 | 83650 | public | twitter_personas | index_twitter_personas_on_screen_name_persona_id | 10719449 | 31110769
155022 | 155026 | public | persona_followers | persona_followers_pkey | 7671437 | 17785986
189194 | 189202 | public | twitter_interactions_2012_03_05 | twitter_interactions_2012_03_05_pkey | 5531801 | 45186780
207526 | 207534 | public | twitter_interactions_2012_03_12 | twitter_interactions_2012_03_12_pkey | 3588138 | 58664979
18524 | 52299 | public | facebook_personas | index_facebook_personas_on_facebook_user_id_persona_id | 3103294 | 1419822
18524 | 51368 | public | facebook_personas | index_facebook_personas_facebook_user_id | 2553665 | 412443055
175472 | 175480 | public | twitter_interactions_2012_02_27 | twitter_interactions_2012_02_27_pkey | 2491361 | 1294953
Raw
pg_statio_user_tables.txt
# while sleep 2 ; do ( psql -h localhost -U svanalytics svanalytics_staging -c "select * from pg_statio_user_tables order by heap_blks_read desc limit 10" | head -n 12 ; echo ) >> pg_statio_user_tables.txt ; done
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284828 | 107793756 | 7654700 | 436545668 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284830 | 107793756 | 7654705 | 436545687 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284830 | 107793756 | 7654707 | 436545701 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284831 | 107793756 | 7654710 | 436545710 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284832 | 107793756 | 7654713 | 436545727 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284833 | 107793756 | 7654716 | 436545744 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284836 | 107793756 | 7654720 | 436545760 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284837 | 107793756 | 7654724 | 436545776 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284837 | 107793756 | 7654726 | 436545790 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284837 | 107793756 | 7654727 | 436545797 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284837 | 107793756 | 7654729 | 436545811 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284838 | 107793756 | 7654732 | 436545828 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284838 | 107793756 | 7654733 | 436545835 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490948 | 60899020 | 611173319 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284838 | 107793756 | 7654736 | 436545848 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679179 | 7086885 | 234146693 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73354444 | 2557531 | 106880006 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784303 | 3966494 | 252759143 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602919 | 211490950 | 60899020 | 611173327 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284838 | 107793756 | 7654738 | 436545870 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679180 | 7086885 | 234146696 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2609890 | 73355373 | 2557531 | 106880328 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28784305 | 3966494 | 252759149 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 612107 | 5582 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 502424 | 5905 | | | |
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------+------------+---------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
18808 | public | twitter_personas | 81602920 | 211490950 | 60899020 | 611173327 | 63 | 27 | 9 | 9
175472 | public | twitter_interactions_2012_02_27 | 10269737 | 2065823 | 5921997 | 151603009 | 0 | 0 | 0 | 0
18524 | public | facebook_personas | 9284839 | 107793756 | 7654739 | 436545877 | 0 | 0 | 0 | 0
189194 | public | twitter_interactions_2012_03_05 | 5215657 | 17679180 | 7086885 | 234146696 | 0 | 0 | 0 | 0
158946 | public | twitter_interactions_2012_02_20 | 4781035 | 41171698 | 3449923 | 112909601 | 0 | 0 | 0 | 0
18647 | public | summary_show_unique_personas | 2634186 | 73487735 | 2557531 | 106891052 | | | |
207526 | public | twitter_interactions_2012_03_12 | 2234108 | 28808052 | 3966495 | 252759320 | 0 | 0 | 0 | 0
123482 | public | show_bindings_2012_02_06 | 1581986 | 62561 | 615707 | 27189 | | | |
155022 | public | persona_followers | 1351152 | 6231735 | 9960510 | 41852789 | | | |
141626 | public | show_bindings_2012_02_13 | 1308340 | 51250 | 505503 | 28025 | | | |
Raw
postgresql-9.1-main.log
2012-03-14 17:19:40.568 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(johanrazaq) already exists.
2012-03-14 17:19:40.568 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:19:41.024 UTC - svanalytics@svanalytics_staging 6058 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:19:41.024 UTC - svanalytics@svanalytics_staging 6058 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(RockHard__) already exists.
2012-03-14 17:19:41.024 UTC - svanalytics@svanalytics_staging 6058 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:19:41.689 UTC - svanalytics@svanalytics_staging 6063 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:19:41.689 UTC - svanalytics@svanalytics_staging 6063 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(Aries_AngelFyre) already exists.
2012-03-14 17:19:41.689 UTC - svanalytics@svanalytics_staging 6063 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:19:42.324 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:19:42.324 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(Lagarteando__) already exists.
2012-03-14 17:19:42.324 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:19:42.459 UTC - svanalytics@svanalytics_staging 6063 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:19:42.459 UTC - svanalytics@svanalytics_staging 6063 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(MelThaRapper) already exists.
2012-03-14 17:19:42.459 UTC - svanalytics@svanalytics_staging 6063 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:19:43.156 UTC - svanalytics@svanalytics_staging 6039 (00000) 2012-03-09 13:12:46 UTC - LOG: duration: 6423.939 ms execute <unnamed>: SELECT screen_name, persona_id FROM twitter_personas WHERE screen_name IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266)
2012-03-14 17:19:43.156 UTC - svanalytics@svanalytics_staging 6039 (00000) 2012-03-09 13:12:46 UTC - DETAIL: parameters: $1 = 'Redacteur_CAC', $2 = '22_avril_2012', $3 = 'manonbarbeau', $4 = 'RM032010', $5 = 'PatriceGagnon', $6 = 'AndresRestrepo', $7 = 'TorenAmadeus', $8 = 'brbrs_rrgnts', $9 = 'cmchulak', $10 = 'magicdan07', $11 = 'MathParadis', $12 = 'ManonMasse_Qs', $13 = 'J_lesageOQ', $14 = 'MoreauCynthia', $15 = 'elisemond', $16 = 'ekiCYCLE', $17 = 'JozeeBelanger', $18 = 'noisjero', $19 = 'mungerdavid', $20 = 'RaLaniel', $21 = 'BeaVaugrante', $22 = 'projetj', $23 = 'mdpotvin', $24 = 'EdouardDugas', $25 = 'faislesaut', $26 = 'beaufra', $27 = 'sirois99', $28 = 'V_Grenier', $29 = 'JFLEPAGE', $30 = 'pimentrouge', $31 = 'MacStHyacinthe', $32 = 'LDolen', $33 = 'VMACHINS', $34 = 'UtopiaMy', $35 = 'CharlesGagnon5', $36 = 'Crisantenne', $37 = 'EloiseLaraD', $38 = 'JoseeLegault', $39 = 'RueMasson', $40 = 'CharlesRichard0', $41 = 'NETWORKSRA', $42 = 'VilleneuveMarco', $43 = 'ma_robert', $44 = 'SUCO_org', $45 = 'CaroLevek', $46 = 'celinebrassard', $47 = 'CybelProduction', $48 = 'gabrielthardy', $49 = 'Blackraist', $50 = 'Samuel_Lauzon', $51 = 'dangablan', $52 = 'MarieEve_Nault', $53 = 'fleurymesplet', $54 = 'LeCheuf', $55 = 'yvanboulay', $56 = 'voices_voix', $57 = 'DavidGat77', $58 = 'gpayette', $59 = 'stephanegarnier', $60 = 'cinoche08', $61 = 'CameraLuminosa', $62 = 'Chantal_Lamarre', $63 = 'RenouveauTerreb', $64 = 'TwiterwatchingU', $65 = 'Robert_Deragon', $66 = 'goodnesstv', $67 = 'SauvonsLeQuebec', $68 = 'CoopMemoArt', $69 = 'M_Charpentier', $70 = 'PauleFred', $71 = 'PlucxCharron', $72 = 'PascalePerron', $73 = 'richardmarceau', $74 = 'Cath_HR', $75 = 'TablefemmesMtl', $76 = 'MathetAude', $77 = 'CollecSolidaire', $78 = 'MDMusika', $79 = 'P_Poirier', $80 = 'Cybersolidaires', $81 = 'brunojlsarcher', $82 = 'BiloSuzanne', $83 = 'Terp4Life077727', $84 = 'JulienDecam', $85 = 'MicheleSpieler', $86 = 'Gwenola_A', $87 = 'mapaquet', $88 = 'Mobilisatron', $89 = 'lhdlh', $90 = 'BLajeunesse', $91 = 'Sebrivardmtl', $92 = 'Happelle', $93 = 'nicbeaudoin', $94 = 'AlexDuq9', $95 = 'stouim', $96 = 'EG1312', $97 = 'stdemers', $98 = 'LeGlobe', $99 = '_LaCLES', $100 = 'MagasindumondeO', $101 = 'BenoitTuyizere', $102 = 'cimonga', $103 = 'FGenest', $104 = 'adnewsmtl', $105 = 'Severine_F', $106 = 'blueray2111', $107 = 'MGN31', $108 = 'e_bonini', $109 = 'lefouduvillage', $110 = 'CECI_Canada', $111 = 'NadineMethot', $112 = 'Aude_', $113 = 'SCEPTIK22', $114 = 'nnepton', $115 = 'michael_fortin', $116 = 'StephaneBiron', $117 = 'PerryNormand', $118 = 'PsychoMedia', $119 = 'gdoraisb', $120 = 'Jean_Lapierre', $121 = 'JoVeilleux', $122 = 'Miss_communique', $123 = 'vincent45nord', $124 = 'jpvillemure', $125 = 'ChaacQC', $126 = 'projethaiti', $127 = 'talidube', $128 = 'societecrimino', $129 = 'lecturesdici', $130 = 'amirkhadir', $131 = 'murielfari9gd', $132 = 'bibliomancienne', $133 = 'Projet_Plateau', $134 = 'MozRenoir', $135 = 'fabienmajor', $136 = 'bourgys', $137 = 'chaleurafrique', $138 = 'jeanfmenard', $139 = 'Tremblay77', $140 = '_fec', $141 = 'AlexisDeLancer', $142 = 'OccMontreal', $143 = 'IndepofQuebec', $144 = 'ericvacarme', $145 = 'OttiliaR', $146 = 'TakingRoot', $147 = 'Rcentres', $148 = 'KarineLec', $149 = 'H8kitten', $150 = 'stradefi', $151 = 'MarieCostisella', $152 = 'OxfamQuebec', $153 = 'jugaudet', $154 = 'monsieurufus', $155 = 'DmpstrBaby', $156 = 'mosaurel', $157 = '1eresEnAffaires', $158 = 'rocfmontreal', $159 = 'JourdelaterreQc', $160 = 'UCQc', $161 = 'marilaneu', $162 = 'macbionik', $163 = 'JoDesjardins', $164 = 'annickdes', $165 = 'oxfam_mdm', $166 = 'FlaviaFaggiana', $167 = 'ProtegezVous', $168 = 'MarieMenini', $169 = 'cecilegladel', $170 = 'Dagniers', $171 = 'SoAnne', $172 = 'Louis_Sirois1', $173 = 'ASSEsolidarite', $174 = 'projetmontreal', $175 = 'Bourjoi', $176 = 'ben_dupuis', $177 = 'CPiou', $178 = 'PaquinJulie', $179 = 'koudonk', $180 = 'YvanTM', $181 = 'MurUnidxs', $182 = 'lordesautres', $183 = 'MatthieuDugal', $184 = 'aalvox', $185 = 'kiwibruissant', $186 = 'jonathanpayette', $187 = 'Lea_Kim', $188 = 'sabrinahammoum', $189 = 'SophMarathon42K', $190 = 'PatatriciaB', $191 = 'MiradorBBQ', $192 = 'CitoyenLambda77', $193 = 'touann', $194 = 'emc_jacques', $195 = '99_Quebec', $196 = 'so_tremblay', $197 = 'francoiscroteau', $198 = 'APTSQ', $199 = 'alternativesMTL', $200 = 'EmilieJoyal', $201 = 'shoeshinr', $202 = 'Michellicorne', $203 = 'Carcajou69', $204 = 'rcarbasse', $205 = 'MaxinePatel', $206 = 'CQCAM', $207 = 'renartleveille', $208 = 'gregoire_franco', $209 = 'xpat_viau', $210 = 'M_Potvin', $211 = 'ParoleCitoyenne', $212 = 'yvanrousseau', $213 = 'audreygp', $214 = 'Fiscal_Genereux', $215 = 'MatthieuBonnier', $216 = 'shoppons1', $217 = 'MonsEquitable', $218 = 'MC_Risorius', $219 = 'Vero_Fournier_', $220 = 'Zamindian21', $221 = 'jiklop', $222 = 'fmcentreville', $223 = 'ValerieGuilmain', $224 = 'Nouvelleslibres', $225 = 'dandu5', $226 = 'JPageauBienvenu', $227 = 'OptionNationale', $228 = 'shinz78', $229 = 'jasonkeays', $230 = 'neoloys', $231 = 'hel_lau', $232 = 'mariehcaron', $233 = 'OlivierGouletQC', $234 = 'Mimibemol', $235 = 'ValerieTeasdale', $236 = 'mysteryoussef', $237 = 'MDNinfo', $238 = 'le_jeromien', $239 = 'jeanjean3', $240 = 'Sanatura', $241 = 'UnReveVivant', $242 = 'Steffanyie', $243 = 'julienroyal', $244 = 'marcottejf', $245 = 'WilliamsRec', $246 = 'SolMond', $247 = 'metronomephil', $248 = 'QB_cdeacf', $249 = 'EricBouchard66', $250 = 'natif8', $251 = 'luclefebvre', $252 = 'Shavirez', $253 = 'gueulesale', $254 = 'op_solidarite', $255 = 'CollectifQ', $256 = 'AncienMaigre', $257 = 'XMmusiquefranco', $258 = 'ACCHFS', $259 = 'richpaq', $260 = 'Cat006', $261 = 'mbinzolambert', $262 = 'cellequiva', $263 = 'Hayeur', $264 = 'Ju1ieGervais', $265 = 'MelissaCDouyon', $266 = 'pascal129'
2012-03-14 17:19:43.583 UTC - svanalytics@svanalytics_staging 6047 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:19:43.583 UTC - svanalytics@svanalytics_staging 6047 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(isaaal_27) already exists.
2012-03-14 17:19:43.583 UTC - svanalytics@svanalytics_staging 6047 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:19:43.787 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:19:43.787 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - DETAIL: Key (screen_name)=(Majdaa182) already exists.
2012-03-14 17:19:43.787 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:19:43.989 UTC - svanalytics@svanalytics_staging 6058 (00000) 2012-03-09 13:12:48 UTC - LOG: duration: 2576.939 ms execute <unnamed>: SELECT screen_name, persona_id FROM twitter_personas WHERE screen_name IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78)
2012-03-14 17:19:43.989 UTC - svanalytics@svanalytics_staging 6058 (00000) 2012-03-09 13:12:48 UTC - DETAIL: parameters: $1 = 'AdamHamway', $2 = 'THEPHILSHOW', $3 = 'gmc_bookpr', $4 = 'zacbrownband', $5 = 'Fam4Life_', $6 = 'trulia', $7 = 'RothenbergESPN', $8 = 'itspatsilva', $9 = 'MadStorkSports', $10 = 'jambottledotcom', $11 = 'Xsefcdsf', $12 = 'TheDaveSimsShow', $13 = 'anitacure', $14 = 'SteveJ78', $15 = 'zillow', $16 = 'ShortSweetShows', $17 = 'Julie_SimmonsN', $18 = 'licensedbrokers', $19 = 'TheTuscanGun', $20 = 'phatjuicycock', $21 = 'nyrr', $22 = '__Real_Toby_K__', $23 = '1lb_A_Day', $24 = 'JimMaisano', $25 = 'J_LinFanClub', $26 = 'julierubes', $27 = 'pauloverstreet', $28 = 'ecoApp', $29 = 'WynonnaMusic', $30 = 'issuu', $31 = 'PhilIazzetta', $32 = 'LNoce18', $33 = 'DivaTalkRadio', $34 = 'H2O_Moon', $35 = 'Joesofavenueu', $36 = 'krissygasbarre', $37 = 'aksports', $38 = 'jimimcclure', $39 = 'Odin10102010', $40 = 'vincedelisi', $41 = 'SeanBertollo', $42 = 'metspress', $43 = 'nickteodoro', $44 = 'Fan4Calvin', $45 = 'FrescoByScotto', $46 = 'tsmithsports', $47 = 'missingshea', $48 = 'gayle_jamieson', $49 = 'Mets_mb', $50 = 'MikeRadio', $51 = 'gottahavebags', $52 = 'big_mets841', $53 = 'Leonagy97', $54 = 'LionellaCheap', $55 = 'Quotes4Writers', $56 = 'JanaRickon8160', $57 = 'Ingeborggmf', $58 = 'ladyhetty', $59 = 'CupcakeStop', $60 = 'patrick_cerezo', $61 = 'EasyAffiliateGd', $62 = 'EssayAdvice', $63 = 'kakatracey', $64 = 'DanielGoddard', $65 = 'electronicideas', $66 = 'billengvall', $67 = 'susankonig', $68 = 'BoomFitNYC', $69 = 'musiccharles', $70 = 'BarbecueParty', $71 = 'Comedydaddy', $72 = 'NotTerryCollins', $73 = 'Jeannaenm', $74 = 'susanks12', $75 = 'ideyas', $76 = 'MetsWFAN', $77 = 'Galmusic', $78 = 'kkcoolj'
2012-03-14 17:19:45.123 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:19:45.123 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(Indianweave) already exists.
2012-03-14 17:19:45.123 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:19:46.185 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:19:46.185 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - DETAIL: Key (screen_name)=(dollypurewal) already exists.
2012-03-14 17:19:46.185 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, real_name = $2, screen_name = $3, avatar_url = $4 WHERE persona_id = $5
2012-03-14 17:19:46.974 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:19:46.974 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(LADIE_SHAR) already exists.
2012-03-14 17:19:46.974 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:19:47.852 UTC - svanalytics@svanalytics_staging 6058 (00000) 2012-03-09 13:12:48 UTC - LOG: duration: 3064.554 ms execute <unnamed>:
INSERT INTO persona_followers(persona_id, follower_id)
SELECT $1, persona_id AS follower_id
FROM (
SELECT twitter_user_id
FROM ( VALUES ($2),($3),($4),($5),($6),($7),($8),($9),($10),($11),($12),($13),($14),($15),($16),($17),($18),($19),($20),($21),($22),($23),($24),($25),($26),($27),($28),($29),($30),($31),($32),($33),($34),($35),($36),($37),($38),($39),($40),($41),($42),($43),($44),($45),($46),($47),($48),($49),($50),($51),($52),($53),($54),($55),($56),($57),($58),($59),($60),($61),($62),($63),($64),($65),($66),($67),($68),($69),($70),($71),($72),($73),($74),($75),($76),($77),($78),($79) ) AS t1(twitter_user_id)
EXCEPT
SELECT twitter_user_id
FROM persona_followers
JOIN twitter_personas ON twitter_personas.persona_id = persona_followers.follower_id
WHERE persona_followers.persona_id = $80) AS t1(twitter_user_id)
JOIN twitter_personas USING (twitter_user_id)
2012-03-14 17:19:47.852 UTC - svanalytics@svanalytics_staging 6058 (00000) 2012-03-09 13:12:48 UTC - DETAIL: parameters: $1 = 'ea60bd21-0152-11e1-ba45-4040b4d10eb4', $2 = '143157367', $3 = '151494005', $4 = '389758444', $5 = '22689810', $6 = '327980960', $7 = '311209570', $8 = '109471902', $9 = '28858910', $10 = '472581201', $11 = '85723700', $12 = '32720859', $13 = '470843828', $14 = '162606893', $15 = '135010862', $16 = '27064433', $17 = '19262500', $18 = '40378798', $19 = '37515801', $20 = '308529059', $21 = '20853344', $22 = '121159112', $23 = '272929714', $24 = '369270423', $25 = '53818003', $26 = '513257454', $27 = '58432349', $28 = '26668603', $29 = '321088936', $30 = '399775775', $31 = '446955539', $32 = '15861044', $33 = '175872365', $34 = '19242281', $35 = '18192214', $36 = '15158510', $37 = '18124756', $38 = '10156602', $39 = '42442684', $40 = '300393460', $41 = '212598670', $42 = '166161317', $43 = '43393720', $44 = '446521182', $45 = '193417588', $46 = '16371414', $47 = '288046818', $48 = '91279525', $49 = '57895084', $50 = '80677794', $51 = '17632642', $52 = '28756617', $53 = '275969736', $54 = '21721743', $55 = '353491391', $56 = '213004095', $57 = '224256404', $58 = '20783321', $59 = '91089726', $60 = '16568022', $61 = '36266761', $62 = '19233124', $63 = '28587352', $64 = '164718319', $65 = '362815145', $66 = '218233483', $67 = '34784832', $68 = '38259727', $69 = '27484043', $70 = '298219037', $71 = '103706597', $72 = '49152398', $73 = '17322854', $74 = '369906422', $75 = '930091', $76 = '20080648', $77 = '17480428', $78 = '431797537', $79 = '163107571', $80 = 'ea60bd21-0152-11e1-ba45-4040b4d10eb4'
2012-03-14 17:19:48.905 UTC - svanalytics@svanalytics_staging 6067 (23505) 2012-03-09 13:12:49 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:19:48.905 UTC - svanalytics@svanalytics_staging 6067 (23505) 2012-03-09 13:12:49 UTC - DETAIL: Key (screen_name)=(prettygenesiss) already exists.
2012-03-14 17:19:48.905 UTC - svanalytics@svanalytics_staging 6067 (23505) 2012-03-09 13:12:49 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:19:49.750 UTC - svanalytics@svanalytics_staging 6039 (00000) 2012-03-09 13:12:46 UTC - LOG: duration: 3385.261 ms execute <unnamed>:
INSERT INTO persona_followers(persona_id, follower_id)
SELECT $1, persona_id AS follower_id
FROM (
SELECT twitter_user_id
FROM ( VALUES ($2),($3),($4),($5),($6),($7),($8),($9),($10),($11),($12),($13),($14),($15),($16),($17),($18),($19),($20),($21),($22),($23),($24),($25),($26),($27),($28),($29),($30),($31),($32),($33),($34),($35),($36),($37),($38),($39),($40),($41),($42),($43),($44),($45),($46),($47),($48),($49),($50),($51),($52),($53),($54),($55),($56),($57),($58),($59),($60),($61),($62),($63),($64),($65),($66),($67),($68),($69),($70),($71),($72),($73),($74),($75),($76),($77),($78),($79),($80),($81),($82),($83),($84),($85),($86),($87),($88),($89),($90),($91),($92),($93),($94),($95),($96),($97),($98),($99),($100),($101),($102),($103),($104),($105),($106),($107),($108),($109),($110),($111),($112),($113),($114),($115),($116),($117),($118),($119),($120),($121),($122),($123),($124),($125),($126),($127),($128),($129),($130),($131),($132),($133),($134),($135),($136),($137),($138),($139),($140),($141),($142),($143),($144),($145),($146),($147),($148),($149),($150),($151),($152),($153),($154),($155),($156),($157),($158),($159),($160),($161),($162),($163),($164),($165),($166),($167),($168),($169),($170),($171),($172),($173),($174),($175),($176),($177),($178),($179),($180),($181),($182),($183),($184),($185),($186),($187),($188),($189),($190),($191),($192),($193),($194),($195),($196),($197),($198),($199),($200),($201),($202),($203),($204),($205),($206),($207),($208),($209),($210),($211),($212),($213),($214),($215),($216),($217),($218),($219),($220),($221),($222),($223),($224),($225),($226),($227),($228),($229),($230),($231),($232),($233),($234),($235),($236),($237),($238),($239),($240),($241),($242),($243),($244),($245),($246),($247),($248),($249),($250),($251),($252),($253),($254),($255),($256),($257),($258),($259),($260),($261),($262),($263),($264),($265),($266),($267) ) AS t1(twitter_user_id)
EXCEPT
SELECT twitter_user_id
FROM persona_followers
JOIN twitter_personas ON twitter_personas.persona_id = persona_followers.follower_id
WHERE persona_followers.persona_id = $268) AS t1(twitter_user_id)
JOIN twitter_personas USING (twitter_user_id)
2012-03-14 17:19:49.750 UTC - svanalytics@svanalytics_staging 6039 (00000) 2012-03-09 13:12:46 UTC - DETAIL: parameters: $1 = '98990eb0-2d40-11e1-a5ee-4040b4d10eb4', $2 = '158131399', $3 = '352712154', $4 = '166305497', $5 = '277697823', $6 = '214530693', $7 = '13402712', $8 = '24427930', $9 = '17195103', $10 = '32112311', $11 = '404071871', $12 = '270084453', $13 = '18380341', $14 = '214583137', $15 = '36480457', $16 = '44284197', $17 = '105267610', $18 = '436498053', $19 = '399374260', $20 = '474987262', $21 = '125617607', $22 = '164901042', $23 = '458724963', $24 = '507359074', $25 = '374487510', $26 = '421152354', $27 = '46646707', $28 = '21154399', $29 = '120309695', $30 = '133752184', $31 = '212504425', $32 = '137164769', $33 = '213381472', $34 = '43771294', $35 = '198330073', $36 = '116552755', $37 = '235380476', $38 = '28817262', $39 = '71727470', $40 = '77651084', $41 = '122953104', $42 = '291501941', $43 = '54089384', $44 = '148374347', $45 = '17093935', $46 = '155636123', $47 = '86393253', $48 = '15220118', $49 = '45429237', $50 = '268442511', $51 = '42629082', $52 = '67029440', $53 = '145404628', $54 = '94209630', $55 = '182532528', $56 = '485115603', $57 = '262262503', $58 = '19215050', $59 = '346705023', $60 = '21237105', $61 = '46925851', $62 = '292712523', $63 = '48708159', $64 = '261220787', $65 = '399181743', $66 = '257051821', $67 = '428400397', $68 = '292740627', $69 = '32107808', $70 = '487980809', $71 = '429401269', $72 = '7005852', $73 = '457731141', $74 = '261943140', $75 = '475926982', $76 = '5662022', $77 = '42962226', $78 = '216232774', $79 = '139582655', $80 = '256604556', $81 = '213170073', $82 = '55112258', $83 = '138769081', $84 = '253398125', $85 = '269380887', $86 = '385585360', $87 = '35364732', $88 = '229901392', $89 = '428226044', $90 = '41864709', $91 = '401395047', $92 = '81148891', $93 = '257707372', $94 = '102761470', $95 = '518048246', $96 = '18033807', $97 = '510473542', $98 = '82103097', $99 = '208660902', $100 = '98669817', $101 = '265503886', $102 = '460545929', $103 = '105037217', $104 = '110139929', $105 = '207307425', $106 = '46671172', $107 = '291915860', $108 = '105975090', $109 = '21750844', $110 = '380008096', $111 = '218611828', $112 = '238320624', $113 = '22578663', $114 = '95072719', $115 = '17603416', $116 = '292460050', $117 = '37663082', $118 = '126056028', $119 = '378582494', $120 = '29286190', $121 = '407201154', $122 = '97483268', $123 = '495973917', $124 = '390499253', $125 = '273698237', $126 = '399136677', $127 = '496474129', $128 = '18696897', $129 = '23397066', $130 = '208641115', $131 = '97492119', $132 = '184768346', $133 = '487928826', $134 = '26225432', $135 = '272241445', $136 = '18739576', $137 = '494482441', $138 = '89140058', $139 = '329373430', $140 = '363330055', $141 = '29982421', $142 = '277492775', $143 = '502456353', $144 = '119790135', $145 = '449833884', $146 = '473261214', $147 = '260801865', $148 = '272349783', $149 = '142144921', $150 = '306439618', $151 = '96736521', $152 = '97754007', $153 = '353578484', $154 = '402255307', $155 = '18287852', $156 = '214103585', $157 = '158832573', $158 = '83923348', $159 = '16499608', $160 = '87213639', $161 = '130088630', $162 = '90511247', $163 = '393392091', $164 = '224752617', $165 = '16130709', $166 = '382421751', $167 = '261831269', $168 = '22106639', $169 = '104918211', $170 = '139968525', $171 = '22156555', $172 = '501085660', $173 = '502043555', $174 = '17492939', $175 = '351306386', $176 = '85723075', $177 = '17140508', $178 = '191394424', $179 = '225839174', $180 = '15891145', $181 = '25712114', $182 = '444687176', $183 = '383960179', $184 = '21684027', $185 = '25185848', $186 = '50785229', $187 = '38735904', $188 = '36963296', $189 = '217111628', $190 = '292795360', $191 = '75930398', $192 = '322289993', $193 = '280069039', $194 = '125834480', $195 = '22023360', $196 = '515936283', $197 = '53066221', $198 = '33756927', $199 = '310411893', $200 = '42215526', $201 = '365670476', $202 = '419683030', $203 = '471242593', $204 = '245502476', $205 = '507591428', $206 = '285804058', $207 = '500707444', $208 = '88782126', $209 = '225902419', $210 = '393661964', $211 = '260948055', $212 = '425126925', $213 = '217475559', $214 = '22845410', $215 = '107876701', $216 = '256323275', $217 = '12648062', $218 = '236124651', $219 = '242777986', $220 = '20750719', $221 = '279725968', $222 = '34579323', $223 = '338349721', $224 = '303394568', $225 = '66924754', $226 = '233073653', $227 = '124295665', $228 = '125738923', $229 = '124338868', $230 = '53895499', $231 = '304244619', $232 = '197093366', $233 = '417912220', $234 = '291443816', $235 = '483206882', $236 = '14750909', $237 = '521810592', $238 = '48996036', $239 = '34541320', $240 = '267728489', $241 = '493258788', $242 = '40153677', $243 = '18400162', $244 = '226271034', $245 = '74840883', $246 = '249963553', $247 = '73998391', $248 = '273726968', $249 = '23542173', $250 = '336091537', $251 = '50013886', $252 = '111402543', $253 = '29893160', $254 = '313475126', $255 = '142339975', $256 = '460283478', $257 = '17787174', $258 = '496108277', $259 = '414466459', $260 = '129316450', $261 = '190233092', $262 = '413792072', $263 = '185354845', $264 = '284439426', $265 = '197572363', $266 = '424458947', $267 = '67115132', $268 = '98990eb0-2d40-11e1-a5ee-4040b4d10eb4'
2012-03-14 17:19:50.122 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:19:50.122 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(CarolineVogue05) already exists.
2012-03-14 17:19:50.122 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:19:51.417 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:19:51.417 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(jesseowens20) already exists.
2012-03-14 17:19:51.417 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:19:52.446 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:19:52.446 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - DETAIL: Key (screen_name)=(Keriiii_) already exists.
2012-03-14 17:19:52.446 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:17.179 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:17.179 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(_TwerkMyMonkey) already exists.
2012-03-14 17:20:17.179 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:19.236 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:19.236 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(OMGitsAdje) already exists.
2012-03-14 17:20:19.236 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:19.350 UTC - svanalytics@svanalytics_staging 6047 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:19.350 UTC - svanalytics@svanalytics_staging 6047 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(Drionnnna_) already exists.
2012-03-14 17:20:19.350 UTC - svanalytics@svanalytics_staging 6047 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:21.191 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:21.191 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(alison_nicollxo) already exists.
2012-03-14 17:20:21.191 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:22.524 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:22.524 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(_loveKWEEN) already exists.
2012-03-14 17:20:22.524 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:22.709 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:22.709 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(TweetyTwoop) already exists.
2012-03-14 17:20:22.709 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:24.443 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:24.443 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(LiviiTW_1D) already exists.
2012-03-14 17:20:24.443 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:25.181 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:25.181 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(JuanitaSavannah) already exists.
2012-03-14 17:20:25.181 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:26.518 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:26.518 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(_MrsWale) already exists.
2012-03-14 17:20:26.518 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:26.821 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:26.821 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - DETAIL: Key (screen_name)=(TasteMy_CoCo) already exists.
2012-03-14 17:20:26.821 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:27.551 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:27.551 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(shelbystrawson) already exists.
2012-03-14 17:20:27.551 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:28.435 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:28.435 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - DETAIL: Key (screen_name)=(Mavictoria093) already exists.
2012-03-14 17:20:28.435 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:28.857 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:28.857 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(DaNG3RRR) already exists.
2012-03-14 17:20:28.857 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:29.680 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:29.680 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - DETAIL: Key (screen_name)=(hannamarks182) already exists.
2012-03-14 17:20:29.680 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:30.361 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:30.361 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(annamande) already exists.
2012-03-14 17:20:30.361 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:31.175 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:31.175 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(REEZY_SHAGWELL) already exists.
2012-03-14 17:20:31.175 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:31.297 UTC - svanalytics@svanalytics_staging 6054 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:31.297 UTC - svanalytics@svanalytics_staging 6054 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(LilOL_DIamond) already exists.
2012-03-14 17:20:31.297 UTC - svanalytics@svanalytics_staging 6054 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:31.513 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:31.513 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - DETAIL: Key (screen_name)=(Freakytyo_O) already exists.
2012-03-14 17:20:31.513 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:32.524 UTC - svanalytics@svanalytics_staging 6039 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:32.524 UTC - svanalytics@svanalytics_staging 6039 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(she_PuLLiN) already exists.
2012-03-14 17:20:32.524 UTC - svanalytics@svanalytics_staging 6039 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:34.292 UTC - svanalytics@svanalytics_staging 6067 (23505) 2012-03-09 13:12:49 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:34.292 UTC - svanalytics@svanalytics_staging 6067 (23505) 2012-03-09 13:12:49 UTC - DETAIL: Key (screen_name)=(CurlyChopSuey) already exists.
2012-03-14 17:20:34.292 UTC - svanalytics@svanalytics_staging 6067 (23505) 2012-03-09 13:12:49 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:35.444 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:35.444 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(MarckyGoldchain) already exists.
2012-03-14 17:20:35.444 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:35.939 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:35.939 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - DETAIL: Key (screen_name)=(rath_nazh) already exists.
2012-03-14 17:20:35.939 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:36.236 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:36.236 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(hlenazailani) already exists.
2012-03-14 17:20:36.236 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:36.502 UTC - svanalytics@svanalytics_staging 9306 (00000) 2012-03-09 13:16:54 UTC - LOG: duration: 2424.015 ms execute <unnamed>: SELECT screen_name, persona_id FROM twitter_personas WHERE screen_name IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79)
2012-03-14 17:20:36.502 UTC - svanalytics@svanalytics_staging 9306 (00000) 2012-03-09 13:16:54 UTC - DETAIL: parameters: $1 = 'Gabi_neuro', $2 = 'lauralovesart', $3 = 'loriteo', $4 = 'PanAmSanjeev', $5 = 'loubeale11', $6 = 'paul123p', $7 = 'PanAmLaura', $8 = 'laurabaldini82', $9 = 'Itsmeoscar100', $10 = 'lizlizgee', $11 = 'mandy2911', $12 = 'Carina_Mendes', $13 = 'CRN_RFL', $14 = 'PanAmLove', $15 = 'anne_isenborghs', $16 = 'Claytor225', $17 = 'missabbie14', $18 = 'JordanLouisCole', $19 = 'PanAmBridget', $20 = 'exhiboy', $21 = 'GabzOnta1', $22 = 'sgsoutherngurl', $23 = 'leslierobert', $24 = 'hannebonte', $25 = 'WjCollins84', $26 = 'rarr19', $27 = 'icarolinam', $28 = 'paulwilson26a', $29 = 'PanAmMaggie', $30 = 'wmussell', $31 = 'JessicaBlack101', $32 = 'DannelDawson', $33 = 'panampodcast', $34 = 'Niky1105', $35 = 'untalisrael', $36 = 'rogerwiloughby', $37 = 'CharlesDawsone', $38 = 'trumpet72', $39 = 'MinuteofZombie', $40 = 'lottybuckby', $41 = 'OliviaCornwall', $42 = 'Balougraph1150', $43 = 'Samw69', $44 = 'Elliej27', $45 = 'Fernan2Andres', $46 = 'EriqMorales', $47 = 'Miss_143', $48 = 'kuprikov', $49 = 'chrisgubble', $50 = 'lovinkari', $51 = 'PanAmTed', $52 = 'declanhart1', $53 = 'ColetteFan22', $54 = 'idelyse', $55 = 'hellsbells932', $56 = 'JanickLandry', $57 = 'lulupoppies', $58 = 'SachaLangton', $59 = 'NuggetMill', $60 = 'ggblock', $61 = 'nanete', $62 = 'WorldWingsInter', $63 = 'm3alima', $64 = 'NatyHYBD', $65 = 'PanAm_MobWives', $66 = 'ElaineETYL', $67 = 'alisonjap', $68 = 'MissHavemeyer', $69 = 'carmenroxx', $70 = 'wrightbigdog', $71 = 'PanAmKate', $72 = 'dadaogongdang', $73 = 'PanAm_Fans', $74 = 'MaryK_Dancex', $75 = 'OwenCollier1', $76 = 'JoanneBrown1981', $77 = 'macauley22', $78 = 'starla37', $79 = 'PanAmDean'
2012-03-14 17:20:37.142 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:37.142 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - DETAIL: Key (screen_name)=(Gabi_neuro) already exists.
2012-03-14 17:20:37.142 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - STATEMENT: INSERT INTO twitter_personas(screen_name, location, description, followers_count, twitter_user_id, real_name, avatar_url, persona_id) VALUES ($1,$2,$3,$4,$5,$6,$7,$8)
2012-03-14 17:20:38.470 UTC - postgres@postgres 4782 (08P01) 2012-03-14 17:20:38 UTC - LOG: unexpected EOF on client connection
2012-03-14 17:20:39.649 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:39.649 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - DETAIL: Key (screen_name)=(AddictFantasy) already exists.
2012-03-14 17:20:39.649 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:40.028 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:40.028 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(NeedCofee) already exists.
2012-03-14 17:20:40.028 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:40.657 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:40.657 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - DETAIL: Key (screen_name)=(JeremyW55) already exists.
2012-03-14 17:20:40.657 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:40.746 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:40.746 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(GossipSutton) already exists.
2012-03-14 17:20:40.746 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:41.258 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:41.258 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(ObviousCunt) already exists.
2012-03-14 17:20:41.258 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:42.088 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:42.088 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - DETAIL: Key (screen_name)=(Jassy_Jayee) already exists.
2012-03-14 17:20:42.088 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:43.206 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:43.206 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - DETAIL: Key (screen_name)=(JuicyM0ntana) already exists.
2012-03-14 17:20:43.206 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:45.641 UTC - svanalytics@svanalytics_staging 6047 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:45.641 UTC - svanalytics@svanalytics_staging 6047 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(KristenDreamBIG) already exists.
2012-03-14 17:20:45.641 UTC - svanalytics@svanalytics_staging 6047 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:47.385 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:47.385 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(emmma98) already exists.
2012-03-14 17:20:47.385 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:47.967 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:47.967 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - DETAIL: Key (screen_name)=(SlickWitIt_) already exists.
2012-03-14 17:20:47.967 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:48.533 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:48.533 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - DETAIL: Key (screen_name)=(AnonymousKoNijn) already exists.
2012-03-14 17:20:48.533 UTC - svanalytics@svanalytics_staging 6065 (23505) 2012-03-09 13:12:49 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:48.626 UTC - svanalytics@svanalytics_staging 6067 (23505) 2012-03-09 13:12:49 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:48.626 UTC - svanalytics@svanalytics_staging 6067 (23505) 2012-03-09 13:12:49 UTC - DETAIL: Key (screen_name)=(Crazy4_CoCo) already exists.
2012-03-14 17:20:48.626 UTC - svanalytics@svanalytics_staging 6067 (23505) 2012-03-09 13:12:49 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:49.104 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:49.104 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - DETAIL: Key (screen_name)=(TWismystrength) already exists.
2012-03-14 17:20:49.104 UTC - svanalytics@svanalytics_staging 9306 (23505) 2012-03-09 13:16:54 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:51.926 UTC - svanalytics@svanalytics_staging 6054 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:51.926 UTC - svanalytics@svanalytics_staging 6054 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(arabdihh) already exists.
2012-03-14 17:20:51.926 UTC - svanalytics@svanalytics_staging 6054 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:52.572 UTC - svanalytics@svanalytics_staging 6039 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:52.572 UTC - svanalytics@svanalytics_staging 6039 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(GomezGolden) already exists.
2012-03-14 17:20:52.572 UTC - svanalytics@svanalytics_staging 6039 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:53.094 UTC - svanalytics@svanalytics_staging 6063 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:53.094 UTC - svanalytics@svanalytics_staging 6063 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(NotOnTwirrer) already exists.
2012-03-14 17:20:53.094 UTC - svanalytics@svanalytics_staging 6063 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:54.263 UTC - svanalytics@svanalytics_staging 6054 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:54.263 UTC - svanalytics@svanalytics_staging 6054 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(Kr_LockZ) already exists.
2012-03-14 17:20:54.263 UTC - svanalytics@svanalytics_staging 6054 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:55.416 UTC - svanalytics@svanalytics_staging 6058 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:55.416 UTC - svanalytics@svanalytics_staging 6058 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(CookAndTheFly) already exists.
2012-03-14 17:20:55.416 UTC - svanalytics@svanalytics_staging 6058 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:56.934 UTC - svanalytics@svanalytics_staging 6047 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:56.935 UTC - svanalytics@svanalytics_staging 6047 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(RobertEAvery) already exists.
2012-03-14 17:20:56.935 UTC - svanalytics@svanalytics_staging 6047 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:57.021 UTC - svanalytics@svanalytics_staging 6058 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:57.021 UTC - svanalytics@svanalytics_staging 6058 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(Wet_Ya_Sheets) already exists.
2012-03-14 17:20:57.021 UTC - svanalytics@svanalytics_staging 6058 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:58.534 UTC - svanalytics@svanalytics_staging 6063 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:58.534 UTC - svanalytics@svanalytics_staging 6063 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(AmusingSwift) already exists.
2012-03-14 17:20:58.534 UTC - svanalytics@svanalytics_staging 6063 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:20:59.806 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:20:59.806 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(FrankLloyd_NICE) already exists.
2012-03-14 17:20:59.806 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:21:01.270 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:21:01.270 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(MollieApple_TW) already exists.
2012-03-14 17:21:01.270 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:21:01.568 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:21:01.568 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(RellyOXO) already exists.
2012-03-14 17:21:01.568 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:21:02.449 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:21:02.449 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(_TheSalesman) already exists.
2012-03-14 17:21:02.449 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:21:03.514 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:21:03.514 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(illTweetEmRight) already exists.
2012-03-14 17:21:03.514 UTC - svanalytics@svanalytics_staging 6038 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:21:03.661 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:21:03.661 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - DETAIL: Key (screen_name)=(ASDFGHJKatyL) already exists.
2012-03-14 17:21:03.661 UTC - svanalytics@svanalytics_staging 6059 (23505) 2012-03-09 13:12:48 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:21:05.895 UTC - svanalytics@svanalytics_staging 6054 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:21:05.895 UTC - svanalytics@svanalytics_staging 6054 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(BitchUm_Juicy) already exists.
2012-03-14 17:21:05.895 UTC - svanalytics@svanalytics_staging 6054 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:21:11.118 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:21:11.118 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - DETAIL: Key (screen_name)=(katamaris) already exists.
2012-03-14 17:21:11.118 UTC - svanalytics@svanalytics_staging 6037 (23505) 2012-03-09 13:12:46 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
2012-03-14 17:21:11.340 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - ERROR: duplicate key value violates unique constraint "index_twitter_personas_on_screen_name"
2012-03-14 17:21:11.340 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - DETAIL: Key (screen_name)=(HoesDntGetWifed) already exists.
2012-03-14 17:21:11.340 UTC - svanalytics@svanalytics_staging 6042 (23505) 2012-03-09 13:12:47 UTC - STATEMENT: UPDATE twitter_personas SET persona_id = $1, screen_name = $2, location = $3, description = $4, followers_count = $5, real_name = $6, avatar_url = $7 WHERE persona_id = $8
Raw
postgresql.conf
# This bare file is configured for a dedicated machine with at least 8 GiB RAM.
#
#
# Memory units: kB = kilobytes Time units: ms = milliseconds
# MB = megabytes s = seconds
# GB = gigabytes min = minutes
# h = hours
# d = days
data_directory = '/var/lib/postgresql/9.1/main'
listen_addresses = '*'
port = 5432
max_connections = 120
# Expected to run on a 16GB machine
shared_buffers = 4GB
work_mem = 32MB
synchronous_commit = off
checkpoint_segments = 96
checkpoint_timeout = 10min
checkpoint_completion_target = 0.9
effective_cache_size = 6GB
maintenance_work_mem = 512MB
log_min_duration_statement = 2s
debug_print_plan = off
debug_pretty_print = on
log_checkpoints = on
log_line_prefix = '%m - %u@%d %p (%e) %s - '
datestyle = 'iso, mdy'
lc_messages = 'en_US.UTF-8'
lc_monetary = 'en_US.UTF-8'
lc_numeric = 'en_US.UTF-8'
lc_time = 'en_US.UTF-8'
default_text_search_config = 'pg_catalog.english'
# Master Configuration
archive_mode = on
wal_level = hot_standby
max_wal_senders = 3
wal_keep_segments = 256
archive_command = '/usr/local/bin/archive-wal %p /data/cloudfiles/dbanalytics.staging.internal/wal/'
Raw
vmstat.txt
# vmstat -S M 2 30
procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
0 8 23 84 70 13588 1 1 711 355 1 0 15 2 68 15
1 9 23 84 71 13581 0 0 6312 1604 3100 2498 6 3 49 42
1 12 23 97 71 13573 0 0 3302 12548 4065 2690 5 4 45 46
0 12 23 85 71 13582 0 0 3320 1040 2137 1678 4 2 50 44
0 10 23 85 71 13577 0 0 3964 3608 2606 1912 4 2 50 44
0 10 23 80 71 13580 0 0 3144 924 2103 1645 3 3 45 49
1 10 23 100 72 13568 0 0 5670 1604 3054 2341 17 3 40 39
1 8 23 85 72 13583 0 0 5680 3938 3403 2692 9 3 44 44
0 8 23 85 72 13582 0 0 4102 1440 3751 2927 7 3 49 41
1 10 23 93 72 13569 0 0 3772 2914 2758 2088 4 3 49 45
1 9 23 83 72 13575 0 0 2674 912 1947 1561 2 2 49 46
1 8 23 85 73 13571 0 0 5890 1732 3207 2657 9 3 51 37
1 8 23 86 74 13569 0 0 7150 3528 3156 2486 6 3 50 41
5 7 23 86 75 13559 0 0 6958 1564 3302 2720 7 3 47 43
0 9 23 83 76 13562 0 0 6624 11882 4611 3328 5 4 49 43
1 17 23 96 76 13544 0 0 5388 1300 2342 1904 4 2 48 45
0 10 23 93 77 13556 0 0 4022 3520 2570 2045 4 3 47 46
0 13 23 85 77 13560 0 0 4280 2064 2359 1839 3 2 45 49
0 10 23 87 78 13555 0 0 7278 1666 3336 2920 4 3 48 44
2 10 23 89 78 13544 0 0 8022 1692 3661 3167 6 4 49 41
0 14 23 95 79 13535 0 0 5866 4012 4029 2851 5 4 49 43
procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
0 10 23 82 79 13545 0 0 4092 972 2181 1698 3 2 50 44
0 8 23 88 79 13535 0 0 5796 3206 3304 2624 4 4 47 45
0 8 23 84 80 13538 0 0 6162 3042 3188 2576 4 4 44 47
2 8 23 85 81 13526 0 0 6534 2904 3397 2730 6 4 47 43
2 9 23 84 81 13524 0 0 3530 1324 4016 3147 7 5 39 50
0 9 23 107 81 13502 0 0 2620 10726 2481 1493 3 3 48 46
2 10 23 92 82 13516 0 0 6044 2664 3295 2553 5 4 44 47
0 9 23 81 82 13527 0 0 4514 1068 2800 2176 4 4 40 52
0 17 23 83 82 13525 0 0 2912 4004 2707 2091 4 4 40 51
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment