pgBadger-
Global information
- Generated on Tue May 17 09:17:09 2022
- Log file: /data/pglog/huge_log_test/pgbouncer.log.1, ..., /data/pglog/huge_log_test/postgresql-Tue.log
- Parsed 48,851,970 log entries in 14m4s
- Log start from 2012-12-07 00:00:00 to 2012-12-07 23:59:59
-
Overview
Global Stats
- 331 Number of unique normalized queries
- 11,653,347 Number of queries
- 1d18h33m38s Total query duration
- 2012-12-07 00:00:00 First query
- 2012-12-07 23:59:59 Last query
- 744 queries/s at 2012-12-07 02:02:02 Query peak
- 1d18h33m38s Total query duration
- 571ms Prepare/parse total duration
- 10s497ms Bind total duration
- 1d18h33m27s Execute total duration
- 982 Number of events
- 5 Number of unique normalized events
- 967 Max number of times the same event was reported
- 0 Number of cancellation
- 10 Total number of automatic vacuums
- 51 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,232,003 Total number of sessions
- 79 sessions at 2012-12-07 02:44:23 Session peak
- 295d19h54m24s Total duration of sessions
- 11s451ms Average duration of sessions
- 5 Average queries per session
- 68ms Average queries duration per session
- 11s382ms Average idle time per session
- 2,232,001 Total number of connections
- 266 connections/s at 2012-12-07 02:02:02 Connection peak
- 6 Total number of databases
SQL Traffic
Key values
- 744 queries/s Query Peak
- 2012-12-07 02:02:02 Date
SELECT Traffic
Key values
- 98 queries/s Query Peak
- 2012-12-07 05:33:25 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 62 queries/s Query Peak
- 2012-12-07 07:37:52 Date
Queries duration
Key values
- 1d18h33m38s 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 07 00 922,072 0ms 41s106ms 12ms 3m28s 3m31s 3m56s 01 905,558 0ms 1s757ms 11ms 3m16s 3m19s 3m30s 02 942,735 0ms 56s896ms 13ms 3m43s 4m5s 24m6s 03 988,647 0ms 1s760ms 13ms 4m43s 5m8s 5m15s 04 378,360 0ms 3s355ms 11ms 2m7s 3m1s 3m25s 05 286,447 0ms 3m46s 29ms 3m52s 8m42s 31m10s 06 335,553 0ms 4m6s 26ms 6m20s 12m11s 22m3s 07 529,065 0ms 2m38s 19ms 5m9s 5m47s 15m37s 08 637,734 0ms 2m11s 14ms 3m45s 5m53s 7m31s 09 768,156 0ms 1m16s 12ms 3m 3m45s 5m54s 10 849,464 0ms 1m27s 14ms 3m59s 4m17s 6m23s 11 874,876 0ms 1s773ms 12ms 3m7s 3m11s 3m27s 12 881,041 0ms 1m11s 12ms 3m17s 4m4s 5m6s 13 884,404 0ms 1s960ms 11ms 3m9s 3m11s 3m14s 14 322,633 0ms 1s753ms 11ms 2m57s 3m7s 3m14s 15 81,443 0ms 462ms 10ms 43s251ms 45s520ms 1m6s 16 108,381 0ms 797ms 10ms 56s272ms 58s339ms 1m 17 124,660 0ms 238ms 10ms 55s155ms 56s873ms 1m 18 120,542 0ms 820ms 5ms 23s363ms 34s834ms 58s748ms 19 123,359 0ms 184ms 3ms 20s279ms 26s295ms 44s707ms 20 128,255 0ms 2s102ms 3ms 18s695ms 31s505ms 35s13ms 21 137,780 0ms 103ms 3ms 18s2ms 29s502ms 37s888ms 22 148,728 0ms 117ms 2ms 20s172ms 36s28ms 39s157ms 23 173,454 0ms 114ms 3ms 28s761ms 31s699ms 41s691ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 07 00 94 0 767ms 1s695ms 2s136ms 10s588ms 01 146 0 590ms 2s176ms 4s26ms 8s400ms 02 634 0 2s331ms 3s493ms 10s643ms 3m50s 03 86 0 679ms 2s28ms 2s831ms 3s436ms 04 13 0 1s77ms 0ms 1s1ms 2s384ms 05 1,330 0 1s815ms 3s151ms 27s54ms 13m35s 06 963 0 806ms 3s132ms 31s129ms 3m15s 07 322 0 661ms 6s600ms 8s414ms 13s431ms 08 482 0 555ms 3s732ms 9s405ms 41s202ms 09 297 0 756ms 1s364ms 2s105ms 33s787ms 10 73 0 864ms 1s720ms 2s522ms 3s173ms 11 89 0 633ms 1s717ms 2s537ms 3s892ms 12 428 0 688ms 2s530ms 9s904ms 54s14ms 13 61 0 790ms 1s737ms 2s350ms 3s420ms 14 29 0 590ms 483ms 1s75ms 2s154ms 15 1 0 462ms 0ms 0ms 0ms 16 3 0 354ms 0ms 0ms 305ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 10 0 652ms 0ms 0ms 2s590ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 07 00 1 1 1 1 10s868ms 0ms 0ms 795ms 01 2 8 4 1 568ms 0ms 0ms 1s20ms 02 0 120 1 0 1s339ms 0ms 328ms 2s21ms 03 24 0 0 1 792ms 0ms 802ms 1s628ms 04 251 0 0 13 782ms 2s426ms 6s422ms 11s974ms 05 132 1,434 61 94 1s619ms 21s392ms 1m27s 4m1s 06 328 2,152 47 62 1s581ms 33s91ms 1m36s 7m22s 07 50 2,542 19 56 1s230ms 28s814ms 1m21s 3m15s 08 55 1,033 10 27 1s36ms 3s727ms 14s257ms 2m10s 09 31 93 1 22 1s562ms 1s433ms 2s290ms 14s732ms 10 43 187 0 16 1s536ms 1s612ms 2s464ms 1m9s 11 19 0 0 6 723ms 0ms 453ms 1s630ms 12 2 61 2 5 1s679ms 0ms 809ms 7s22ms 13 0 0 0 2 345ms 0ms 0ms 0ms 14 0 0 0 3 396ms 0ms 0ms 328ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 4 0 0 3 623ms 0ms 0ms 421ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 4 0 0 1 782ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 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 07 00 0 3 3.00 0.00% 01 0 0 0.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 1 20 20.00 0.03% 07 0 0 0.00 0.00% 08 0 1 1.00 0.00% 09 0 26 26.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 14 14.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.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 10 10.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Dec 07 00 194,869 54.13/s 01 192,356 53.43/s 02 205,311 57.03/s 03 205,475 57.08/s 04 62,092 17.25/s 05 46,561 12.93/s 06 51,599 14.33/s 07 110,626 30.73/s 08 132,129 36.70/s 09 157,066 43.63/s 10 171,138 47.54/s 11 184,797 51.33/s 12 175,268 48.69/s 13 177,802 49.39/s 14 58,427 16.23/s 15 11,147 3.10/s 16 16,497 4.58/s 17 21,217 5.89/s 18 13,482 3.75/s 19 8,668 2.41/s 20 8,637 2.40/s 21 8,801 2.44/s 22 8,873 2.46/s 23 9,163 2.55/s Day Hour Count Average Duration Average idle time Dec 07 00 194,869 5s546ms 5s489ms 01 192,356 5s610ms 5s553ms 02 205,311 5s258ms 5s195ms 03 205,476 5s245ms 5s178ms 04 62,091 17s218ms 17s150ms 05 46,561 23s166ms 22s982ms 06 51,599 21s49ms 20s878ms 07 110,628 9s811ms 9s718ms 08 132,127 8s168ms 8s99ms 09 157,066 6s871ms 6s810ms 10 171,138 6s305ms 6s233ms 11 184,797 5s834ms 5s777ms 12 175,269 6s160ms 6s98ms 13 177,801 6s74ms 6s14ms 14 58,497 16s499ms 16s436ms 15 11,079 1m28s 1m28s 16 16,504 1m4s 1m4s 17 21,211 50s68ms 50s9ms 18 13,488 1m16s 1m16s 19 8,662 2m1s 2m1s 20 8,640 2m3s 2m3s 21 8,796 2m 2m 22 8,872 2m2s 2m2s 23 9,165 1m57s 1m57s -
Connections
Established Connections
Key values
- 266 connections Connection Peak
- 2012-12-07 02:02:02 Date
Connections per database
Key values
- nightly Main Database
- 2,232,001 connections Total
Connections per user
Key values
- lfriedman Main User
- 2,232,001 connections Total
-
Sessions
Simultaneous sessions
Key values
- 79 sessions Session Peak
- 2012-12-07 02:44:23 Date
Histogram of session times
Key values
- 1,362,960 1000-30000ms duration
Sessions per database
Key values
- nightly Main Database
- 2,232,003 sessions Total
Sessions per user
Key values
- lfriedman Main User
- 2,232,003 sessions Total
Sessions per host
Key values
- 10.31.96.124 Main Host
- 2,232,003 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 182,507 buffers Checkpoint Peak
- 2012-12-07 06:24:34 Date
- 210.020 seconds Highest write time
- 153.739 seconds Sync time
Checkpoints Wal files
Key values
- 115 files Wal files usage Peak
- 2012-12-07 05:50:58 Date
Checkpoints distance
Key values
- 0.00 Mo Distance Peak
- 2012-12-07 00:45:17 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Dec 07 00 74,555 2,406.294s 0.413s 2,406.77s 01 20,961 2,063.76s 0.178s 2,063.994s 02 22,195 2,093.686s 0.104s 2,093.848s 03 21,316 2,116.301s 0.102s 2,116.454s 04 47,433 2,299.988s 0.58s 2,300.619s 05 1,338,294 2,571.408s 305.761s 2,877.4s 06 1,286,860 2,278.729s 287.058s 2,566.084s 07 1,219,145 2,551.646s 241.282s 2,793.739s 08 693,279 2,227.931s 132.918s 2,360.936s 09 366,456 2,428.615s 14.108s 2,442.803s 10 463,863 2,468.153s 12.607s 2,480.866s 11 33,262 2,457.584s 0.274s 2,457.915s 12 174,737 2,225.872s 2.732s 2,228.68s 13 22,747 2,225.218s 0.15s 2,225.436s 14 13,376 1,244.215s 0.14s 1,244.415s 15 3,035 303.536s 0.189s 303.781s 16 5,222 522.161s 0.187s 522.403s 17 3,290 328.902s 0.126s 329.079s 18 2,860 285.789s 0.135s 285.979s 19 2,108 210.939s 0.095s 211.091s 20 2,398 239.411s 0.087s 239.552s 21 1,611 161.002s 0.092s 161.146s 22 1,619 161.854s 0.09s 161.998s 23 1,723 172.261s 0.107s 172.423s Day Hour Added Removed Recycled Synced files Longest sync Average sync Dec 07 00 0 0 81 3,852 0.026s 0s 01 0 0 59 2,372 0.008s 0s 02 0 0 58 1,071 0.003s 0s 03 0 0 59 764 0.003s 0s 04 0 0 55 12,289 0.007s 0s 05 0 0 642 17,498 31.633s 0.277s 06 0 0 586 13,744 24.497s 0.33s 07 0 0 607 11,501 22.186s 0.336s 08 0 0 289 11,595 22.709s 0.144s 09 0 0 171 9,028 3.071s 0.017s 10 0 0 229 6,135 3.763s 0.019s 11 0 0 59 4,267 0.002s 0s 12 0 0 113 4,381 2.218s 0.005s 13 0 0 59 2,730 0.007s 0s 14 0 0 60 1,447 0.002s 0s 15 0 0 60 1,030 0.002s 0s 16 0 0 59 1,350 0.007s 0s 17 0 0 59 654 0.002s 0s 18 0 0 59 548 0.009s 0s 19 0 0 59 521 0.001s 0s 20 0 0 58 410 0.003s 0s 21 0 0 59 441 0.004s 0s 22 0 0 59 442 0.001s 0s 23 0 0 59 478 0.001s 0s Day Hour Count Avg time (sec) Dec 07 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 07 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 07 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
- 18.12 sec Highest CPU-cost vacuum
Table public.gpu
Database nightly - 2012-12-07 05:33:26 Date
- 129.73 sec Highest CPU-cost analyze
Table public.nppsmoketests_2012_12
Database nightly - 2012-12-07 06:42:10 Date
Analyzes per table
Key values
- public.thrusttests_2012_12 (2) Main table analyzed (database nightly)
- 51 analyzes Total
Table Number of analyzes nightly.public.thrusttests_2012_12 2 nightly.public.dblcublastests_2012_12 2 nightly.public.nppsmoketests_2012_12 2 pvs.public.thrusttests_2012_12 2 pvs.public.sparse_cublastests_2012_12 2 pvs.public.njsmoketests_2012_12 2 nightly.public.cudasmoketests_2012_12 2 nightly.public.smoke32on64tests_2012_12 2 nightly.public.curandtests_2012_12 2 nightly.public.dblamodeltests_2012_12 2 pvs.public.nppsmoketests_2012_12 2 nightly.public.sparse_cublastests_2012_12 2 nightly.public.cublassmoketests_2012_12 2 nightly.public.mc_dblcublastests_2012_12 2 nightly.public.mathsmokesm2xtests_2012_12 2 pvs.public.cudasmoketests_2012_12 2 nightly.public.nvproftests_2012_12 2 nightly.public.cufftsmoketests_2012_12 2 nightly.public.mc_cusparsetests_2012_12 1 pvs.public.njdblcublastests_2012_12 1 nightly.public.njsmoketests_2012_12 1 cbs.public.systems 1 nightly.public.samplestests_2012_12 1 pvs.public.mc_dblcublastests_2012_12 1 inventory.public.user_preferences 1 nightly.public.dblcuffttests_2012_12 1 pvs.public.dblcublastests_2012_12 1 pvs.public.cublassmoketests_2012_12 1 pvs.public.dblamodeltests_2012_12 1 nightly.public.mc_cublastests_2012_12 1 pvs.public.cufftsmoketests_2012_12 1 nightly.public.oclconformance11tests_2012_12 1 nightly.public.profsmokenewtests_2012_12 1 Total 51 Vacuums per table
Key values
- public.gpu (6) Main table vacuumed on database nightly
- 10 vacuums Total
Tuples removed per table
Key values
- public.gpu (5961) Main table with removed tuples on database nightly
- 9671 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 07 00 0 0 01 0 0 02 1 0 03 0 0 04 0 2 05 3 13 06 1 7 07 1 8 08 3 5 09 1 4 10 0 5 11 0 0 12 0 3 13 0 1 14 0 1 15 0 0 16 0 2 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 18.12 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ExclusiveLock Main Lock Type
- 7 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 7 15s327ms 1s284ms 4s564ms 2s189ms copy nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) from stdin with csv header escape ?;-
COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 06:20:48 Database: nightly User: lfriedman
-
COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 06:20:53 Database: nightly User: lfriedman
-
COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 06:20:10 Database: nightly User: lfriedman
Queries that waited the most
Rank Wait time Query 1 4s564ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:32:25 - Database: nightly - User: lfriedman ]
2 3s213ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:33:28 - Database: nightly - User: lfriedman ]
3 1s912ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 06:17:24 - Database: nightly - User: lfriedman ]
4 1s681ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:32:06 - Database: nightly - User: lfriedman ]
5 1s460ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:31:20 - Database: nightly - User: lfriedman ]
6 1s284ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:31:49 - Database: nightly - User: lfriedman ]
7 1s210ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 07:52:33 - Database: nightly - User: lfriedman ]
-
Queries
Queries by type
Key values
- 5,061 Total read queries
- 9,036 Total write queries
Queries by database
Key values
- nightly Main database
- 10,158,952 Requests
- 1d17h3m48s (nightly)
- Main time consuming database
Database Request type Count Duration cbs Total 262,412 37m25s select 159 2m38s update 1,297 19m12s inventory Total 1,058,877 17m15s copy from 4 2s965ms delete 89 1m16s insert 9 10s748ms select 29 25s630ms update 82 54s86ms mbm Total 86,595 2m19s select 9 5s156ms update 6 4s554ms nightly Total 10,158,952 1d17h3m48s copy from 259 1h12m41s delete 52 1m20s insert 919 12m58s select 4,776 1h35m47s update 6,211 1h29m7s postgres Total 432 889ms pvs Total 86,079 32m36s copy from 50 10m4s delete 5 3s443ms insert 18 18s357ms select 88 2m35s update 35 25s451ms Queries by user
Key values
- lfriedman Main user
- 32,027,827 Requests
User Request type Count Duration lfriedman Total 32,027,827 4d21h58m19s copy from 635 2h37m10s ddl 2,964 0ms delete 287 5m49s insert 2,524 36m30s select 10,550 3h57m54s tcl 2 1s345ms update 12,523 3h11m27s postgres Total 811 1s836ms select 1 330ms Duration by user
Key values
- 4d21h58m19s (lfriedman) Main time consuming user
User Request type Count Duration lfriedman Total 32,027,827 4d21h58m19s copy from 635 2h37m10s ddl 2,964 0ms delete 287 5m49s insert 2,524 36m30s select 10,550 3h57m54s tcl 2 1s345ms update 12,523 3h11m27s postgres Total 811 1s836ms select 1 330ms Queries by host
Key values
- unknown Main host
- 32,028,638 Requests
- 4d21h58m21s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 11,653,347 Requests
- 1d18h33m27s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2012-12-07 19:45:02 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 6,570,052 0-1ms duration
Slowest individual queries
Rank Duration Query 1 4m6s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 06:20:48 - Database: nightly - User: lfriedman ]
2 4m5s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 06:20:53 - Database: nightly - User: lfriedman ]
3 4m5s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 06:20:10 - Database: nightly - User: lfriedman ]
4 3m46s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:33:45 - Database: nightly - User: lfriedman ]
5 3m40s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 06:21:04 - Database: nightly - User: lfriedman ]
6 3m36s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:34:02 - Database: nightly - User: lfriedman ]
7 2m38s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 07:38:14 - Database: nightly - User: lfriedman ]
8 2m36s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 06:17:29 - Database: nightly - User: lfriedman ]
9 2m23s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:03:25 - Database: nightly - User: lfriedman ]
10 2m19s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 07:52:51 - Database: nightly - User: lfriedman ]
11 2m11s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 08:37:24 - Database: nightly - User: lfriedman ]
12 2m11s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 07:53:28 - Database: nightly - User: lfriedman ]
13 1m51s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:31:15 - Database: nightly - User: lfriedman ]
14 1m37s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:49:33 - Database: nightly - User: lfriedman ]
15 1m37s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 08:00:05 - Database: nightly - User: lfriedman ]
16 1m31s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:42:50 - Database: nightly - User: lfriedman ]
17 1m31s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 06:40:44 - Database: nightly - User: lfriedman ]
18 1m28s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 08:32:18 - Database: nightly - User: lfriedman ]
19 1m28s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:47:56 - Database: nightly - User: lfriedman ]
20 1m27s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 10:43:49 - Database: nightly - User: lfriedman ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h24m3s 4,021 300ms 12s892ms 1s254ms 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 07 23 8 7s53ms 881ms 00 75 40s844ms 544ms 01 540 21m26s 2s383ms 04 1,272 38m15s 1s804ms 05 902 11m35s 770ms 06 252 2m19s 552ms 07 405 3m28s 513ms 08 213 2m18s 652ms 10 11 6s55ms 550ms 11 343 3m45s 657ms [ User: lfriedman - Total duration: 1h24m3s - Times executed: 4021 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('keplercublastests') AND c.relpersistence = 'u';
Date: 2012-12-07 02:44:37 Duration: 12s892ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('tests') AND c.relpersistence = 'u';
Date: 2012-12-07 02:44:37 Duration: 12s509ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('ddupdate') AND c.relpersistence = 'u';
Date: 2012-12-07 02:44:37 Duration: 11s707ms Database: nightly User: lfriedman
2 1h19m10s 43 1m4s 4m6s 1m50s copy nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) from stdin with csv header escape ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 07 04 11 21m8s 1m55s 05 12 27m43s 2m18s 06 9 15m5s 1m40s 07 5 7m46s 1m33s 08 2 2m22s 1m11s 09 3 3m52s 1m17s 11 1 1m11s 1m11s [ User: lfriedman - Total duration: 1h19m10s - Times executed: 43 ]
-
COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 06:20:48 Duration: 4m6s Database: nightly User: lfriedman
-
COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 06:20:53 Duration: 4m5s Database: nightly User: lfriedman
-
COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 06:20:10 Duration: 4m5s Database: nightly User: lfriedman
3 38m55s 2,666 300ms 9s690ms 875ms update gpu set dd_date = ?, last_update = ( select date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 07 23 1 820ms 820ms 00 4 2s201ms 550ms 01 61 1m23s 1s376ms 04 380 5m7s 809ms 05 728 12m22s 1s20ms 06 982 15m1s 917ms 07 360 3m32s 589ms 08 40 22s535ms 563ms 09 75 39s352ms 524ms 11 35 22s689ms 648ms [ User: lfriedman - Total duration: 38m55s - Times executed: 2666 ]
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win8-test14';
Date: 2012-12-07 07:52:28 Duration: 9s690ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win764-test29';
Date: 2012-12-07 07:52:28 Duration: 9s482ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win8-test5';
Date: 2012-12-07 07:52:28 Duration: 9s478ms Database: nightly User: lfriedman
4 19m10s 1,294 300ms 9s564ms 889ms update systems set daemon_update = now(), activated = ? where vm = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 07 01 14 21s250ms 1s517ms 04 293 4m48s 983ms 05 402 6m18s 940ms 06 385 5m35s 871ms 07 157 1m43s 657ms 08 14 7s21ms 501ms 09 25 13s899ms 555ms 11 4 3s105ms 776ms [ User: lfriedman - Total duration: 19m10s - Times executed: 1294 ]
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-win732-build12';
Date: 2012-12-07 07:52:28 Duration: 9s564ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-linux64-build0';
Date: 2012-12-07 07:52:28 Duration: 9s171ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-linux64-build9';
Date: 2012-12-07 07:52:28 Duration: 8s325ms Database: cbs User: lfriedman
5 18m36s 1,248 300ms 9s896ms 894ms update gpu set dd_date = ?, last_update = (date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 07 00 1 569ms 569ms 01 5 2s895ms 579ms 04 255 3m29s 820ms 05 387 6m18s 979ms 06 402 6m52s 1s24ms 07 154 1m29s 582ms 08 11 5s57ms 459ms 09 28 14s309ms 511ms 11 5 3s191ms 638ms [ User: lfriedman - Total duration: 18m36s - Times executed: 1248 ]
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs17';
Date: 2012-12-07 07:52:28 Duration: 9s896ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = 'Thu Dec 6 00:52:36 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux32-cvs6';
Date: 2012-12-07 07:52:28 Duration: 9s647ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs15';
Date: 2012-12-07 07:52:28 Duration: 9s629ms Database: nightly User: lfriedman
6 8m29s 572 681ms 15s37ms 890ms insert into proccheck (hostname, process, subtestid) values (?, ?, ?); delete from proccheck where age(now(), datestamp) > interval ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 07 23 1 795ms 795ms 00 2 1s615ms 807ms 02 24 19s416ms 809ms 03 251 3m20s 800ms 04 86 1m39s 1s154ms 05 38 42s396ms 1s115ms 06 29 25s892ms 892ms 07 41 37s363ms 911ms 08 29 23s346ms 805ms 09 42 35s254ms 839ms 10 19 15s373ms 809ms 11 2 1s616ms 808ms 15 4 3s186ms 796ms 17 4 3s204ms 801ms [ User: lfriedman - Total duration: 8m29s - Times executed: 572 ]
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test35', '/usr/lib64/scim-1.0/scim-helper-manager', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 05:33:26 Duration: 15s37ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-win764-test29', 'cmd', '113'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 06:17:19 Duration: 7s32ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test35', '/usr/lib64/scim-1.0/scim-launcher -d -c simple -e all -f socket --no-stay', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 05:30:56 Duration: 3s430ms Database: nightly User: lfriedman
7 8m4s 640 300ms 9s209ms 757ms update gpu set daemon_update = now() where system = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 07 04 124 1m39s 805ms 05 191 2m47s 875ms 06 227 2m40s 707ms 07 82 47s804ms 582ms 08 5 2s370ms 474ms 09 7 4s316ms 616ms 11 4 2s405ms 601ms [ User: lfriedman - Total duration: 8m4s - Times executed: 640 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac64-cvs3';
Date: 2012-12-07 07:52:28 Duration: 9s209ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-cvs21';
Date: 2012-12-07 06:19:49 Duration: 7s645ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-cvs0';
Date: 2012-12-07 06:19:49 Duration: 7s643ms Database: nightly User: lfriedman
8 6m22s 529 303ms 5s532ms 723ms update gpu set daemon_update = now(), activated = ? where system = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 07 01 2 755ms 377ms 04 123 1m33s 760ms 05 159 2m2s 767ms 06 157 1m55s 733ms 07 63 38s125ms 605ms 08 6 3s762ms 627ms 09 17 8s373ms 492ms 11 2 1s 500ms [ User: lfriedman - Total duration: 6m22s - Times executed: 529 ]
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs12';
Date: 2012-12-07 07:37:52 Duration: 5s532ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win7-cvs5';
Date: 2012-12-07 07:52:30 Duration: 4s663ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs11';
Date: 2012-12-07 05:33:24 Duration: 4s192ms Database: nightly User: lfriedman
9 6m21s 406 399ms 13s184ms 939ms select count(id) from nppsmoketests where regressioncl = ? and current_status = ? and (active is null or active = ?) and os = ? and arch = ? and osversion = ? and branch = ? and (gpu = ? or gpu = ?) and age(now(), last_update) < interval ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 07 23 44 48s447ms 1s101ms 00 35 30s840ms 881ms 01 35 30s910ms 883ms 02 54 45s714ms 846ms 03 4 4s490ms 1s122ms 04 1 646ms 646ms 05 2 1s109ms 554ms 06 24 30s77ms 1s253ms 07 23 23s640ms 1s27ms 08 19 17s134ms 901ms 09 34 32s233ms 948ms 10 48 37s172ms 774ms 11 30 27s919ms 930ms 12 36 38s212ms 1s61ms 13 15 11s872ms 791ms 14 1 462ms 462ms 15 1 457ms 457ms [ User: lfriedman - Total duration: 6m21s - Times executed: 406 ]
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win764-test55') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '310' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 00:37:14 Duration: 13s184ms Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac-test8') AND os = 'Darwin' AND arch = 'i386' AND osversion = '10.7' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 07:07:35 Duration: 11s310ms Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux64-test8') AND os = 'Linux' AND arch = 'x86_64' AND osversion = '2.6.32-279.el6.x86_64' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 08:48:43 Duration: 2s923ms Database: nightly User: lfriedman
10 4m14s 300 300ms 9s519ms 849ms update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 07 01 12 20s406ms 1s700ms 04 5 2s531ms 506ms 05 17 16s972ms 998ms 06 140 2m18s 991ms 07 87 55s75ms 633ms 08 9 5s388ms 598ms 09 25 12s806ms 512ms 11 5 2s927ms 585ms [ User: lfriedman - Total duration: 4m14s - Times executed: 300 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac64-test11'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test11';
Date: 2012-12-07 07:52:28 Duration: 9s519ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test13'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-linux32-test13';
Date: 2012-12-07 07:52:28 Duration: 7s501ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac-gputest16'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac-gputest16';
Date: 2012-12-07 07:52:24 Duration: 6s355ms Database: nightly User: lfriedman
11 3m25s 274 300ms 7s464ms 750ms insert into regressspace (reftable, reftableid, cl, cldate, clowner) values (?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 07 04 14 11s20ms 787ms 05 260 3m14s 748ms [ User: lfriedman - Total duration: 3m25s - Times executed: 274 ]
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('nvprof32on64tests', '342824', '14523179', '2012/12/04', 'builder');
Date: 2012-12-07 06:19:47 Duration: 7s464ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('nvprof32on64tests', '342824', '14523080', '2012/12/04', 'debalinab');
Date: 2012-12-07 06:19:37 Duration: 4s464ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('thrusttests', '22769387', '14538319', '2012/12/06', 'sanjain');
Date: 2012-12-07 05:33:30 Duration: 2s728ms Database: nightly User: lfriedman
12 2m56s 176 300ms 7s945ms 1s3ms update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 07 01 5 9s114ms 1s822ms 04 16 13s266ms 829ms 05 34 41s477ms 1s219ms 06 82 1m25s 1s39ms 07 32 23s750ms 742ms 09 5 2s902ms 580ms 11 2 818ms 409ms [ User: lfriedman - Total duration: 2m56s - Times executed: 176 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test28'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test28';
Date: 2012-12-07 07:52:28 Duration: 7s945ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win764-test13'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win764-test13';
Date: 2012-12-07 02:44:36 Duration: 7s407ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win764-test63'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win764-test63';
Date: 2012-12-07 07:52:24 Duration: 6s574ms Database: nightly User: lfriedman
13 2m14s 85 323ms 12s47ms 1s588ms select count(*) from pg_class as c, pg_namespace as n where c.oid = pgpool_regclass (?) and c.relnamespace = n.oid and n.nspname = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 07 01 2 1s 500ms 04 37 1m28s 2s378ms 05 41 42s559ms 1s38ms 06 1 432ms 432ms 07 2 1s197ms 598ms 11 2 1s775ms 887ms [ User: lfriedman - Total duration: 2m14s - Times executed: 85 ]
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('cublassmoke') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-07 05:33:25 Duration: 12s47ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('cublassmoke') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-07 05:33:25 Duration: 8s374ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('mc_cublas') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-07 05:32:20 Duration: 6s789ms Database: nightly User: lfriedman
14 2m13s 338 300ms 997ms 394ms select count(id) from thrusttests where regressioncl = ? and current_status = ? and (active is null or active = ?) and os = ? and arch = ? and osversion = ? and branch = ? and (gpu = ? or gpu = ?) and age(now(), last_update) < interval ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 07 23 39 15s293ms 392ms 00 34 13s286ms 390ms 01 36 13s370ms 371ms 02 32 12s701ms 396ms 03 3 1s123ms 374ms 05 4 1s391ms 347ms 06 18 7s732ms 429ms 07 21 8s639ms 411ms 08 27 11s243ms 416ms 09 30 11s851ms 395ms 10 26 10s106ms 388ms 11 28 11s240ms 401ms 12 24 9s582ms 399ms 13 14 5s256ms 375ms 15 2 607ms 303ms [ User: lfriedman - Total duration: 2m13s - Times executed: 338 ]
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win7-gputest19') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '304' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 08:39:21 Duration: 997ms Database: nightly User: lfriedman
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win7-gputest19') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '304' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 07:26:06 Duration: 880ms Database: nightly User: lfriedman
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win764-test28') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '304' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 09:46:25 Duration: 658ms Database: nightly User: lfriedman
15 1m57s 137 302ms 5s682ms 855ms update gpu set daemon_update = now() where system = ? and age(now(), daemon_update) > interval ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 07 00 3 1s266ms 422ms 01 10 15s49ms 1s504ms 04 27 28s496ms 1s55ms 05 42 32s187ms 766ms 06 34 27s766ms 816ms 07 16 9s204ms 575ms 08 2 1s612ms 806ms 11 3 1s611ms 537ms [ User: lfriedman - Total duration: 1m57s - Times executed: 137 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-vista32-test2' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-07 07:52:28 Duration: 5s682ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-win7-test22' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-07 02:44:16 Duration: 4s377ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-test5' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-07 06:19:37 Duration: 3s961ms Database: nightly User: lfriedman
16 1m48s 161 310ms 3s333ms 671ms update gpu set daemon_update = now(), running = ? where system = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 07 01 6 4s692ms 782ms 04 35 22s942ms 655ms 05 52 39s785ms 765ms 06 60 36s199ms 603ms 07 6 3s390ms 565ms 09 1 445ms 445ms 11 1 714ms 714ms [ User: lfriedman - Total duration: 1m48s - Times executed: 161 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test17';
Date: 2012-12-07 06:19:37 Duration: 3s333ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test20';
Date: 2012-12-07 06:19:34 Duration: 2s856ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test19';
Date: 2012-12-07 06:19:34 Duration: 2s623ms Database: nightly User: lfriedman
17 1m8s 79 301ms 4s285ms 865ms delete from cuhc where system = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 07 00 4 2s562ms 640ms 04 36 39s738ms 1s103ms 05 21 15s945ms 759ms 06 12 5s915ms 492ms 07 3 1s953ms 651ms 08 1 734ms 734ms 11 2 1s493ms 746ms [ User: lfriedman - Total duration: 1m8s - Times executed: 79 ]
-
DELETE FROM cuhc WHERE system = 'cuda-win764-test1';
Date: 2012-12-07 05:33:23 Duration: 4s285ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-linux32-test24';
Date: 2012-12-07 05:32:25 Duration: 2s740ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-win764-cvs24';
Date: 2012-12-07 05:33:11 Duration: 1s956ms Database: inventory User: lfriedman
18 58s190ms 28 576ms 5s692ms 2s78ms select testname from nppsmoketests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 07 08 20 41s357ms 2s67ms 11 8 16s833ms 2s104ms [ User: lfriedman - Total duration: 58s190ms - Times executed: 28 ]
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4619' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-07 09:40:52 Duration: 5s692ms Database: pvs User: lfriedman Bind query: yes
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4615' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-07 09:41:08 Duration: 5s429ms Database: pvs User: lfriedman Bind query: yes
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4619' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-07 12:40:56 Duration: 5s204ms Database: pvs User: lfriedman Bind query: yes
19 56s896ms 1 56s896ms 56s896ms 56s896ms ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from cidertests as a, pg_class as p, cider as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from cufftbigmemtests as a, pg_class as p, cufftbigmem as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from cuptitests as a, pg_class as p, cupti as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from cupti_bcr40tests as a, pg_class as p, cupti_bcr40 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from cupti_bcr41tests as a, pg_class as p, cupti_bcr41 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from cupti_bcr42tests as a, pg_class as p, cupti_bcr42 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from curandtests as a, pg_class as p, curand as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from dblcublastests as a, pg_class as p, dblcublas as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from dblcuffttests as a, pg_class as p, dblcufft as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debuggertests as a, pg_class as p, debugger as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger32on64tests as a, pg_class as p, debugger32on64 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debuggermodestests as a, pg_class as p, debuggermodes as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger_bcr30tests as a, pg_class as p, debugger_bcr30 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger_bcr31tests as a, pg_class as p, debugger_bcr31 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger_bcr32tests as a, pg_class as p, debugger_bcr32 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger_bcr40tests as a, pg_class as p, debugger_bcr40 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger_bcr41tests as a, pg_class as p, debugger_bcr41 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger_bcr42tests as a, pg_class as p, debugger_bcr42 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from njcublastests as a, pg_class as p, njcublas as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from njdblcublastests as a, pg_class as p, njdblcublas as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from interoptests as a, pg_class as p, interop as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from interop32on64tests as a, pg_class as p, interop32on64 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from keplerappssm32tests as a, pg_class as p, keplerappssm32 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from keplerappssm35tests as a, pg_class as p, keplerappssm35 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) limit ? offset ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 07 01 1 56s896ms 56s896ms [ User: lfriedman - Total duration: 56s896ms - Times executed: 1 ]
-
( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'cider' AS regexp_replace, 'Cider' AS testsuite_user, o.osname, t.info FROM cidertests AS a, pg_class AS p, cider AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'cidertests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'cufftbigmem' AS regexp_replace, 'Cufft BigMem' AS testsuite_user, o.osname, t.info FROM cufftbigmemtests AS a, pg_class AS p, cufftbigmem AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'cufftbigmemtests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'cupti' AS regexp_replace, 'Cupti' AS testsuite_user, o.osname, t.info FROM cuptitests AS a, pg_class AS p, cupti AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'cuptitests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'cupti_bcr40' AS regexp_replace, 'Cupti r4.0' AS testsuite_user, o.osname, t.info FROM cupti_bcr40tests AS a, pg_class AS p, cupti_bcr40 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'cupti_bcr40tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'cupti_bcr41' AS regexp_replace, 'Cupti r4.1' AS testsuite_user, o.osname, t.info FROM cupti_bcr41tests AS a, pg_class AS p, cupti_bcr41 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'cupti_bcr41tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'cupti_bcr42' AS regexp_replace, 'Cupti r4.2' AS testsuite_user, o.osname, t.info FROM cupti_bcr42tests AS a, pg_class AS p, cupti_bcr42 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'cupti_bcr42tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'curand' AS regexp_replace, 'Curand' AS testsuite_user, o.osname, t.info FROM curandtests AS a, pg_class AS p, curand AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'curandtests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'dblcublas' AS regexp_replace, 'Dbl Cublas' AS testsuite_user, o.osname, t.info FROM dblcublastests AS a, pg_class AS p, dblcublas AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'dblcublastests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'dblcufft' AS regexp_replace, 'Dbl Cufft' AS testsuite_user, o.osname, t.info FROM dblcuffttests AS a, pg_class AS p, dblcufft AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'dblcuffttests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger' AS regexp_replace, 'Debugger' AS testsuite_user, o.osname, t.info FROM debuggertests AS a, pg_class AS p, debugger AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debuggertests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger32on64' AS regexp_replace, 'Debugger 32 on 64' AS testsuite_user, o.osname, t.info FROM debugger32on64tests AS a, pg_class AS p, debugger32on64 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger32on64tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debuggermodes' AS regexp_replace, 'Debugger Modes' AS testsuite_user, o.osname, t.info FROM debuggermodestests AS a, pg_class AS p, debuggermodes AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debuggermodestests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger_bcr30' AS regexp_replace, 'Debugger r3.0' AS testsuite_user, o.osname, t.info FROM debugger_bcr30tests AS a, pg_class AS p, debugger_bcr30 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger_bcr30tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger_bcr31' AS regexp_replace, 'Debugger r3.1' AS testsuite_user, o.osname, t.info FROM debugger_bcr31tests AS a, pg_class AS p, debugger_bcr31 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger_bcr31tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger_bcr32' AS regexp_replace, 'Debugger r3.2' AS testsuite_user, o.osname, t.info FROM debugger_bcr32tests AS a, pg_class AS p, debugger_bcr32 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger_bcr32tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger_bcr40' AS regexp_replace, 'Debugger r4.0' AS testsuite_user, o.osname, t.info FROM debugger_bcr40tests AS a, pg_class AS p, debugger_bcr40 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger_bcr40tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger_bcr41' AS regexp_replace, 'Debugger r4.1' AS testsuite_user, o.osname, t.info FROM debugger_bcr41tests AS a, pg_class AS p, debugger_bcr41 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger_bcr41tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger_bcr42' AS regexp_replace, 'Debugger r4.2' AS testsuite_user, o.osname, t.info FROM debugger_bcr42tests AS a, pg_class AS p, debugger_bcr42 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger_bcr42tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'njcublas' AS regexp_replace, 'Fortran Cublas' AS testsuite_user, o.osname, t.info FROM njcublastests AS a, pg_class AS p, njcublas AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'njcublastests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'njdblcublas' AS regexp_replace, 'Fortran Dbl Cublas' AS testsuite_user, o.osname, t.info FROM njdblcublastests AS a, pg_class AS p, njdblcublas AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'njdblcublastests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'interop' AS regexp_replace, 'GLInterop' AS testsuite_user, o.osname, t.info FROM interoptests AS a, pg_class AS p, interop AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'interoptests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'interop32on64' AS regexp_replace, 'GLInterop 32 on 64' AS testsuite_user, o.osname, t.info FROM interop32on64tests AS a, pg_class AS p, interop32on64 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'interop32on64tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'keplerappssm32' AS regexp_replace, 'Kepler Apps sm32' AS testsuite_user, o.osname, t.info FROM keplerappssm32tests AS a, pg_class AS p, keplerappssm32 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'keplerappssm32tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'keplerappssm35' AS regexp_replace, 'Kepler Apps sm35' AS testsuite_user, o.osname, t.info FROM keplerappssm35tests AS a, pg_class AS p, keplerappssm35 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'keplerappssm35tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) LIMIT 1 OFFSET 0;
Date: 2012-12-07 02:45:00 Duration: 56s896ms Database: nightly User: lfriedman
20 46s54ms 27 303ms 7s374ms 1s705ms select relname as table from pg_catalog.pg_class c join pg_catalog.pg_roles r on r.oid = c.relowner left join pg_catalog.pg_namespace n on n.oid = relnamespace where c.relkind in (...) and n.nspname not in (...) and pg_catalog.pg_table_is_visible(c.oid) and relname != ? and relname like ? order by random();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 07 00 2 1s222ms 611ms 01 6 27s547ms 4s591ms 04 1 5s400ms 5s400ms 05 3 2s469ms 823ms 06 1 458ms 458ms 07 8 4s861ms 607ms 08 1 371ms 371ms 11 5 3s721ms 744ms [ User: lfriedman - Total duration: 46s54ms - Times executed: 27 ]
-
SELECT relname as table FROM pg_catalog.pg_class c JOIN pg_catalog.pg_roles r ON r.oid = c.relowner LEFT JOIN pg_catalog.pg_namespace n ON n.oid = relnamespace WHERE c.relkind IN ('r', '') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid) AND relname != 'tests' AND relname LIKE '%tests' ORDER BY random();
Date: 2012-12-07 02:44:24 Duration: 7s374ms Database: nightly User: lfriedman
-
SELECT relname as table FROM pg_catalog.pg_class c JOIN pg_catalog.pg_roles r ON r.oid = c.relowner LEFT JOIN pg_catalog.pg_namespace n ON n.oid = relnamespace WHERE c.relkind IN ('r', '') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid) AND relname != 'tests' AND relname LIKE '%tests' ORDER BY random();
Date: 2012-12-07 02:44:24 Duration: 7s327ms Database: nightly User: lfriedman
-
SELECT relname as table FROM pg_catalog.pg_class c JOIN pg_catalog.pg_roles r ON r.oid = c.relowner LEFT JOIN pg_catalog.pg_namespace n ON n.oid = relnamespace WHERE c.relkind IN ('r', '') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid) AND relname != 'tests' AND relname LIKE '%tests' ORDER BY random();
Date: 2012-12-07 02:44:24 Duration: 7s285ms Database: nightly User: lfriedman
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 4,021 1h24m3s 300ms 12s892ms 1s254ms 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 07 23 8 7s53ms 881ms 00 75 40s844ms 544ms 01 540 21m26s 2s383ms 04 1,272 38m15s 1s804ms 05 902 11m35s 770ms 06 252 2m19s 552ms 07 405 3m28s 513ms 08 213 2m18s 652ms 10 11 6s55ms 550ms 11 343 3m45s 657ms [ User: lfriedman - Total duration: 1h24m3s - Times executed: 4021 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('keplercublastests') AND c.relpersistence = 'u';
Date: 2012-12-07 02:44:37 Duration: 12s892ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('tests') AND c.relpersistence = 'u';
Date: 2012-12-07 02:44:37 Duration: 12s509ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('ddupdate') AND c.relpersistence = 'u';
Date: 2012-12-07 02:44:37 Duration: 11s707ms Database: nightly User: lfriedman
2 2,666 38m55s 300ms 9s690ms 875ms update gpu set dd_date = ?, last_update = ( select date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 07 23 1 820ms 820ms 00 4 2s201ms 550ms 01 61 1m23s 1s376ms 04 380 5m7s 809ms 05 728 12m22s 1s20ms 06 982 15m1s 917ms 07 360 3m32s 589ms 08 40 22s535ms 563ms 09 75 39s352ms 524ms 11 35 22s689ms 648ms [ User: lfriedman - Total duration: 38m55s - Times executed: 2666 ]
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win8-test14';
Date: 2012-12-07 07:52:28 Duration: 9s690ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win764-test29';
Date: 2012-12-07 07:52:28 Duration: 9s482ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win8-test5';
Date: 2012-12-07 07:52:28 Duration: 9s478ms Database: nightly User: lfriedman
3 1,294 19m10s 300ms 9s564ms 889ms update systems set daemon_update = now(), activated = ? where vm = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 07 01 14 21s250ms 1s517ms 04 293 4m48s 983ms 05 402 6m18s 940ms 06 385 5m35s 871ms 07 157 1m43s 657ms 08 14 7s21ms 501ms 09 25 13s899ms 555ms 11 4 3s105ms 776ms [ User: lfriedman - Total duration: 19m10s - Times executed: 1294 ]
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-win732-build12';
Date: 2012-12-07 07:52:28 Duration: 9s564ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-linux64-build0';
Date: 2012-12-07 07:52:28 Duration: 9s171ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-linux64-build9';
Date: 2012-12-07 07:52:28 Duration: 8s325ms Database: cbs User: lfriedman
4 1,248 18m36s 300ms 9s896ms 894ms update gpu set dd_date = ?, last_update = (date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 07 00 1 569ms 569ms 01 5 2s895ms 579ms 04 255 3m29s 820ms 05 387 6m18s 979ms 06 402 6m52s 1s24ms 07 154 1m29s 582ms 08 11 5s57ms 459ms 09 28 14s309ms 511ms 11 5 3s191ms 638ms [ User: lfriedman - Total duration: 18m36s - Times executed: 1248 ]
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs17';
Date: 2012-12-07 07:52:28 Duration: 9s896ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = 'Thu Dec 6 00:52:36 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux32-cvs6';
Date: 2012-12-07 07:52:28 Duration: 9s647ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs15';
Date: 2012-12-07 07:52:28 Duration: 9s629ms Database: nightly User: lfriedman
5 640 8m4s 300ms 9s209ms 757ms update gpu set daemon_update = now() where system = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 07 04 124 1m39s 805ms 05 191 2m47s 875ms 06 227 2m40s 707ms 07 82 47s804ms 582ms 08 5 2s370ms 474ms 09 7 4s316ms 616ms 11 4 2s405ms 601ms [ User: lfriedman - Total duration: 8m4s - Times executed: 640 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac64-cvs3';
Date: 2012-12-07 07:52:28 Duration: 9s209ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-cvs21';
Date: 2012-12-07 06:19:49 Duration: 7s645ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-cvs0';
Date: 2012-12-07 06:19:49 Duration: 7s643ms Database: nightly User: lfriedman
6 572 8m29s 681ms 15s37ms 890ms insert into proccheck (hostname, process, subtestid) values (?, ?, ?); delete from proccheck where age(now(), datestamp) > interval ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 07 23 1 795ms 795ms 00 2 1s615ms 807ms 02 24 19s416ms 809ms 03 251 3m20s 800ms 04 86 1m39s 1s154ms 05 38 42s396ms 1s115ms 06 29 25s892ms 892ms 07 41 37s363ms 911ms 08 29 23s346ms 805ms 09 42 35s254ms 839ms 10 19 15s373ms 809ms 11 2 1s616ms 808ms 15 4 3s186ms 796ms 17 4 3s204ms 801ms [ User: lfriedman - Total duration: 8m29s - Times executed: 572 ]
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test35', '/usr/lib64/scim-1.0/scim-helper-manager', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 05:33:26 Duration: 15s37ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-win764-test29', 'cmd', '113'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 06:17:19 Duration: 7s32ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test35', '/usr/lib64/scim-1.0/scim-launcher -d -c simple -e all -f socket --no-stay', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 05:30:56 Duration: 3s430ms Database: nightly User: lfriedman
7 529 6m22s 303ms 5s532ms 723ms update gpu set daemon_update = now(), activated = ? where system = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 07 01 2 755ms 377ms 04 123 1m33s 760ms 05 159 2m2s 767ms 06 157 1m55s 733ms 07 63 38s125ms 605ms 08 6 3s762ms 627ms 09 17 8s373ms 492ms 11 2 1s 500ms [ User: lfriedman - Total duration: 6m22s - Times executed: 529 ]
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs12';
Date: 2012-12-07 07:37:52 Duration: 5s532ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win7-cvs5';
Date: 2012-12-07 07:52:30 Duration: 4s663ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs11';
Date: 2012-12-07 05:33:24 Duration: 4s192ms Database: nightly User: lfriedman
8 406 6m21s 399ms 13s184ms 939ms select count(id) from nppsmoketests where regressioncl = ? and current_status = ? and (active is null or active = ?) and os = ? and arch = ? and osversion = ? and branch = ? and (gpu = ? or gpu = ?) and age(now(), last_update) < interval ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 07 23 44 48s447ms 1s101ms 00 35 30s840ms 881ms 01 35 30s910ms 883ms 02 54 45s714ms 846ms 03 4 4s490ms 1s122ms 04 1 646ms 646ms 05 2 1s109ms 554ms 06 24 30s77ms 1s253ms 07 23 23s640ms 1s27ms 08 19 17s134ms 901ms 09 34 32s233ms 948ms 10 48 37s172ms 774ms 11 30 27s919ms 930ms 12 36 38s212ms 1s61ms 13 15 11s872ms 791ms 14 1 462ms 462ms 15 1 457ms 457ms [ User: lfriedman - Total duration: 6m21s - Times executed: 406 ]
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win764-test55') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '310' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 00:37:14 Duration: 13s184ms Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac-test8') AND os = 'Darwin' AND arch = 'i386' AND osversion = '10.7' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 07:07:35 Duration: 11s310ms Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux64-test8') AND os = 'Linux' AND arch = 'x86_64' AND osversion = '2.6.32-279.el6.x86_64' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 08:48:43 Duration: 2s923ms Database: nightly User: lfriedman
9 338 2m13s 300ms 997ms 394ms select count(id) from thrusttests where regressioncl = ? and current_status = ? and (active is null or active = ?) and os = ? and arch = ? and osversion = ? and branch = ? and (gpu = ? or gpu = ?) and age(now(), last_update) < interval ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 07 23 39 15s293ms 392ms 00 34 13s286ms 390ms 01 36 13s370ms 371ms 02 32 12s701ms 396ms 03 3 1s123ms 374ms 05 4 1s391ms 347ms 06 18 7s732ms 429ms 07 21 8s639ms 411ms 08 27 11s243ms 416ms 09 30 11s851ms 395ms 10 26 10s106ms 388ms 11 28 11s240ms 401ms 12 24 9s582ms 399ms 13 14 5s256ms 375ms 15 2 607ms 303ms [ User: lfriedman - Total duration: 2m13s - Times executed: 338 ]
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win7-gputest19') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '304' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 08:39:21 Duration: 997ms Database: nightly User: lfriedman
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win7-gputest19') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '304' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 07:26:06 Duration: 880ms Database: nightly User: lfriedman
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win764-test28') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '304' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 09:46:25 Duration: 658ms Database: nightly User: lfriedman
10 300 4m14s 300ms 9s519ms 849ms update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 07 01 12 20s406ms 1s700ms 04 5 2s531ms 506ms 05 17 16s972ms 998ms 06 140 2m18s 991ms 07 87 55s75ms 633ms 08 9 5s388ms 598ms 09 25 12s806ms 512ms 11 5 2s927ms 585ms [ User: lfriedman - Total duration: 4m14s - Times executed: 300 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac64-test11'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test11';
Date: 2012-12-07 07:52:28 Duration: 9s519ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test13'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-linux32-test13';
Date: 2012-12-07 07:52:28 Duration: 7s501ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac-gputest16'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac-gputest16';
Date: 2012-12-07 07:52:24 Duration: 6s355ms Database: nightly User: lfriedman
11 274 3m25s 300ms 7s464ms 750ms insert into regressspace (reftable, reftableid, cl, cldate, clowner) values (?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 07 04 14 11s20ms 787ms 05 260 3m14s 748ms [ User: lfriedman - Total duration: 3m25s - Times executed: 274 ]
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('nvprof32on64tests', '342824', '14523179', '2012/12/04', 'builder');
Date: 2012-12-07 06:19:47 Duration: 7s464ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('nvprof32on64tests', '342824', '14523080', '2012/12/04', 'debalinab');
Date: 2012-12-07 06:19:37 Duration: 4s464ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('thrusttests', '22769387', '14538319', '2012/12/06', 'sanjain');
Date: 2012-12-07 05:33:30 Duration: 2s728ms Database: nightly User: lfriedman
12 176 2m56s 300ms 7s945ms 1s3ms update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 07 01 5 9s114ms 1s822ms 04 16 13s266ms 829ms 05 34 41s477ms 1s219ms 06 82 1m25s 1s39ms 07 32 23s750ms 742ms 09 5 2s902ms 580ms 11 2 818ms 409ms [ User: lfriedman - Total duration: 2m56s - Times executed: 176 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test28'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test28';
Date: 2012-12-07 07:52:28 Duration: 7s945ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win764-test13'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win764-test13';
Date: 2012-12-07 02:44:36 Duration: 7s407ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win764-test63'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win764-test63';
Date: 2012-12-07 07:52:24 Duration: 6s574ms Database: nightly User: lfriedman
13 161 1m48s 310ms 3s333ms 671ms update gpu set daemon_update = now(), running = ? where system = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 07 01 6 4s692ms 782ms 04 35 22s942ms 655ms 05 52 39s785ms 765ms 06 60 36s199ms 603ms 07 6 3s390ms 565ms 09 1 445ms 445ms 11 1 714ms 714ms [ User: lfriedman - Total duration: 1m48s - Times executed: 161 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test17';
Date: 2012-12-07 06:19:37 Duration: 3s333ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test20';
Date: 2012-12-07 06:19:34 Duration: 2s856ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test19';
Date: 2012-12-07 06:19:34 Duration: 2s623ms Database: nightly User: lfriedman
14 137 1m57s 302ms 5s682ms 855ms update gpu set daemon_update = now() where system = ? and age(now(), daemon_update) > interval ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 07 00 3 1s266ms 422ms 01 10 15s49ms 1s504ms 04 27 28s496ms 1s55ms 05 42 32s187ms 766ms 06 34 27s766ms 816ms 07 16 9s204ms 575ms 08 2 1s612ms 806ms 11 3 1s611ms 537ms [ User: lfriedman - Total duration: 1m57s - Times executed: 137 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-vista32-test2' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-07 07:52:28 Duration: 5s682ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-win7-test22' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-07 02:44:16 Duration: 4s377ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-test5' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-07 06:19:37 Duration: 3s961ms Database: nightly User: lfriedman
15 85 2m14s 323ms 12s47ms 1s588ms select count(*) from pg_class as c, pg_namespace as n where c.oid = pgpool_regclass (?) and c.relnamespace = n.oid and n.nspname = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 07 01 2 1s 500ms 04 37 1m28s 2s378ms 05 41 42s559ms 1s38ms 06 1 432ms 432ms 07 2 1s197ms 598ms 11 2 1s775ms 887ms [ User: lfriedman - Total duration: 2m14s - Times executed: 85 ]
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('cublassmoke') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-07 05:33:25 Duration: 12s47ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('cublassmoke') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-07 05:33:25 Duration: 8s374ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('mc_cublas') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-07 05:32:20 Duration: 6s789ms Database: nightly User: lfriedman
16 79 1m8s 301ms 4s285ms 865ms delete from cuhc where system = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 07 00 4 2s562ms 640ms 04 36 39s738ms 1s103ms 05 21 15s945ms 759ms 06 12 5s915ms 492ms 07 3 1s953ms 651ms 08 1 734ms 734ms 11 2 1s493ms 746ms [ User: lfriedman - Total duration: 1m8s - Times executed: 79 ]
-
DELETE FROM cuhc WHERE system = 'cuda-win764-test1';
Date: 2012-12-07 05:33:23 Duration: 4s285ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-linux32-test24';
Date: 2012-12-07 05:32:25 Duration: 2s740ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-win764-cvs24';
Date: 2012-12-07 05:33:11 Duration: 1s956ms Database: inventory User: lfriedman
17 56 42s481ms 305ms 3s157ms 758ms delete from tests where id = ? and active = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 07 04 23 14s383ms 625ms 05 22 18s815ms 855ms 06 5 4s216ms 843ms 07 6 5s66ms 844ms [ User: lfriedman - Total duration: 42s481ms - Times executed: 56 ]
-
DELETE FROM tests WHERE id = '2418081' AND active = 'cuda-vista32-test1';
Date: 2012-12-07 06:19:34 Duration: 3s157ms Database: nightly User: lfriedman
-
DELETE FROM tests WHERE id = '2419431' AND active = 'cuda-linux64-test75';
Date: 2012-12-07 08:37:37 Duration: 1s970ms Database: nightly User: lfriedman
-
DELETE FROM tests WHERE id = '2417535' AND active = 'cuda-linux-gputest3';
Date: 2012-12-07 07:38:04 Duration: 1s895ms Database: nightly User: lfriedman
18 50 43s693ms 304ms 4s849ms 873ms update tests set active = ? where id = ? and active is null;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 07 04 14 9s377ms 669ms 05 19 18s251ms 960ms 06 8 12s71ms 1s508ms 07 8 3s653ms 456ms 08 1 339ms 339ms [ User: lfriedman - Total duration: 43s693ms - Times executed: 50 ]
-
UPDATE tests SET active = 'cuda-linux-gputest16' WHERE id = '2419187' AND active IS NULL;
Date: 2012-12-07 07:37:52 Duration: 4s849ms Database: nightly User: lfriedman
-
UPDATE tests SET active = 'cuda-linux-gputest10' WHERE id = '2418304' AND active IS NULL;
Date: 2012-12-07 06:40:44 Duration: 4s786ms Database: nightly User: lfriedman
-
UPDATE tests SET active = 'cuda-vista32-test1' WHERE id = '2418291' AND active IS NULL;
Date: 2012-12-07 07:37:52 Duration: 3s365ms Database: nightly User: lfriedman
19 48 32s896ms 416ms 3s968ms 685ms copy thrusttests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) from stdin with csv header escape ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 07 03 6 2s986ms 497ms 04 14 11s758ms 839ms 05 5 3s85ms 617ms 06 2 1s43ms 521ms 07 3 1s549ms 516ms 08 6 3s19ms 503ms 09 4 5s811ms 1s452ms 10 5 2s368ms 473ms 11 1 416ms 416ms 13 2 859ms 429ms [ User: lfriedman - Total duration: 32s896ms - Times executed: 48 ]
-
COPY thrusttests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 10:06:19 Duration: 3s968ms Database: pvs User: lfriedman
-
COPY thrusttests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 05:35:21 Duration: 2s217ms Database: nightly User: lfriedman
-
COPY thrusttests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 05:50:51 Duration: 1s664ms Database: nightly User: lfriedman
20 46 25s486ms 301ms 1s242ms 554ms update disks set update = date_trunc(?, now()), size = ?, used = ? where hostname = ?; insert into disks (hostname, size, used, update) ( select ?, ?, ?, date_trunc(?, now()) where not exists ( select ? from disks where hostname = ?));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 07 01 2 1s801ms 900ms 04 6 3s175ms 529ms 07 38 20s508ms 539ms [ User: lfriedman - Total duration: 25s486ms - Times executed: 46 ]
-
UPDATE disks SET update = date_trunc('second', now()), size = '0', used = '0' WHERE hostname = 'cuda-win8-test6'; INSERT into disks (hostname, size, used, update) ( select 'cuda-win8-test6', '0', '0', date_trunc('second', now()) WHERE NOT EXISTS ( select 1 FROM disks WHERE hostname = 'cuda-win8-test6'));
Date: 2012-12-07 08:04:11 Duration: 1s242ms Database: inventory User: lfriedman
-
UPDATE disks SET update = date_trunc('second', now()), size = '161', used = '115' WHERE hostname = 'cuda-win732-build13'; INSERT into disks (hostname, size, used, update) ( select 'cuda-win732-build13', '161', '115', date_trunc('second', now()) WHERE NOT EXISTS ( select 1 FROM disks WHERE hostname = 'cuda-win732-build13'));
Date: 2012-12-07 08:04:47 Duration: 1s205ms Database: inventory User: lfriedman
-
UPDATE disks SET update = date_trunc('second', now()), size = '999', used = '90' WHERE hostname = 'cuda-mac32-build4'; INSERT into disks (hostname, size, used, update) ( select 'cuda-mac32-build4', '999', '90', date_trunc('second', now()) WHERE NOT EXISTS ( select 1 FROM disks WHERE hostname = 'cuda-mac32-build4'));
Date: 2012-12-07 08:04:35 Duration: 1s19ms Database: inventory User: lfriedman
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1m4s 4m6s 1m50s 43 1h19m10s copy nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) from stdin with csv header escape ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 07 04 11 21m8s 1m55s 05 12 27m43s 2m18s 06 9 15m5s 1m40s 07 5 7m46s 1m33s 08 2 2m22s 1m11s 09 3 3m52s 1m17s 11 1 1m11s 1m11s [ User: lfriedman - Total duration: 1h19m10s - Times executed: 43 ]
-
COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 06:20:48 Duration: 4m6s Database: nightly User: lfriedman
-
COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 06:20:53 Duration: 4m5s Database: nightly User: lfriedman
-
COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 06:20:10 Duration: 4m5s Database: nightly User: lfriedman
2 56s896ms 56s896ms 56s896ms 1 56s896ms ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from cidertests as a, pg_class as p, cider as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from cufftbigmemtests as a, pg_class as p, cufftbigmem as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from cuptitests as a, pg_class as p, cupti as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from cupti_bcr40tests as a, pg_class as p, cupti_bcr40 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from cupti_bcr41tests as a, pg_class as p, cupti_bcr41 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from cupti_bcr42tests as a, pg_class as p, cupti_bcr42 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from curandtests as a, pg_class as p, curand as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from dblcublastests as a, pg_class as p, dblcublas as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from dblcuffttests as a, pg_class as p, dblcufft as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debuggertests as a, pg_class as p, debugger as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger32on64tests as a, pg_class as p, debugger32on64 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debuggermodestests as a, pg_class as p, debuggermodes as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger_bcr30tests as a, pg_class as p, debugger_bcr30 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger_bcr31tests as a, pg_class as p, debugger_bcr31 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger_bcr32tests as a, pg_class as p, debugger_bcr32 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger_bcr40tests as a, pg_class as p, debugger_bcr40 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger_bcr41tests as a, pg_class as p, debugger_bcr41 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from debugger_bcr42tests as a, pg_class as p, debugger_bcr42 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from njcublastests as a, pg_class as p, njcublas as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from njdblcublastests as a, pg_class as p, njdblcublas as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from interoptests as a, pg_class as p, interop as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from interop32on64tests as a, pg_class as p, interop32on64 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from keplerappssm32tests as a, pg_class as p, keplerappssm32 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) union all ( select a.id, a.suiteid, a.testname, date_trunc(?, a.last_update) as last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, ? as regexp_replace, ? as testsuite_user, o.osname, t.info from keplerappssm35tests as a, pg_class as p, keplerappssm35 as t, osversmap as o where o.arch = a.arch and a.osversion = o.osversion and a.suiteid = t.id and p.relname = ? and (a.regressioncl = ? or a.regressioncl > ?) and a.last_update > ? and a.last_update < ? order by id) limit ? offset ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 07 01 1 56s896ms 56s896ms [ User: lfriedman - Total duration: 56s896ms - Times executed: 1 ]
-
( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'cider' AS regexp_replace, 'Cider' AS testsuite_user, o.osname, t.info FROM cidertests AS a, pg_class AS p, cider AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'cidertests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'cufftbigmem' AS regexp_replace, 'Cufft BigMem' AS testsuite_user, o.osname, t.info FROM cufftbigmemtests AS a, pg_class AS p, cufftbigmem AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'cufftbigmemtests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'cupti' AS regexp_replace, 'Cupti' AS testsuite_user, o.osname, t.info FROM cuptitests AS a, pg_class AS p, cupti AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'cuptitests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'cupti_bcr40' AS regexp_replace, 'Cupti r4.0' AS testsuite_user, o.osname, t.info FROM cupti_bcr40tests AS a, pg_class AS p, cupti_bcr40 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'cupti_bcr40tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'cupti_bcr41' AS regexp_replace, 'Cupti r4.1' AS testsuite_user, o.osname, t.info FROM cupti_bcr41tests AS a, pg_class AS p, cupti_bcr41 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'cupti_bcr41tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'cupti_bcr42' AS regexp_replace, 'Cupti r4.2' AS testsuite_user, o.osname, t.info FROM cupti_bcr42tests AS a, pg_class AS p, cupti_bcr42 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'cupti_bcr42tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'curand' AS regexp_replace, 'Curand' AS testsuite_user, o.osname, t.info FROM curandtests AS a, pg_class AS p, curand AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'curandtests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'dblcublas' AS regexp_replace, 'Dbl Cublas' AS testsuite_user, o.osname, t.info FROM dblcublastests AS a, pg_class AS p, dblcublas AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'dblcublastests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'dblcufft' AS regexp_replace, 'Dbl Cufft' AS testsuite_user, o.osname, t.info FROM dblcuffttests AS a, pg_class AS p, dblcufft AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'dblcuffttests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger' AS regexp_replace, 'Debugger' AS testsuite_user, o.osname, t.info FROM debuggertests AS a, pg_class AS p, debugger AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debuggertests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger32on64' AS regexp_replace, 'Debugger 32 on 64' AS testsuite_user, o.osname, t.info FROM debugger32on64tests AS a, pg_class AS p, debugger32on64 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger32on64tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debuggermodes' AS regexp_replace, 'Debugger Modes' AS testsuite_user, o.osname, t.info FROM debuggermodestests AS a, pg_class AS p, debuggermodes AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debuggermodestests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger_bcr30' AS regexp_replace, 'Debugger r3.0' AS testsuite_user, o.osname, t.info FROM debugger_bcr30tests AS a, pg_class AS p, debugger_bcr30 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger_bcr30tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger_bcr31' AS regexp_replace, 'Debugger r3.1' AS testsuite_user, o.osname, t.info FROM debugger_bcr31tests AS a, pg_class AS p, debugger_bcr31 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger_bcr31tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger_bcr32' AS regexp_replace, 'Debugger r3.2' AS testsuite_user, o.osname, t.info FROM debugger_bcr32tests AS a, pg_class AS p, debugger_bcr32 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger_bcr32tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger_bcr40' AS regexp_replace, 'Debugger r4.0' AS testsuite_user, o.osname, t.info FROM debugger_bcr40tests AS a, pg_class AS p, debugger_bcr40 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger_bcr40tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger_bcr41' AS regexp_replace, 'Debugger r4.1' AS testsuite_user, o.osname, t.info FROM debugger_bcr41tests AS a, pg_class AS p, debugger_bcr41 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger_bcr41tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'debugger_bcr42' AS regexp_replace, 'Debugger r4.2' AS testsuite_user, o.osname, t.info FROM debugger_bcr42tests AS a, pg_class AS p, debugger_bcr42 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'debugger_bcr42tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'njcublas' AS regexp_replace, 'Fortran Cublas' AS testsuite_user, o.osname, t.info FROM njcublastests AS a, pg_class AS p, njcublas AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'njcublastests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'njdblcublas' AS regexp_replace, 'Fortran Dbl Cublas' AS testsuite_user, o.osname, t.info FROM njdblcublastests AS a, pg_class AS p, njdblcublas AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'njdblcublastests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'interop' AS regexp_replace, 'GLInterop' AS testsuite_user, o.osname, t.info FROM interoptests AS a, pg_class AS p, interop AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'interoptests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'interop32on64' AS regexp_replace, 'GLInterop 32 on 64' AS testsuite_user, o.osname, t.info FROM interop32on64tests AS a, pg_class AS p, interop32on64 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'interop32on64tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'keplerappssm32' AS regexp_replace, 'Kepler Apps sm32' AS testsuite_user, o.osname, t.info FROM keplerappssm32tests AS a, pg_class AS p, keplerappssm32 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'keplerappssm32tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) UNION ALL ( SELECT a.id, a.suiteid, a.testname, date_trunc('second', a.last_update) AS last_update, a.current_status, a.testcl, a.regressioncl, a.os, a.arch, a.osversion, a.branch, a.gpu, a.bug, a.owner, 'keplerappssm35' AS regexp_replace, 'Kepler Apps sm35' AS testsuite_user, o.osname, t.info FROM keplerappssm35tests AS a, pg_class AS p, keplerappssm35 AS t, osversmap AS o WHERE o.arch = a.arch AND a.osversion = o.osversion AND a.suiteid = t.id AND p.relname = 'keplerappssm35tests' AND (a.regressioncl = '3' OR a.regressioncl > '100') AND a.last_update > '2012-12-02 04:00:00' AND a.last_update < '2012-12-03 04:00:00' ORDER BY id) LIMIT 1 OFFSET 0;
Date: 2012-12-07 02:45:00 Duration: 56s896ms Database: nightly User: lfriedman
3 576ms 5s692ms 2s78ms 28 58s190ms select testname from nppsmoketests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 07 08 20 41s357ms 2s67ms 11 8 16s833ms 2s104ms [ User: lfriedman - Total duration: 58s190ms - Times executed: 28 ]
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4619' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-07 09:40:52 Duration: 5s692ms Database: pvs User: lfriedman Bind query: yes
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4615' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-07 09:41:08 Duration: 5s429ms Database: pvs User: lfriedman Bind query: yes
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4619' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-07 12:40:56 Duration: 5s204ms Database: pvs User: lfriedman Bind query: yes
4 303ms 7s374ms 1s705ms 27 46s54ms select relname as table from pg_catalog.pg_class c join pg_catalog.pg_roles r on r.oid = c.relowner left join pg_catalog.pg_namespace n on n.oid = relnamespace where c.relkind in (...) and n.nspname not in (...) and pg_catalog.pg_table_is_visible(c.oid) and relname != ? and relname like ? order by random();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 07 00 2 1s222ms 611ms 01 6 27s547ms 4s591ms 04 1 5s400ms 5s400ms 05 3 2s469ms 823ms 06 1 458ms 458ms 07 8 4s861ms 607ms 08 1 371ms 371ms 11 5 3s721ms 744ms [ User: lfriedman - Total duration: 46s54ms - Times executed: 27 ]
-
SELECT relname as table FROM pg_catalog.pg_class c JOIN pg_catalog.pg_roles r ON r.oid = c.relowner LEFT JOIN pg_catalog.pg_namespace n ON n.oid = relnamespace WHERE c.relkind IN ('r', '') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid) AND relname != 'tests' AND relname LIKE '%tests' ORDER BY random();
Date: 2012-12-07 02:44:24 Duration: 7s374ms Database: nightly User: lfriedman
-
SELECT relname as table FROM pg_catalog.pg_class c JOIN pg_catalog.pg_roles r ON r.oid = c.relowner LEFT JOIN pg_catalog.pg_namespace n ON n.oid = relnamespace WHERE c.relkind IN ('r', '') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid) AND relname != 'tests' AND relname LIKE '%tests' ORDER BY random();
Date: 2012-12-07 02:44:24 Duration: 7s327ms Database: nightly User: lfriedman
-
SELECT relname as table FROM pg_catalog.pg_class c JOIN pg_catalog.pg_roles r ON r.oid = c.relowner LEFT JOIN pg_catalog.pg_namespace n ON n.oid = relnamespace WHERE c.relkind IN ('r', '') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid) AND relname != 'tests' AND relname LIKE '%tests' ORDER BY random();
Date: 2012-12-07 02:44:24 Duration: 7s285ms Database: nightly User: lfriedman
5 323ms 12s47ms 1s588ms 85 2m14s select count(*) from pg_class as c, pg_namespace as n where c.oid = pgpool_regclass (?) and c.relnamespace = n.oid and n.nspname = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 07 01 2 1s 500ms 04 37 1m28s 2s378ms 05 41 42s559ms 1s38ms 06 1 432ms 432ms 07 2 1s197ms 598ms 11 2 1s775ms 887ms [ User: lfriedman - Total duration: 2m14s - Times executed: 85 ]
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('cublassmoke') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-07 05:33:25 Duration: 12s47ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('cublassmoke') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-07 05:33:25 Duration: 8s374ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('mc_cublas') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-07 05:32:20 Duration: 6s789ms Database: nightly User: lfriedman
6 300ms 12s892ms 1s254ms 4,021 1h24m3s select count(*) from pg_catalog.pg_class as c where c.oid = pgpool_regclass (?) and c.relpersistence = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 07 23 8 7s53ms 881ms 00 75 40s844ms 544ms 01 540 21m26s 2s383ms 04 1,272 38m15s 1s804ms 05 902 11m35s 770ms 06 252 2m19s 552ms 07 405 3m28s 513ms 08 213 2m18s 652ms 10 11 6s55ms 550ms 11 343 3m45s 657ms [ User: lfriedman - Total duration: 1h24m3s - Times executed: 4021 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('keplercublastests') AND c.relpersistence = 'u';
Date: 2012-12-07 02:44:37 Duration: 12s892ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('tests') AND c.relpersistence = 'u';
Date: 2012-12-07 02:44:37 Duration: 12s509ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('ddupdate') AND c.relpersistence = 'u';
Date: 2012-12-07 02:44:37 Duration: 11s707ms Database: nightly User: lfriedman
7 300ms 7s945ms 1s3ms 176 2m56s update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 07 01 5 9s114ms 1s822ms 04 16 13s266ms 829ms 05 34 41s477ms 1s219ms 06 82 1m25s 1s39ms 07 32 23s750ms 742ms 09 5 2s902ms 580ms 11 2 818ms 409ms [ User: lfriedman - Total duration: 2m56s - Times executed: 176 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test28'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test28';
Date: 2012-12-07 07:52:28 Duration: 7s945ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win764-test13'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win764-test13';
Date: 2012-12-07 02:44:36 Duration: 7s407ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win764-test63'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win764-test63';
Date: 2012-12-07 07:52:24 Duration: 6s574ms Database: nightly User: lfriedman
8 399ms 13s184ms 939ms 406 6m21s select count(id) from nppsmoketests where regressioncl = ? and current_status = ? and (active is null or active = ?) and os = ? and arch = ? and osversion = ? and branch = ? and (gpu = ? or gpu = ?) and age(now(), last_update) < interval ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 07 23 44 48s447ms 1s101ms 00 35 30s840ms 881ms 01 35 30s910ms 883ms 02 54 45s714ms 846ms 03 4 4s490ms 1s122ms 04 1 646ms 646ms 05 2 1s109ms 554ms 06 24 30s77ms 1s253ms 07 23 23s640ms 1s27ms 08 19 17s134ms 901ms 09 34 32s233ms 948ms 10 48 37s172ms 774ms 11 30 27s919ms 930ms 12 36 38s212ms 1s61ms 13 15 11s872ms 791ms 14 1 462ms 462ms 15 1 457ms 457ms [ User: lfriedman - Total duration: 6m21s - Times executed: 406 ]
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win764-test55') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '310' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 00:37:14 Duration: 13s184ms Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac-test8') AND os = 'Darwin' AND arch = 'i386' AND osversion = '10.7' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 07:07:35 Duration: 11s310ms Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux64-test8') AND os = 'Linux' AND arch = 'x86_64' AND osversion = '2.6.32-279.el6.x86_64' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 08:48:43 Duration: 2s923ms Database: nightly User: lfriedman
9 300ms 9s896ms 894ms 1,248 18m36s update gpu set dd_date = ?, last_update = (date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 07 00 1 569ms 569ms 01 5 2s895ms 579ms 04 255 3m29s 820ms 05 387 6m18s 979ms 06 402 6m52s 1s24ms 07 154 1m29s 582ms 08 11 5s57ms 459ms 09 28 14s309ms 511ms 11 5 3s191ms 638ms [ User: lfriedman - Total duration: 18m36s - Times executed: 1248 ]
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs17';
Date: 2012-12-07 07:52:28 Duration: 9s896ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = 'Thu Dec 6 00:52:36 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux32-cvs6';
Date: 2012-12-07 07:52:28 Duration: 9s647ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs15';
Date: 2012-12-07 07:52:28 Duration: 9s629ms Database: nightly User: lfriedman
10 681ms 15s37ms 890ms 572 8m29s insert into proccheck (hostname, process, subtestid) values (?, ?, ?); delete from proccheck where age(now(), datestamp) > interval ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 07 23 1 795ms 795ms 00 2 1s615ms 807ms 02 24 19s416ms 809ms 03 251 3m20s 800ms 04 86 1m39s 1s154ms 05 38 42s396ms 1s115ms 06 29 25s892ms 892ms 07 41 37s363ms 911ms 08 29 23s346ms 805ms 09 42 35s254ms 839ms 10 19 15s373ms 809ms 11 2 1s616ms 808ms 15 4 3s186ms 796ms 17 4 3s204ms 801ms [ User: lfriedman - Total duration: 8m29s - Times executed: 572 ]
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test35', '/usr/lib64/scim-1.0/scim-helper-manager', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 05:33:26 Duration: 15s37ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-win764-test29', 'cmd', '113'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 06:17:19 Duration: 7s32ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test35', '/usr/lib64/scim-1.0/scim-launcher -d -c simple -e all -f socket --no-stay', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 05:30:56 Duration: 3s430ms Database: nightly User: lfriedman
11 300ms 9s564ms 889ms 1,294 19m10s update systems set daemon_update = now(), activated = ? where vm = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 07 01 14 21s250ms 1s517ms 04 293 4m48s 983ms 05 402 6m18s 940ms 06 385 5m35s 871ms 07 157 1m43s 657ms 08 14 7s21ms 501ms 09 25 13s899ms 555ms 11 4 3s105ms 776ms [ User: lfriedman - Total duration: 19m10s - Times executed: 1294 ]
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-win732-build12';
Date: 2012-12-07 07:52:28 Duration: 9s564ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-linux64-build0';
Date: 2012-12-07 07:52:28 Duration: 9s171ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-linux64-build9';
Date: 2012-12-07 07:52:28 Duration: 8s325ms Database: cbs User: lfriedman
12 300ms 9s690ms 875ms 2,666 38m55s 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 07 23 1 820ms 820ms 00 4 2s201ms 550ms 01 61 1m23s 1s376ms 04 380 5m7s 809ms 05 728 12m22s 1s20ms 06 982 15m1s 917ms 07 360 3m32s 589ms 08 40 22s535ms 563ms 09 75 39s352ms 524ms 11 35 22s689ms 648ms [ User: lfriedman - Total duration: 38m55s - Times executed: 2666 ]
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win8-test14';
Date: 2012-12-07 07:52:28 Duration: 9s690ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win764-test29';
Date: 2012-12-07 07:52:28 Duration: 9s482ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/06', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win8-test5';
Date: 2012-12-07 07:52:28 Duration: 9s478ms Database: nightly User: lfriedman
13 304ms 4s849ms 873ms 50 43s693ms update tests set active = ? where id = ? and active is null;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 07 04 14 9s377ms 669ms 05 19 18s251ms 960ms 06 8 12s71ms 1s508ms 07 8 3s653ms 456ms 08 1 339ms 339ms [ User: lfriedman - Total duration: 43s693ms - Times executed: 50 ]
-
UPDATE tests SET active = 'cuda-linux-gputest16' WHERE id = '2419187' AND active IS NULL;
Date: 2012-12-07 07:37:52 Duration: 4s849ms Database: nightly User: lfriedman
-
UPDATE tests SET active = 'cuda-linux-gputest10' WHERE id = '2418304' AND active IS NULL;
Date: 2012-12-07 06:40:44 Duration: 4s786ms Database: nightly User: lfriedman
-
UPDATE tests SET active = 'cuda-vista32-test1' WHERE id = '2418291' AND active IS NULL;
Date: 2012-12-07 07:37:52 Duration: 3s365ms Database: nightly User: lfriedman
14 301ms 4s285ms 865ms 79 1m8s delete from cuhc where system = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 07 00 4 2s562ms 640ms 04 36 39s738ms 1s103ms 05 21 15s945ms 759ms 06 12 5s915ms 492ms 07 3 1s953ms 651ms 08 1 734ms 734ms 11 2 1s493ms 746ms [ User: lfriedman - Total duration: 1m8s - Times executed: 79 ]
-
DELETE FROM cuhc WHERE system = 'cuda-win764-test1';
Date: 2012-12-07 05:33:23 Duration: 4s285ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-linux32-test24';
Date: 2012-12-07 05:32:25 Duration: 2s740ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-win764-cvs24';
Date: 2012-12-07 05:33:11 Duration: 1s956ms Database: inventory User: lfriedman
15 302ms 5s682ms 855ms 137 1m57s update gpu set daemon_update = now() where system = ? and age(now(), daemon_update) > interval ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 07 00 3 1s266ms 422ms 01 10 15s49ms 1s504ms 04 27 28s496ms 1s55ms 05 42 32s187ms 766ms 06 34 27s766ms 816ms 07 16 9s204ms 575ms 08 2 1s612ms 806ms 11 3 1s611ms 537ms [ User: lfriedman - Total duration: 1m57s - Times executed: 137 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-vista32-test2' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-07 07:52:28 Duration: 5s682ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-win7-test22' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-07 02:44:16 Duration: 4s377ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-test5' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-07 06:19:37 Duration: 3s961ms Database: nightly User: lfriedman
16 300ms 9s519ms 849ms 300 4m14s update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 07 01 12 20s406ms 1s700ms 04 5 2s531ms 506ms 05 17 16s972ms 998ms 06 140 2m18s 991ms 07 87 55s75ms 633ms 08 9 5s388ms 598ms 09 25 12s806ms 512ms 11 5 2s927ms 585ms [ User: lfriedman - Total duration: 4m14s - Times executed: 300 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac64-test11'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test11';
Date: 2012-12-07 07:52:28 Duration: 9s519ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test13'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-linux32-test13';
Date: 2012-12-07 07:52:28 Duration: 7s501ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac-gputest16'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac-gputest16';
Date: 2012-12-07 07:52:24 Duration: 6s355ms Database: nightly User: lfriedman
17 305ms 3s157ms 758ms 56 42s481ms delete from tests where id = ? and active = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 07 04 23 14s383ms 625ms 05 22 18s815ms 855ms 06 5 4s216ms 843ms 07 6 5s66ms 844ms [ User: lfriedman - Total duration: 42s481ms - Times executed: 56 ]
-
DELETE FROM tests WHERE id = '2418081' AND active = 'cuda-vista32-test1';
Date: 2012-12-07 06:19:34 Duration: 3s157ms Database: nightly User: lfriedman
-
DELETE FROM tests WHERE id = '2419431' AND active = 'cuda-linux64-test75';
Date: 2012-12-07 08:37:37 Duration: 1s970ms Database: nightly User: lfriedman
-
DELETE FROM tests WHERE id = '2417535' AND active = 'cuda-linux-gputest3';
Date: 2012-12-07 07:38:04 Duration: 1s895ms Database: nightly User: lfriedman
18 300ms 9s209ms 757ms 640 8m4s update gpu set daemon_update = now() where system = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 07 04 124 1m39s 805ms 05 191 2m47s 875ms 06 227 2m40s 707ms 07 82 47s804ms 582ms 08 5 2s370ms 474ms 09 7 4s316ms 616ms 11 4 2s405ms 601ms [ User: lfriedman - Total duration: 8m4s - Times executed: 640 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac64-cvs3';
Date: 2012-12-07 07:52:28 Duration: 9s209ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-cvs21';
Date: 2012-12-07 06:19:49 Duration: 7s645ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-cvs0';
Date: 2012-12-07 06:19:49 Duration: 7s643ms Database: nightly User: lfriedman
19 300ms 7s464ms 750ms 274 3m25s insert into regressspace (reftable, reftableid, cl, cldate, clowner) values (?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 07 04 14 11s20ms 787ms 05 260 3m14s 748ms [ User: lfriedman - Total duration: 3m25s - Times executed: 274 ]
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('nvprof32on64tests', '342824', '14523179', '2012/12/04', 'builder');
Date: 2012-12-07 06:19:47 Duration: 7s464ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('nvprof32on64tests', '342824', '14523080', '2012/12/04', 'debalinab');
Date: 2012-12-07 06:19:37 Duration: 4s464ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('thrusttests', '22769387', '14538319', '2012/12/06', 'sanjain');
Date: 2012-12-07 05:33:30 Duration: 2s728ms Database: nightly User: lfriedman
20 303ms 5s532ms 723ms 529 6m22s update gpu set daemon_update = now(), activated = ? where system = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 07 01 2 755ms 377ms 04 123 1m33s 760ms 05 159 2m2s 767ms 06 157 1m55s 733ms 07 63 38s125ms 605ms 08 6 3s762ms 627ms 09 17 8s373ms 492ms 11 2 1s 500ms [ User: lfriedman - Total duration: 6m22s - Times executed: 529 ]
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs12';
Date: 2012-12-07 07:37:52 Duration: 5s532ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win7-cvs5';
Date: 2012-12-07 07:52:30 Duration: 4s663ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs11';
Date: 2012-12-07 05:33:24 Duration: 4s192ms Database: nightly User: lfriedman
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 571ms 1 571ms 571ms 571ms UPDATE saved_searches SET last_used = NOW() WHERE LOWER(title) = LOWER($1);Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Dec 07 05 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 3s388ms 2 1s245ms 2s142ms 1s694ms 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 #1
Day Hour Count Duration Avg duration Dec 07 00 1 2s142ms 2s142ms Dec 07 08 1 1s245ms 1s245ms [ 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 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
2 2s512ms 1 2s512ms 2s512ms 2s512ms 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 #2
Day Hour Count Duration Avg duration 23 1 2s512ms 2s512ms [ 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_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
3 2s267ms 2 708ms 1s558ms 1s133ms 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 #3
Day Hour Count Duration Avg duration 08 1 1s558ms 1s558ms 07 1 708ms 708ms [ 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 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
4 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 #4
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
5 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 #5
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
6 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 #6
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
7 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 #7
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
8 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 #8
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
9 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 #9
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'
10 1s304ms 2 545ms 758ms 652ms 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 #10
Day Hour Count Duration Avg duration 23 1 758ms 758ms 07 1 545ms 545ms [ User: lfriedman - Total duration: 76ms - Times executed: 2 ]
-
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-07 09:40:35 Duration: 545ms Database: postgres User: pvs Remote: lfriedman
11 1s199ms 2 407ms 792ms 599ms 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 #11
Day Hour Count Duration Avg duration 08 1 407ms 407ms 14 1 792ms 792ms [ User: lfriedman - Total duration: 6ms - Times executed: 2 ]
-
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-06 10:01:19 Duration: 407ms Database: postgres User: pvs Remote: lfriedman
12 887ms 2 390ms 496ms 443ms 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 #12
Day Hour Count Duration Avg duration 14 1 496ms 496ms 07 1 390ms 390ms [ User: lfriedman - Total duration: 3s433ms - Times executed: 2 ]
-
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
-
SELECT testname FROM thrusttests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-07 09:41:36 Duration: 390ms Database: postgres User: pvs Remote: lfriedman parameters: $1 = '5309', $2 = 'FAILED'
13 830ms 1 830ms 830ms 830ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM memcheck_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 #13
Day Hour Count Duration Avg duration 08 1 830ms 830ms [ 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 memcheck_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 10:01:31 Duration: 830ms Database: postgres User: pvs Remote: lfriedman
14 739ms 1 739ms 739ms 739ms SELECT id, pass, fail, error, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM nppsmoke 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 #14
Day Hour Count Duration Avg duration 08 1 739ms 739ms [ User: lfriedman - Total duration: 6ms - Times executed: 1 ]
-
SELECT id, pass, fail, error, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM nppsmoke 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:54 Duration: 739ms Database: postgres User: pvs Remote: lfriedman
15 718ms 1 718ms 718ms 718ms SELECT testname FROM vipertests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 14 1 718ms 718ms [ User: lfriedman - Total duration: 0ms - Times executed: 1 ]
-
SELECT testname FROM vipertests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-06 16:39:39 Duration: 718ms Database: postgres User: nightly Remote: lfriedman
16 690ms 1 690ms 690ms 690ms INSERT INTO user_preferences (cookie, json) VALUES ($1, $2);Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 04 1 690ms 690ms [ User: lfriedman - Total duration: 1ms - Times executed: 1 ]
-
INSERT INTO user_preferences (cookie, json) VALUES ($1, $2);
Date: 2012-12-07 06:19:27 Duration: 690ms Database: postgres User: inventory Remote: lfriedman
17 607ms 1 607ms 607ms 607ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM dblamodel 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 10 1 607ms 607ms [ 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 dblamodel 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:40:41 Duration: 607ms Database: postgres User: pvs Remote: lfriedman
18 558ms 1 558ms 558ms 558ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM cublassmoke 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 558ms 558ms [ User: lfriedman - Total duration: 6ms - Times executed: 1 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM cublassmoke 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:35 Duration: 558ms Database: postgres User: pvs Remote: lfriedman
19 531ms 1 531ms 531ms 531ms 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 #19
Day Hour Count Duration Avg duration 10 1 531ms 531ms [ 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 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
20 522ms 1 522ms 522ms 522ms SELECT testname FROM cufftsmoketests 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 08 1 522ms 522ms [ User: lfriedman - Total duration: 85ms - Times executed: 1 ]
-
SELECT testname FROM cufftsmoketests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-06 10:00:29 Duration: 522ms Database: postgres User: pvs Remote: lfriedman
-
pgBouncer
Request Throughput
Key values
- 3,081 queries/s Request Peak
- 2012-12-07 21:41:20 Date
Bytes I/O Throughput
Key values
- 1,092,413 Bytes/s In Bytes Peak
- 2012-12-07 01:01:19 Date
- 1,011,184 Bytes/s Out Bytes Peak
- 2012-12-07 00:01:19 Date
Queries Average duration
Key values
- 113ms Average Duration Peak
- 2012-12-07 07:10:19 Date
Established Connections
Key values
- 222 connections Connection Peak
- 2012-12-07 22:10:38 Date
Connections per database
Key values
- nightly Main Database
- 1,236,406 connections Total
Database User Count albatros_dimp_test 2 lfriedman 2 gasworks2 484 lfriedman 484 grinderman 2,830 lfriedman 2,830 intranet 94,899 lfriedman 94,899 intranet_test 1,434 lfriedman 1,434 jdb 440 lfriedman 440 lfriedman_test 576 lfriedman 576 nightly 983,640 lfriedman 983,640 optique_production 288 lfriedman 288 pgbouncer 567 dalibo 567 sterne_production 755 lfriedman 755 vangard_prod 6,054 lfriedman 6,054 webmail 144,437 lfriedman 144,437 Connections per user
Key values
- lfriedman Main User
- 1,236,406 connections Total
Connections per host
Key values
- 10.10.10.22.13 Main host with 898797 connections
- 1,236,406 Total connections
Simultaneous sessions
Key values
- 395 sessions Session Peak
- 2012-12-07 15:45:49 Date
Histogram of session times
Key values
- 1,102,417 0-500ms duration
Sessions per database
Key values
- nightly Main Database
- 1,241,674 sessions Total
Database User Count Total Duration Average Duration albatros_dimp_test 3 1m 20s gasworks2 742 5h42m41s 27s710ms grinderman 2,830 23m43s 502ms intranet 95,715 3d15h54m34s 3s306ms intranet_test 1,434 16h20m56s 41s43ms jdb 698 5h35m1s 28s797ms lfriedman_test 576 0ms 0ms nightly 985,942 26d6h57m39s 2s303ms optique_production 316 29m15s 5s553ms pgbouncer 567 0ms 0ms sterne_production 1,179 9h28m26s 28s927ms vangard_prod 6,323 2d3h54m25s 29s553ms webmail 145,349 4d5h51m53s 2s522ms Sessions per user
Key values
- lfriedman Main User
- 1,241,674 sessions Total
Sessions per host
Key values
- 10.10.10.22.13 Main Host
- 1,241,674 sessions Total
Most used reserved pools
Key values
- lfriedman@nightly Most used reserved pool
- 1,322 Time used
- 1,340 Total time reserved pools was used
Rank Times used Reserved pool 1 1,322 lfriedman@nightlyTimes Reported Most used reserved pools #1
Day Hour Count Dec 07 23 30 00 30 01 30 02 30 03 30 04 32 05 55 06 74 07 75 08 84 09 60 10 50 11 26 12 27 13 35 14 60 15 64 16 78 17 84 18 75 19 76 20 82 21 76 22 59 2 11 lfriedman@intranetTimes Reported Most used reserved pools #2
Day Hour Count Dec 07 07 5 08 2 09 1 14 3 3 7 lfriedman@webmailTimes Reported Most used reserved pools #3
Day Hour Count Dec 07 09 7 Most Frequent Errors/Events
Key values
- 1,340 Max number of times the same event was reported
- 1,340 Total events found
Rank Times reported Error 1 1,340 WARNING: Taking connection from reserve_poolTimes Reported Most Frequent Error / Event #1
Day Hour Count Dec 07 23 30 00 30 01 30 02 30 03 30 04 32 05 55 06 74 07 80 08 86 09 68 10 50 11 26 12 27 13 35 14 63 15 64 16 78 17 84 18 75 19 76 20 82 21 76 22 59 - WARNING: Taking connection from reserve_pool
- WARNING: Taking connection from reserve_pool
- WARNING: Taking connection from reserve_pool
Date: 2012-12-07 00:00:28 Database: nightly User: lfriedman Remote: 10.10.10.22.13
Date: 2012-12-07 00:00:28 Database: nightly User: lfriedman Remote: 10.10.10.22.13
Date: 2012-12-07 00:00:28 Database: nightly User: lfriedman Remote: 10.10.10.22.13
-
Events
Log levels
Key values
- 18,352,079 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 982 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 967 Max number of times the same event was reported
- 982 Total events found
Rank Times reported Error 1 967 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 07 10 7 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='WIN8' AND arch='x86_64' AND branch='cuda_a' AND dbname='nightly';
Date: 2012-12-07 12:05:38 Database: inventory Application: User: lfriedman Remote:
2 7 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #2
Day Hour Count Dec 07 04 5 05 1 06 1 - ERROR: process 19742 still waiting for ExclusiveLock on extension of relation 485634 of database 16413 after 1000.087 ms
- ERROR: process 25246 still waiting for ExclusiveLock on extension of relation 485634 of database 16413 after 1000.101 ms
- ERROR: process 25246 still waiting for ExclusiveLock on extension of relation 485634 of database 16413 after 1000.117 ms
Context: SQL statement "INSERT INTO nppsmoketests_2012_12 VALUES (NEW.*)" PL/pgSQL function nppsmoketests_insert_trigger() line 30 at SQL statement COPY nppsmoketests, line 63985: ""2012-12-07 07:51:16","Root/Functional/Image/FilterTests/FilterBox/8u_C4R/Sink/Src_Offset10","PASSED..."
Statement: COPY nppsmoketests (last_update,testname,current_status,suiteid,regressioncl,testcl,os,arch,build_type,branch,gpu,subtest,osversion) FROM STDIN with CSV HEADER ESCAPE '~';Date: 2012-12-07 07:52:33 Database: nightly Application: User: lfriedman Remote:
Context: SQL statement "INSERT INTO nppsmoketests_2012_12 VALUES (NEW.*)" PL/pgSQL function nppsmoketests_insert_trigger() line 30 at SQL statement COPY nppsmoketests, line 46115: ""2012-12-07 05:30:25","Root/Functional/Image/Arithmetic/ImageSqr_AC4R_Tests/Sqr_16u_AC4RSfs_Test/Int..."
Statement: COPY nppsmoketests (last_update,testname,current_status,suiteid,regressioncl,testcl,os,arch,build_type,branch,gpu,subtest,osversion) FROM STDIN with CSV HEADER ESCAPE '~';Date: 2012-12-07 05:31:19 Database: nightly Application: User: lfriedman Remote:
Context: SQL statement "INSERT INTO nppsmoketests_2012_12 VALUES (NEW.*)" PL/pgSQL function nppsmoketests_insert_trigger() line 30 at SQL statement COPY nppsmoketests, line 69762: ""2012-12-07 05:30:25","Root/Functional/Image/FilterTests/FilterSobelHoriz/8u_C4R/Source/Dst_Offset8"..."
Statement: COPY nppsmoketests (last_update,testname,current_status,suiteid,regressioncl,testcl,os,arch,build_type,branch,gpu,subtest,osversion) FROM STDIN with CSV HEADER ESCAPE '~';Date: 2012-12-07 05:31:49 Database: nightly Application: User: lfriedman Remote:
3 6 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Dec 07 00 1 08 1 09 1 11 2 12 1 - ERROR: syntax error at or near "/" at character 1
- ERROR: syntax error at or near ":" at character 18
- ERROR: syntax error at or near "GROUP" at character 17
Statement: /d select * from locations;
Date: 2012-12-07 10:20:07 Database: inventory Application: User: lfriedman Remote:
Statement: select * from gpu: select * from gpu;
Date: 2012-12-07 12:15:11 Database: nightly Application: User: lfriedman Remote:
Statement: SELECT cl FROM GROUP BY cl ORDER BY cl DESC LIMIT 7
Date: 2012-12-07 01:42:49 Database: nightly Application: User: lfriedman Remote:
4 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Dec 07 10 1 - ERROR: column "system" does not exist at character 63
Statement: update systems set active='f',comment='AP:reallocating' where system='cuda-mac64-build11' ;
Date: 2012-12-07 11:33:14 Database: cbs Application: User: lfriedman Remote:
5 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Dec 07 10 1 - ERROR: relation "bulds" does not exist at character 13
Statement: delete from bulds where active='disabled' ;
Date: 2012-12-07 11:56:13 Database: cbs 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