-
Overview
Global Stats
- 18,158 Number of unique normalized queries
- 518,681 Number of queries
- 27m20s Total query duration
- 2014-10-02 18:47:19 First query
- 2014-10-02 21:07:26 Last query
- 419 queries/s at 2014-10-02 20:10:15 Query peak
- 14 Number of events
- 3 Number of unique normalized events
- 9 Max number of times the same event was reported
- 3 Total number of automatic vacuums
- 7 Total number of automatic analyzes
- 2 Number temporary file
- 515,776,512 Max size of temporary file
- 515,379,200.00 Average size of temporary file
- 16,974 Total number of sessions
- 31 sessions at 2014-10-02 20:13:03 Session peak
- 1d7h47m38s Total duration of sessions
- 6s743ms Average duration of sessions
- 17,004 Total number of connections
- 97 connections/s at 2014-10-02 19:05:20 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 419 queries/s Query Peak
- 2014-10-02 20:10:15 Date
Queries per second (5 minutes average)
SELECT Traffic
Key values
- 86 queries/s Query Peak
- 2014-10-02 20:55:05 Date
SELECT queries per second (5 minutes average)
INSERT/UPDATE/DELETE Traffic
Key values
- 155 queries/s Query Peak
- 2014-10-02 20:10:22 Date
Write queries per second (5 minutes average)
Queries duration
Key values
- 27m20s Total query duration
Average queries duration (5 minutes average)
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
Ratio of bind vs prepare statements (5 minutes average)
General Activity
Day Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 02 18 40,400 0s 2s793ms 2ms 8s466ms 13s671ms 13s671ms 19 231,292 0s 1m40s 2ms 13s496ms 20s541ms 1m51s 20 218,356 0s 1m46s 3ms 17s714ms 21s885ms 1m57s 21 28,633 0s 12s36ms 5ms 55s815ms 55s815ms 55s815ms Day Hour Count Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 02 18 1,568 10ms 1s864ms 4s87ms 4s87ms 19 11,846 17ms 3s793ms 11s955ms 1m42s 20 10,271 19ms 3s328ms 4s480ms 1m48s 21 1,847 20ms 18s841ms 18s841ms 18s841ms Day Hour INSERT UPDATE DELETE Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 02 18 8,280 6 2,677 0s 240ms 290ms 3s12ms 19 46,070 82 14,730 0s 290ms 1s105ms 3s342ms 20 43,224 84 14,272 0s 277ms 362ms 3s436ms 21 5,476 123 1,657 0s 269ms 290ms 3s471ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 02 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% Day Hour Count Average / Second Oct 02 18 1,076 0.30/s 19 8,111 2.25/s 20 6,556 1.82/s 21 1,261 0.35/s Day Hour Count Average Duration Oct 02 18 1,065 1s664ms 19 8,103 4s693ms 20 6,559 10s84ms 21 1,247 6s823ms -
Connections
Established Connections
Key values
- 97 connections Connection Peak
- 2014-10-02 19:05:20 Date
Connections per second (5 minutes average)
Connections per database
Key values
- breakpad Main Database
- 17,004 connections Total
Connections per user
Key values
- breakpad_rw Main User
- 17,004 connections Total
-
Sessions
Simultaneous sessions
Key values
- 31 sessions Session Peak
- 2014-10-02 20:13:03 Date
Number of sessions (5 minutes average)
Sessions per database
Key values
- breakpad Main Database
- 16,974 sessions Total
Sessions per user
Key values
- breakpad_rw Main User
- 16,974 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 52,852 buffers Checkpoint Peak
- 2014-10-02 19:20:44 Date
- 150.033 seconds Highest write time
- 0.120 seconds Sync time
Checkpoint write buffers (5 minutes average)
Checkpoints Wal files
Key values
- 20 files Wal files usage Peak
- 2014-10-02 19:20:44 Date
Checkpoint Wal files usage (5 minutes average)
Checkpoints Activity
Day Hour Written buffers Write time Sync time Total time Oct 02 18 35,125 299.493s 0.061s 299.576s 19 247,333 1,798.359s 0.465s 1,798.875s 20 224,561 1,798.325s 0.447s 1,798.823s 21 29,606 297.754s 0.066s 297.828s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 02 18 0 0 16 116 0.034s 0s 19 0 0 106 793 0.081s 0.001s 20 0 0 98 775 0.044s 0.001s 21 0 0 13 95 0.027s 0s Day Hour Count Avg time (sec) Oct 02 18 0 0s 19 0 0s 20 0 0s 21 0 0s -
Temporary Files
Size of temporary files
Key values
- 491.88 MiB Temp Files Peak
- 2014-10-02 19:16:36 Date
Size of temporary files (5 minutes average)
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2014-10-02 20:21:39 Date
Number of temporary files (5 minutes average)
Temporary Files Activity
Day Hour Count Average size Oct 02 18 0 0 19 1 491.88 MiB 20 1 491.12 MiB 21 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 2 983.01 MiB 491.12 MiB 491.88 MiB 491.50 MiB SELECT * FROM update_reports_clean ( '' ::timestamptz );-
SELECT * FROM update_reports_clean ( '2014-10-02T17:28:24.657714+00:00' ::timestamptz );
-
SELECT * FROM update_reports_clean ( '2014-10-02T16:28:24.657714+00:00' ::timestamptz );
Duration: 1m46s
Database: breakpad
User: breakpad_rw
Remote: 10.8.70.203Duration: 1m40s
Database: breakpad
User: breakpad_rw
Remote: 10.8.70.203Queries generating the largest temporary files
Rank Size Query 1 491.88 MiB SELECT * FROM update_reports_clean ( '2014-10-02T16:28:24.657714+00:00' ::timestamptz );[ย Date: 2014-10-02 19:16:36 - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
2 491.12 MiB SELECT * FROM update_reports_clean ( '2014-10-02T17:28:24.657714+00:00' ::timestamptz );[ย Date: 2014-10-02 20:21:39 - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.43 sec Highest CPU-cost vacuum
Table public.reports_bad
Database breakpad - 2014-10-02 19:17:35 Date
- 30.55 sec Highest CPU-cost analyze
Table public.reports_20140929
Database breakpad - 2014-10-02 19:02:05 Date
Autovacuum actions (5 minutes average)
Analyses per table
Key values
- public.crontabber (2) Main table analyzed (database breakpad)
- 7 analyzes Total
Vacuums per table
Key values
- public.crontabber (2) Main table vacuumed on database breakpad
- 3 vacuums Total
Tuples removed per table
Key values
- public.reports_bad (2308) Main table with removed tuples on database breakpad
- 2432 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database
- 0 pages Total removed
Autovacuum Activity
Day Hour VACUUMs ANALYZEs Oct 02 18 0 0 19 2 6 20 1 1 21 0 0 - 0.43 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 25,532 Total read queries
- 136,681 Total write queries
Queries by database
Key values
- breakpad Main database
- 518,460 Requests
Queries by user
Key values
- processor Main user
- 458,469 Requests
Queries by host
Key values
- [local] Main host
- 465,390 Requests
Queries by application
Key values
- unknown Main application
- 518,511 Requests
Application Request type Count ""debug_file"": ""HcApi.pdb"" Total 1 ""debug_file"": ""IPSEng32.pdb"" Total 1 ""debug_id"": ""000000000000000000000000000000000""} Total 1 ""debug_id"": ""06DDDD5A12E4EF48365336D646CD22060""} Total 1 ""debug_id"": ""648BD7AA74708D693CBE9BF594087F880""} Total 1 ""debug_id"": ""98A8C704C646DF8F21669A2E600E24C50""} Total 1 ""debug_id"": ""A0183052C47E4652BFC983CC603C12442""} Total 1 ""debug_id"": ""A895A052F325481B9E2DA00A29E8D5DF2""} Total 1 ""debug_id"": ""CA9529136EF86A9A7093786C7D006D850""} Total 1 ""file"": ""f:\\dd\\vctools\\crt_bld\\self_x86\\crt\\src\\threadex.c"" Total 3 ""file"": ""hg:hg.mozilla.org/releases/mozilla-beta:ipc/chromium/src/base/message_loop.cc:9502b0a5c5f1"" Total 1 ""file"": ""hg:hg.mozilla.org/releases/mozilla-beta:nsprpub/pr/src/threads/combined/prucv.c:de4652503fb7"" Total 1 ""file"": ""hg:hg.mozilla.org/releases/mozilla-beta:xpcom/threads/nsThread.cpp:3a4f085a6398"" Total 1 ""file"": ""hg:hg.mozilla.org/releases/mozilla-beta:xpcom/threads/nsThread.cpp:c506a8413075"" Total 1 ""file"": ""hg:hg.mozilla.org/releases/mozilla-esr31:xpcom/threads/nsThread.cpp:81747568d309"" Total 1 ""file"": ""hg:hg.mozilla.org/releases/mozilla-release:ipc/chromium/src/base/message_loop.cc:e83766eb801d"" Total 1 ""file"": ""hg:hg.mozilla.org/releases/mozilla-release:nsprpub/pr/src/threads/combined/prulock.c:c88f138e4b4e"" Total 1 ""file"": ""hg:hg.mozilla.org/releases/mozilla-release:xpcom/threads/nsThread.cpp:c88f138e4b4e"" Total 1 ""filename"": ""Ubiquity"" Total 1 ""filename"": ""Verdana.ttf"" Total 1 ""filename"": ""ntmarta.dll"" Total 1 ""filename"": ""powrprof.dll"" Total 1 ""frame"": 1 Total 3 ""frame"": 10 Total 1 ""frame"": 14 Total 1 ""frame"": 2 Total 3 ""frame"": 25 Total 1 ""frame"": 4 Total 4 ""frame"": 5 Total 1 ""frame"": 8 Total 1 ""frame_count"": 15} Total 1 ""frame_count"": 17} Total 1 ""function_offset"": ""0x0"" Total 3 ""function_offset"": ""0x109"" Total 1 ""function_offset"": ""0x12"" Total 1 ""function_offset"": ""0x166"" Total 1 ""function_offset"": ""0x17"" Total 1 ""function_offset"": ""0x18"" Total 1 ""function_offset"": ""0x1a"" Total 1 ""function_offset"": ""0x2f"" Total 1 ""function_offset"": ""0x36"" Total 1 ""function_offset"": ""0x5f"" Total 1 ""function_offset"": ""0x61"" Total 1 ""function_offset"": ""0x6b"" Total 1 ""function_offset"": ""0xc"" Total 1 ""line"": 113 Total 1 ""line"": 172 Total 1 ""line"": 90 Total 1 ""loaded_symbols"": true Total 2 ""missing_symbols"": true Total 3 ""module"": ""KERNELBASE.dll"" Total 1 ""module"": ""XUL"" Total 1 ""module"": ""app_process"" Total 1 ""module"": ""dalvik-LinearAlloc (deleted)"" Total 2 ""module"": ""kernel32.dll"" Total 2 ""module"": ""libdvm.so"" Total 3 ""module"": ""libnss3.so"" Total 1 ""module"": ""libsystem_c.dylib"" Total 1 ""module"": ""libxul.so"" Total 1 ""module"": ""mozglue.dll"" Total 1 ""module"": ""msvcr100.dll"" Total 2 ""module"": ""nspr4.dll"" Total 1 ""module"": ""nss3.dll"" Total 1 ""module"": ""ntdll.dll"" Total 2 ""module"": ""tblive-4-core-x86-4.13.0.0.dll"" Total 1 ""module"": ""xul.dll"" Total 1 ""module_offset"": ""0x179b"" Total 1 ""module_offset"": ""0x1f70a"" Total 1 ""module_offset"": ""0x1fae7"" Total 1 ""module_offset"": ""0x20576"" Total 1 ""module_offset"": ""0x349d84"" Total 1 ""module_offset"": ""0x39f71"" Total 1 ""module_offset"": ""0x5b3f4"" Total 1 ""module_offset"": ""0xb712"" Total 1 ""module_offset"": ""0xe228"" Total 1 ""offset"": ""0x3a16dc"" Total 1 ""offset"": ""0x4007a282"" Total 1 ""offset"": ""0x401f5a07"" Total 1 ""offset"": ""0x4049d84"" Total 1 ""offset"": ""0x41716db6"" Total 1 ""offset"": ""0x5bf7f20a"" Total 1 ""offset"": ""0x5e2a1e6b"" Total 1 ""offset"": ""0x638e0089"" Total 1 ""offset"": ""0x649e8919"" Total 1 ""offset"": ""0x658fc6dd"" Total 1 ""offset"": ""0x67a0f4c7"" Total 1 ""offset"": ""0x682d698a"" Total 1 ""offset"": ""0x6a020576"" Total 1 ""offset"": ""0x6b53e228"" Total 1 ""offset"": ""0x6f96281f"" Total 1 ""offset"": ""0x7063ba81"" Total 1 ""offset"": ""0x75cbef91"" Total 1 ""offset"": ""0x773bee1b"" Total 1 ""offset"": ""0xcef70a"" Total 1 ""os_ver"": ""6.0.6002 Service Pack 2"" Total 1 ""trust"": ""cfi""} Total 5 ""trust"": ""cfi""}] Total 1 ""trust"": ""frame_pointer""}] Total 1 ""version"": """" Total 1 ""version"": ""10.0.30319.1"" Total 1 ""version"": ""7.0.7601.17744"" Total 1 nsIRunnable**)"" Total 1 {""base_addr"": ""0x52a60000"" Total 1 {""base_addr"": ""0x5d119000"" Total 1 {""base_addr"": ""0x77b10000"" Total 1 {""function"": ""BaseThreadInitThunk"" Total 1 {""function"": ""F2166389_____________________________________________________________________"" Total 1 {""function"": ""F96146851____________________________"" Total 1 {""function"": ""MessageLoop::Run()"" Total 1 {""function"": ""PseudoStack::sampleRuntime(JSRuntime *)"" Total 1 {""function"": ""WaitForSingleObjectEx"" Total 1 {""function"": ""_PR_WaitCondVar"" Total 1 {""function"": ""_callthreadstartex"" Total 2 {""function"": ""_threadstartex"" Total 1 {""function"": ""mozilla::CondVar::Wait(unsigned int)"" Total 1 {""function"": ""nsHostResolver::GetHostToLookup(nsHostRecord**)"" Total 1 {""version"": ""6.1.7601.17514"" Total 1 bool *)"" Total 1 char const * * Total 1 nsISupports * Total 1 psql Total 25 SELECT 14 unknown Total 518,511 DELETE 33,336 INSERT 103,050 SELECT 25,518 UPDATE 295 -
Top Queries
Histogram of query times
Key values
- 422,362 0-1ms duration
Slowest individual queries
Rank Duration Query 1 1m46s SELECT * FROM update_reports_clean ( '2014-10-02T17:28:24.657714+00:00' ::timestamptz );[ Date: 2014-10-02 20:21:52 - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
2 1m40s SELECT * FROM update_reports_clean ( '2014-10-02T16:28:24.657714+00:00' ::timestamptz );[ Date: 2014-10-02 19:16:47 - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
3 13s101ms WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];[ Date: 2014-10-02 20:25:07 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
4 12s36ms WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];[ Date: 2014-10-02 21:01:29 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
5 12s35ms WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];[ Date: 2014-10-02 20:23:05 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
6 7s442ms WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];[ Date: 2014-10-02 20:56:55 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
7 6s415ms WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];[ Date: 2014-10-02 20:57:03 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
8 6s408ms WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];[ Date: 2014-10-02 21:01:32 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
9 6s153ms WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];[ Date: 2014-10-02 21:02:00 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
10 6s70ms WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];[ Date: 2014-10-02 20:23:11 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
11 5s857ms /* EXTERNAL.postgresql.crashes.Crashes.get_fequency */ SELECT r.build AS build_date, count ( CASE WHEN ( r.signature = 'OOM | small' ) THEN 1 END ) AS count, CAST ( count ( CASE WHEN ( r.signature = 'OOM | small' ) THEN 1 END ) [...];[ Date: 2014-10-02 21:02:18 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
12 4s196ms /* socorro.external.postgresql.report.Report.list */ SELECT r.date_processed, r.uptime, r.user_comments, r.uuid ::uuid, r.uuid AS uuid_text, r.product, r.version, [...];[ Date: 2014-10-02 21:02:16 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
13 4s126ms WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];[ Date: 2014-10-02 21:00:48 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
14 3s655ms SELECT * FROM update_reports_duplicates ( '2014-10-02T16:28:19.183999+00:00' ::timestamptz, '2014-10-02T17:28:19.183999+00:00' ::timestamptz );[ Date: 2014-10-02 20:10:08 - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
15 3s588ms WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];[ Date: 2014-10-02 20:57:07 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
16 3s490ms WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];[ Date: 2014-10-02 21:01:33 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
17 3s478ms WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];[ Date: 2014-10-02 21:01:53 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
18 3s405ms /* EXTERNAL.postgresql.crashes.Crashes.get_comments */ SELECT count ( r.uuid ) FROM reports r WHERE r.date_processed BETWEEN '2014-09-25T19:29:50.834175+00:00' ::timestamptz AND '2014-10-02T19:29:50.834175+00:00' ::timestamptz AND r.signature = R [...];[ Date: 2014-10-02 19:29:54 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
19 3s299ms WITH crashes AS ( SELECT os_version_string AS category, sum ( report_count ) AS report_count FROM signature_summary_os JOIN signatures USING ( signature_id ) WHERE signatur [...];[ Date: 2014-10-02 20:58:49 - Database: breakpad - User: breakpad_rw - Remote: [local] ]
20 3s297ms SELECT * FROM update_reports_duplicates ( '2014-10-02T15:28:19.183999+00:00' ::timestamptz, '2014-10-02T16:28:19.183999+00:00' ::timestamptz );[ Date: 2014-10-02 19:05:08 - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 3m26s 2 1m40s 1m46s 1m43s SELECT * FROM update_reports_clean ( '' ::timestamptz );Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 02 19 1 1m40s 1m40s 20 1 1m46s 1m46s -
SELECT * FROM update_reports_clean ( '2014-10-02T17:28:24.657714+00:00' ::timestamptz );
-
SELECT * FROM update_reports_clean ( '2014-10-02T16:28:24.657714+00:00' ::timestamptz );
[ Date: 2014-10-02 20:21:52 - Duration: 1m46s - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 19:16:47 - Duration: 1m40s - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
2 2m54s 8,079 1ms 984ms 21ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 service pack 0 ncpu | x80 | genuineintel family 0 model 0 stepping 0 | 0 ncrash [...];Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 02 18 678 15s168ms 22ms 19 3,612 1m15s 20ms 20 3,394 1m15s 22ms 21 395 8s320ms 21ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:17:10.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 42 stepping 7 | 8 nCrash [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:43:39.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 60 stepping 3 | 4 nCrash [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:29:32.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 42 stepping 7 | 4 nCrash [...];
[ Date: 2014-10-02 20:18:26 - Duration: 984ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:44:31 - Duration: 720ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:30:08 - Duration: 647ms - Database: breakpad - User: processor - Remote: [local] ]
3 2m10s 100 1ms 13s101ms 1s306ms WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 02 19 8 4s312ms 539ms 20 26 1m5s 2s522ms 21 66 1m 919ms -
WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];
-
WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];
-
WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];
[ Date: 2014-10-02 20:25:07 - Duration: 13s101ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
[ Date: 2014-10-02 21:01:29 - Duration: 12s36ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
[ Date: 2014-10-02 20:23:05 - Duration: 12s35ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
4 1m18s 3,862 1ms 619ms 20ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 service pack 0 ncpu | x80 | genuineintel family 0 model 0 stepping 0 | 0 ncras [...];Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 02 18 317 6s561ms 20ms 19 1,710 33s327ms 19ms 20 1,659 34s406ms 20ms 21 176 3s734ms 21ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:29:17.000000", "hang_type" : 0, "dump" : OS | Windows NT | 5.1.2600 Service Pack 3 nCPU | x86 | GenuineIntel family 6 model 23 stepping 10 | 2 nCras [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:29:46.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 23 stepping 10 | 2 nCras [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:13:55.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 28 stepping 10 | 2 nCras [...];
[ Date: 2014-10-02 20:30:08 - Duration: 619ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:30:08 - Duration: 486ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:30:08 - Duration: 290ms - Database: breakpad - User: processor - Remote: [local] ]
5 1m8s 1,642 3ms 320ms 41ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "pluginfilename" : "npswf30_10_0_0_10.dll", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 service pack 0 ncpu | x80 | genui [...];Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 02 18 126 5s512ms 43ms 19 748 30s769ms 41ms 20 674 28s216ms 41ms 21 94 4s86ms 43ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:47:02.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | Genui [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:01:42.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | Genui [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:03:25.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | Genui [...];
[ Date: 2014-10-02 18:48:16 - Duration: 320ms - Database: breakpad - User: processor - Remote: [local] - Application: ""offset"": ""0x5bf7f20a"" ]
[ Date: 2014-10-02 19:05:09 - Duration: 167ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:05:04 - Duration: 148ms - Database: breakpad - User: processor - Remote: [local] ]
6 49s849ms 280 109ms 225ms 178ms SELECT 0 FROM performance_check_1;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 02 18 24 4s169ms 173ms 19 120 21s414ms 178ms 20 120 21s455ms 178ms 21 16 2s809ms 175ms -
SELECT 1 FROM performance_check_1;
-
SELECT 1 FROM performance_check_1;
-
SELECT 1 FROM performance_check_1;
[ Date: 2014-10-02 20:25:04 - Duration: 225ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
[ Date: 2014-10-02 20:12:03 - Duration: 224ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
[ Date: 2014-10-02 21:05:06 - Duration: 209ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
7 47s838ms 16 2s761ms 3s171ms 2s989ms INSERT INTO server_status ( date_recently_completed, date_oldest_job_queued, avg_process_sec, avg_wait_sec, waiting_job_count, processors_count, date_created ) SELECT ( SELECT max ( r.completed_datetime ) FROM reports_20 r ) AS date_recently_completed, [...];Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 02 18 1 2s793ms 2s793ms 19 8 23s554ms 2s944ms 20 6 18s318ms 3s53ms 21 1 3s171ms 3s171ms -
INSERT INTO server_status ( date_recently_completed, date_oldest_job_queued, avg_process_sec, avg_wait_sec, waiting_job_count, processors_count, date_created ) SELECT ( SELECT MAX ( r.completed_datetime ) FROM reports_20140929 r ) AS date_recently_completed, [...];
-
INSERT INTO server_status ( date_recently_completed, date_oldest_job_queued, avg_process_sec, avg_wait_sec, waiting_job_count, processors_count, date_created ) SELECT ( SELECT MAX ( r.completed_datetime ) FROM reports_20140929 r ) AS date_recently_completed, [...];
-
INSERT INTO server_status ( date_recently_completed, date_oldest_job_queued, avg_process_sec, avg_wait_sec, waiting_job_count, processors_count, date_created ) SELECT ( SELECT MAX ( r.completed_datetime ) FROM reports_20140929 r ) AS date_recently_completed, [...];
[ Date: 2014-10-02 21:00:13 - Duration: 3s171ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 19:55:10 - Duration: 3s145ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 20:00:12 - Duration: 3s139ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
8 40s667ms 2,315 10ms 26ms 17ms SELECT column_name FROM information_schema.columns WHERE table_name = '' AND column_name = '';Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 02 18 179 3s141ms 17ms 19 991 17s438ms 17ms 20 961 16s860ms 17ms 21 184 3s226ms 17ms -
SELECT column_name FROM information_schema.columns WHERE table_name = 'crontabber' AND column_name = 'ongoing';
-
SELECT column_name FROM information_schema.columns WHERE table_name = 'crontabber' AND column_name = 'ongoing';
-
SELECT column_name FROM information_schema.columns WHERE table_name = 'crontabber' AND column_name = 'ongoing';
[ Date: 2014-10-02 21:00:08 - Duration: 26ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 20:30:08 - Duration: 25ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 19:10:07 - Duration: 25ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
9 37s985ms 1,884 2ms 313ms 20ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 ncpu | x80 | genuineintel family 0 model 0 stepping 0 | 0 ncrash | exception_acc [...];Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 02 18 138 3s41ms 22ms 19 847 16s671ms 19ms 20 781 16s69ms 20ms 21 118 2s203ms 18ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 21:48:27.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.2.9200 nCPU | x86 | GenuineIntel family 6 model 58 stepping 9 | 2 nCrash | EXCEPTION_ACC [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:03:41.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.3.9600 nCPU | x86 | GenuineIntel family 6 model 60 stepping 3 | 4 nCrash | EXCEPTION_ACC [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:49:33.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.3.9600 nCPU | x86 | GenuineIntel family 6 model 58 stepping 9 | 8 nCrash | EXCEPTION_ACC [...];
[ Date: 2014-10-02 20:39:05 - Duration: 313ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:16:50 - Duration: 313ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 18:50:18 - Duration: 305ms - Database: breakpad - User: processor - Remote: [local] ]
10 32s972ms 97,720 0s 384ms 0s INSERT INTO extensions_20 ( report_id, date_processed, extension_key, extension_id, extension_version ) VALUES ( 0, '' ::timestamptz, 0, '', '' );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 02 18 7,836 2s625ms 0s 19 43,796 14s424ms 0s 20 40,974 14s207ms 0s 21 5,114 1s714ms 0s -
INSERT INTO extensions_20140929 ( report_id, date_processed, extension_key, extension_id, extension_version ) VALUES ( 718677463, '2014-10-02T20:22:49.558777+00:00' ::timestamptz, 1, '{972ce4c6-7e08-4474-a285-3208198ce6fd}', '32.0.3' );
-
INSERT INTO extensions_20140929 ( report_id, date_processed, extension_key, extension_id, extension_version ) VALUES ( 718680438, '2014-10-02T20:35:28.654663+00:00' ::timestamptz, 0, '{20a82645-c095-46ed-80e3-08825760534b}', '0.0.0' );
-
INSERT INTO extensions_20140929 ( report_id, date_processed, extension_key, extension_id, extension_version ) VALUES ( 718679145, '2014-10-02T20:30:05.434157+00:00' ::timestamptz, 0, '{972ce4c6-7e08-4474-a285-3208198ce6fd}', '3.6.8' );
[ Date: 2014-10-02 20:23:04 - Duration: 384ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:35:37 - Duration: 106ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:30:17 - Duration: 92ms - Database: breakpad - User: processor - Remote: [local] ]
11 31s856ms 1,475 2ms 205ms 21ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 service pack 0 ncpu | x80 | authenticamd family 0 model 0 stepping 0 | 0 ncrash [...];Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 02 18 126 2s515ms 19ms 19 642 13s796ms 21ms 20 613 13s433ms 21ms 21 94 2s111ms 22ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:35:22.000000", "hang_type" : 0, "dump" : OS | Windows NT | 5.1.2600 Service Pack 3 nCPU | x86 | AuthenticAMD family 16 model 2 stepping 3 | 3 nCrash [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:35:03.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | AuthenticAMD family 16 model 6 stepping 3 | 2 nCrash [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:03:05.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | AuthenticAMD family 20 model 1 stepping 0 | 1 nCrash [...];
[ Date: 2014-10-02 20:35:37 - Duration: 205ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:35:21 - Duration: 189ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:03:53 - Duration: 179ms - Database: breakpad - User: processor - Remote: [local] ]
12 29s868ms 85,409 0s 47ms 0s COMMIT;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 02 18 6,493 2s135ms 0s 19 37,900 13s579ms 0s 20 36,429 12s680ms 0s 21 4,587 1s473ms 0s -
COMMIT;
-
COMMIT;
-
COMMIT;
[ Date: 2014-10-02 20:28:39 - Duration: 47ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:42:00 - Duration: 46ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:51:50 - Duration: 43ms - Database: breakpad - User: processor - Remote: [local] ]
13 27s775ms 696 5ms 173ms 39ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "pluginfilename" : "npswf30_10_0_0_10.dll", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 ncpu | x80 | genuineintel family [...];Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 02 18 97 4s335ms 44ms 19 266 10s629ms 39ms 20 295 11s391ms 38ms 21 38 1s419ms 37ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:29:35.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.2.9200 nCPU | x86 | GenuineIntel family [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:32:27.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7600 nCPU | x86 | GenuineIntel family [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:50:04.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.2.9200 nCPU | x86 | GenuineIntel family [...];
[ Date: 2014-10-02 18:51:54 - Duration: 173ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:36:36 - Duration: 104ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:20:31 - Duration: 91ms - Database: breakpad - User: processor - Remote: [local] ]
14 21s608ms 1,120 2ms 62ms 19ms SELECT sum ( pg_relation_size ( tablename::text ) ) FROM pg_tables WHERE tablename LIKE '';Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 02 18 96 1s911ms 19ms 19 480 9s252ms 19ms 20 480 9s194ms 19ms 21 64 1s248ms 19ms -
SELECT sum ( pg_relation_size ( tablename::text ) ) FROM pg_tables WHERE tablename LIKE 'reports%';
-
SELECT sum ( pg_relation_size ( tablename::text ) ) FROM pg_tables WHERE tablename LIKE 'reports%';
-
SELECT sum ( pg_relation_size ( tablename::text ) ) FROM pg_tables WHERE tablename LIKE 'reports%';
[ Date: 2014-10-02 20:21:03 - Duration: 62ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
[ Date: 2014-10-02 20:45:05 - Duration: 59ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
[ Date: 2014-10-02 19:18:01 - Duration: 58ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
15 20s796ms 778 3ms 699ms 26ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 ncpu | x80 | genuineintel family 0 model 0 stepping 0 | 0 ncrash | exception_bre [...];Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 02 18 70 1s568ms 22ms 19 362 9s4ms 24ms 20 303 9s219ms 30ms 21 43 1s3ms 23ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:26:42.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.2.9200 nCPU | x86 | GenuineIntel family 6 model 42 stepping 7 | 2 nCrash | EXCEPTION_BRE [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:03:06.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.2.9200 nCPU | x86 | GenuineIntel family 6 model 42 stepping 7 | 4 nCrash | EXCEPTION_BRE [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:32:05.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7600 nCPU | x86 | GenuineIntel family 6 model 37 stepping 5 | 2 nCrash | EXCEPTION_BRE [...];
[ Date: 2014-10-02 20:28:34 - Duration: 699ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:26:32 - Duration: 427ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:34:22 - Duration: 415ms - Database: breakpad - User: processor - Remote: [local] ]
16 13s733ms 723 2ms 113ms 18ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 ncpu | x80 | genuineintel family 0 model 0 stepping 0 | 0 ncrash | exception_ac [...];Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 02 18 63 1s327ms 21ms 19 331 6s391ms 19ms 20 292 5s287ms 18ms 21 37 727ms 19ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:50:56.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7600 nCPU | x86 | GenuineIntel family 6 model 23 stepping 10 | 2 nCrash | EXCEPTION_AC [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:44:16.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7600 nCPU | x86 | GenuineIntel family 6 model 15 stepping 11 | 4 nCrash | EXCEPTION_AC [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:50:53.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.3.9600 nCPU | x86 | GenuineIntel family 6 model 23 stepping 10 | 4 nCrash | EXCEPTION_AC [...];
[ Date: 2014-10-02 18:52:00 - Duration: 113ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:44:41 - Duration: 50ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 18:51:26 - Duration: 38ms - Database: breakpad - User: processor - Remote: [local] ]
17 12s861ms 4 2s841ms 3s655ms 3s215ms SELECT * FROM update_reports_duplicates ( '' ::timestamptz, '' ::timestamptz );Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 02 19 2 6s139ms 3s69ms 20 2 6s722ms 3s361ms -
SELECT * FROM update_reports_duplicates ( '2014-10-02T16:28:19.183999+00:00' ::timestamptz, '2014-10-02T17:28:19.183999+00:00' ::timestamptz );
-
SELECT * FROM update_reports_duplicates ( '2014-10-02T15:28:19.183999+00:00' ::timestamptz, '2014-10-02T16:28:19.183999+00:00' ::timestamptz );
-
SELECT * FROM update_reports_duplicates ( '2014-10-02T16:58:19.183999+00:00' ::timestamptz, '2014-10-02T17:58:19.183999+00:00' ::timestamptz );
[ Date: 2014-10-02 20:10:08 - Duration: 3s655ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 19:05:08 - Duration: 3s297ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 20:10:11 - Duration: 3s66ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
18 12s658ms 140 53ms 219ms 90ms SELECT avg ( avg_wait_sec ) FROM server_status;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 02 18 12 1s74ms 89ms 19 60 5s395ms 89ms 20 60 5s465ms 91ms 21 8 722ms 90ms -
SELECT avg ( avg_wait_sec ) FROM server_status;
-
SELECT avg ( avg_wait_sec ) FROM server_status;
-
SELECT avg ( avg_wait_sec ) FROM server_status;
[ Date: 2014-10-02 20:25:05 - Duration: 219ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
[ Date: 2014-10-02 19:54:03 - Duration: 106ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
[ Date: 2014-10-02 20:37:05 - Duration: 102ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
19 12s631ms 318 5ms 143ms 39ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "pluginfilename" : "npswf30_10_0_0_10.dll", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 service pack 0 ncpu | x80 | authe [...];Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 02 18 30 1s271ms 42ms 19 119 4s636ms 38ms 20 147 5s822ms 39ms 21 22 900ms 40ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:33:06.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | Authe [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:16:35.000000", "PluginFilename" : "NPSWF32_14_0_0_179.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.0.6002 Service Pack 2 nCPU | x86 | Authe [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:07:57.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | Authe [...];
[ Date: 2014-10-02 20:10:04 - Duration: 143ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:20:01 - Duration: 102ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:08:25 - Duration: 89ms - Database: breakpad - User: processor - Remote: [local] ]
20 12s498ms 28 15ms 4s196ms 446ms SELECT r.date_processed, r.uptime, r.user_comments, r.uuid ::uuid, r.uuid AS uuid_text, r.product, r.version, [...];Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 02 19 6 4s288ms 714ms 20 12 1s562ms 130ms 21 10 6s646ms 664ms -
/* socorro.external.postgresql.report.Report.list */ SELECT r.date_processed, r.uptime, r.user_comments, r.uuid ::uuid, r.uuid AS uuid_text, r.product, r.version, [...];
-
/* socorro.external.postgresql.report.Report.list */ SELECT r.date_processed, r.uptime, r.user_comments, r.uuid ::uuid, r.uuid AS uuid_text, r.product, r.version, [...];
-
/* socorro.external.postgresql.report.Report.list */ SELECT r.date_processed, r.uptime, r.user_comments, r.uuid ::uuid, r.uuid AS uuid_text, r.product, r.version, [...];
[ Date: 2014-10-02 21:02:16 - Duration: 4s196ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
[ Date: 2014-10-02 19:29:56 - Duration: 2s291ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
[ Date: 2014-10-02 19:29:56 - Duration: 1s350ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 97,720 32s972ms 0s 384ms 0s INSERT INTO extensions_20 ( report_id, date_processed, extension_key, extension_id, extension_version ) VALUES ( 0, '' ::timestamptz, 0, '', '' );Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 02 18 7,836 2s625ms 0s 19 43,796 14s424ms 0s 20 40,974 14s207ms 0s 21 5,114 1s714ms 0s -
INSERT INTO extensions_20140929 ( report_id, date_processed, extension_key, extension_id, extension_version ) VALUES ( 718677463, '2014-10-02T20:22:49.558777+00:00' ::timestamptz, 1, '{972ce4c6-7e08-4474-a285-3208198ce6fd}', '32.0.3' );
-
INSERT INTO extensions_20140929 ( report_id, date_processed, extension_key, extension_id, extension_version ) VALUES ( 718680438, '2014-10-02T20:35:28.654663+00:00' ::timestamptz, 0, '{20a82645-c095-46ed-80e3-08825760534b}', '0.0.0' );
-
INSERT INTO extensions_20140929 ( report_id, date_processed, extension_key, extension_id, extension_version ) VALUES ( 718679145, '2014-10-02T20:30:05.434157+00:00' ::timestamptz, 0, '{972ce4c6-7e08-4474-a285-3208198ce6fd}', '3.6.8' );
[ Date: 2014-10-02 20:23:04 - Duration: 384ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:35:37 - Duration: 106ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:30:17 - Duration: 92ms - Database: breakpad - User: processor - Remote: [local] ]
2 91,503 4s276ms 0s 2ms 0s BEGIN;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 02 18 6,797 302ms 0s 19 41,342 1s973ms 0s 20 38,313 1s741ms 0s 21 5,051 259ms 0s -
BEGIN;
-
BEGIN;
-
BEGIN;
[ Date: 2014-10-02 20:21:07 - Duration: 2ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:22:03 - Duration: 0s - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:10:23 - Duration: 0s - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
3 85,409 29s868ms 0s 47ms 0s COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 02 18 6,493 2s135ms 0s 19 37,900 13s579ms 0s 20 36,429 12s680ms 0s 21 4,587 1s473ms 0s -
COMMIT;
-
COMMIT;
-
COMMIT;
[ Date: 2014-10-02 20:28:39 - Duration: 47ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:42:00 - Duration: 46ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:51:50 - Duration: 43ms - Database: breakpad - User: processor - Remote: [local] ]
4 71,282 3s875ms 0s 0s 0s DISCARD ALL;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 02 18 5,802 318ms 0s 19 31,545 1s714ms 0s 20 30,087 1s630ms 0s 21 3,848 212ms 0s -
DISCARD ALL;
-
DISCARD ALL;
-
DISCARD ALL;
[ Date: 2014-10-02 19:17:32 - Duration: 0s - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 21:02:53 - Duration: 0s - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:48:39 - Duration: 0s - Database: breakpad - User: processor - Remote: [local] ]
5 26,741 4s858ms 0s 14ms 0s DELETE FROM extensions_20 WHERE report_id = 0;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 02 18 2,238 409ms 0s 19 11,823 2s157ms 0s 20 11,305 2s38ms 0s 21 1,375 252ms 0s -
DELETE FROM extensions_20140811 WHERE report_id = 718664884;
-
DELETE FROM extensions_20140929 WHERE report_id = 718670566;
-
DELETE FROM extensions_20140929 WHERE report_id = 718672850;
[ Date: 2014-10-02 19:35:55 - Duration: 14ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:56:54 - Duration: 0s - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:05:05 - Duration: 0s - Database: breakpad - User: processor - Remote: [local] ]
6 8,079 2m54s 1ms 984ms 21ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 service pack 0 ncpu | x80 | genuineintel family 0 model 0 stepping 0 | 0 ncrash [...];Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 02 18 678 15s168ms 22ms 19 3,612 1m15s 20ms 20 3,394 1m15s 22ms 21 395 8s320ms 21ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:17:10.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 42 stepping 7 | 8 nCrash [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:43:39.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 60 stepping 3 | 4 nCrash [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:29:32.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 42 stepping 7 | 4 nCrash [...];
[ Date: 2014-10-02 20:18:26 - Duration: 984ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:44:31 - Duration: 720ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:30:08 - Duration: 647ms - Database: breakpad - User: processor - Remote: [local] ]
7 5,105 926ms 0s 20ms 0s DELETE FROM plugins_reports_20 WHERE report_id = 0;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 02 18 438 77ms 0s 19 2,201 390ms 0s 20 2,187 407ms 0s 21 279 51ms 0s -
DELETE FROM plugins_reports_20140929 WHERE report_id = 718682524;
-
DELETE FROM plugins_reports_20140929 WHERE report_id = 718687784;
-
DELETE FROM plugins_reports_20140929 WHERE report_id = 718684737;
[ Date: 2014-10-02 20:43:54 - Duration: 20ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 21:05:39 - Duration: 0s - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:53:05 - Duration: 0s - Database: breakpad - User: processor - Remote: [local] ]
8 5,105 3s258ms 0s 26ms 0s INSERT INTO plugins_reports_20 ( report_id, plugin_id, date_processed, version ) VALUES ( 0, 0, '' ::timestamptz, '' );Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 02 18 438 270ms 0s 19 2,201 1s416ms 0s 20 2,187 1s396ms 0s 21 279 174ms 0s -
INSERT INTO plugins_reports_20140929 ( report_id, plugin_id, date_processed, version ) VALUES ( 718677926, 20659420, '2014-10-02T20:24:52.805374+00:00' ::timestamptz, '15.0.0.152' );
-
INSERT INTO plugins_reports_20140929 ( report_id, plugin_id, date_processed, version ) VALUES ( 718656585, 20657041, '2014-10-02T19:05:53.528023+00:00' ::timestamptz, '1.0.0.0' );
-
INSERT INTO plugins_reports_20140929 ( report_id, plugin_id, date_processed, version ) VALUES ( 718658163, 20656671, '2014-10-02T19:11:38.442948+00:00' ::timestamptz, '8.2.10.911' );
[ Date: 2014-10-02 20:25:04 - Duration: 26ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:06:09 - Duration: 19ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:11:50 - Duration: 16ms - Database: breakpad - User: processor - Remote: [local] ]
9 5,105 1s531ms 0s 9ms 0s SELECT id FROM plugins WHERE filename = '' AND name = '';Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 02 18 438 130ms 0s 19 2,201 651ms 0s 20 2,187 662ms 0s 21 279 87ms 0s -
SELECT id FROM plugins WHERE filename = 'npDeepView.dll' AND name = 'SAP Visual Enterprise Viewer';
-
SELECT id FROM plugins WHERE filename = 'npdivx32.dll' AND name = 'DivX Plus Web Player';
-
SELECT id FROM plugins WHERE filename = 'npSAFARIMontagePlayer.dll' AND name = '';
[ Date: 2014-10-02 19:25:44 - Duration: 9ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:17:39 - Duration: 9ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:06:13 - Duration: 7ms - Database: breakpad - User: processor - Remote: [local] ]
10 4,630 6s772ms 0s 208ms 1ms SELECT relname FROM pg_class WHERE relname = '';Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 02 18 358 512ms 1ms 19 1,982 2s808ms 1ms 20 1,922 2s928ms 1ms 21 368 523ms 1ms -
SELECT relname FROM pg_class WHERE relname = 'crontabber';
-
SELECT relname FROM pg_class WHERE relname = 'crontabber';
-
SELECT relname FROM pg_class WHERE relname = 'crontabber';
[ Date: 2014-10-02 20:35:06 - Duration: 208ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 20:35:41 - Duration: 2ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 19:10:06 - Duration: 2ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
11 4,174 4s137ms 0s 158ms 0s WITH update_raw_crash AS ( UPDATE raw_crashes_20 SET raw_crash = "totalpagefile" : "0", "useragent_locale" : "en-us", "totalphysicalmemory" : "0", "framepoisonsize" : "0", "totalvirtualmemory" : "0", "breakpadreserveaddress" : 0 [...];Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 02 18 338 321ms 0s 19 1,806 1s866ms 1ms 20 1,789 1s723ms 0s 21 241 226ms 0s -
WITH update_raw_crash AS ( UPDATE raw_crashes_20140929 SET raw_crash = "TotalPageFile" : "15512920064", "useragent_locale" : "en-US", "TotalPhysicalMemory" : "12828565504", "FramePoisonSize" : "65536", "TotalVirtualMemory" : "4294836224", "BreakpadReserveAddress" : 4 [...];
-
WITH update_raw_crash AS ( UPDATE raw_crashes_20140908 SET raw_crash = "TotalPageFile" : "4051402752", "useragent_locale" : "en-US", "TotalPhysicalMemory" : "1992146944", "FramePoisonSize" : "65536", "TotalVirtualMemory" : "4294836224", "BreakpadReserveAddress" : 483 [...];
-
WITH update_raw_crash AS ( UPDATE raw_crashes_20140929 SET raw_crash = "TotalPageFile" : "5160906752", "useragent_locale" : "en-US", "TotalPhysicalMemory" : "3184435200", "FramePoisonSize" : "65536", "TotalVirtualMemory" : "2147352576", "BreakpadReserveAddress" : 692 [...];
[ Date: 2014-10-02 19:48:24 - Duration: 158ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:30:25 - Duration: 23ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:59:59 - Duration: 10ms - Database: breakpad - User: processor - Remote: [local] ]
12 3,862 1m18s 1ms 619ms 20ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 service pack 0 ncpu | x80 | genuineintel family 0 model 0 stepping 0 | 0 ncras [...];Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 02 18 317 6s561ms 20ms 19 1,710 33s327ms 19ms 20 1,659 34s406ms 20ms 21 176 3s734ms 21ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:29:17.000000", "hang_type" : 0, "dump" : OS | Windows NT | 5.1.2600 Service Pack 3 nCPU | x86 | GenuineIntel family 6 model 23 stepping 10 | 2 nCras [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:29:46.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 23 stepping 10 | 2 nCras [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:13:55.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 28 stepping 10 | 2 nCras [...];
[ Date: 2014-10-02 20:30:08 - Duration: 619ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:30:08 - Duration: 486ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:30:08 - Duration: 290ms - Database: breakpad - User: processor - Remote: [local] ]
13 3,399 3s436ms 0s 82ms 1ms WITH update_raw_crash AS ( UPDATE raw_crashes_20 SET raw_crash = "totalpagefile" : "0", "installtime" : "0", "totalphysicalmemory" : "0", "framepoisonsize" : "0", "totalvirtualmemory" : "0", "breakpadreserveaddress" : 0 [...];Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 02 18 287 281ms 0s 19 1,567 1s567ms 1ms 20 1,373 1s412ms 1ms 21 172 175ms 1ms -
WITH update_raw_crash AS ( UPDATE raw_crashes_20140929 SET raw_crash = "TotalPageFile" : "4121423872", "InstallTime" : "1411664290", "TotalPhysicalMemory" : "2136514560", "FramePoisonSize" : "65536", "TotalVirtualMemory" : "2147352576", "BreakpadReserveAddress" : 518 [...];
-
WITH update_raw_crash AS ( UPDATE raw_crashes_20140922 SET raw_crash = "TotalPageFile" : "5892980736", "InstallTime" : "1410819170", "TotalPhysicalMemory" : "2947444736", "FramePoisonSize" : "65536", "TotalVirtualMemory" : "4294836224", "BreakpadReserveAddress" : 410 [...];
-
WITH update_raw_crash AS ( UPDATE raw_crashes_20140929 SET raw_crash = "TotalPageFile" : "8379064320", "InstallTime" : "1411588990", "TotalPhysicalMemory" : "4190486528", "FramePoisonSize" : "65536", "TotalVirtualMemory" : "4294836224", "BreakpadReserveAddress" : 462 [...];
[ Date: 2014-10-02 20:25:06 - Duration: 82ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:50:04 - Duration: 22ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:32:33 - Duration: 13ms - Database: breakpad - User: processor - Remote: [local] ]
14 2,315 40s667ms 10ms 26ms 17ms SELECT column_name FROM information_schema.columns WHERE table_name = '' AND column_name = '';Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 02 18 179 3s141ms 17ms 19 991 17s438ms 17ms 20 961 16s860ms 17ms 21 184 3s226ms 17ms -
SELECT column_name FROM information_schema.columns WHERE table_name = 'crontabber' AND column_name = 'ongoing';
-
SELECT column_name FROM information_schema.columns WHERE table_name = 'crontabber' AND column_name = 'ongoing';
-
SELECT column_name FROM information_schema.columns WHERE table_name = 'crontabber' AND column_name = 'ongoing';
[ Date: 2014-10-02 21:00:08 - Duration: 26ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 20:30:08 - Duration: 25ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 19:10:07 - Duration: 25ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
15 2,198 4s599ms 1ms 16ms 2ms WITH update_report AS ( UPDATE reports_20 SET addons_checked = TRUE, address = '', app_notes = adaptervendorid: 0x, adapterdeviceid: 0x, adaptersubsysid: 0, adapterdriverversion: 0.0.0.0 d2d ? d2d + dwrite ? dwrite + d3d10 layers ? [...];Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 02 18 163 325ms 1ms 19 990 2s76ms 2ms 20 922 1s918ms 2ms 21 123 279ms 2ms -
WITH update_report AS ( UPDATE reports_20140929 SET addons_checked = TRUE, address = '0x5d6e38c1', app_notes = AdapterVendorID: 0x8086, AdapterDeviceID: 0x2e22, AdapterSubsysID: 00000000, AdapterDriverVersion: 8.15.10.2869 D2D ? D2D + DWrite ? DWrite + D3D10 Layers ? [...];
-
WITH update_report AS ( UPDATE reports_20140929 SET addons_checked = TRUE, address = '0x3f800000', app_notes = AdapterVendorID: 0x10de, AdapterDeviceID: 0x0fc6, AdapterSubsysID: 26503842, AdapterDriverVersion: 9.18.13.3221 D2D ? D2D + DWrite ? DWrite + D3D10 Layers ? [...];
-
WITH update_report AS ( UPDATE reports_20140929 SET addons_checked = TRUE, address = '0x6fcc141b', app_notes = AdapterVendorID: 0x8086, AdapterDeviceID: 0x0102, AdapterSubsysID: 00000000, AdapterDriverVersion: 9.17.10.2932 D2D ? D2D + DWrite ? DWrite + D3D10 Layers ? [...];
[ Date: 2014-10-02 19:05:36 - Duration: 16ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:31:00 - Duration: 16ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:34:55 - Duration: 15ms - Database: breakpad - User: processor - Remote: [local] ]
16 1,986 1s203ms 0s 1ms 0s SELECT add_new_release ( '', '', '', 0, '', 0, '', NULL, TRUE, TRUE );Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 02 19 993 616ms 0s 20 993 587ms 0s -
/* socorro.lib.buildutil.insert_build */ SELECT add_new_release ( 'seamonkey', '2.20', 'Beta', 20130708004505, 'macosx64', 1, 'mozilla-beta', NULL, TRUE, TRUE );
-
/* socorro.lib.buildutil.insert_build */ SELECT add_new_release ( 'seamonkey', '2.20', 'Beta', 20130708004437, 'linux', 1, 'mozilla-beta', NULL, TRUE, TRUE );
-
/* socorro.lib.buildutil.insert_build */ SELECT add_new_release ( 'mobile', '27.0', 'Beta', 20131210063153, 'android-armv6', 1, 'mozilla-beta', NULL, TRUE, TRUE );
[ Date: 2014-10-02 19:08:01 - Duration: 1ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 19:08:01 - Duration: 1ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 19:06:53 - Duration: 1ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
17 1,884 37s985ms 2ms 313ms 20ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 ncpu | x80 | genuineintel family 0 model 0 stepping 0 | 0 ncrash | exception_acc [...];Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 02 18 138 3s41ms 22ms 19 847 16s671ms 19ms 20 781 16s69ms 20ms 21 118 2s203ms 18ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 21:48:27.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.2.9200 nCPU | x86 | GenuineIntel family 6 model 58 stepping 9 | 2 nCrash | EXCEPTION_ACC [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:03:41.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.3.9600 nCPU | x86 | GenuineIntel family 6 model 60 stepping 3 | 4 nCrash | EXCEPTION_ACC [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:49:33.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.3.9600 nCPU | x86 | GenuineIntel family 6 model 58 stepping 9 | 8 nCrash | EXCEPTION_ACC [...];
[ Date: 2014-10-02 20:39:05 - Duration: 313ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:16:50 - Duration: 313ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 18:50:18 - Duration: 305ms - Database: breakpad - User: processor - Remote: [local] ]
18 1,817 7s603ms 2ms 92ms 4ms SELECT ba.signature, bugs.id FROM bugs JOIN bug_associations AS ba ON bugs.id = ba.bug_id WHERE EXISTS ( SELECT 0 FROM bug_associations WHERE bug [...];Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 02 18 6 22ms 3ms 19 1,650 6s235ms 3ms 20 67 375ms 5ms 21 94 969ms 10ms -
/* socorro.external.postgresql.bugs.Bugs.get */ SELECT ba.signature, bugs.id FROM bugs JOIN bug_associations AS ba ON bugs.id = ba.bug_id WHERE EXISTS ( SELECT 1 FROM bug_associations WHERE bug [...];
-
/* socorro.external.postgresql.bugs.Bugs.get */ SELECT ba.signature, bugs.id FROM bugs JOIN bug_associations AS ba ON bugs.id = ba.bug_id WHERE EXISTS ( SELECT 1 FROM bug_associations WHERE bug [...];
-
/* socorro.external.postgresql.bugs.Bugs.get */ SELECT ba.signature, bugs.id FROM bugs JOIN bug_associations AS ba ON bugs.id = ba.bug_id WHERE EXISTS ( SELECT 1 FROM bug_associations WHERE bug [...];
[ Date: 2014-10-02 21:01:53 - Duration: 92ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
[ Date: 2014-10-02 21:01:53 - Duration: 48ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
[ Date: 2014-10-02 21:02:52 - Duration: 19ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
19 1,642 1m8s 3ms 320ms 41ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "pluginfilename" : "npswf30_10_0_0_10.dll", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 service pack 0 ncpu | x80 | genui [...];Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 02 18 126 5s512ms 43ms 19 748 30s769ms 41ms 20 674 28s216ms 41ms 21 94 4s86ms 43ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:47:02.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | Genui [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:01:42.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | Genui [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:03:25.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | Genui [...];
[ Date: 2014-10-02 18:48:16 - Duration: 320ms - Database: breakpad - User: processor - Remote: [local] - Application: ""offset"": ""0x5bf7f20a"" ]
[ Date: 2014-10-02 19:05:09 - Duration: 167ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:05:04 - Duration: 148ms - Database: breakpad - User: processor - Remote: [local] ]
20 1,558 3s9ms 1ms 26ms 1ms WITH update_report AS ( UPDATE reports_20 SET addons_checked = TRUE, address = '', app_notes = '', build = 0 [...];Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 02 18 121 224ms 1ms 19 697 1s338ms 1ms 20 652 1s279ms 1ms 21 88 166ms 1ms -
WITH update_report AS ( UPDATE reports_20140929 SET addons_checked = TRUE, address = '0x34343a31', app_notes = 'AdapterVendorID: 1039, AdapterDeviceID: 6330, AdapterDriverVersion: 6.14.10.3920 D3D10 Layers? D3D10 Layers- D3D9 Layers? D3D9 Layers- ', build = 20110 [...];
-
WITH update_report AS ( UPDATE reports_20140929 SET addons_checked = TRUE, address = '0x4', app_notes = 'AdapterVendorID: 8086, AdapterDeviceID: 27a2, AdapterDriverVersion: 6.14.10.4926 D3D10 Layers? D3D10 Layers- D3D9 Layers? D3D9 Layers- ', build = 201103180527 [...];
-
WITH update_report AS ( UPDATE reports_20140929 SET addons_checked = TRUE, address = '0x3e1a39', app_notes = 'AdapterVendorID: 1039, AdapterDeviceID: 6330, AdapterDriverVersion: 6.14.10.3920 D3D10 Layers? D3D10 Layers- D3D9 Layers? D3D9 Layers- ', build = 2011070 [...];
[ Date: 2014-10-02 20:25:55 - Duration: 26ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:57:46 - Duration: 14ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:01:58 - Duration: 11ms - Database: breakpad - User: processor - Remote: [local] ]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1m40s 1m46s 1m43s 2 3m26s SELECT * FROM update_reports_clean ( '' ::timestamptz );Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 02 19 1 1m40s 1m40s 20 1 1m46s 1m46s -
SELECT * FROM update_reports_clean ( '2014-10-02T17:28:24.657714+00:00' ::timestamptz );
-
SELECT * FROM update_reports_clean ( '2014-10-02T16:28:24.657714+00:00' ::timestamptz );
[ Date: 2014-10-02 20:21:52 - Duration: 1m46s - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 19:16:47 - Duration: 1m40s - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
2 2s841ms 3s655ms 3s215ms 4 12s861ms SELECT * FROM update_reports_duplicates ( '' ::timestamptz, '' ::timestamptz );Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 02 19 2 6s139ms 3s69ms 20 2 6s722ms 3s361ms -
SELECT * FROM update_reports_duplicates ( '2014-10-02T16:28:19.183999+00:00' ::timestamptz, '2014-10-02T17:28:19.183999+00:00' ::timestamptz );
-
SELECT * FROM update_reports_duplicates ( '2014-10-02T15:28:19.183999+00:00' ::timestamptz, '2014-10-02T16:28:19.183999+00:00' ::timestamptz );
-
SELECT * FROM update_reports_duplicates ( '2014-10-02T16:58:19.183999+00:00' ::timestamptz, '2014-10-02T17:58:19.183999+00:00' ::timestamptz );
[ Date: 2014-10-02 20:10:08 - Duration: 3s655ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 19:05:08 - Duration: 3s297ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 20:10:11 - Duration: 3s66ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
3 2s761ms 3s171ms 2s989ms 16 47s838ms INSERT INTO server_status ( date_recently_completed, date_oldest_job_queued, avg_process_sec, avg_wait_sec, waiting_job_count, processors_count, date_created ) SELECT ( SELECT max ( r.completed_datetime ) FROM reports_20 r ) AS date_recently_completed, [...];Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 02 18 1 2s793ms 2s793ms 19 8 23s554ms 2s944ms 20 6 18s318ms 3s53ms 21 1 3s171ms 3s171ms -
INSERT INTO server_status ( date_recently_completed, date_oldest_job_queued, avg_process_sec, avg_wait_sec, waiting_job_count, processors_count, date_created ) SELECT ( SELECT MAX ( r.completed_datetime ) FROM reports_20140929 r ) AS date_recently_completed, [...];
-
INSERT INTO server_status ( date_recently_completed, date_oldest_job_queued, avg_process_sec, avg_wait_sec, waiting_job_count, processors_count, date_created ) SELECT ( SELECT MAX ( r.completed_datetime ) FROM reports_20140929 r ) AS date_recently_completed, [...];
-
INSERT INTO server_status ( date_recently_completed, date_oldest_job_queued, avg_process_sec, avg_wait_sec, waiting_job_count, processors_count, date_created ) SELECT ( SELECT MAX ( r.completed_datetime ) FROM reports_20140929 r ) AS date_recently_completed, [...];
[ Date: 2014-10-02 21:00:13 - Duration: 3s171ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 19:55:10 - Duration: 3s145ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 20:00:12 - Duration: 3s139ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
4 1ms 13s101ms 1s306ms 100 2m10s WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 02 19 8 4s312ms 539ms 20 26 1m5s 2s522ms 21 66 1m 919ms -
WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];
-
WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];
-
WITH tcbs_r AS ( SELECT tcbs.signature_id, signature, pv.product_name, version_string, sum ( report_count ) AS report_count, sum ( win_count ) AS win_count, sum ( lin_count ) AS lin_count, [...];
[ Date: 2014-10-02 20:25:07 - Duration: 13s101ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
[ Date: 2014-10-02 21:01:29 - Duration: 12s36ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
[ Date: 2014-10-02 20:23:05 - Duration: 12s35ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
5 15ms 4s196ms 446ms 28 12s498ms SELECT r.date_processed, r.uptime, r.user_comments, r.uuid ::uuid, r.uuid AS uuid_text, r.product, r.version, [...];Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 02 19 6 4s288ms 714ms 20 12 1s562ms 130ms 21 10 6s646ms 664ms -
/* socorro.external.postgresql.report.Report.list */ SELECT r.date_processed, r.uptime, r.user_comments, r.uuid ::uuid, r.uuid AS uuid_text, r.product, r.version, [...];
-
/* socorro.external.postgresql.report.Report.list */ SELECT r.date_processed, r.uptime, r.user_comments, r.uuid ::uuid, r.uuid AS uuid_text, r.product, r.version, [...];
-
/* socorro.external.postgresql.report.Report.list */ SELECT r.date_processed, r.uptime, r.user_comments, r.uuid ::uuid, r.uuid AS uuid_text, r.product, r.version, [...];
[ Date: 2014-10-02 21:02:16 - Duration: 4s196ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
[ Date: 2014-10-02 19:29:56 - Duration: 2s291ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
[ Date: 2014-10-02 19:29:56 - Duration: 1s350ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
6 109ms 225ms 178ms 280 49s849ms SELECT 0 FROM performance_check_1;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 02 18 24 4s169ms 173ms 19 120 21s414ms 178ms 20 120 21s455ms 178ms 21 16 2s809ms 175ms -
SELECT 1 FROM performance_check_1;
-
SELECT 1 FROM performance_check_1;
-
SELECT 1 FROM performance_check_1;
[ Date: 2014-10-02 20:25:04 - Duration: 225ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
[ Date: 2014-10-02 20:12:03 - Duration: 224ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
[ Date: 2014-10-02 21:05:06 - Duration: 209ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
7 53ms 219ms 90ms 140 12s658ms SELECT avg ( avg_wait_sec ) FROM server_status;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 02 18 12 1s74ms 89ms 19 60 5s395ms 89ms 20 60 5s465ms 91ms 21 8 722ms 90ms -
SELECT avg ( avg_wait_sec ) FROM server_status;
-
SELECT avg ( avg_wait_sec ) FROM server_status;
-
SELECT avg ( avg_wait_sec ) FROM server_status;
[ Date: 2014-10-02 20:25:05 - Duration: 219ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
[ Date: 2014-10-02 19:54:03 - Duration: 106ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
[ Date: 2014-10-02 20:37:05 - Duration: 102ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
8 3ms 320ms 41ms 1,642 1m8s WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "pluginfilename" : "npswf30_10_0_0_10.dll", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 service pack 0 ncpu | x80 | genui [...];Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 02 18 126 5s512ms 43ms 19 748 30s769ms 41ms 20 674 28s216ms 41ms 21 94 4s86ms 43ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:47:02.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | Genui [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:01:42.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | Genui [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:03:25.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | Genui [...];
[ Date: 2014-10-02 18:48:16 - Duration: 320ms - Database: breakpad - User: processor - Remote: [local] - Application: ""offset"": ""0x5bf7f20a"" ]
[ Date: 2014-10-02 19:05:09 - Duration: 167ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:05:04 - Duration: 148ms - Database: breakpad - User: processor - Remote: [local] ]
9 5ms 173ms 39ms 696 27s775ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "pluginfilename" : "npswf30_10_0_0_10.dll", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 ncpu | x80 | genuineintel family [...];Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 02 18 97 4s335ms 44ms 19 266 10s629ms 39ms 20 295 11s391ms 38ms 21 38 1s419ms 37ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:29:35.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.2.9200 nCPU | x86 | GenuineIntel family [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:32:27.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7600 nCPU | x86 | GenuineIntel family [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:50:04.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.2.9200 nCPU | x86 | GenuineIntel family [...];
[ Date: 2014-10-02 18:51:54 - Duration: 173ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:36:36 - Duration: 104ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:20:31 - Duration: 91ms - Database: breakpad - User: processor - Remote: [local] ]
10 5ms 143ms 39ms 318 12s631ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "pluginfilename" : "npswf30_10_0_0_10.dll", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 service pack 0 ncpu | x80 | authe [...];Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 02 18 30 1s271ms 42ms 19 119 4s636ms 38ms 20 147 5s822ms 39ms 21 22 900ms 40ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:33:06.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | Authe [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:16:35.000000", "PluginFilename" : "NPSWF32_14_0_0_179.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.0.6002 Service Pack 2 nCPU | x86 | Authe [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:07:57.000000", "PluginFilename" : "NPSWF32_15_0_0_152.dll", "hang_type" : - 1, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | Authe [...];
[ Date: 2014-10-02 20:10:04 - Duration: 143ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:20:01 - Duration: 102ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:08:25 - Duration: 89ms - Database: breakpad - User: processor - Remote: [local] ]
11 3ms 699ms 26ms 778 20s796ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 ncpu | x80 | genuineintel family 0 model 0 stepping 0 | 0 ncrash | exception_bre [...];Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 02 18 70 1s568ms 22ms 19 362 9s4ms 24ms 20 303 9s219ms 30ms 21 43 1s3ms 23ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:26:42.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.2.9200 nCPU | x86 | GenuineIntel family 6 model 42 stepping 7 | 2 nCrash | EXCEPTION_BRE [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:03:06.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.2.9200 nCPU | x86 | GenuineIntel family 6 model 42 stepping 7 | 4 nCrash | EXCEPTION_BRE [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:32:05.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7600 nCPU | x86 | GenuineIntel family 6 model 37 stepping 5 | 2 nCrash | EXCEPTION_BRE [...];
[ Date: 2014-10-02 20:28:34 - Duration: 699ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:26:32 - Duration: 427ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:34:22 - Duration: 415ms - Database: breakpad - User: processor - Remote: [local] ]
12 2ms 205ms 21ms 1,475 31s856ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 service pack 0 ncpu | x80 | authenticamd family 0 model 0 stepping 0 | 0 ncrash [...];Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 02 18 126 2s515ms 19ms 19 642 13s796ms 21ms 20 613 13s433ms 21ms 21 94 2s111ms 22ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:35:22.000000", "hang_type" : 0, "dump" : OS | Windows NT | 5.1.2600 Service Pack 3 nCPU | x86 | AuthenticAMD family 16 model 2 stepping 3 | 3 nCrash [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:35:03.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | AuthenticAMD family 16 model 6 stepping 3 | 2 nCrash [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:03:05.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | AuthenticAMD family 20 model 1 stepping 0 | 1 nCrash [...];
[ Date: 2014-10-02 20:35:37 - Duration: 205ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:35:21 - Duration: 189ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:03:53 - Duration: 179ms - Database: breakpad - User: processor - Remote: [local] ]
13 1ms 984ms 21ms 8,079 2m54s WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 service pack 0 ncpu | x80 | genuineintel family 0 model 0 stepping 0 | 0 ncrash [...];Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 02 18 678 15s168ms 22ms 19 3,612 1m15s 20ms 20 3,394 1m15s 22ms 21 395 8s320ms 21ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:17:10.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 42 stepping 7 | 8 nCrash [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:43:39.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 60 stepping 3 | 4 nCrash [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:29:32.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 42 stepping 7 | 4 nCrash [...];
[ Date: 2014-10-02 20:18:26 - Duration: 984ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:44:31 - Duration: 720ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:30:08 - Duration: 647ms - Database: breakpad - User: processor - Remote: [local] ]
14 1ms 619ms 20ms 3,862 1m18s WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 service pack 0 ncpu | x80 | genuineintel family 0 model 0 stepping 0 | 0 ncras [...];Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 02 18 317 6s561ms 20ms 19 1,710 33s327ms 19ms 20 1,659 34s406ms 20ms 21 176 3s734ms 21ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:29:17.000000", "hang_type" : 0, "dump" : OS | Windows NT | 5.1.2600 Service Pack 3 nCPU | x86 | GenuineIntel family 6 model 23 stepping 10 | 2 nCras [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:29:46.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 23 stepping 10 | 2 nCras [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 20:13:55.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7601 Service Pack 1 nCPU | x86 | GenuineIntel family 6 model 28 stepping 10 | 2 nCras [...];
[ Date: 2014-10-02 20:30:08 - Duration: 619ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:30:08 - Duration: 486ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:30:08 - Duration: 290ms - Database: breakpad - User: processor - Remote: [local] ]
15 2ms 313ms 20ms 1,884 37s985ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 ncpu | x80 | genuineintel family 0 model 0 stepping 0 | 0 ncrash | exception_acc [...];Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 02 18 138 3s41ms 22ms 19 847 16s671ms 19ms 20 781 16s69ms 20ms 21 118 2s203ms 18ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 21:48:27.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.2.9200 nCPU | x86 | GenuineIntel family 6 model 58 stepping 9 | 2 nCrash | EXCEPTION_ACC [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:03:41.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.3.9600 nCPU | x86 | GenuineIntel family 6 model 60 stepping 3 | 4 nCrash | EXCEPTION_ACC [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:49:33.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.3.9600 nCPU | x86 | GenuineIntel family 6 model 58 stepping 9 | 8 nCrash | EXCEPTION_ACC [...];
[ Date: 2014-10-02 20:39:05 - Duration: 313ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 20:16:50 - Duration: 313ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 18:50:18 - Duration: 305ms - Database: breakpad - User: processor - Remote: [local] ]
16 2ms 62ms 19ms 1,120 21s608ms SELECT sum ( pg_relation_size ( tablename::text ) ) FROM pg_tables WHERE tablename LIKE '';Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 02 18 96 1s911ms 19ms 19 480 9s252ms 19ms 20 480 9s194ms 19ms 21 64 1s248ms 19ms -
SELECT sum ( pg_relation_size ( tablename::text ) ) FROM pg_tables WHERE tablename LIKE 'reports%';
-
SELECT sum ( pg_relation_size ( tablename::text ) ) FROM pg_tables WHERE tablename LIKE 'reports%';
-
SELECT sum ( pg_relation_size ( tablename::text ) ) FROM pg_tables WHERE tablename LIKE 'reports%';
[ Date: 2014-10-02 20:21:03 - Duration: 62ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
[ Date: 2014-10-02 20:45:05 - Duration: 59ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
[ Date: 2014-10-02 19:18:01 - Duration: 58ms - Database: breakpad - User: ganglia - Remote: 127.0.0.1 ]
17 2ms 113ms 18ms 723 13s733ms WITH update_processed_crash AS ( UPDATE processed_crashes_20 SET processed_crash = "client_crash_date" : "0-10-00 0:0:0.0", "hang_type" : 0, "dump" : os | windows nt | 0.0.0 ncpu | x80 | genuineintel family 0 model 0 stepping 0 | 0 ncrash | exception_ac [...];Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 02 18 63 1s327ms 21ms 19 331 6s391ms 19ms 20 292 5s287ms 18ms 21 37 727ms 19ms -
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:50:56.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7600 nCPU | x86 | GenuineIntel family 6 model 23 stepping 10 | 2 nCrash | EXCEPTION_AC [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 19:44:16.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.1.7600 nCPU | x86 | GenuineIntel family 6 model 15 stepping 11 | 4 nCrash | EXCEPTION_AC [...];
-
WITH update_processed_crash AS ( UPDATE processed_crashes_20140929 SET processed_crash = "client_crash_date" : "2014-10-02 18:50:53.000000", "hang_type" : 0, "dump" : OS | Windows NT | 6.3.9600 nCPU | x86 | GenuineIntel family 6 model 23 stepping 10 | 4 nCrash | EXCEPTION_AC [...];
[ Date: 2014-10-02 18:52:00 - Duration: 113ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:44:41 - Duration: 50ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 18:51:26 - Duration: 38ms - Database: breakpad - User: processor - Remote: [local] ]
18 10ms 26ms 17ms 2,315 40s667ms SELECT column_name FROM information_schema.columns WHERE table_name = '' AND column_name = '';Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 02 18 179 3s141ms 17ms 19 991 17s438ms 17ms 20 961 16s860ms 17ms 21 184 3s226ms 17ms -
SELECT column_name FROM information_schema.columns WHERE table_name = 'crontabber' AND column_name = 'ongoing';
-
SELECT column_name FROM information_schema.columns WHERE table_name = 'crontabber' AND column_name = 'ongoing';
-
SELECT column_name FROM information_schema.columns WHERE table_name = 'crontabber' AND column_name = 'ongoing';
[ Date: 2014-10-02 21:00:08 - Duration: 26ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 20:30:08 - Duration: 25ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
[ Date: 2014-10-02 19:10:07 - Duration: 25ms - Database: breakpad - User: breakpad_rw - Remote: 10.8.70.203 ]
19 2ms 92ms 4ms 1,817 7s603ms SELECT ba.signature, bugs.id FROM bugs JOIN bug_associations AS ba ON bugs.id = ba.bug_id WHERE EXISTS ( SELECT 0 FROM bug_associations WHERE bug [...];Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 02 18 6 22ms 3ms 19 1,650 6s235ms 3ms 20 67 375ms 5ms 21 94 969ms 10ms -
/* socorro.external.postgresql.bugs.Bugs.get */ SELECT ba.signature, bugs.id FROM bugs JOIN bug_associations AS ba ON bugs.id = ba.bug_id WHERE EXISTS ( SELECT 1 FROM bug_associations WHERE bug [...];
-
/* socorro.external.postgresql.bugs.Bugs.get */ SELECT ba.signature, bugs.id FROM bugs JOIN bug_associations AS ba ON bugs.id = ba.bug_id WHERE EXISTS ( SELECT 1 FROM bug_associations WHERE bug [...];
-
/* socorro.external.postgresql.bugs.Bugs.get */ SELECT ba.signature, bugs.id FROM bugs JOIN bug_associations AS ba ON bugs.id = ba.bug_id WHERE EXISTS ( SELECT 1 FROM bug_associations WHERE bug [...];
[ Date: 2014-10-02 21:01:53 - Duration: 92ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
[ Date: 2014-10-02 21:01:53 - Duration: 48ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
[ Date: 2014-10-02 21:02:52 - Duration: 19ms - Database: breakpad - User: breakpad_rw - Remote: [local] ]
20 1ms 16ms 2ms 2,198 4s599ms WITH update_report AS ( UPDATE reports_20 SET addons_checked = TRUE, address = '', app_notes = adaptervendorid: 0x, adapterdeviceid: 0x, adaptersubsysid: 0, adapterdriverversion: 0.0.0.0 d2d ? d2d + dwrite ? dwrite + d3d10 layers ? [...];Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 02 18 163 325ms 1ms 19 990 2s76ms 2ms 20 922 1s918ms 2ms 21 123 279ms 2ms -
WITH update_report AS ( UPDATE reports_20140929 SET addons_checked = TRUE, address = '0x5d6e38c1', app_notes = AdapterVendorID: 0x8086, AdapterDeviceID: 0x2e22, AdapterSubsysID: 00000000, AdapterDriverVersion: 8.15.10.2869 D2D ? D2D + DWrite ? DWrite + D3D10 Layers ? [...];
-
WITH update_report AS ( UPDATE reports_20140929 SET addons_checked = TRUE, address = '0x3f800000', app_notes = AdapterVendorID: 0x10de, AdapterDeviceID: 0x0fc6, AdapterSubsysID: 26503842, AdapterDriverVersion: 9.18.13.3221 D2D ? D2D + DWrite ? DWrite + D3D10 Layers ? [...];
-
WITH update_report AS ( UPDATE reports_20140929 SET addons_checked = TRUE, address = '0x6fcc141b', app_notes = AdapterVendorID: 0x8086, AdapterDeviceID: 0x0102, AdapterSubsysID: 00000000, AdapterDriverVersion: 9.17.10.2932 D2D ? D2D + DWrite ? DWrite + D3D10 Layers ? [...];
[ Date: 2014-10-02 19:05:36 - Duration: 16ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:31:00 - Duration: 16ms - Database: breakpad - User: processor - Remote: [local] ]
[ Date: 2014-10-02 19:34:55 - Duration: 15ms - Database: breakpad - User: processor - Remote: [local] ]
-
Events
Log levels
Key values
- 569,747 Log entries
- 10 Number of ERROR entries
- 0 Number of FATAL entries
Most Frequent Errors/Events
Key values
- 9 Max number of times the same event was reported
- 14 Total events found
Rank Times reported Error 1 9 LOG: parameter "..." changed to "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 02 21 9 - LOG: parameter "log_rotation_age" changed to "1d"
- LOG: parameter "log_filename" changed to "activitylog-%Y%m%d.log"
- LOG: parameter "log_connections" changed to "off"
- LOG: parameter "log_disconnections" changed to "off"
Date: 2014-10-02 21:07:26
Date: 2014-10-02 21:07:26
Date: 2014-10-02 21:07:26
Date: 2014-10-02 21:07:26
2 3 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 02 19 1 21 2 - ERROR: syntax error at or near "l"
- ERROR: syntax error at or near "as"
- ERROR: syntax error at or near ","
Date: 2014-10-02 19:24:36 Statement: show log_destination l ;
Database: postgres User: postgres Remote: [local]Date: 2014-10-02 21:07:26 Statement: COPY(select 'database size'::text as name, pg_database_size(current_database() as info) TO '/var/lib/pgsql/datacollection/OUTPUT/project/monitor/breakpad/breakpad.other_stats_end.ds.csv' with delimiter ',' csv header
Database: breakpad User: postgres Remote: [local]Date: 2014-10-02 21:07:26 Statement: COPY(SELECT pg_database.datname, pg_size_pretty(pg_database_size(pg_database.datname)) AS size FROM pg_database where datname <> 'template1' AND datname <> 'template0' AND datname <> 'postgres) TO '/var/lib/pgsql/datacollection/OUTPUT/project/monitor/server/server.pg_database_size_end.csv' with delimiter ',' csv header
Database: breakpad User: postgres Remote: [local]3 2 ERROR: integer out of range
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 02 19 1 20 1 - ERROR: integer out of range
Date: 2014-10-02 19:12:25 Statement: WITH update_report AS ( UPDATE reports_20140929 SET addons_checked = true, address = '0xc8', app_notes = 'AdapterVendorID: 8086, AdapterDeviceID: 29d2, AdapterSubsysID: 4f4a8086, AdapterDriverVersion: 8.15.10.1749 ', build = '20111206234556', client_crash_date = '2014-10-02T19:11:58+00:00'::timestamptz, completed_datetime = '2014-10-02T19:12:25.841613+00:00'::timestamptz, cpu_info = 'GenuineIntel family 6 model 15 stepping 11 | 2', cpu_name = 'x86', date_processed = '2014-10-02T19:12:12.675967+00:00'::timestamptz, distributor = NULL, distributor_version = NULL, email = NULL, exploitability = 'none', flash_version = '[blank]', hangid = NULL, install_age = 2583786952, last_crash = 82557, os_name = 'Windows NT', os_version = '6.1.7600', processor_notes = 'sp-processor06_phx1_mozilla_com.21710:2012; HybridCrashProcessor', process_type = NULL, product = 'Firefox', productid = NULL, reason = 'EXCEPTION_ACCESS_VIOLATION_WRITE', release_channel = 'beta', signature = 'JS_BeginRequest', started_datetime = '2014-10-02T19:12:24.090590+00:00'::timestamptz, success = true, topmost_filenames = 'hg:hg.mozilla.org/releases/mozilla-beta:js/src/jsapi.cpp:dea4e14dc88a', truncated = false, uptime = 218, user_comments = NULL, user_id = '', url = 'https://www.facebook.com/xti.php?xt=3.AQJgC46JbR8L2vBd7SowxPKeNOUVJojYmzoV4JINL31zNRwmbJnyZyeyJajvcJMXHfGmYPBnzW5LJAhm_XqM-WNzwiiejs_Vt6wWAd3R1hr4icl-sh71wbzUEfIvlb9Qbjg06NfDtEbC_sTDN5gjx8BNNW98SsTlplGzvFA7wIaennem0UKI6ISQZ7sy3NdqUVRJ3x9LNzFKmdPEzhj-YLTsq', uuid = '9c907512-9022-4d61-97ee-3c3532141002', version = '9.0' WHERE uuid = '9c907512-9022-4d61-97ee-3c3532141002' RETURNING id ), insert_report AS ( INSERT INTO reports_20140929 (addons_checked, address, app_notes, build, client_crash_date, completed_datetime, cpu_info, cpu_name, date_processed, distributor, distributor_version, email, exploitability, flash_version, hangid, install_age, last_crash, os_name, os_version, processor_notes, process_type, product, productid, reason, release_channel, signature, started_datetime, success, topmost_filenames, truncated, uptime, user_comments, user_id, url, uuid, version) ( SELECT true as addons_checked, '0xc8' as address, 'AdapterVendorID: 8086, AdapterDeviceID: 29d2, AdapterSubsysID: 4f4a8086, AdapterDriverVersion: 8.15.10.1749 ' as app_notes, '20111206234556' as build, '2014-10-02T19:11:58+00:00'::timestamptz as client_crash_date, '2014-10-02T19:12:25.841613+00:00'::timestamptz as completed_datetime, 'GenuineIntel family 6 model 15 stepping 11 | 2' as cpu_info, 'x86' as cpu_name, '2014-10-02T19:12:12.675967+00:00'::timestamptz as date_processed, NULL as distributor, NULL as distributor_version, NULL as email, 'none' as exploitability, '[blank]' as flash_version, NULL as hangid, 2583786952 as install_age, 82557 as last_crash, 'Windows NT' as os_name, '6.1.7600' as os_version, 'sp-processor06_phx1_mozilla_com.21710:2012; HybridCrashProcessor' as processor_notes, NULL as process_type, 'Firefox' as product, NULL as productid, 'EXCEPTION_ACCESS_VIOLATION_WRITE' as reason, 'beta' as release_channel, 'JS_BeginRequest' as signature, '2014-10-02T19:12:24.090590+00:00'::timestamptz as started_datetime, true as success, 'hg:hg.mozilla.org/releases/mozilla-beta:js/src/jsapi.cpp:dea4e14dc88a' as topmost_filenames, false as truncated, 218 as uptime, NULL as user_comments, '' as user_id, 'https://www.facebook.com/xti.php?xt=3.AQJgC46JbR8L2vBd7SowxPKeNOUVJojYmzoV4JINL31zNRwmbJnyZyeyJajvcJMXHfGmYPBnzW5LJAhm_XqM-WNzwiiejs_Vt6wWAd3R1hr4icl-sh71wbzUEfIvlb9Qbjg06NfDtEbC_sTDN5gjx8BNNW98SsTlplGzvFA7wIaennem0UKI6ISQZ7sy3NdqUVRJ3x9LNzFKmdPEzhj-YLTsq' as url, '9c907512-9022-4d61-97ee-3c3532141002' as uuid, '9.0' as version WHERE NOT EXISTS ( SELECT uuid from reports_20140929 WHERE uuid = '9c907512-9022-4d61-97ee-3c3532141002' LIMIT 1 ) ) RETURNING id ) SELECT * from update_report UNION ALL SELECT * from insert_report
Database: breakpad User: processor Remote: [local]