pgBadger-
Global information
- Generated on Tue May 17 09:17:19 2022
- Log file: /data/pglog/huge_log_test/pgbouncer.log.1, ..., /data/pglog/huge_log_test/postgresql-Tue.log
- Parsed 16,359,941 log entries in 14m14s
- Log start from 2012-12-08 00:00:00 to 2012-12-08 23:59:59
-
Overview
Global Stats
- 13 Number of unique normalized queries
- 5,107,419 Number of queries
- 2h27m10s Total query duration
- 2012-12-08 00:00:00 First query
- 2012-12-08 23:59:59 Last query
- 406 queries/s at 2012-12-08 21:40:04 Query peak
- 2h27m10s Total query duration
- 673ms Prepare/parse total duration
- 18s480ms Bind total duration
- 2h26m51s Execute total duration
- 1,920 Number of events
- 1 Number of unique normalized events
- 1,920 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 227,057 Total number of sessions
- 5 sessions at 2012-12-08 17:39:01 Session peak
- 299d22h33m58s Total duration of sessions
- 1m54s Average duration of sessions
- 22 Average queries per session
- 38ms Average queries duration per session
- 1m54s Average idle time per session
- 227,059 Total number of connections
- 43 connections/s at 2012-12-08 06:59:16 Connection peak
- 6 Total number of databases
SQL Traffic
Key values
- 406 queries/s Query Peak
- 2012-12-08 21:40:04 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2012-12-08 17:39:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2012-12-08 17:13:30 Date
Queries duration
Key values
- 2h27m10s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 08 00 168,402 0ms 40s841ms 2ms 16s53ms 31s136ms 1m3s 01 180,904 0ms 3s20ms 2ms 14s26ms 32s865ms 48s785ms 02 187,450 0ms 102ms 1ms 14s139ms 29s33ms 32s773ms 03 197,609 0ms 101ms 1ms 14s403ms 29s879ms 36s18ms 04 207,838 0ms 101ms 1ms 14s558ms 30s56ms 36s550ms 05 214,571 0ms 111ms 1ms 14s910ms 31s305ms 35s711ms 06 216,098 0ms 121ms 1ms 14s733ms 24s967ms 43s541ms 07 217,873 0ms 4s543ms 1ms 14s519ms 35s175ms 38s149ms 08 220,227 0ms 583ms 1ms 14s524ms 27s468ms 41s241ms 09 218,055 0ms 938ms 1ms 14s955ms 31s662ms 34s569ms 10 217,777 0ms 102ms 1ms 14s421ms 26s940ms 30s336ms 11 218,436 0ms 248ms 1ms 14s594ms 27s312ms 30s46ms 12 222,356 0ms 794ms 1ms 14s748ms 28s872ms 44s547ms 13 217,762 0ms 112ms 1ms 13s687ms 26s817ms 33s73ms 14 217,832 0ms 100ms 1ms 14s344ms 28s704ms 31s661ms 15 219,920 0ms 446ms 1ms 14s318ms 27s890ms 39s381ms 16 217,308 0ms 101ms 1ms 13s915ms 23s667ms 28s731ms 17 218,902 0ms 951ms 1ms 16s249ms 34s769ms 39s736ms 18 220,504 0ms 767ms 1ms 13s72ms 28s443ms 32s775ms 19 217,747 0ms 107ms 1ms 13s742ms 18s373ms 29s590ms 20 217,177 0ms 101ms 1ms 14s379ms 27s366ms 32s273ms 21 219,995 0ms 3s603ms 1ms 14s295ms 23s133ms 27s990ms 22 218,289 0ms 105ms 1ms 15s771ms 25s260ms 33s727ms 23 234,387 0ms 967ms 2ms 21s88ms 28s434ms 42s283ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 08 00 0 0 0ms 0ms 0ms 0ms 01 5 0 1s312ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 2 0 4s80ms 0ms 0ms 0ms 08 1 0 583ms 0ms 0ms 0ms 09 4 0 585ms 0ms 0ms 357ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 2 0 680ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 1 0 446ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 63 0 546ms 663ms 1s426ms 7s566ms 18 1 0 767ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 6 0 1s248ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 1 0 967ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 08 00 0 0 1 0 40s841ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 1 0 0 418ms 0ms 0ms 0ms 09 1 0 0 0 705ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 4 1 0 471ms 0ms 0ms 435ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 2 0 0 682ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Dec 08 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 2 2.00 0.00% 08 1 0 0.00 50.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Dec 08 00 8,799 2.44/s 01 8,900 2.47/s 02 9,118 2.53/s 03 9,174 2.55/s 04 9,455 2.63/s 05 9,753 2.71/s 06 9,954 2.77/s 07 9,426 2.62/s 08 9,426 2.62/s 09 9,628 2.67/s 10 9,519 2.64/s 11 9,626 2.67/s 12 9,578 2.66/s 13 9,451 2.63/s 14 9,593 2.66/s 15 9,303 2.58/s 16 9,394 2.61/s 17 9,820 2.73/s 18 9,247 2.57/s 19 9,454 2.63/s 20 9,334 2.59/s 21 9,508 2.64/s 22 9,616 2.67/s 23 9,983 2.77/s Day Hour Count Average Duration Average idle time Dec 08 00 8,797 2m 2m 01 8,900 2m1s 2m1s 02 9,118 1m58s 1m58s 03 9,174 1m57s 1m57s 04 9,455 1m54s 1m54s 05 9,753 1m51s 1m51s 06 9,954 1m50s 1m50s 07 9,426 1m51s 1m51s 08 9,426 1m54s 1m54s 09 9,628 1m52s 1m52s 10 9,519 1m53s 1m53s 11 9,626 1m52s 1m52s 12 9,578 1m52s 1m52s 13 9,451 1m54s 1m54s 14 9,593 1m52s 1m52s 15 9,303 1m55s 1m55s 16 9,394 1m54s 1m54s 17 9,820 1m49s 1m49s 18 9,247 1m56s 1m56s 19 9,454 1m54s 1m54s 20 9,334 1m56s 1m56s 21 9,508 1m52s 1m52s 22 9,616 1m51s 1m51s 23 9,983 1m48s 1m48s -
Connections
Established Connections
Key values
- 43 connections Connection Peak
- 2012-12-08 06:59:16 Date
Connections per database
Key values
- inventory Main Database
- 227,059 connections Total
Connections per user
Key values
- lfriedman Main User
- 227,059 connections Total
-
Sessions
Simultaneous sessions
Key values
- 5 sessions Session Peak
- 2012-12-08 17:39:01 Date
Histogram of session times
Key values
- 80,288 60000-600000ms duration
Sessions per database
Key values
- inventory Main Database
- 227,057 sessions Total
Sessions per user
Key values
- lfriedman Main User
- 227,057 sessions Total
Sessions per host
Key values
- 10.31.96.124 Main Host
- 227,057 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 51,328 buffers Checkpoint Peak
- 2012-12-08 00:06:33 Date
- 209.862 seconds Highest write time
- 0.061 seconds Sync time
Checkpoints Wal files
Key values
- 29 files Wal files usage Peak
- 2012-12-08 00:06:33 Date
Checkpoints distance
Key values
- 0.00 Mo Distance Peak
- 2012-12-08 11:53:17 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Dec 08 00 52,573 334.335s 0.145s 334.536s 01 1,869 186.691s 0.1s 186.847s 02 1,500 149.768s 0.092s 149.916s 03 2,283 228.231s 0.111s 228.396s 04 1,965 196.373s 0.106s 196.534s 05 1,805 180.342s 0.108s 180.504s 06 1,740 173.927s 0.111s 174.089s 07 2,058 205.73s 0.114s 205.9s 08 1,776 177.659s 0.109s 177.823s 09 1,702 170.255s 0.106s 170.412s 10 1,735 173.258s 0.108s 173.419s 11 1,784 178.24s 0.107s 178.402s 12 1,908 190.664s 0.108s 190.827s 13 1,789 178.74s 0.109s 178.9s 14 1,784 178.333s 0.109s 178.498s 15 2,085 208.498s 0.106s 208.655s 16 1,719 171.726s 0.105s 171.886s 17 1,774 177.328s 0.11s 177.493s 18 1,784 178.334s 0.11s 178.494s 19 1,794 179.372s 0.113s 179.539s 20 1,755 175.363s 0.108s 175.525s 21 1,742 174.049s 0.105s 174.21s 22 1,815 181.478s 0.109s 181.639s 23 2,006 200.307s 0.122s 200.485s Day Hour Added Removed Recycled Synced files Longest sync Average sync Dec 08 00 0 0 80 471 0.029s 0s 01 0 0 59 513 0.001s 0s 02 0 0 59 429 0.001s 0s 03 0 0 59 490 0.005s 0s 04 0 0 59 507 0.002s 0s 05 0 0 59 489 0.002s 0s 06 0 0 59 499 0.002s 0s 07 0 0 59 587 0.001s 0s 08 0 0 59 502 0.001s 0s 09 0 0 59 481 0.001s 0s 10 0 0 59 487 0.001s 0s 11 0 0 59 489 0.001s 0s 12 0 0 59 521 0.001s 0s 13 0 0 59 493 0.001s 0s 14 0 0 59 497 0.001s 0s 15 0 0 59 534 0.002s 0s 16 0 0 59 490 0.001s 0s 17 0 0 59 494 0.001s 0s 18 0 0 59 492 0.001s 0s 19 0 0 59 492 0.008s 0s 20 0 0 59 486 0.002s 0s 21 0 0 58 490 0.001s 0s 22 0 0 59 499 0s 0s 23 0 0 60 549 0.002s 0s Day Hour Count Avg time (sec) Dec 08 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Dec 08 00 0.00 kB 0.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 0.00 kB 04 0.00 kB 0.00 kB 05 0.00 kB 0.00 kB 06 0.00 kB 0.00 kB 07 0.00 kB 0.00 kB 08 0.00 kB 0.00 kB 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB 11 0.00 kB 0.00 kB 12 0.00 kB 0.00 kB 13 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 0.00 kB 0.00 kB 16 0.00 kB 0.00 kB 17 0.00 kB 0.00 kB 18 0.00 kB 0.00 kB 19 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB 21 0.00 kB 0.00 kB 22 0.00 kB 0.00 kB 23 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Dec 08 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Dec 08 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 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
- 86 Total read queries
- 10 Total write queries
Queries by database
Key values
- inventory Main database
- 4,538,137 Requests
- 1h51m39s (nightly)
- Main time consuming database
Database Request type Count Duration cbs Total 3,182 8s791ms select 2 1s272ms inventory Total 4,538,137 27m54s select 37 23s279ms update 6 3s465ms mbm Total 11,017 16s436ms nightly Total 515,192 1h51m39s delete 2 41s173ms insert 1 705ms select 45 31s316ms update 1 341ms postgres Total 432 688ms pvs Total 39,459 6m51s select 2 7s221ms Queries by user
Key values
- lfriedman Main user
- 38,379,709 Requests
User Request type Count Duration lfriedman Total 38,379,709 5d2h26m9s copy from 640 2h37m13s ddl 2,964 0ms delete 289 6m30s insert 2,533 36m37s select 10,654 3h59m7s tcl 2 1s345ms update 12,530 3h11m31s postgres Total 1,417 2s791ms select 1 330ms Duration by user
Key values
- 5d2h26m9s (lfriedman) Main time consuming user
User Request type Count Duration lfriedman Total 38,379,709 5d2h26m9s copy from 640 2h37m13s ddl 2,964 0ms delete 289 6m30s insert 2,533 36m37s select 10,654 3h59m7s tcl 2 1s345ms update 12,530 3h11m31s postgres Total 1,417 2s791ms select 1 330ms Queries by host
Key values
- unknown Main host
- 38,381,126 Requests
- 5d2h26m12s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 5,107,419 Requests
- 2h26m51s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2012-12-08 11:36:55 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 4,657,530 0-1ms duration
Slowest individual queries
Rank Duration Query 1 40s841ms DELETE FROM filterout WHERE last_update = '2012-12-08'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);[ Date: 2012-12-08 00:00:42 - Database: nightly - User: lfriedman ]
2 4s543ms SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.x86_64' AND arch = 'x86_64' AND gpu = '100' AND branch = 'cuda_a' AND build = 'debug' AND vc = 'g' AND script = 'kepler-apps_sm35.sh' AND active = 't' AND last_update = '2012-12-08' AND farm = '0' ORDER BY testname;[ Date: 2012-12-08 07:40:25 - Database: nightly - User: lfriedman - Bind query: yes ]
3 3s618ms SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;[ Date: 2012-12-08 07:40:41 - Database: pvs - User: lfriedman - Bind query: yes ]
4 3s603ms SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;[ Date: 2012-12-08 21:40:16 - Database: pvs - User: lfriedman - Bind query: yes ]
5 3s20ms SELECT testname, category, bug FROM filterout WHERE os = 'WINXP' AND osversion = 'WINXP' AND arch = 'i686' AND gpu = '200' AND branch = 'cuda_a' AND build = 'debug' AND vc = 'g' AND script = 'cuda_gpgpu-smoke.sh' AND active = 't' AND last_update = '2012-12-08' AND farm = '0' ORDER BY testname;[ Date: 2012-12-08 01:19:25 - Database: nightly - User: lfriedman - Bind query: yes ]
6 1s690ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';[ Date: 2012-12-08 01:19:45 - Database: inventory - User: lfriedman ]
7 967ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('cuhc') AND c.relpersistence = 'u';[ Date: 2012-12-08 23:19:35 - Database: inventory - User: lfriedman ]
8 951ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';[ Date: 2012-12-08 17:39:01 - Database: nightly - User: lfriedman ]
9 938ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';[ Date: 2012-12-08 09:00:36 - Database: inventory - User: lfriedman ]
10 918ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';[ Date: 2012-12-08 17:19:09 - Database: inventory - User: lfriedman ]
11 899ms UPDATE cuhc SET count = '372' WHERE system = 'cuda-linux64-test3';[ Date: 2012-12-08 21:40:22 - Database: inventory - User: lfriedman ]
12 894ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';[ Date: 2012-12-08 21:40:23 - Database: inventory - User: lfriedman ]
13 843ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';[ Date: 2012-12-08 17:19:02 - Database: inventory - User: lfriedman ]
14 827ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';[ Date: 2012-12-08 17:19:08 - Database: nightly - User: lfriedman ]
15 821ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';[ Date: 2012-12-08 17:19:05 - Database: nightly - User: lfriedman ]
16 817ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';[ Date: 2012-12-08 17:39:02 - Database: inventory - User: lfriedman ]
17 809ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';[ Date: 2012-12-08 21:40:23 - Database: inventory - User: lfriedman ]
18 805ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';[ Date: 2012-12-08 21:40:23 - Database: inventory - User: lfriedman ]
19 794ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';[ Date: 2012-12-08 12:39:20 - Database: nightly - User: lfriedman ]
20 768ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('cuhc') AND c.relpersistence = 'u';[ Date: 2012-12-08 17:09:03 - Database: inventory - User: lfriedman ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 43s330ms 74 304ms 1s690ms 585ms select count(*) from pg_catalog.pg_class as c where c.oid = pgpool_regclass (?) and c.relpersistence = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 08 00 3 2s905ms 968ms 07 1 583ms 583ms 08 4 2s340ms 585ms 11 2 1s361ms 680ms 16 58 31s227ms 538ms 17 1 767ms 767ms 20 4 3s176ms 794ms 22 1 967ms 967ms [ User: lfriedman - Total duration: 43s330ms - Times executed: 74 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';
Date: 2012-12-08 01:19:45 Duration: 1s690ms Database: inventory User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('cuhc') AND c.relpersistence = 'u';
Date: 2012-12-08 23:19:35 Duration: 967ms Database: inventory User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';
Date: 2012-12-08 17:39:01 Duration: 951ms Database: nightly User: lfriedman
2 40s841ms 1 40s841ms 40s841ms 40s841ms delete from filterout where last_update = ?; insert into filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) select script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion from filterout where last_update = ( select max(last_update) from filterout where last_update != now()::date);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 08 23 1 40s841ms 40s841ms [ User: lfriedman - Total duration: 40s841ms - Times executed: 1 ]
-
DELETE FROM filterout WHERE last_update = '2012-12-08'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);
Date: 2012-12-08 00:00:42 Duration: 40s841ms Database: nightly User: lfriedman
3 8s10ms 3 446ms 4s543ms 2s670ms select testname, category, bug from filterout where os = ? and osversion = ? and arch = ? and gpu = ? and branch = ? and build = ? and vc = ? and script = ? and active = ? and last_update = ? and farm = ? order by testname;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 08 00 1 3s20ms 3s20ms 06 1 4s543ms 4s543ms 14 1 446ms 446ms [ User: lfriedman - Total duration: 8s10ms - Times executed: 3 ]
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.x86_64' AND arch = 'x86_64' AND gpu = '100' AND branch = 'cuda_a' AND build = 'debug' AND vc = 'g' AND script = 'kepler-apps_sm35.sh' AND active = 't' AND last_update = '2012-12-08' AND farm = '0' ORDER BY testname;
Date: 2012-12-08 07:40:25 Duration: 4s543ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'WINXP' AND osversion = 'WINXP' AND arch = 'i686' AND gpu = '200' AND branch = 'cuda_a' AND build = 'debug' AND vc = 'g' AND script = 'cuda_gpgpu-smoke.sh' AND active = 't' AND last_update = '2012-12-08' AND farm = '0' ORDER BY testname;
Date: 2012-12-08 01:19:25 Duration: 3s20ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'VISTA' AND osversion = 'VISTA' AND arch = 'i686' AND gpu = '84' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'cuda_gpgpu-smoke.sh' AND active = 't' AND last_update = '2012-12-08' AND farm = '0' ORDER BY testname;
Date: 2012-12-08 15:19:52 Duration: 446ms Database: nightly User: lfriedman Bind query: yes
4 7s221ms 2 3s603ms 3s618ms 3s610ms select testname from nppsmoketests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 08 06 1 3s618ms 3s618ms 20 1 3s603ms 3s603ms [ User: lfriedman - Total duration: 7s221ms - Times executed: 2 ]
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 07:40:41 Duration: 3s618ms Database: pvs User: lfriedman Bind query: yes
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 21:40:16 Duration: 3s603ms Database: pvs User: lfriedman Bind query: yes
5 3s465ms 6 418ms 899ms 577ms update cuhc set count = ? where system = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 08 07 1 418ms 418ms 16 3 1s682ms 560ms 20 2 1s364ms 682ms [ User: lfriedman - Total duration: 3s465ms - Times executed: 6 ]
-
UPDATE cuhc SET count = '372' WHERE system = 'cuda-linux64-test3';
Date: 2012-12-08 21:40:22 Duration: 899ms Database: inventory User: lfriedman
-
UPDATE cuhc SET count = '315' WHERE system = 'cuda-win764-test14';
Date: 2012-12-08 17:13:30 Duration: 681ms Database: inventory User: lfriedman
-
UPDATE cuhc SET count = '315' WHERE system = 'cuda-win7-gputest14';
Date: 2012-12-08 17:14:20 Duration: 564ms Database: inventory User: lfriedman
6 1s285ms 2 558ms 726ms 642ms select title from saved_searches where is_default = ? order by id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 08 16 2 1s285ms 642ms [ User: lfriedman - Total duration: 1s285ms - Times executed: 2 ]
-
SELECT title FROM saved_searches WHERE is_default = 't' order by id;
Date: 2012-12-08 17:19:02 Duration: 726ms Database: inventory User: lfriedman
-
SELECT title FROM saved_searches WHERE is_default = 't' order by id;
Date: 2012-12-08 17:39:02 Duration: 558ms Database: inventory User: lfriedman
7 1s130ms 2 513ms 617ms 565ms select branch from gpu where active = ? and system not like ? and p4client is not null and dbname = ? group by branch order by branch;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 08 16 2 1s130ms 565ms [ User: lfriedman - Total duration: 1s130ms - Times executed: 2 ]
-
SELECT branch FROM gpu WHERE active = 't' AND system NOT LIKE '%cvs%' AND p4client IS NOT NULL AND dbname = 'nightly' GROUP BY branch ORDER BY branch;
Date: 2012-12-08 17:19:02 Duration: 617ms Database: nightly User: lfriedman
-
SELECT branch FROM gpu WHERE active = 't' AND system NOT LIKE '%cvs%' AND p4client IS NOT NULL AND dbname = 'nightly' GROUP BY branch ORDER BY branch;
Date: 2012-12-08 17:39:02 Duration: 513ms Database: nightly User: lfriedman
8 765ms 1 765ms 765ms 765ms select count(id) from tests where (active is null or active != ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 08 16 1 765ms 765ms [ User: lfriedman - Total duration: 765ms - Times executed: 1 ]
-
SELECT count(id) FROM tests where (active IS NULL OR active != 'disabled');
Date: 2012-12-08 17:20:29 Duration: 765ms Database: nightly User: lfriedman
9 710ms 1 710ms 710ms 710ms select count(id) from builds where (active is null or active != ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 08 20 1 710ms 710ms [ User: lfriedman - Total duration: 710ms - Times executed: 1 ]
-
SELECT count(id) FROM builds where (active IS NULL OR active != 'disabled');
Date: 2012-12-08 21:40:27 Duration: 710ms Database: cbs User: lfriedman
10 705ms 1 705ms 705ms 705ms insert into chart_cache (chart, filedate, branch, file) values (?, ?, ?, ( select bytea_import (?)));Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 08 08 1 705ms 705ms [ User: lfriedman - Total duration: 705ms - Times executed: 1 ]
-
INSERT INTO chart_cache (chart, filedate, branch, file) VALUES ('CUDA+GK1xx+%28Kepler%29', '2012-12-08 08:59:01', 'cuda_a', ( SELECT bytea_import ('/tmp/chart-importer/CUDA+GK1xx+%28Kepler%29-cuda_a.gz')));
Date: 2012-12-08 09:00:35 Duration: 705ms Database: nightly User: lfriedman
11 636ms 1 636ms 636ms 636ms select testname from memchecktests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 08 00 1 636ms 636ms [ User: lfriedman - Total duration: 636ms - Times executed: 1 ]
-
SELECT testname FROM memchecktests WHERE suiteid = '54352' AND current_status = 'FAILED' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 01:19:45 Duration: 636ms Database: nightly User: lfriedman Bind query: yes
12 341ms 1 341ms 341ms 341ms update gpu set dd_date = ?, last_update = ( select date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 08 16 1 341ms 341ms [ User: lfriedman - Total duration: 341ms - Times executed: 1 ]
-
UPDATE gpu SET dd_date = 'Fri Dec 7 08:24:24 PST 2012', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-linux-gputest21';
Date: 2012-12-08 17:58:30 Duration: 341ms Database: nightly User: lfriedman
13 331ms 1 331ms 331ms 331ms delete from chart_cache where age(now(), filedate) > interval ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 08 16 1 331ms 331ms [ User: lfriedman - Total duration: 331ms - Times executed: 1 ]
-
DELETE FROM chart_cache WHERE age(now(), filedate) > INTERVAL '10 days';
Date: 2012-12-08 17:39:03 Duration: 331ms Database: nightly User: lfriedman
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 74 43s330ms 304ms 1s690ms 585ms select count(*) from pg_catalog.pg_class as c where c.oid = pgpool_regclass (?) and c.relpersistence = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 08 00 3 2s905ms 968ms 07 1 583ms 583ms 08 4 2s340ms 585ms 11 2 1s361ms 680ms 16 58 31s227ms 538ms 17 1 767ms 767ms 20 4 3s176ms 794ms 22 1 967ms 967ms [ User: lfriedman - Total duration: 43s330ms - Times executed: 74 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';
Date: 2012-12-08 01:19:45 Duration: 1s690ms Database: inventory User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('cuhc') AND c.relpersistence = 'u';
Date: 2012-12-08 23:19:35 Duration: 967ms Database: inventory User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';
Date: 2012-12-08 17:39:01 Duration: 951ms Database: nightly User: lfriedman
2 6 3s465ms 418ms 899ms 577ms update cuhc set count = ? where system = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 08 07 1 418ms 418ms 16 3 1s682ms 560ms 20 2 1s364ms 682ms [ User: lfriedman - Total duration: 3s465ms - Times executed: 6 ]
-
UPDATE cuhc SET count = '372' WHERE system = 'cuda-linux64-test3';
Date: 2012-12-08 21:40:22 Duration: 899ms Database: inventory User: lfriedman
-
UPDATE cuhc SET count = '315' WHERE system = 'cuda-win764-test14';
Date: 2012-12-08 17:13:30 Duration: 681ms Database: inventory User: lfriedman
-
UPDATE cuhc SET count = '315' WHERE system = 'cuda-win7-gputest14';
Date: 2012-12-08 17:14:20 Duration: 564ms Database: inventory User: lfriedman
3 3 8s10ms 446ms 4s543ms 2s670ms select testname, category, bug from filterout where os = ? and osversion = ? and arch = ? and gpu = ? and branch = ? and build = ? and vc = ? and script = ? and active = ? and last_update = ? and farm = ? order by testname;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 08 00 1 3s20ms 3s20ms 06 1 4s543ms 4s543ms 14 1 446ms 446ms [ User: lfriedman - Total duration: 8s10ms - Times executed: 3 ]
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.x86_64' AND arch = 'x86_64' AND gpu = '100' AND branch = 'cuda_a' AND build = 'debug' AND vc = 'g' AND script = 'kepler-apps_sm35.sh' AND active = 't' AND last_update = '2012-12-08' AND farm = '0' ORDER BY testname;
Date: 2012-12-08 07:40:25 Duration: 4s543ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'WINXP' AND osversion = 'WINXP' AND arch = 'i686' AND gpu = '200' AND branch = 'cuda_a' AND build = 'debug' AND vc = 'g' AND script = 'cuda_gpgpu-smoke.sh' AND active = 't' AND last_update = '2012-12-08' AND farm = '0' ORDER BY testname;
Date: 2012-12-08 01:19:25 Duration: 3s20ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'VISTA' AND osversion = 'VISTA' AND arch = 'i686' AND gpu = '84' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'cuda_gpgpu-smoke.sh' AND active = 't' AND last_update = '2012-12-08' AND farm = '0' ORDER BY testname;
Date: 2012-12-08 15:19:52 Duration: 446ms Database: nightly User: lfriedman Bind query: yes
4 2 7s221ms 3s603ms 3s618ms 3s610ms select testname from nppsmoketests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 08 06 1 3s618ms 3s618ms 20 1 3s603ms 3s603ms [ User: lfriedman - Total duration: 7s221ms - Times executed: 2 ]
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 07:40:41 Duration: 3s618ms Database: pvs User: lfriedman Bind query: yes
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 21:40:16 Duration: 3s603ms Database: pvs User: lfriedman Bind query: yes
5 2 1s285ms 558ms 726ms 642ms select title from saved_searches where is_default = ? order by id;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 08 16 2 1s285ms 642ms [ User: lfriedman - Total duration: 1s285ms - Times executed: 2 ]
-
SELECT title FROM saved_searches WHERE is_default = 't' order by id;
Date: 2012-12-08 17:19:02 Duration: 726ms Database: inventory User: lfriedman
-
SELECT title FROM saved_searches WHERE is_default = 't' order by id;
Date: 2012-12-08 17:39:02 Duration: 558ms Database: inventory User: lfriedman
6 2 1s130ms 513ms 617ms 565ms select branch from gpu where active = ? and system not like ? and p4client is not null and dbname = ? group by branch order by branch;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 08 16 2 1s130ms 565ms [ User: lfriedman - Total duration: 1s130ms - Times executed: 2 ]
-
SELECT branch FROM gpu WHERE active = 't' AND system NOT LIKE '%cvs%' AND p4client IS NOT NULL AND dbname = 'nightly' GROUP BY branch ORDER BY branch;
Date: 2012-12-08 17:19:02 Duration: 617ms Database: nightly User: lfriedman
-
SELECT branch FROM gpu WHERE active = 't' AND system NOT LIKE '%cvs%' AND p4client IS NOT NULL AND dbname = 'nightly' GROUP BY branch ORDER BY branch;
Date: 2012-12-08 17:39:02 Duration: 513ms Database: nightly User: lfriedman
7 1 40s841ms 40s841ms 40s841ms 40s841ms delete from filterout where last_update = ?; insert into filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) select script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion from filterout where last_update = ( select max(last_update) from filterout where last_update != now()::date);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 08 23 1 40s841ms 40s841ms [ User: lfriedman - Total duration: 40s841ms - Times executed: 1 ]
-
DELETE FROM filterout WHERE last_update = '2012-12-08'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);
Date: 2012-12-08 00:00:42 Duration: 40s841ms Database: nightly User: lfriedman
8 1 765ms 765ms 765ms 765ms select count(id) from tests where (active is null or active != ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 08 16 1 765ms 765ms [ User: lfriedman - Total duration: 765ms - Times executed: 1 ]
-
SELECT count(id) FROM tests where (active IS NULL OR active != 'disabled');
Date: 2012-12-08 17:20:29 Duration: 765ms Database: nightly User: lfriedman
9 1 710ms 710ms 710ms 710ms select count(id) from builds where (active is null or active != ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 08 20 1 710ms 710ms [ User: lfriedman - Total duration: 710ms - Times executed: 1 ]
-
SELECT count(id) FROM builds where (active IS NULL OR active != 'disabled');
Date: 2012-12-08 21:40:27 Duration: 710ms Database: cbs User: lfriedman
10 1 705ms 705ms 705ms 705ms insert into chart_cache (chart, filedate, branch, file) values (?, ?, ?, ( select bytea_import (?)));Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 08 08 1 705ms 705ms [ User: lfriedman - Total duration: 705ms - Times executed: 1 ]
-
INSERT INTO chart_cache (chart, filedate, branch, file) VALUES ('CUDA+GK1xx+%28Kepler%29', '2012-12-08 08:59:01', 'cuda_a', ( SELECT bytea_import ('/tmp/chart-importer/CUDA+GK1xx+%28Kepler%29-cuda_a.gz')));
Date: 2012-12-08 09:00:35 Duration: 705ms Database: nightly User: lfriedman
11 1 636ms 636ms 636ms 636ms select testname from memchecktests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 08 00 1 636ms 636ms [ User: lfriedman - Total duration: 636ms - Times executed: 1 ]
-
SELECT testname FROM memchecktests WHERE suiteid = '54352' AND current_status = 'FAILED' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 01:19:45 Duration: 636ms Database: nightly User: lfriedman Bind query: yes
12 1 341ms 341ms 341ms 341ms update gpu set dd_date = ?, last_update = ( select date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 08 16 1 341ms 341ms [ User: lfriedman - Total duration: 341ms - Times executed: 1 ]
-
UPDATE gpu SET dd_date = 'Fri Dec 7 08:24:24 PST 2012', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-linux-gputest21';
Date: 2012-12-08 17:58:30 Duration: 341ms Database: nightly User: lfriedman
13 1 331ms 331ms 331ms 331ms delete from chart_cache where age(now(), filedate) > interval ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 08 16 1 331ms 331ms [ User: lfriedman - Total duration: 331ms - Times executed: 1 ]
-
DELETE FROM chart_cache WHERE age(now(), filedate) > INTERVAL '10 days';
Date: 2012-12-08 17:39:03 Duration: 331ms Database: nightly User: lfriedman
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 40s841ms 40s841ms 40s841ms 1 40s841ms delete from filterout where last_update = ?; insert into filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) select script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion from filterout where last_update = ( select max(last_update) from filterout where last_update != now()::date);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 08 23 1 40s841ms 40s841ms [ User: lfriedman - Total duration: 40s841ms - Times executed: 1 ]
-
DELETE FROM filterout WHERE last_update = '2012-12-08'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);
Date: 2012-12-08 00:00:42 Duration: 40s841ms Database: nightly User: lfriedman
2 3s603ms 3s618ms 3s610ms 2 7s221ms select testname from nppsmoketests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 08 06 1 3s618ms 3s618ms 20 1 3s603ms 3s603ms [ User: lfriedman - Total duration: 7s221ms - Times executed: 2 ]
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 07:40:41 Duration: 3s618ms Database: pvs User: lfriedman Bind query: yes
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 21:40:16 Duration: 3s603ms Database: pvs User: lfriedman Bind query: yes
3 446ms 4s543ms 2s670ms 3 8s10ms select testname, category, bug from filterout where os = ? and osversion = ? and arch = ? and gpu = ? and branch = ? and build = ? and vc = ? and script = ? and active = ? and last_update = ? and farm = ? order by testname;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 08 00 1 3s20ms 3s20ms 06 1 4s543ms 4s543ms 14 1 446ms 446ms [ User: lfriedman - Total duration: 8s10ms - Times executed: 3 ]
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.x86_64' AND arch = 'x86_64' AND gpu = '100' AND branch = 'cuda_a' AND build = 'debug' AND vc = 'g' AND script = 'kepler-apps_sm35.sh' AND active = 't' AND last_update = '2012-12-08' AND farm = '0' ORDER BY testname;
Date: 2012-12-08 07:40:25 Duration: 4s543ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'WINXP' AND osversion = 'WINXP' AND arch = 'i686' AND gpu = '200' AND branch = 'cuda_a' AND build = 'debug' AND vc = 'g' AND script = 'cuda_gpgpu-smoke.sh' AND active = 't' AND last_update = '2012-12-08' AND farm = '0' ORDER BY testname;
Date: 2012-12-08 01:19:25 Duration: 3s20ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'VISTA' AND osversion = 'VISTA' AND arch = 'i686' AND gpu = '84' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'cuda_gpgpu-smoke.sh' AND active = 't' AND last_update = '2012-12-08' AND farm = '0' ORDER BY testname;
Date: 2012-12-08 15:19:52 Duration: 446ms Database: nightly User: lfriedman Bind query: yes
4 765ms 765ms 765ms 1 765ms select count(id) from tests where (active is null or active != ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 08 16 1 765ms 765ms [ User: lfriedman - Total duration: 765ms - Times executed: 1 ]
-
SELECT count(id) FROM tests where (active IS NULL OR active != 'disabled');
Date: 2012-12-08 17:20:29 Duration: 765ms Database: nightly User: lfriedman
5 710ms 710ms 710ms 1 710ms select count(id) from builds where (active is null or active != ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 08 20 1 710ms 710ms [ User: lfriedman - Total duration: 710ms - Times executed: 1 ]
-
SELECT count(id) FROM builds where (active IS NULL OR active != 'disabled');
Date: 2012-12-08 21:40:27 Duration: 710ms Database: cbs User: lfriedman
6 705ms 705ms 705ms 1 705ms insert into chart_cache (chart, filedate, branch, file) values (?, ?, ?, ( select bytea_import (?)));Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 08 08 1 705ms 705ms [ User: lfriedman - Total duration: 705ms - Times executed: 1 ]
-
INSERT INTO chart_cache (chart, filedate, branch, file) VALUES ('CUDA+GK1xx+%28Kepler%29', '2012-12-08 08:59:01', 'cuda_a', ( SELECT bytea_import ('/tmp/chart-importer/CUDA+GK1xx+%28Kepler%29-cuda_a.gz')));
Date: 2012-12-08 09:00:35 Duration: 705ms Database: nightly User: lfriedman
7 558ms 726ms 642ms 2 1s285ms select title from saved_searches where is_default = ? order by id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 08 16 2 1s285ms 642ms [ User: lfriedman - Total duration: 1s285ms - Times executed: 2 ]
-
SELECT title FROM saved_searches WHERE is_default = 't' order by id;
Date: 2012-12-08 17:19:02 Duration: 726ms Database: inventory User: lfriedman
-
SELECT title FROM saved_searches WHERE is_default = 't' order by id;
Date: 2012-12-08 17:39:02 Duration: 558ms Database: inventory User: lfriedman
8 636ms 636ms 636ms 1 636ms select testname from memchecktests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 08 00 1 636ms 636ms [ User: lfriedman - Total duration: 636ms - Times executed: 1 ]
-
SELECT testname FROM memchecktests WHERE suiteid = '54352' AND current_status = 'FAILED' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 01:19:45 Duration: 636ms Database: nightly User: lfriedman Bind query: yes
9 304ms 1s690ms 585ms 74 43s330ms select count(*) from pg_catalog.pg_class as c where c.oid = pgpool_regclass (?) and c.relpersistence = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 08 00 3 2s905ms 968ms 07 1 583ms 583ms 08 4 2s340ms 585ms 11 2 1s361ms 680ms 16 58 31s227ms 538ms 17 1 767ms 767ms 20 4 3s176ms 794ms 22 1 967ms 967ms [ User: lfriedman - Total duration: 43s330ms - Times executed: 74 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';
Date: 2012-12-08 01:19:45 Duration: 1s690ms Database: inventory User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('cuhc') AND c.relpersistence = 'u';
Date: 2012-12-08 23:19:35 Duration: 967ms Database: inventory User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';
Date: 2012-12-08 17:39:01 Duration: 951ms Database: nightly User: lfriedman
10 418ms 899ms 577ms 6 3s465ms update cuhc set count = ? where system = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 08 07 1 418ms 418ms 16 3 1s682ms 560ms 20 2 1s364ms 682ms [ User: lfriedman - Total duration: 3s465ms - Times executed: 6 ]
-
UPDATE cuhc SET count = '372' WHERE system = 'cuda-linux64-test3';
Date: 2012-12-08 21:40:22 Duration: 899ms Database: inventory User: lfriedman
-
UPDATE cuhc SET count = '315' WHERE system = 'cuda-win764-test14';
Date: 2012-12-08 17:13:30 Duration: 681ms Database: inventory User: lfriedman
-
UPDATE cuhc SET count = '315' WHERE system = 'cuda-win7-gputest14';
Date: 2012-12-08 17:14:20 Duration: 564ms Database: inventory User: lfriedman
11 513ms 617ms 565ms 2 1s130ms select branch from gpu where active = ? and system not like ? and p4client is not null and dbname = ? group by branch order by branch;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 08 16 2 1s130ms 565ms [ User: lfriedman - Total duration: 1s130ms - Times executed: 2 ]
-
SELECT branch FROM gpu WHERE active = 't' AND system NOT LIKE '%cvs%' AND p4client IS NOT NULL AND dbname = 'nightly' GROUP BY branch ORDER BY branch;
Date: 2012-12-08 17:19:02 Duration: 617ms Database: nightly User: lfriedman
-
SELECT branch FROM gpu WHERE active = 't' AND system NOT LIKE '%cvs%' AND p4client IS NOT NULL AND dbname = 'nightly' GROUP BY branch ORDER BY branch;
Date: 2012-12-08 17:39:02 Duration: 513ms Database: nightly User: lfriedman
12 341ms 341ms 341ms 1 341ms update gpu set dd_date = ?, last_update = ( select date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 08 16 1 341ms 341ms [ User: lfriedman - Total duration: 341ms - Times executed: 1 ]
-
UPDATE gpu SET dd_date = 'Fri Dec 7 08:24:24 PST 2012', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-linux-gputest21';
Date: 2012-12-08 17:58:30 Duration: 341ms Database: nightly User: lfriedman
13 331ms 331ms 331ms 1 331ms delete from chart_cache where age(now(), filedate) > interval ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 08 16 1 331ms 331ms [ User: lfriedman - Total duration: 331ms - Times executed: 1 ]
-
DELETE FROM chart_cache WHERE age(now(), filedate) > INTERVAL '10 days';
Date: 2012-12-08 17:39:03 Duration: 331ms Database: nightly User: lfriedman
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 673ms 1 673ms 673ms 673ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM cider WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Dec 08 07 1 673ms 673ms [ User: lfriedman - Total duration: 37ms - Times executed: 1 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM cider WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 08:59:32 Duration: 673ms Database: postgres User: nightly Remote: lfriedman
2 571ms 1 571ms 571ms 571ms UPDATE saved_searches SET last_used = NOW() WHERE LOWER(title) = LOWER($1);Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 04 1 571ms 571ms [ User: lfriedman - Total duration: 1ms - Times executed: 1 ]
-
UPDATE saved_searches SET last_used = NOW() WHERE LOWER(title) = LOWER($1);
Date: 2012-12-07 06:19:28 Duration: 571ms Database: postgres User: inventory Remote: lfriedman
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 4s613ms 6 370ms 1s558ms 768ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM viper WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Dec 08 09 1 1s558ms 1s558ms Dec 08 08 1 708ms 708ms Dec 08 10 1 562ms 562ms 14 1 705ms 705ms 20 1 370ms 370ms 22 1 708ms 708ms [ User: lfriedman - Total duration: 1ms - Times executed: 6 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM viper WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 10:01:16 Duration: 1s558ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM viper WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:41:33 Duration: 708ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM viper WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 23:19:36 Duration: 708ms Database: postgres User: nightly Remote: lfriedman
2 4s316ms 4 378ms 2s142ms 1s79ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmoke WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 23 1 2s142ms 2s142ms 07 1 1s245ms 1s245ms 16 1 378ms 378ms 19 1 550ms 550ms [ User: lfriedman - Total duration: 1ms - Times executed: 4 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmoke WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 01:40:34 Duration: 2s142ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmoke WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:41:30 Duration: 1s245ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmoke WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 21:40:23 Duration: 550ms Database: postgres User: pvs Remote: lfriedman
3 3s239ms 2 726ms 2s512ms 1s619ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr30 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 23 1 2s512ms 2s512ms 19 1 726ms 726ms [ User: lfriedman - Total duration: 0ms - Times executed: 2 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr30 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 01:40:42 Duration: 2s512ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr30 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 21:40:29 Duration: 726ms Database: postgres User: pvs Remote: lfriedman
4 3s174ms 5 480ms 811ms 634ms SELECT testname FROM curandtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 23 1 758ms 758ms 07 1 545ms 545ms 09 1 480ms 480ms 19 1 811ms 811ms 21 1 578ms 578ms [ User: lfriedman - Total duration: 77ms - Times executed: 5 ]
-
SELECT testname FROM curandtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 21:40:10 Duration: 811ms Database: postgres User: pvs Remote: lfriedman
-
SELECT testname FROM curandtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-06 01:40:25 Duration: 758ms Database: postgres User: pvs Remote: lfriedman
-
SELECT testname FROM curandtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 23:19:31 Duration: 578ms Database: postgres User: nightly Remote: lfriedman
5 1s967ms 4 390ms 579ms 491ms SELECT testname FROM thrusttests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 14 1 496ms 496ms 07 1 390ms 390ms 09 1 579ms 579ms 21 1 500ms 500ms [ User: lfriedman - Total duration: 3s436ms - Times executed: 4 ]
-
SELECT testname FROM thrusttests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 11:20:08 Duration: 579ms Database: postgres User: nightly Remote: lfriedman
-
SELECT testname FROM thrusttests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 23:19:37 Duration: 500ms Database: postgres User: nightly Remote: lfriedman
-
SELECT testname FROM thrusttests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-06 16:39:40 Duration: 496ms Database: postgres User: nightly Remote: lfriedman
6 1s948ms 1 1s948ms 1s948ms 1s948ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr40 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 23 1 1s948ms 1s948ms [ User: lfriedman - Total duration: 0ms - Times executed: 1 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr40 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 01:40:46 Duration: 1s948ms Database: postgres User: pvs Remote: lfriedman
7 1s894ms 3 407ms 792ms 631ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM thrust WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 08 1 407ms 407ms 14 1 792ms 792ms 13 1 695ms 695ms [ User: lfriedman - Total duration: 6ms - Times executed: 3 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM thrust WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 16:39:41 Duration: 792ms Database: postgres User: nightly Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM thrust WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 15:20:05 Duration: 695ms Database: postgres User: nightly Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM thrust WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 10:01:19 Duration: 407ms Database: postgres User: pvs Remote: lfriedman
8 1s889ms 3 461ms 916ms 629ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM oclapps WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 23 1 916ms 916ms 08 1 461ms 461ms 07 1 511ms 511ms [ User: lfriedman - Total duration: 0ms - Times executed: 3 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM oclapps WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 01:40:38 Duration: 916ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM oclapps WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:20:13 Duration: 511ms Database: postgres User: nightly Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM oclapps WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 10:01:22 Duration: 461ms Database: postgres User: pvs Remote: lfriedman
9 1s834ms 3 342ms 959ms 611ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmokenew WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 10 1 531ms 531ms 19 1 959ms 959ms 21 1 342ms 342ms [ User: lfriedman - Total duration: 0ms - Times executed: 3 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmokenew WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 21:40:22 Duration: 959ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmokenew WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 12:41:11 Duration: 531ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmokenew WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 23:19:32 Duration: 342ms Database: postgres User: nightly Remote: lfriedman
10 1s673ms 2 380ms 1s292ms 836ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr32 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 23 1 1s292ms 1s292ms 03 1 380ms 380ms [ User: lfriedman - Total duration: 0ms - Times executed: 2 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr32 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 01:40:44 Duration: 1s292ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr32 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 05:00:43 Duration: 380ms Database: postgres User: pvs Remote: lfriedman
11 1s618ms 2 720ms 898ms 809ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM interop32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 08 1 898ms 898ms 07 1 720ms 720ms [ User: lfriedman - Total duration: 10ms - Times executed: 2 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM interop32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 10:01:09 Duration: 898ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM interop32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:41:27 Duration: 720ms Database: postgres User: pvs Remote: lfriedman
12 1s481ms 1 1s481ms 1s481ms 1s481ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 07 1 1s481ms 1s481ms [ User: lfriedman - Total duration: 0ms - Times executed: 1 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:41:42 Duration: 1s481ms Database: postgres User: pvs Remote: lfriedman
13 1s365ms 1 1s365ms 1s365ms 1s365ms SELECT testname FROM njcublastests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 08 1 1s365ms 1s365ms [ User: lfriedman - Total duration: 1s167ms - Times executed: 1 ]
-
SELECT testname FROM njcublastests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-06 10:00:38 Duration: 1s365ms Database: postgres User: pvs Remote: lfriedman parameters: $1 = '4110', $2 = 'FAILED'
14 1s247ms 3 310ms 567ms 415ms SELECT testname FROM toolssharedtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 23 1 368ms 368ms 13 1 567ms 567ms 21 1 310ms 310ms [ User: lfriedman - Total duration: 1ms - Times executed: 3 ]
-
SELECT testname FROM toolssharedtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 15:20:09 Duration: 567ms Database: postgres User: nightly Remote: lfriedman
-
SELECT testname FROM toolssharedtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 01:19:46 Duration: 368ms Database: postgres User: nightly Remote: lfriedman
-
SELECT testname FROM toolssharedtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 23:19:40 Duration: 310ms Database: postgres User: nightly Remote: lfriedman
15 1s175ms 2 483ms 691ms 587ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM samples WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 07 1 483ms 483ms 19 1 691ms 691ms [ User: lfriedman - Total duration: 9ms - Times executed: 2 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM samples WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 21:40:21 Duration: 691ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM samples WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:41:28 Duration: 483ms Database: postgres User: pvs Remote: lfriedman
16 1s166ms 2 423ms 743ms 583ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM memcheck_bcr32 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 10 1 423ms 423ms 05 1 743ms 743ms [ User: lfriedman - Total duration: 0ms - Times executed: 2 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM memcheck_bcr32 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 07:40:53 Duration: 743ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM memcheck_bcr32 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 12:41:20 Duration: 423ms Database: postgres User: pvs Remote: lfriedman
17 1s51ms 1 1s51ms 1s51ms 1s51ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM nvprof32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 21 1 1s51ms 1s51ms [ User: lfriedman - Total duration: 0ms - Times executed: 1 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM nvprof32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 23:19:35 Duration: 1s51ms Database: postgres User: nightly Remote: lfriedman
18 984ms 2 306ms 677ms 492ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM dblcublas WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 08 1 306ms 306ms 16 1 677ms 677ms [ User: lfriedman - Total duration: 0ms - Times executed: 2 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM dblcublas WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 18:19:21 Duration: 677ms Database: postgres User: nightly Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM dblcublas WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 10:00:40 Duration: 306ms Database: postgres User: pvs Remote: lfriedman
19 921ms 1 921ms 921ms 921ms SELECT testname FROM nppsmoketests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 19 1 921ms 921ms [ User: lfriedman - Total duration: 126ms - Times executed: 1 ]
-
SELECT testname FROM nppsmoketests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 21:40:11 Duration: 921ms Database: postgres User: pvs Remote: lfriedman
20 917ms 1 917ms 917ms 917ms SELECT testname FROM memchecktests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 23 1 917ms 917ms [ User: lfriedman - Total duration: 0ms - Times executed: 1 ]
-
SELECT testname FROM memchecktests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 01:19:44 Duration: 917ms Database: postgres User: nightly Remote: lfriedman
-
pgBouncer
Request Throughput
Key values
- 3,407 queries/s Request Peak
- 2012-12-08 01:01:20 Date
Bytes I/O Throughput
Key values
- 1,056,871 Bytes/s In Bytes Peak
- 2012-12-08 07:46:20 Date
- 1,012,654 Bytes/s Out Bytes Peak
- 2012-12-08 00:01:20 Date
Queries Average duration
Key values
- 38ms Average Duration Peak
- 2012-12-08 22:01:20 Date
Established Connections
Key values
- 210 connections Connection Peak
- 2012-12-08 08:35:38 Date
Connections per database
Key values
- nightly Main Database
- 1,270,326 connections Total
Database User Count albatros_dimp_test 33 lfriedman 33 gasworks2 566 lfriedman 566 grinderman 2,838 lfriedman 2,838 intranet 101,224 lfriedman 101,224 intranet_test 1,438 lfriedman 1,438 jdb 366 lfriedman 366 lfriedman_test 576 lfriedman 576 nightly 988,022 lfriedman 988,022 optique_production 288 lfriedman 288 pgbouncer 577 dalibo 577 sterne_production 675 lfriedman 675 vangard_prod 5,509 lfriedman 5,509 webmail 168,214 lfriedman 168,214 Connections per user
Key values
- lfriedman Main User
- 1,270,326 connections Total
Connections per host
Key values
- 10.10.10.22.13 Main host with 897036 connections
- 1,270,326 Total connections
Simultaneous sessions
Key values
- 350 sessions Session Peak
- 2012-12-08 14:50:23 Date
Histogram of session times
Key values
- 1,112,433 0-500ms duration
Sessions per database
Key values
- nightly Main Database
- 1,276,158 sessions Total
Database User Count Total Duration Average Duration albatros_dimp_test 40 9m44s 14s600ms gasworks2 820 5h44m5s 25s176ms grinderman 2,838 14m27s 305ms intranet 102,321 4d6h18m46s 3s599ms intranet_test 1,438 17h3m26s 42s702ms jdb 597 4h52m25s 29s388ms lfriedman_test 576 3s 5ms nightly 990,511 28d10h57m41s 2s482ms optique_production 324 36m15s 6s712ms pgbouncer 577 0ms 0ms sterne_production 1,087 8h53m28s 29s446ms vangard_prod 5,819 2d5h4m38s 32s836ms webmail 169,210 4d18h55m35s 2s445ms Sessions per user
Key values
- lfriedman Main User
- 1,276,158 sessions Total
Sessions per host
Key values
- 10.10.10.22.13 Main Host
- 1,276,158 sessions Total
Most used reserved pools
Key values
- lfriedman@nightly Most used reserved pool
- 1,507 Time used
- 1,529 Total time reserved pools was used
Rank Times used Reserved pool 1 1,507 lfriedman@nightlyTimes Reported Most used reserved pools #1
Day Hour Count Dec 08 23 55 00 36 01 34 02 41 03 44 04 62 05 72 06 75 07 80 08 76 09 79 10 61 11 40 12 27 13 40 14 58 15 78 16 68 17 76 18 85 19 85 20 83 21 73 22 79 2 19 lfriedman@webmailTimes Reported Most used reserved pools #2
Day Hour Count Dec 08 09 9 12 10 3 3 lfriedman@intranetTimes Reported Most used reserved pools #3
Day Hour Count Dec 08 07 1 10 2 Most Frequent Errors/Events
Key values
- 1,529 Max number of times the same event was reported
- 1,529 Total events found
Rank Times reported Error 1 1,529 WARNING: Taking connection from reserve_poolTimes Reported Most Frequent Error / Event #1
Day Hour Count Dec 08 23 55 00 36 01 34 02 41 03 44 04 62 05 72 06 75 07 81 08 76 09 88 10 63 11 40 12 37 13 40 14 58 15 78 16 68 17 76 18 85 19 85 20 83 21 73 22 79 - WARNING: Taking connection from reserve_pool
- WARNING: Taking connection from reserve_pool
- WARNING: Taking connection from reserve_pool
Date: 2012-12-08 17:40:23 Database: nightly User: lfriedman Remote: 10.10.10.22.13
Date: 2012-12-08 17:40:23 Database: nightly User: lfriedman Remote: 10.10.10.22.13
Date: 2012-12-08 17:40:23 Database: nightly User: lfriedman Remote: 10.10.10.22.13
-
Events
Log levels
Key values
- 5,793,075 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1920 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1,920 Max number of times the same event was reported
- 1,920 Total events found
Rank Times reported Error 1 1,920 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 08 23 80 00 80 01 80 02 80 03 80 04 80 05 80 06 80 07 80 08 80 09 80 10 80 11 80 12 80 13 80 14 80 15 80 16 80 17 80 18 80 19 80 20 80 21 80 22 80 - ERROR: invalid input syntax for type date: "" at character 32
Statement: UPDATE ddtracker SET datestamp='' WHERE os='WINXP' AND arch='i686' AND branch='cuda_a' AND dbname='nightly';
Date: 2012-12-08 18:29:01 Database: inventory Application: User: lfriedman Remote:
- Overview
- Connections
- Sessions
- Checkpoints
- Temp Files
- Vacuums
- Locks
- Queries
- Top
- Events
- PgBouncer
- Request Throughput
- Bytes I/O Throughput
- Queries Average duration
- Simultaneous sessions
- Histogram of sessions times
- Sessions per database
- Sessions per user
- Sessions per host
- Established connections
- Connections per database
- Connections per user
- Connections per host
- Most used reserved pools
- Most Frequent Errors/Events