pgBadger-
Global information
- Generated on Tue May 17 09:17:02 2022
- Log file: /data/pglog/huge_log_test/pgbouncer.log.1, ..., /data/pglog/huge_log_test/postgresql-Tue.log
- Parsed 79,372,355 log entries in 13m57s
- Log start from 2012-12-06 00:00:00 to 2012-12-06 23:59:59
-
Overview
Global Stats
- 3,335 Number of unique normalized queries
- 18,787,532 Number of queries
- 2d21h38m53s Total query duration
- 2012-12-06 00:00:00 First query
- 2012-12-06 23:59:59 Last query
- 709 queries/s at 2012-12-06 14:06:07 Query peak
- 2d21h38m53s Total query duration
- 0ms Prepare/parse total duration
- 21s263ms Bind total duration
- 2d21h38m32s Execute total duration
- 16 Number of events
- 4 Number of unique normalized events
- 8 Max number of times the same event was reported
- 0 Number of cancellation
- 59 Total number of automatic vacuums
- 56 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 3,968,739 Total number of sessions
- 80 sessions at 2012-12-06 05:18:33 Session peak
- 298d23h41m20s Total duration of sessions
- 6s508ms Average duration of sessions
- 4 Average queries per session
- 63ms Average queries duration per session
- 6s445ms Average idle time per session
- 3,968,740 Total number of connections
- 218 connections/s at 2012-12-06 02:02:02 Connection peak
- 6 Total number of databases
SQL Traffic
Key values
- 709 queries/s Query Peak
- 2012-12-06 14:06:07 Date
SELECT Traffic
Key values
- 63 queries/s Query Peak
- 2012-12-06 05:19:12 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 72 queries/s Query Peak
- 2012-12-06 09:06:28 Date
Queries duration
Key values
- 2d21h38m53s 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 06 00 871,022 0ms 44s462ms 12ms 3m11s 3m14s 4m55s 01 859,523 0ms 2s111ms 12ms 3m14s 3m17s 4m3s 02 916,750 0ms 1s797ms 12ms 3m19s 3m27s 3m34s 03 938,542 0ms 2s8ms 12ms 3m24s 3m27s 3m33s 04 317,516 0ms 5s121ms 11ms 1m58s 3m 3m55s 05 232,846 0ms 4m28s 54ms 6m6s 15m3s 1h17m5s 06 290,382 0ms 2m3s 20ms 2m53s 5m26s 12m6s 07 493,028 0ms 2m2s 14ms 3m12s 3m57s 5m10s 08 640,574 0ms 1m15s 13ms 2m55s 3m13s 3m45s 09 720,250 0ms 1m45s 14ms 3m52s 5m49s 11m6s 10 814,328 0ms 1m18s 12ms 3m49s 3m57s 4m56s 11 845,924 0ms 1m2s 12ms 3m14s 3m37s 4m7s 12 849,782 0ms 1m10s 12ms 3m18s 3m43s 4m23s 13 863,172 0ms 2s109ms 12ms 3m20s 3m30s 3m38s 14 852,233 0ms 4s467ms 14ms 5m28s 6m53s 12m56s 15 894,969 0ms 1s758ms 11ms 3m32s 3m38s 3m44s 16 932,263 0ms 1m4s 11ms 3m40s 3m47s 4m31s 17 918,316 0ms 2s620ms 11ms 3m31s 3m39s 3m55s 18 922,675 0ms 1s772ms 13ms 4m35s 5m10s 5m45s 19 911,582 0ms 2s213ms 12ms 3m26s 3m30s 3m40s 20 921,774 0ms 20s749ms 12ms 3m25s 3m33s 7m15s 21 922,400 0ms 11s807ms 11ms 3m22s 3m32s 5m28s 22 914,023 0ms 1s797ms 12ms 3m49s 4m5s 4m56s 23 943,658 0ms 1m8s 13ms 4m28s 4m41s 5m3s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 06 00 234 0 649ms 3s125ms 5s46ms 9s321ms 01 182 0 600ms 2s163ms 2s600ms 6s42ms 02 143 0 569ms 2s169ms 2s657ms 4s764ms 03 143 0 612ms 2s536ms 2s804ms 4s894ms 04 56 0 1s74ms 521ms 1s527ms 4s379ms 05 1,509 0 3s325ms 7s746ms 39s301ms 10m45s 06 292 0 1s452ms 5s626ms 13s449ms 1m8s 07 280 0 1s261ms 7s563ms 9s967ms 1m1s 08 136 0 576ms 2s127ms 5s96ms 6s6ms 09 286 0 494ms 3s721ms 4s842ms 12s747ms 10 257 0 946ms 2s117ms 4s616ms 46s224ms 11 108 0 629ms 1s649ms 3s242ms 3s892ms 12 145 0 591ms 2s316ms 3s293ms 6s546ms 13 232 0 551ms 3s533ms 4s235ms 7s932ms 14 280 0 947ms 2s209ms 3s460ms 52s158ms 15 68 0 656ms 1s708ms 2s99ms 3s202ms 16 104 0 587ms 2s71ms 2s558ms 3s218ms 17 89 0 659ms 1s722ms 2s484ms 4s344ms 18 90 0 639ms 1s728ms 2s356ms 3s438ms 19 111 0 612ms 2s115ms 2s675ms 3s587ms 20 298 0 938ms 1s668ms 2s543ms 4s773ms 21 188 0 856ms 1s722ms 2s456ms 14s893ms 22 65 0 596ms 1s283ms 1s797ms 2s395ms 23 77 0 595ms 1s480ms 1s768ms 2s845ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 06 00 3 21 2 1 2s331ms 0ms 595ms 1s579ms 01 7 8 0 0 754ms 0ms 0ms 1s297ms 02 2 8 1 0 545ms 0ms 0ms 812ms 03 0 9 0 0 514ms 0ms 0ms 819ms 04 238 11 0 16 781ms 2s431ms 7s199ms 12s50ms 05 421 2,063 97 109 1s838ms 1m5s 1m44s 5m9s 06 226 1,245 20 72 1s349ms 8s180ms 1m7s 3m57s 07 87 302 6 33 1s554ms 2s424ms 6s975ms 1m13s 08 104 119 1 23 1s609ms 1s750ms 4s371ms 1m9s 09 106 699 7 20 1s594ms 2s332ms 6s938ms 1m45s 10 120 128 1 11 1s422ms 1s644ms 3s479ms 1m3s 11 90 46 1 7 1s97ms 1s619ms 1s645ms 4s64ms 12 11 115 0 11 1s675ms 331ms 1s616ms 45s110ms 13 6 18 1 3 563ms 0ms 546ms 1s572ms 14 4 24 0 0 864ms 0ms 0ms 2s732ms 15 0 0 0 2 332ms 0ms 0ms 0ms 16 0 4 0 1 13s295ms 0ms 0ms 326ms 17 0 0 0 2 354ms 0ms 0ms 0ms 18 6 4 0 2 674ms 0ms 0ms 808ms 19 30 5 0 3 730ms 0ms 721ms 3s232ms 20 5 28 4 0 795ms 0ms 414ms 937ms 21 48 11 0 1 1s37ms 0ms 0ms 8s917ms 22 1 0 0 1 595ms 0ms 0ms 0ms 23 31 12 0 2 2s281ms 0ms 0ms 11s312ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Dec 06 00 0 2 2.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 9 9.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 18 18.00 0.00% 11 0 12 12.00 0.00% 12 0 0 0.00 0.00% 13 0 1 1.00 0.00% 14 0 0 0.00 0.00% 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 9 9.00 0.00% 21 0 36 36.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Dec 06 00 179,565 49.88/s 01 183,511 50.98/s 02 199,758 55.49/s 03 208,182 57.83/s 04 58,074 16.13/s 05 44,235 12.29/s 06 44,705 12.42/s 07 108,894 30.25/s 08 147,255 40.90/s 09 162,329 45.09/s 10 180,147 50.04/s 11 184,412 51.23/s 12 177,836 49.40/s 13 189,339 52.59/s 14 169,587 47.11/s 15 188,939 52.48/s 16 190,476 52.91/s 17 195,961 54.43/s 18 190,636 52.95/s 19 196,338 54.54/s 20 192,786 53.55/s 21 191,844 53.29/s 22 192,732 53.54/s 23 191,199 53.11/s Day Hour Count Average Duration Average idle time Dec 06 00 179,564 6s6ms 5s945ms 01 183,511 5s885ms 5s827ms 02 199,758 5s408ms 5s352ms 03 208,184 5s181ms 5s126ms 04 58,073 18s333ms 18s270ms 05 44,235 24s420ms 24s132ms 06 44,704 24s235ms 24s101ms 07 108,894 9s988ms 9s923ms 08 147,255 7s332ms 7s275ms 09 162,331 6s653ms 6s589ms 10 180,145 5s993ms 5s934ms 11 184,412 5s844ms 5s785ms 12 177,836 6s72ms 6s11ms 13 189,339 5s707ms 5s649ms 14 169,588 5s958ms 5s884ms 15 188,939 5s706ms 5s650ms 16 190,475 5s667ms 5s609ms 17 195,961 5s514ms 5s458ms 18 190,636 5s653ms 5s585ms 19 196,338 5s500ms 5s444ms 20 192,787 5s589ms 5s531ms 21 191,843 5s632ms 5s575ms 22 192,732 5s594ms 5s535ms 23 191,199 5s640ms 5s574ms -
Connections
Established Connections
Key values
- 218 connections Connection Peak
- 2012-12-06 02:02:02 Date
Connections per database
Key values
- nightly Main Database
- 3,968,740 connections Total
Connections per user
Key values
- lfriedman Main User
- 3,968,740 connections Total
-
Sessions
Simultaneous sessions
Key values
- 80 sessions Session Peak
- 2012-12-06 05:18:33 Date
Histogram of session times
Key values
- 2,647,634 1000-30000ms duration
Sessions per database
Key values
- nightly Main Database
- 3,968,739 sessions Total
Sessions per user
Key values
- lfriedman Main User
- 3,968,739 sessions Total
Sessions per host
Key values
- 10.31.96.233 Main Host
- 3,968,739 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 169,983 buffers Checkpoint Peak
- 2012-12-06 05:43:34 Date
- 210.072 seconds Highest write time
- 139.270 seconds Sync time
Checkpoints Wal files
Key values
- 82 files Wal files usage Peak
- 2012-12-06 09:06:34 Date
Checkpoints distance
Key values
- 0.00 Mo Distance Peak
- 2012-12-06 12:15:08 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Dec 06 00 74,044 2,349.262s 0.364s 2,349.682s 01 21,331 2,129.491s 0.297s 2,129.844s 02 19,894 1,988.969s 0.141s 1,989.176s 03 20,799 2,078.716s 0.106s 2,078.879s 04 56,217 2,460.352s 0.616s 2,461.038s 05 1,380,983 2,136.503s 449.962s 2,586.666s 06 1,093,540 2,009.882s 202.775s 2,212.86s 07 546,752 2,541.818s 18.902s 2,560.821s 08 464,954 2,467.27s 9.554s 2,476.92s 09 467,312 2,353.665s 141.514s 2,495.286s 10 270,953 2,292.833s 13.423s 2,306.355s 11 293,010 2,641.008s 10.22s 2,651.306s 12 289,064 1,994.243s 6.316s 2,000.751s 13 25,869 2,470.542s 0.205s 2,470.808s 14 22,277 2,209.586s 0.157s 2,209.816s 15 22,327 2,206.005s 0.174s 2,206.236s 16 142,113 2,103.11s 0.298s 2,103.47s 17 26,177 2,516.635s 0.13s 2,516.838s 18 23,151 2,225.367s 0.141s 2,225.562s 19 21,116 2,046.125s 0.107s 2,046.283s 20 24,964 2,442.415s 0.121s 2,442.603s 21 19,617 1,959.431s 0.107s 1,959.596s 22 23,582 2,324.538s 0.107s 2,324.711s 23 145,464 2,166.001s 0.177s 2,166.241s Day Hour Added Removed Recycled Synced files Longest sync Average sync Dec 06 00 0 0 80 3,452 0.034s 0s 01 0 0 58 2,583 0.003s 0s 02 0 0 59 1,000 0.003s 0s 03 0 0 59 681 0.008s 0s 04 0 0 60 14,830 0.002s 0s 05 0 0 650 19,436 26.340s 0.564s 06 0 0 515 14,642 51.002s 0.222s 07 0 0 300 12,133 3.992s 0.029s 08 0 0 227 9,840 3.389s 0.011s 09 0 0 244 7,137 25.743s 0.167s 10 0 0 193 6,136 0.399s 0.021s 11 0 0 115 4,574 5.482s 0.019s 12 0 0 156 3,596 3.189s 0.011s 13 0 0 64 2,561 0.007s 0s 14 0 0 57 1,708 0.004s 0s 15 0 0 58 1,514 0.002s 0s 16 0 0 100 1,133 0.051s 0.001s 17 0 0 64 1,964 0.007s 0s 18 0 0 59 1,590 0.008s 0s 19 0 0 54 1,014 0.008s 0s 20 0 0 64 1,533 0.005s 0s 21 0 0 54 718 0.003s 0s 22 0 0 64 906 0.007s 0s 23 0 0 106 795 0.042s 0s Day Hour Count Avg time (sec) Dec 06 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 06 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 06 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
- 16.39 sec Highest CPU-cost vacuum
Table public.gpu
Database nightly - 2012-12-06 05:18:55 Date
- 318.85 sec Highest CPU-cost analyze
Table public.nppsmoketests_2012_12
Database nightly - 2012-12-06 05:21:47 Date
Analyzes per table
Key values
- public.njsmoketests_2012_12 (3) Main table analyzed (database nightly)
- 56 analyzes Total
Table Number of analyzes nightly.public.njsmoketests_2012_12 3 pvs.public.nppsmoketests_2012_12 2 nightly.public.cublassmoketests_2012_12 2 nightly.public.sparse_cublastests_2012_12 2 pvs.public.dblcublastests_2012_12 2 nightly.public.dblamodeltests_2012_12 2 nightly.public.curandtests_2012_12 2 nightly.public.cufftsmoketests_2012_12 2 nightly.public.profsmokenewtests_2012_12 2 nightly.public.mc_cublastests_2012_12 2 pvs.public.cudasmoketests_2012_12 2 nightly.public.nvproftests_2012_12 2 nightly.public.mc_dblcublastests_2012_12 2 nightly.public.mathsmokesm2xtests_2012_12 2 pvs.public.cublassmoketests_2012_12 2 pvs.public.thrusttests_2012_12 2 nightly.public.nppsmoketests_2012_12 2 nightly.public.dblcublastests_2012_12 2 nightly.public.thrusttests_2012_12 2 nightly.public.mc_cusparsetests_2012_12 2 nightly.public.smoke32on64tests_2012_12 2 nightly.public.dblcuffttests_2012_12 2 nightly.public.cudasmoketests_2012_12 2 pvs.public.njsmoketests_2012_12 2 pvs.public.dblcuffttests_2012_12 1 pvs.public.dblamodeltests_2012_12 1 pvs.public.sparse_cublastests_2012_12 1 nightly.public.gpu 1 cbs.public.systems 1 nightly.public.interop32on64tests 1 nightly.public.debuggertests_2012_12 1 Total 56 Vacuums per table
Key values
- public.gpu (56) Main table vacuumed on database nightly
- 59 vacuums Total
Tuples removed per table
Key values
- public.gpu (21685) Main table with removed tuples on database nightly
- 21783 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 06 00 0 0 01 0 0 02 0 0 03 0 0 04 0 5 05 5 15 06 2 10 07 0 8 08 0 2 09 1 7 10 12 3 11 39 3 12 0 0 13 0 1 14 0 0 15 0 0 16 0 1 17 0 0 18 0 0 19 0 1 20 0 0 21 0 0 22 0 0 23 0 0 - 16.39 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ExclusiveLock Main Lock Type
- 8 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 8 16s54ms 1s45ms 3s160ms 2s6ms 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-06 05:20:11 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-06 05:20:19 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-06 05:20:21 Database: nightly User: lfriedman
Queries that waited the most
Rank Wait time Query 1 3s160ms 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-06 05:18:21 - Database: nightly - User: lfriedman ]
2 2s476ms 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-06 05:17:47 - Database: nightly - User: lfriedman ]
3 2s464ms 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-06 05:17:47 - Database: nightly - User: lfriedman ]
4 2s441ms 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-06 05:17:50 - Database: nightly - User: lfriedman ]
5 1s929ms 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-06 05:16:56 - Database: nightly - User: lfriedman ]
6 1s486ms 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-06 05:17:52 - Database: nightly - User: lfriedman ]
7 1s50ms 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-06 05:16:57 - Database: nightly - User: lfriedman ]
8 1s45ms 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-06 05:16:57 - Database: nightly - User: lfriedman ]
-
Queries
Queries by type
Key values
- 5,373 Total read queries
- 9,853 Total write queries
Queries by database
Key values
- nightly Main database
- 17,669,344 Requests
- 2d19h54m7s (nightly)
- Main time consuming database
Database Request type Count Duration cbs Total 504,453 45m delete 1 517ms insert 1 607ms select 204 4m58s update 990 17m24s inventory Total 374,641 16m16s copy from 4 3s1ms delete 81 1m42s insert 8 4s706ms select 60 1m38s update 136 2m8s mbm Total 126,672 3m24s select 9 7s290ms nightly Total 17,669,344 2d19h54m7s copy from 256 1h2m8s ddl 2,964 0ms delete 53 1m22s insert 1,516 22m14s select 5,054 2h5m47s tcl 2 1s345ms update 3,723 1h1m20s postgres Total 349 902ms select 1 330ms pvs Total 112,073 39m41s copy from 60 11m delete 6 3s918ms insert 21 16s274ms select 45 2m39s update 31 42s310ms Queries by user
Key values
- lfriedman Main user
- 18,787,183 Requests
User Request type Count Duration lfriedman Total 18,787,183 2d21h38m31s copy from 320 1h13m11s ddl 2,964 0ms delete 141 3m9s insert 1,546 22m36s select 5,372 2h15m12s tcl 2 1s345ms update 4,880 1h21m35s postgres Total 349 902ms select 1 330ms Duration by user
Key values
- 2d21h38m31s (lfriedman) Main time consuming user
User Request type Count Duration lfriedman Total 18,787,183 2d21h38m31s copy from 320 1h13m11s ddl 2,964 0ms delete 141 3m9s insert 1,546 22m36s select 5,372 2h15m12s tcl 2 1s345ms update 4,880 1h21m35s postgres Total 349 902ms select 1 330ms Queries by host
Key values
- unknown Main host
- 18,787,532 Requests
- 2d21h38m32s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 18,787,532 Requests
- 2d21h38m32s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2012-12-06 21:54:27 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 10,051,612 0-1ms duration
Slowest individual queries
Rank Duration Query 1 4m28s 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-06 05:20:11 - Database: nightly - User: lfriedman ]
2 4m22s 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-06 05:20:19 - Database: nightly - User: lfriedman ]
3 4m19s 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-06 05:20:21 - Database: nightly - User: lfriedman ]
4 2m4s 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-06 05:04:57 - Database: nightly - User: lfriedman ]
5 2m3s 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-06 06:29:37 - Database: nightly - User: lfriedman ]
6 2m2s SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux64-test7') 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-06 07:03:53 - Database: nightly - User: lfriedman ]
7 2m 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-06 05:16:38 - Database: nightly - User: lfriedman ]
8 1m58s 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-06 06:29:37 - Database: nightly - User: lfriedman ]
9 1m46s 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-06 05:16:11 - Database: nightly - User: lfriedman ]
10 1m45s 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-06 09:07:15 - Database: nightly - User: lfriedman ]
11 1m42s 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-06 05:41:42 - Database: nightly - User: lfriedman ]
12 1m41s 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-06 05:42:18 - Database: nightly - User: lfriedman ]
13 1m36s 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-06 05:10:42 - Database: pvs - User: lfriedman ]
14 1m32s 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-06 05:41:13 - Database: nightly - User: lfriedman ]
15 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-06 06:28:15 - Database: nightly - User: lfriedman ]
16 1m28s select suiteid from nppsmoketests where last_update > '2012-11-29T05:38:15' group by suiteid order by suiteid;[ Date: 2012-12-06 05:39:44 - Database: nightly - User: lfriedman ]
17 1m26s 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-06 09:04:21 - Database: nightly - User: lfriedman ]
18 1m26s 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-06 05:34:20 - Database: nightly - User: lfriedman ]
19 1m24s 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-06 05:48:16 - Database: nightly - User: lfriedman ]
20 1m19s SELECT testname FROM filterout WHERE script = 'thrust.sh' AND os = 'Darwin' AND arch = 'x86_64' AND build = 'release' AND gpu = '116' AND branch = 'cuda_a' AND vc = 'g' AND last_update = '2012-12-06' AND active = 't' and category = 1;[ Date: 2012-12-06 05:18:53 - Database: nightly - User: lfriedman ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h37m34s 3,353 300ms 23s855ms 1s746ms 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 06 23 162 1m41s 628ms 00 90 59s592ms 662ms 01 66 32s413ms 491ms 02 43 20s911ms 486ms 03 45 54s347ms 1s207ms 04 1,384 1h14m42s 3s239ms 05 221 2m41s 732ms 06 183 2m5s 688ms 07 67 33s419ms 498ms 08 216 1m33s 434ms 09 152 1m40s 662ms 10 7 3s577ms 511ms 11 50 24s543ms 490ms 12 164 1m26s 528ms 13 159 2m52s 1s81ms 15 15 7s93ms 472ms 17 8 4s488ms 561ms 18 29 15s543ms 535ms 19 219 3m16s 898ms 20 73 1m16s 1s44ms [ User: lfriedman - Total duration: 1h37m34s - Times executed: 3353 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';
Date: 2012-12-06 05:18:15 Duration: 23s855ms 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-06 05:18:11 Duration: 21s68ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('canary') AND c.relpersistence = 'u';
Date: 2012-12-06 05:18:11 Duration: 19s886ms Database: nightly User: lfriedman
2 1h8m20s 44 30s641ms 4m28s 1m33s 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 06 04 14 30m49s 2m12s 05 10 13m16s 1m19s 06 5 6m6s 1m13s 07 3 3m36s 1m12s 08 4 5m32s 1m23s 09 3 3m26s 1m8s 10 1 1m2s 1m2s 11 2 2m15s 1m7s 15 1 1m4s 1m4s 22 1 1m8s 1m8s [ User: lfriedman - Total duration: 1h8m20s - Times executed: 44 ]
-
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-06 05:20:11 Duration: 4m28s 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-06 05:20:19 Duration: 4m22s 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-06 05:20:21 Duration: 4m19s Database: nightly User: lfriedman
3 29m7s 1,857 300ms 10s997ms 940ms 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 06 23 11 8s468ms 769ms 00 2 777ms 388ms 01 4 2s468ms 617ms 04 679 11m35s 1s24ms 05 482 6m25s 799ms 06 145 1m42s 707ms 07 44 27s148ms 617ms 08 315 6m55s 1s317ms 09 52 23s432ms 450ms 10 18 7s76ms 393ms 11 58 40s244ms 693ms 12 10 5s874ms 587ms 13 13 11s255ms 865ms 15 1 326ms 326ms 18 2 839ms 419ms 19 11 8s471ms 770ms 20 5 9s974ms 1s994ms 22 5 2s598ms 519ms [ User: lfriedman - Total duration: 29m7s - Times executed: 1857 ]
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win764-test7';
Date: 2012-12-06 09:06:28 Duration: 10s997ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win7-gputest12';
Date: 2012-12-06 09:06:28 Duration: 10s881ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win864-test12';
Date: 2012-12-06 05:18:15 Duration: 10s794ms Database: nightly User: lfriedman
4 17m22s 988 300ms 11s30ms 1s55ms update systems set daemon_update = now(), activated = ? where vm = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 06 23 1 456ms 456ms 00 1 469ms 469ms 02 2 951ms 475ms 03 5 2s311ms 462ms 04 477 8m32s 1s74ms 05 274 4m30s 986ms 06 41 34s551ms 842ms 07 24 21s29ms 876ms 08 107 2m42s 1s519ms 09 14 7s331ms 523ms 10 9 3s915ms 435ms 11 15 8s918ms 594ms 12 3 1s260ms 420ms 13 5 5s49ms 1s9ms 17 2 1s328ms 664ms 18 1 436ms 436ms 19 3 2s223ms 741ms 20 2 4s553ms 2s276ms 22 2 2s260ms 1s130ms [ User: lfriedman - Total duration: 17m22s - Times executed: 988 ]
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-win732-build20';
Date: 2012-12-06 09:06:28 Duration: 11s30ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-linux64-build0';
Date: 2012-12-06 09:06:28 Duration: 10s628ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-mac64-build8';
Date: 2012-12-06 09:06:28 Duration: 9s355ms Database: cbs User: lfriedman
5 14m48s 1,068 318ms 3s354ms 831ms insert into proccheck (hostname, process, subtestid) values (?, ?, ?); delete from proccheck where age(now(), datestamp) > interval ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 06 23 2 1s627ms 813ms 00 6 4s876ms 812ms 01 2 1s613ms 806ms 03 236 3m8s 798ms 04 148 2m11s 887ms 05 54 51s689ms 957ms 06 70 57s280ms 818ms 07 104 1m26s 830ms 08 97 1m21s 835ms 09 120 1m37s 814ms 10 90 1m13s 814ms 11 9 7s289ms 809ms 12 5 4s34ms 806ms 13 4 3s747ms 936ms 17 6 4s901ms 816ms 18 30 24s282ms 809ms 19 5 4s28ms 805ms 20 48 38s688ms 806ms 21 1 823ms 823ms 22 31 25s222ms 813ms [ User: lfriedman - Total duration: 14m48s - Times executed: 1068 ]
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test96', '/home/lfriedman/cuda-stuff/sw/gpgpu/opencl/conformance_1.1/nvidia/tests/test_conformance/../../../../../bin/x86_64_Linux_release/conformance_test_image_streams use_pitches CL_FILTER_NEAREST CL_RGBA 2D NO_HOST_PTR', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-06 06:29:32 Duration: 3s354ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux32-test23', 'sh -c /home/lfriedman/cuda-stuff/sw/gpgpu/bin/i686_Linux_release/memcpy_sysdev > memcpy_sysdev.output', '177'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-06 05:42:06 Duration: 2s183ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test16', './TestNPP -q -f npp-filterlist -r', '76'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-06 05:20:07 Duration: 2s46ms Database: nightly User: lfriedman
6 13m48s 828 397ms 2m2s 1s 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 #6
Day Hour Count Duration Avg duration Dec 06 23 45 38s158ms 847ms 00 41 29s797ms 726ms 01 41 34s480ms 840ms 02 46 45s351ms 985ms 03 3 1s765ms 588ms 04 3 1s668ms 556ms 05 4 2s206ms 551ms 06 20 2m35s 7s776ms 07 27 22s219ms 822ms 08 30 29s39ms 967ms 09 37 37s275ms 1s7ms 10 45 35s79ms 779ms 11 37 29s123ms 787ms 12 36 26s795ms 744ms 13 43 34s561ms 803ms 14 38 32s611ms 858ms 15 45 37s67ms 823ms 16 46 38s188ms 830ms 17 45 38s241ms 849ms 18 40 35s219ms 880ms 19 36 29s257ms 812ms 20 46 36s295ms 789ms 21 35 27s589ms 788ms 22 39 30s956ms 793ms [ User: lfriedman - Total duration: 13m48s - Times executed: 828 ]
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux64-test7') 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-06 07:03:53 Duration: 2m2s Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac-test6') 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-06 07:05:03 Duration: 14s979ms Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac-test10') 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-06 10:00:50 Duration: 3s256ms Database: nightly User: lfriedman
7 8m18s 550 300ms 10s743ms 906ms update gpu set dd_date = ?, last_update = (date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 06 02 1 398ms 398ms 03 1 693ms 693ms 04 241 3m32s 883ms 05 158 2m8s 814ms 06 31 18s937ms 610ms 07 14 10s98ms 721ms 08 73 1m46s 1s461ms 09 13 6s462ms 497ms 10 3 1s478ms 492ms 11 10 8s403ms 840ms 12 1 372ms 372ms 17 1 333ms 333ms 19 1 2s149ms 2s149ms 22 2 953ms 476ms [ User: lfriedman - Total duration: 8m18s - Times executed: 550 ]
-
UPDATE gpu SET dd_date = 'Thu Dec 6 00:27:45 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux64-cvs22';
Date: 2012-12-06 09:06:28 Duration: 10s743ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs4';
Date: 2012-12-06 09:06:28 Duration: 10s258ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs9';
Date: 2012-12-06 05:18:30 Duration: 9s721ms Database: nightly User: lfriedman
8 5m44s 422 302ms 10s728ms 816ms update gpu set daemon_update = now(), activated = ? where system = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 06 23 1 513ms 513ms 02 1 585ms 585ms 03 1 746ms 746ms 04 173 2m45s 954ms 05 127 1m40s 793ms 06 34 19s153ms 563ms 07 16 12s301ms 768ms 08 49 34s455ms 703ms 09 8 3s349ms 418ms 10 2 1s64ms 532ms 11 10 6s191ms 619ms [ User: lfriedman - Total duration: 5m44s - Times executed: 422 ]
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs24';
Date: 2012-12-06 05:18:15 Duration: 10s728ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs3';
Date: 2012-12-06 05:18:14 Duration: 9s422ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win7-cvs5';
Date: 2012-12-06 05:18:13 Duration: 8s457ms Database: nightly User: lfriedman
9 5m41s 358 303ms 9s839ms 955ms insert into regressspace (reftable, reftableid, cl, cldate, clowner) values (?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 06 04 189 3m49s 1s214ms 05 158 1m46s 672ms 06 10 5s671ms 567ms 08 1 371ms 371ms [ User: lfriedman - Total duration: 5m41s - Times executed: 358 ]
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('cublassmoketests', '28970731', '14523510', '2012/12/04', 'builder');
Date: 2012-12-06 05:18:14 Duration: 9s839ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('cublassmoketests', '28970731', '14524023', '2012/12/04', 'builder');
Date: 2012-12-06 05:18:29 Duration: 7s894ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('cublassmoketests', '28971536', '14536746', '2012/12/05', 'builder');
Date: 2012-12-06 05:18:11 Duration: 7s154ms Database: nightly User: lfriedman
10 5m19s 172 301ms 20s369ms 1s859ms 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 #10
Day Hour Count Duration Avg duration Dec 06 23 3 2s285ms 761ms 00 1 888ms 888ms 01 1 308ms 308ms 02 1 363ms 363ms 03 3 1s360ms 453ms 04 87 4m9s 2s863ms 05 9 9s79ms 1s8ms 06 7 4s894ms 699ms 07 1 347ms 347ms 08 2 1s53ms 526ms 09 8 3s989ms 498ms 11 1 471ms 471ms 12 5 3s6ms 601ms 13 41 41s495ms 1s12ms 17 1 539ms 539ms 18 1 521ms 521ms [ User: lfriedman - Total duration: 5m19s - Times executed: 172 ]
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('vipertests') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-06 05:18:39 Duration: 20s369ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('nvprof32on64') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-06 05:18:18 Duration: 18s710ms 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-06 05:18:18 Duration: 14s524ms Database: nightly User: lfriedman
11 4m48s 712 300ms 4s333ms 404ms 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 #11
Day Hour Count Duration Avg duration Dec 06 23 23 8s838ms 384ms 00 49 18s734ms 382ms 01 34 13s306ms 391ms 02 53 21s32ms 396ms 03 3 1s114ms 371ms 04 3 1s179ms 393ms 05 4 3s17ms 754ms 06 13 9s917ms 762ms 07 28 11s144ms 398ms 08 29 11s477ms 395ms 09 29 14s649ms 505ms 10 36 14s197ms 394ms 11 44 17s699ms 402ms 12 22 8s839ms 401ms 13 32 12s605ms 393ms 14 29 11s388ms 392ms 15 42 16s41ms 381ms 16 36 14s139ms 392ms 17 33 12s975ms 393ms 18 40 16s35ms 400ms 19 31 11s459ms 369ms 20 31 12s175ms 392ms 21 30 11s184ms 372ms 22 38 14s896ms 392ms [ User: lfriedman - Total duration: 4m48s - Times executed: 712 ]
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac64-test8') AND os = 'Darwin' AND arch = 'x86_64' AND osversion = '10.8' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-06 07:12:06 Duration: 4s333ms Database: nightly User: lfriedman
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux64-test34') AND os = 'Linux' AND arch = 'x86_64' AND osversion = '2.6.18-308.el5' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-06 10:54:07 Duration: 3s359ms Database: nightly User: lfriedman
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win764-test38') 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-06 06:31:28 Duration: 1s198ms Database: nightly User: lfriedman
12 2m14s 2 45s765ms 1m28s 1m7s select suiteid from nppsmoketests where last_update > ? group by suiteid order by suiteid;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 06 04 1 1m28s 1m28s 09 1 45s765ms 45s765ms [ User: lfriedman - Total duration: 2m14s - Times executed: 2 ]
-
select suiteid from nppsmoketests where last_update > '2012-11-29T05:38:15' group by suiteid order by suiteid;
Date: 2012-12-06 05:39:44 Duration: 1m28s Database: nightly User: lfriedman
-
select suiteid from nppsmoketests where last_update > '2012-11-29T10:47:30' group by suiteid order by suiteid;
Date: 2012-12-06 10:48:15 Duration: 45s765ms Database: pvs User: lfriedman
13 1m59s 95 318ms 16s750ms 1s261ms update gpu set daemon_update = now() where system = ? and age(now(), daemon_update) > interval ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 06 23 5 2s929ms 585ms 00 1 1s215ms 1s215ms 01 2 806ms 403ms 02 3 1s397ms 465ms 03 1 2s611ms 2s611ms 04 44 1m5s 1s478ms 05 12 21s964ms 1s830ms 06 7 6s80ms 868ms 08 4 2s473ms 618ms 09 2 890ms 445ms 11 1 331ms 331ms 12 1 1s12ms 1s12ms 13 2 1s40ms 520ms 15 1 768ms 768ms 17 1 450ms 450ms 19 6 5s647ms 941ms 20 2 5s159ms 2s579ms [ User: lfriedman - Total duration: 1m59s - Times executed: 95 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-test10' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-06 05:18:14 Duration: 16s750ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-win764-test20' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-06 05:18:14 Duration: 9s931ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-win32-test17' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-06 05:18:12 Duration: 8s200ms Database: nightly User: lfriedman
14 1m44s 140 304ms 9s988ms 745ms update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 06 23 1 643ms 643ms 00 1 414ms 414ms 02 1 914ms 914ms 04 7 4s389ms 627ms 05 17 11s429ms 672ms 06 12 6s954ms 579ms 07 6 2s799ms 466ms 08 56 57s804ms 1s32ms 09 18 7s925ms 440ms 10 3 1s296ms 432ms 11 8 3s807ms 475ms 12 2 806ms 403ms 13 1 559ms 559ms 15 1 426ms 426ms 18 2 1s60ms 530ms 19 2 1s521ms 760ms 22 2 1s563ms 781ms [ User: lfriedman - Total duration: 1m44s - Times executed: 140 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac64-test8'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test8';
Date: 2012-12-06 09:06:26 Duration: 9s988ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac64-test1'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test1';
Date: 2012-12-06 09:06:28 Duration: 5s987ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac64-test20'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test20';
Date: 2012-12-06 09:05:50 Duration: 2s67ms Database: nightly User: lfriedman
15 1m38s 143 301ms 3s412ms 686ms update gpu set daemon_update = now() where system = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 06 04 54 35s636ms 659ms 05 47 31s973ms 680ms 06 7 5s434ms 776ms 07 6 3s323ms 553ms 08 24 18s708ms 779ms 10 1 378ms 378ms 11 2 1s533ms 766ms 15 1 707ms 707ms 19 1 482ms 482ms [ User: lfriedman - Total duration: 1m38s - Times executed: 143 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac-cvs6';
Date: 2012-12-06 05:18:38 Duration: 3s412ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac64-cvs11';
Date: 2012-12-06 09:06:28 Duration: 3s264ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac-cvs6';
Date: 2012-12-06 06:29:27 Duration: 2s368ms Database: nightly User: lfriedman
16 1m37s 3 303ms 1m19s 32s357ms select testname from filterout where script = ? and os = ? and arch = ? and build = ? and gpu = ? and branch = ? and vc = ? and last_update = ? and active = ? and category = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 06 04 3 1m37s 32s357ms [ User: lfriedman - Total duration: 1m37s - Times executed: 3 ]
-
SELECT testname FROM filterout WHERE script = 'thrust.sh' AND os = 'Darwin' AND arch = 'x86_64' AND build = 'release' AND gpu = '116' AND branch = 'cuda_a' AND vc = 'g' AND last_update = '2012-12-06' AND active = 't' and category = 1;
Date: 2012-12-06 05:18:53 Duration: 1m19s Database: nightly User: lfriedman
-
SELECT testname FROM filterout WHERE script = 'thrust.sh' AND os = 'Linux' AND arch = 'x86_64' AND build = 'release' AND gpu = '200' AND branch = 'cuda_a' AND vc = 'i' AND last_update = '2012-12-06' AND active = 't' and category = 1;
Date: 2012-12-06 05:07:26 Duration: 17s450ms Database: nightly User: lfriedman
-
SELECT testname FROM filterout WHERE script = 'thrust.sh' AND os = 'Darwin' AND arch = 'x86_64' AND build = 'release' AND gpu = '307' AND branch = 'cuda_a' AND vc = 'g' AND last_update = '2012-12-06' AND active = 't' and category = 1;
Date: 2012-12-06 05:25:08 Duration: 303ms Database: nightly User: lfriedman
17 1m36s 105 300ms 10s375ms 914ms update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 06 01 1 300ms 300ms 04 14 9s419ms 672ms 05 25 14s594ms 583ms 06 7 5s699ms 814ms 07 6 4s543ms 757ms 08 29 47s201ms 1s627ms 09 8 5s250ms 656ms 10 2 784ms 392ms 11 8 4s788ms 598ms 13 1 646ms 646ms 19 4 2s846ms 711ms [ User: lfriedman - Total duration: 1m36s - Times executed: 105 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test1'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test1';
Date: 2012-12-06 09:06:28 Duration: 10s375ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win764-test50'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win764-test50';
Date: 2012-12-06 09:06:26 Duration: 9s994ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test24'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test24';
Date: 2012-12-06 09:06:28 Duration: 5s4ms Database: nightly User: lfriedman
18 1m24s 72 311ms 9s412ms 1s179ms delete from cuhc where system = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 06 01 1 339ms 339ms 04 51 1m13s 1s441ms 05 5 2s670ms 534ms 06 5 3s434ms 686ms 07 1 348ms 348ms 08 4 1s903ms 475ms 12 1 643ms 643ms 19 4 2s52ms 513ms [ User: lfriedman - Total duration: 1m24s - Times executed: 72 ]
-
DELETE FROM cuhc WHERE system = 'cuda-mac64-test3';
Date: 2012-12-06 05:18:13 Duration: 9s412ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-mac64-test23';
Date: 2012-12-06 05:18:04 Duration: 6s502ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-mac-cvs4';
Date: 2012-12-06 05:18:28 Duration: 4s308ms Database: inventory User: lfriedman
19 1m13s 13 300ms 1m5s 5s626ms select count(id) from njsmoketests 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 #19
Day Hour Count Duration Avg duration Dec 06 05 4 1m8s 17s26ms 06 4 3s235ms 808ms 07 2 693ms 346ms 08 1 330ms 330ms 10 1 459ms 459ms 11 1 324ms 324ms [ User: lfriedman - Total duration: 1m13s - Times executed: 13 ]
-
SELECT count(id) FROM njsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win7-test28') AND os = 'WIN7' AND arch = 'i686' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-06 06:55:29 Duration: 1m5s Database: nightly User: lfriedman
-
SELECT count(id) FROM njsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac64-test7') AND os = 'Darwin' AND arch = 'x86_64' AND osversion = '10.8' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-06 07:26:56 Duration: 1s74ms Database: nightly User: lfriedman
-
SELECT count(id) FROM njsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux32-test10') AND os = 'Linux' AND arch = 'i686' AND osversion = '2.6.32-279.el6.i686' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-06 06:05:25 Duration: 948ms Database: nightly User: lfriedman
20 53s328ms 1 53s328ms 53s328ms 53s328ms select suiteid from cudasmoketests where last_update > ? group by suiteid order by suiteid;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 06 04 1 53s328ms 53s328ms [ User: lfriedman - Total duration: 53s328ms - Times executed: 1 ]
-
select suiteid from cudasmoketests where last_update > '2012-11-29T05:17:38' group by suiteid order by suiteid;
Date: 2012-12-06 05:18:39 Duration: 53s328ms Database: pvs User: lfriedman
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 3,353 1h37m34s 300ms 23s855ms 1s746ms 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 06 23 162 1m41s 628ms 00 90 59s592ms 662ms 01 66 32s413ms 491ms 02 43 20s911ms 486ms 03 45 54s347ms 1s207ms 04 1,384 1h14m42s 3s239ms 05 221 2m41s 732ms 06 183 2m5s 688ms 07 67 33s419ms 498ms 08 216 1m33s 434ms 09 152 1m40s 662ms 10 7 3s577ms 511ms 11 50 24s543ms 490ms 12 164 1m26s 528ms 13 159 2m52s 1s81ms 15 15 7s93ms 472ms 17 8 4s488ms 561ms 18 29 15s543ms 535ms 19 219 3m16s 898ms 20 73 1m16s 1s44ms [ User: lfriedman - Total duration: 1h37m34s - Times executed: 3353 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';
Date: 2012-12-06 05:18:15 Duration: 23s855ms 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-06 05:18:11 Duration: 21s68ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('canary') AND c.relpersistence = 'u';
Date: 2012-12-06 05:18:11 Duration: 19s886ms Database: nightly User: lfriedman
2 1,857 29m7s 300ms 10s997ms 940ms 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 06 23 11 8s468ms 769ms 00 2 777ms 388ms 01 4 2s468ms 617ms 04 679 11m35s 1s24ms 05 482 6m25s 799ms 06 145 1m42s 707ms 07 44 27s148ms 617ms 08 315 6m55s 1s317ms 09 52 23s432ms 450ms 10 18 7s76ms 393ms 11 58 40s244ms 693ms 12 10 5s874ms 587ms 13 13 11s255ms 865ms 15 1 326ms 326ms 18 2 839ms 419ms 19 11 8s471ms 770ms 20 5 9s974ms 1s994ms 22 5 2s598ms 519ms [ User: lfriedman - Total duration: 29m7s - Times executed: 1857 ]
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win764-test7';
Date: 2012-12-06 09:06:28 Duration: 10s997ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win7-gputest12';
Date: 2012-12-06 09:06:28 Duration: 10s881ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win864-test12';
Date: 2012-12-06 05:18:15 Duration: 10s794ms Database: nightly User: lfriedman
3 1,068 14m48s 318ms 3s354ms 831ms insert into proccheck (hostname, process, subtestid) values (?, ?, ?); delete from proccheck where age(now(), datestamp) > interval ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 06 23 2 1s627ms 813ms 00 6 4s876ms 812ms 01 2 1s613ms 806ms 03 236 3m8s 798ms 04 148 2m11s 887ms 05 54 51s689ms 957ms 06 70 57s280ms 818ms 07 104 1m26s 830ms 08 97 1m21s 835ms 09 120 1m37s 814ms 10 90 1m13s 814ms 11 9 7s289ms 809ms 12 5 4s34ms 806ms 13 4 3s747ms 936ms 17 6 4s901ms 816ms 18 30 24s282ms 809ms 19 5 4s28ms 805ms 20 48 38s688ms 806ms 21 1 823ms 823ms 22 31 25s222ms 813ms [ User: lfriedman - Total duration: 14m48s - Times executed: 1068 ]
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test96', '/home/lfriedman/cuda-stuff/sw/gpgpu/opencl/conformance_1.1/nvidia/tests/test_conformance/../../../../../bin/x86_64_Linux_release/conformance_test_image_streams use_pitches CL_FILTER_NEAREST CL_RGBA 2D NO_HOST_PTR', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-06 06:29:32 Duration: 3s354ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux32-test23', 'sh -c /home/lfriedman/cuda-stuff/sw/gpgpu/bin/i686_Linux_release/memcpy_sysdev > memcpy_sysdev.output', '177'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-06 05:42:06 Duration: 2s183ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test16', './TestNPP -q -f npp-filterlist -r', '76'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-06 05:20:07 Duration: 2s46ms Database: nightly User: lfriedman
4 988 17m22s 300ms 11s30ms 1s55ms update systems set daemon_update = now(), activated = ? where vm = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 06 23 1 456ms 456ms 00 1 469ms 469ms 02 2 951ms 475ms 03 5 2s311ms 462ms 04 477 8m32s 1s74ms 05 274 4m30s 986ms 06 41 34s551ms 842ms 07 24 21s29ms 876ms 08 107 2m42s 1s519ms 09 14 7s331ms 523ms 10 9 3s915ms 435ms 11 15 8s918ms 594ms 12 3 1s260ms 420ms 13 5 5s49ms 1s9ms 17 2 1s328ms 664ms 18 1 436ms 436ms 19 3 2s223ms 741ms 20 2 4s553ms 2s276ms 22 2 2s260ms 1s130ms [ User: lfriedman - Total duration: 17m22s - Times executed: 988 ]
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-win732-build20';
Date: 2012-12-06 09:06:28 Duration: 11s30ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-linux64-build0';
Date: 2012-12-06 09:06:28 Duration: 10s628ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-mac64-build8';
Date: 2012-12-06 09:06:28 Duration: 9s355ms Database: cbs User: lfriedman
5 828 13m48s 397ms 2m2s 1s 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 #5
Day Hour Count Duration Avg duration Dec 06 23 45 38s158ms 847ms 00 41 29s797ms 726ms 01 41 34s480ms 840ms 02 46 45s351ms 985ms 03 3 1s765ms 588ms 04 3 1s668ms 556ms 05 4 2s206ms 551ms 06 20 2m35s 7s776ms 07 27 22s219ms 822ms 08 30 29s39ms 967ms 09 37 37s275ms 1s7ms 10 45 35s79ms 779ms 11 37 29s123ms 787ms 12 36 26s795ms 744ms 13 43 34s561ms 803ms 14 38 32s611ms 858ms 15 45 37s67ms 823ms 16 46 38s188ms 830ms 17 45 38s241ms 849ms 18 40 35s219ms 880ms 19 36 29s257ms 812ms 20 46 36s295ms 789ms 21 35 27s589ms 788ms 22 39 30s956ms 793ms [ User: lfriedman - Total duration: 13m48s - Times executed: 828 ]
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux64-test7') 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-06 07:03:53 Duration: 2m2s Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac-test6') 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-06 07:05:03 Duration: 14s979ms Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac-test10') 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-06 10:00:50 Duration: 3s256ms Database: nightly User: lfriedman
6 712 4m48s 300ms 4s333ms 404ms 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 #6
Day Hour Count Duration Avg duration Dec 06 23 23 8s838ms 384ms 00 49 18s734ms 382ms 01 34 13s306ms 391ms 02 53 21s32ms 396ms 03 3 1s114ms 371ms 04 3 1s179ms 393ms 05 4 3s17ms 754ms 06 13 9s917ms 762ms 07 28 11s144ms 398ms 08 29 11s477ms 395ms 09 29 14s649ms 505ms 10 36 14s197ms 394ms 11 44 17s699ms 402ms 12 22 8s839ms 401ms 13 32 12s605ms 393ms 14 29 11s388ms 392ms 15 42 16s41ms 381ms 16 36 14s139ms 392ms 17 33 12s975ms 393ms 18 40 16s35ms 400ms 19 31 11s459ms 369ms 20 31 12s175ms 392ms 21 30 11s184ms 372ms 22 38 14s896ms 392ms [ User: lfriedman - Total duration: 4m48s - Times executed: 712 ]
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac64-test8') AND os = 'Darwin' AND arch = 'x86_64' AND osversion = '10.8' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-06 07:12:06 Duration: 4s333ms Database: nightly User: lfriedman
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux64-test34') AND os = 'Linux' AND arch = 'x86_64' AND osversion = '2.6.18-308.el5' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-06 10:54:07 Duration: 3s359ms Database: nightly User: lfriedman
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win764-test38') 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-06 06:31:28 Duration: 1s198ms Database: nightly User: lfriedman
7 550 8m18s 300ms 10s743ms 906ms update gpu set dd_date = ?, last_update = (date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 06 02 1 398ms 398ms 03 1 693ms 693ms 04 241 3m32s 883ms 05 158 2m8s 814ms 06 31 18s937ms 610ms 07 14 10s98ms 721ms 08 73 1m46s 1s461ms 09 13 6s462ms 497ms 10 3 1s478ms 492ms 11 10 8s403ms 840ms 12 1 372ms 372ms 17 1 333ms 333ms 19 1 2s149ms 2s149ms 22 2 953ms 476ms [ User: lfriedman - Total duration: 8m18s - Times executed: 550 ]
-
UPDATE gpu SET dd_date = 'Thu Dec 6 00:27:45 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux64-cvs22';
Date: 2012-12-06 09:06:28 Duration: 10s743ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs4';
Date: 2012-12-06 09:06:28 Duration: 10s258ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs9';
Date: 2012-12-06 05:18:30 Duration: 9s721ms Database: nightly User: lfriedman
8 422 5m44s 302ms 10s728ms 816ms update gpu set daemon_update = now(), activated = ? where system = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 06 23 1 513ms 513ms 02 1 585ms 585ms 03 1 746ms 746ms 04 173 2m45s 954ms 05 127 1m40s 793ms 06 34 19s153ms 563ms 07 16 12s301ms 768ms 08 49 34s455ms 703ms 09 8 3s349ms 418ms 10 2 1s64ms 532ms 11 10 6s191ms 619ms [ User: lfriedman - Total duration: 5m44s - Times executed: 422 ]
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs24';
Date: 2012-12-06 05:18:15 Duration: 10s728ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs3';
Date: 2012-12-06 05:18:14 Duration: 9s422ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win7-cvs5';
Date: 2012-12-06 05:18:13 Duration: 8s457ms Database: nightly User: lfriedman
9 358 5m41s 303ms 9s839ms 955ms insert into regressspace (reftable, reftableid, cl, cldate, clowner) values (?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 06 04 189 3m49s 1s214ms 05 158 1m46s 672ms 06 10 5s671ms 567ms 08 1 371ms 371ms [ User: lfriedman - Total duration: 5m41s - Times executed: 358 ]
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('cublassmoketests', '28970731', '14523510', '2012/12/04', 'builder');
Date: 2012-12-06 05:18:14 Duration: 9s839ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('cublassmoketests', '28970731', '14524023', '2012/12/04', 'builder');
Date: 2012-12-06 05:18:29 Duration: 7s894ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('cublassmoketests', '28971536', '14536746', '2012/12/05', 'builder');
Date: 2012-12-06 05:18:11 Duration: 7s154ms Database: nightly User: lfriedman
10 172 5m19s 301ms 20s369ms 1s859ms 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 #10
Day Hour Count Duration Avg duration Dec 06 23 3 2s285ms 761ms 00 1 888ms 888ms 01 1 308ms 308ms 02 1 363ms 363ms 03 3 1s360ms 453ms 04 87 4m9s 2s863ms 05 9 9s79ms 1s8ms 06 7 4s894ms 699ms 07 1 347ms 347ms 08 2 1s53ms 526ms 09 8 3s989ms 498ms 11 1 471ms 471ms 12 5 3s6ms 601ms 13 41 41s495ms 1s12ms 17 1 539ms 539ms 18 1 521ms 521ms [ User: lfriedman - Total duration: 5m19s - Times executed: 172 ]
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('vipertests') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-06 05:18:39 Duration: 20s369ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('nvprof32on64') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-06 05:18:18 Duration: 18s710ms 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-06 05:18:18 Duration: 14s524ms Database: nightly User: lfriedman
11 143 1m38s 301ms 3s412ms 686ms update gpu set daemon_update = now() where system = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 06 04 54 35s636ms 659ms 05 47 31s973ms 680ms 06 7 5s434ms 776ms 07 6 3s323ms 553ms 08 24 18s708ms 779ms 10 1 378ms 378ms 11 2 1s533ms 766ms 15 1 707ms 707ms 19 1 482ms 482ms [ User: lfriedman - Total duration: 1m38s - Times executed: 143 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac-cvs6';
Date: 2012-12-06 05:18:38 Duration: 3s412ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac64-cvs11';
Date: 2012-12-06 09:06:28 Duration: 3s264ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac-cvs6';
Date: 2012-12-06 06:29:27 Duration: 2s368ms Database: nightly User: lfriedman
12 140 1m44s 304ms 9s988ms 745ms 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 06 23 1 643ms 643ms 00 1 414ms 414ms 02 1 914ms 914ms 04 7 4s389ms 627ms 05 17 11s429ms 672ms 06 12 6s954ms 579ms 07 6 2s799ms 466ms 08 56 57s804ms 1s32ms 09 18 7s925ms 440ms 10 3 1s296ms 432ms 11 8 3s807ms 475ms 12 2 806ms 403ms 13 1 559ms 559ms 15 1 426ms 426ms 18 2 1s60ms 530ms 19 2 1s521ms 760ms 22 2 1s563ms 781ms [ User: lfriedman - Total duration: 1m44s - Times executed: 140 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac64-test8'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test8';
Date: 2012-12-06 09:06:26 Duration: 9s988ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac64-test1'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test1';
Date: 2012-12-06 09:06:28 Duration: 5s987ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac64-test20'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test20';
Date: 2012-12-06 09:05:50 Duration: 2s67ms Database: nightly User: lfriedman
13 105 1m36s 300ms 10s375ms 914ms update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 06 01 1 300ms 300ms 04 14 9s419ms 672ms 05 25 14s594ms 583ms 06 7 5s699ms 814ms 07 6 4s543ms 757ms 08 29 47s201ms 1s627ms 09 8 5s250ms 656ms 10 2 784ms 392ms 11 8 4s788ms 598ms 13 1 646ms 646ms 19 4 2s846ms 711ms [ User: lfriedman - Total duration: 1m36s - Times executed: 105 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test1'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test1';
Date: 2012-12-06 09:06:28 Duration: 10s375ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win764-test50'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win764-test50';
Date: 2012-12-06 09:06:26 Duration: 9s994ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test24'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test24';
Date: 2012-12-06 09:06:28 Duration: 5s4ms Database: nightly User: lfriedman
14 95 1m59s 318ms 16s750ms 1s261ms 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 06 23 5 2s929ms 585ms 00 1 1s215ms 1s215ms 01 2 806ms 403ms 02 3 1s397ms 465ms 03 1 2s611ms 2s611ms 04 44 1m5s 1s478ms 05 12 21s964ms 1s830ms 06 7 6s80ms 868ms 08 4 2s473ms 618ms 09 2 890ms 445ms 11 1 331ms 331ms 12 1 1s12ms 1s12ms 13 2 1s40ms 520ms 15 1 768ms 768ms 17 1 450ms 450ms 19 6 5s647ms 941ms 20 2 5s159ms 2s579ms [ User: lfriedman - Total duration: 1m59s - Times executed: 95 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-test10' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-06 05:18:14 Duration: 16s750ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-win764-test20' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-06 05:18:14 Duration: 9s931ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-win32-test17' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-06 05:18:12 Duration: 8s200ms Database: nightly User: lfriedman
15 72 1m24s 311ms 9s412ms 1s179ms delete from cuhc where system = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 06 01 1 339ms 339ms 04 51 1m13s 1s441ms 05 5 2s670ms 534ms 06 5 3s434ms 686ms 07 1 348ms 348ms 08 4 1s903ms 475ms 12 1 643ms 643ms 19 4 2s52ms 513ms [ User: lfriedman - Total duration: 1m24s - Times executed: 72 ]
-
DELETE FROM cuhc WHERE system = 'cuda-mac64-test3';
Date: 2012-12-06 05:18:13 Duration: 9s412ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-mac64-test23';
Date: 2012-12-06 05:18:04 Duration: 6s502ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-mac-cvs4';
Date: 2012-12-06 05:18:28 Duration: 4s308ms Database: inventory User: lfriedman
16 56 40s223ms 302ms 2s744ms 718ms delete from tests where id = ? and active = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 06 04 37 23s944ms 647ms 05 15 11s406ms 760ms 06 1 2s120ms 2s120ms 08 3 2s752ms 917ms [ User: lfriedman - Total duration: 40s223ms - Times executed: 56 ]
-
DELETE FROM tests WHERE id = '2415746' AND active = 'cuda-linux64-test50';
Date: 2012-12-06 06:29:35 Duration: 2s744ms Database: nightly User: lfriedman
-
DELETE FROM tests WHERE id = '2417131' AND active = 'cuda-win864-test15';
Date: 2012-12-06 07:50:05 Duration: 2s120ms Database: nightly User: lfriedman
-
DELETE FROM tests WHERE id = '2417345' AND active = 'cuda-win764-test29';
Date: 2012-12-06 05:16:46 Duration: 1s652ms Database: nightly User: lfriedman
17 52 36s717ms 304ms 4s295ms 706ms 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 #17
Day Hour Count Duration Avg duration Dec 06 23 2 1s971ms 985ms 03 1 4s295ms 4s295ms 04 4 1s673ms 418ms 06 6 5s655ms 942ms 08 23 12s871ms 559ms 09 6 3s615ms 602ms 10 8 3s85ms 385ms 20 2 3s548ms 1s774ms [ User: lfriedman - Total duration: 36s717ms - Times executed: 52 ]
-
UPDATE disks SET update = date_trunc('second', now()), size = '490', used = '44' WHERE hostname = 'cuda-linux32-test49'; INSERT into disks (hostname, size, used, update) ( select 'cuda-linux32-test49', '490', '44', date_trunc('second', now()) WHERE NOT EXISTS ( select 1 FROM disks WHERE hostname = 'cuda-linux32-test49'));
Date: 2012-12-06 04:00:50 Duration: 4s295ms Database: inventory User: lfriedman
-
UPDATE disks SET update = date_trunc('second', now()), size = '490', used = '46' WHERE hostname = 'cuda-linux32-cvs2'; INSERT into disks (hostname, size, used, update) ( select 'cuda-linux32-cvs2', '490', '46', date_trunc('second', now()) WHERE NOT EXISTS ( select 1 FROM disks WHERE hostname = 'cuda-linux32-cvs2'));
Date: 2012-12-06 21:00:05 Duration: 2s787ms Database: inventory User: lfriedman
-
UPDATE disks SET update = date_trunc('second', now()), size = '602', used = '71' WHERE hostname = 'cuda-win64-test15'; INSERT into disks (hostname, size, used, update) ( select 'cuda-win64-test15', '602', '71', date_trunc('second', now()) WHERE NOT EXISTS ( select 1 FROM disks WHERE hostname = 'cuda-win64-test15'));
Date: 2012-12-06 07:02:04 Duration: 2s91ms Database: inventory User: lfriedman
18 51 46s459ms 322ms 20s485ms 910ms 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 #18
Day Hour Count Duration Avg duration Dec 06 03 11 4s11ms 364ms 04 10 27s34ms 2s703ms 05 9 6s515ms 723ms 06 6 2s300ms 383ms 07 4 1s536ms 384ms 08 3 1s544ms 514ms 09 1 332ms 332ms 10 2 826ms 413ms 11 3 1s648ms 549ms 16 2 708ms 354ms [ User: lfriedman - Total duration: 46s459ms - Times executed: 51 ]
-
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-06 05:18:39 Duration: 20s485ms 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-06 05:36:34 Duration: 2s90ms 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-06 06:25:30 Duration: 1s612ms Database: pvs User: lfriedman
19 47 34s46ms 305ms 2s137ms 724ms select testname, category, bug from filterout where os = ? and osversion = ? and arch = ? and gpu = ? and branch = ? and build = ? and vc = ? and script = ? and active = ? and last_update = ? and farm = ? order by testname;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 06 10 11 9s240ms 840ms 14 1 618ms 618ms 19 3 3s655ms 1s218ms 20 32 20s531ms 641ms [ User: lfriedman - Total duration: 34s46ms - Times executed: 47 ]
-
SELECT testname, category, bug FROM filterout WHERE os = 'Darwin' AND osversion = '10.7' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'npp-smoke.sh' AND active = 't' AND last_update = '2012-12-06' AND farm = '0' ORDER BY testname;
Date: 2012-12-06 11:00:49 Duration: 2s137ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.x86_64' AND arch = 'x86_64' AND gpu = '304' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'memcheck_sparse_cublas.sh' AND active = 't' AND last_update = '2012-12-06' AND farm = '0' ORDER BY testname;
Date: 2012-12-06 20:59:20 Duration: 1s674ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.x86_64' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'npp-smoke.sh' AND active = 't' AND last_update = '2012-12-06' AND farm = '0' ORDER BY testname;
Date: 2012-12-06 20:21:43 Duration: 1s561ms Database: nightly User: lfriedman Bind query: yes
20 44 1h8m20s 30s641ms 4m28s 1m33s 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 #20
Day Hour Count Duration Avg duration Dec 06 04 14 30m49s 2m12s 05 10 13m16s 1m19s 06 5 6m6s 1m13s 07 3 3m36s 1m12s 08 4 5m32s 1m23s 09 3 3m26s 1m8s 10 1 1m2s 1m2s 11 2 2m15s 1m7s 15 1 1m4s 1m4s 22 1 1m8s 1m8s [ User: lfriedman - Total duration: 1h8m20s - Times executed: 44 ]
-
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-06 05:20:11 Duration: 4m28s 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-06 05:20:19 Duration: 4m22s 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-06 05:20:21 Duration: 4m19s Database: nightly User: lfriedman
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 30s641ms 4m28s 1m33s 44 1h8m20s 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 06 04 14 30m49s 2m12s 05 10 13m16s 1m19s 06 5 6m6s 1m13s 07 3 3m36s 1m12s 08 4 5m32s 1m23s 09 3 3m26s 1m8s 10 1 1m2s 1m2s 11 2 2m15s 1m7s 15 1 1m4s 1m4s 22 1 1m8s 1m8s [ User: lfriedman - Total duration: 1h8m20s - Times executed: 44 ]
-
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-06 05:20:11 Duration: 4m28s 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-06 05:20:19 Duration: 4m22s 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-06 05:20:21 Duration: 4m19s Database: nightly User: lfriedman
2 45s765ms 1m28s 1m7s 2 2m14s select suiteid from nppsmoketests where last_update > ? group by suiteid order by suiteid;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 06 04 1 1m28s 1m28s 09 1 45s765ms 45s765ms [ User: lfriedman - Total duration: 2m14s - Times executed: 2 ]
-
select suiteid from nppsmoketests where last_update > '2012-11-29T05:38:15' group by suiteid order by suiteid;
Date: 2012-12-06 05:39:44 Duration: 1m28s Database: nightly User: lfriedman
-
select suiteid from nppsmoketests where last_update > '2012-11-29T10:47:30' group by suiteid order by suiteid;
Date: 2012-12-06 10:48:15 Duration: 45s765ms Database: pvs User: lfriedman
3 53s328ms 53s328ms 53s328ms 1 53s328ms select suiteid from cudasmoketests where last_update > ? group by suiteid order by suiteid;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 06 04 1 53s328ms 53s328ms [ User: lfriedman - Total duration: 53s328ms - Times executed: 1 ]
-
select suiteid from cudasmoketests where last_update > '2012-11-29T05:17:38' group by suiteid order by suiteid;
Date: 2012-12-06 05:18:39 Duration: 53s328ms Database: pvs User: lfriedman
4 303ms 1m19s 32s357ms 3 1m37s select testname from filterout where script = ? and os = ? and arch = ? and build = ? and gpu = ? and branch = ? and vc = ? and last_update = ? and active = ? and category = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 06 04 3 1m37s 32s357ms [ User: lfriedman - Total duration: 1m37s - Times executed: 3 ]
-
SELECT testname FROM filterout WHERE script = 'thrust.sh' AND os = 'Darwin' AND arch = 'x86_64' AND build = 'release' AND gpu = '116' AND branch = 'cuda_a' AND vc = 'g' AND last_update = '2012-12-06' AND active = 't' and category = 1;
Date: 2012-12-06 05:18:53 Duration: 1m19s Database: nightly User: lfriedman
-
SELECT testname FROM filterout WHERE script = 'thrust.sh' AND os = 'Linux' AND arch = 'x86_64' AND build = 'release' AND gpu = '200' AND branch = 'cuda_a' AND vc = 'i' AND last_update = '2012-12-06' AND active = 't' and category = 1;
Date: 2012-12-06 05:07:26 Duration: 17s450ms Database: nightly User: lfriedman
-
SELECT testname FROM filterout WHERE script = 'thrust.sh' AND os = 'Darwin' AND arch = 'x86_64' AND build = 'release' AND gpu = '307' AND branch = 'cuda_a' AND vc = 'g' AND last_update = '2012-12-06' AND active = 't' and category = 1;
Date: 2012-12-06 05:25:08 Duration: 303ms Database: nightly User: lfriedman
5 300ms 1m5s 5s626ms 13 1m13s select count(id) from njsmoketests 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 #5
Day Hour Count Duration Avg duration Dec 06 05 4 1m8s 17s26ms 06 4 3s235ms 808ms 07 2 693ms 346ms 08 1 330ms 330ms 10 1 459ms 459ms 11 1 324ms 324ms [ User: lfriedman - Total duration: 1m13s - Times executed: 13 ]
-
SELECT count(id) FROM njsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win7-test28') AND os = 'WIN7' AND arch = 'i686' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-06 06:55:29 Duration: 1m5s Database: nightly User: lfriedman
-
SELECT count(id) FROM njsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac64-test7') AND os = 'Darwin' AND arch = 'x86_64' AND osversion = '10.8' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-06 07:26:56 Duration: 1s74ms Database: nightly User: lfriedman
-
SELECT count(id) FROM njsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux32-test10') AND os = 'Linux' AND arch = 'i686' AND osversion = '2.6.32-279.el6.i686' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-06 06:05:25 Duration: 948ms Database: nightly User: lfriedman
6 301ms 20s369ms 1s859ms 172 5m19s 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 #6
Day Hour Count Duration Avg duration Dec 06 23 3 2s285ms 761ms 00 1 888ms 888ms 01 1 308ms 308ms 02 1 363ms 363ms 03 3 1s360ms 453ms 04 87 4m9s 2s863ms 05 9 9s79ms 1s8ms 06 7 4s894ms 699ms 07 1 347ms 347ms 08 2 1s53ms 526ms 09 8 3s989ms 498ms 11 1 471ms 471ms 12 5 3s6ms 601ms 13 41 41s495ms 1s12ms 17 1 539ms 539ms 18 1 521ms 521ms [ User: lfriedman - Total duration: 5m19s - Times executed: 172 ]
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('vipertests') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-06 05:18:39 Duration: 20s369ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('nvprof32on64') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-06 05:18:18 Duration: 18s710ms 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-06 05:18:18 Duration: 14s524ms Database: nightly User: lfriedman
7 300ms 23s855ms 1s746ms 3,353 1h37m34s select count(*) from pg_catalog.pg_class as c where c.oid = pgpool_regclass (?) and c.relpersistence = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 06 23 162 1m41s 628ms 00 90 59s592ms 662ms 01 66 32s413ms 491ms 02 43 20s911ms 486ms 03 45 54s347ms 1s207ms 04 1,384 1h14m42s 3s239ms 05 221 2m41s 732ms 06 183 2m5s 688ms 07 67 33s419ms 498ms 08 216 1m33s 434ms 09 152 1m40s 662ms 10 7 3s577ms 511ms 11 50 24s543ms 490ms 12 164 1m26s 528ms 13 159 2m52s 1s81ms 15 15 7s93ms 472ms 17 8 4s488ms 561ms 18 29 15s543ms 535ms 19 219 3m16s 898ms 20 73 1m16s 1s44ms [ User: lfriedman - Total duration: 1h37m34s - Times executed: 3353 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';
Date: 2012-12-06 05:18:15 Duration: 23s855ms 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-06 05:18:11 Duration: 21s68ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('canary') AND c.relpersistence = 'u';
Date: 2012-12-06 05:18:11 Duration: 19s886ms Database: nightly User: lfriedman
8 318ms 16s750ms 1s261ms 95 1m59s update gpu set daemon_update = now() where system = ? and age(now(), daemon_update) > interval ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 06 23 5 2s929ms 585ms 00 1 1s215ms 1s215ms 01 2 806ms 403ms 02 3 1s397ms 465ms 03 1 2s611ms 2s611ms 04 44 1m5s 1s478ms 05 12 21s964ms 1s830ms 06 7 6s80ms 868ms 08 4 2s473ms 618ms 09 2 890ms 445ms 11 1 331ms 331ms 12 1 1s12ms 1s12ms 13 2 1s40ms 520ms 15 1 768ms 768ms 17 1 450ms 450ms 19 6 5s647ms 941ms 20 2 5s159ms 2s579ms [ User: lfriedman - Total duration: 1m59s - Times executed: 95 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-test10' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-06 05:18:14 Duration: 16s750ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-win764-test20' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-06 05:18:14 Duration: 9s931ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-win32-test17' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-06 05:18:12 Duration: 8s200ms Database: nightly User: lfriedman
9 311ms 9s412ms 1s179ms 72 1m24s delete from cuhc where system = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 06 01 1 339ms 339ms 04 51 1m13s 1s441ms 05 5 2s670ms 534ms 06 5 3s434ms 686ms 07 1 348ms 348ms 08 4 1s903ms 475ms 12 1 643ms 643ms 19 4 2s52ms 513ms [ User: lfriedman - Total duration: 1m24s - Times executed: 72 ]
-
DELETE FROM cuhc WHERE system = 'cuda-mac64-test3';
Date: 2012-12-06 05:18:13 Duration: 9s412ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-mac64-test23';
Date: 2012-12-06 05:18:04 Duration: 6s502ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-mac-cvs4';
Date: 2012-12-06 05:18:28 Duration: 4s308ms Database: inventory User: lfriedman
10 300ms 11s30ms 1s55ms 988 17m22s update systems set daemon_update = now(), activated = ? where vm = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 06 23 1 456ms 456ms 00 1 469ms 469ms 02 2 951ms 475ms 03 5 2s311ms 462ms 04 477 8m32s 1s74ms 05 274 4m30s 986ms 06 41 34s551ms 842ms 07 24 21s29ms 876ms 08 107 2m42s 1s519ms 09 14 7s331ms 523ms 10 9 3s915ms 435ms 11 15 8s918ms 594ms 12 3 1s260ms 420ms 13 5 5s49ms 1s9ms 17 2 1s328ms 664ms 18 1 436ms 436ms 19 3 2s223ms 741ms 20 2 4s553ms 2s276ms 22 2 2s260ms 1s130ms [ User: lfriedman - Total duration: 17m22s - Times executed: 988 ]
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-win732-build20';
Date: 2012-12-06 09:06:28 Duration: 11s30ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-linux64-build0';
Date: 2012-12-06 09:06:28 Duration: 10s628ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-mac64-build8';
Date: 2012-12-06 09:06:28 Duration: 9s355ms Database: cbs User: lfriedman
11 397ms 2m2s 1s 828 13m48s 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 #11
Day Hour Count Duration Avg duration Dec 06 23 45 38s158ms 847ms 00 41 29s797ms 726ms 01 41 34s480ms 840ms 02 46 45s351ms 985ms 03 3 1s765ms 588ms 04 3 1s668ms 556ms 05 4 2s206ms 551ms 06 20 2m35s 7s776ms 07 27 22s219ms 822ms 08 30 29s39ms 967ms 09 37 37s275ms 1s7ms 10 45 35s79ms 779ms 11 37 29s123ms 787ms 12 36 26s795ms 744ms 13 43 34s561ms 803ms 14 38 32s611ms 858ms 15 45 37s67ms 823ms 16 46 38s188ms 830ms 17 45 38s241ms 849ms 18 40 35s219ms 880ms 19 36 29s257ms 812ms 20 46 36s295ms 789ms 21 35 27s589ms 788ms 22 39 30s956ms 793ms [ User: lfriedman - Total duration: 13m48s - Times executed: 828 ]
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux64-test7') 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-06 07:03:53 Duration: 2m2s Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac-test6') 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-06 07:05:03 Duration: 14s979ms Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac-test10') 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-06 10:00:50 Duration: 3s256ms Database: nightly User: lfriedman
12 303ms 9s839ms 955ms 358 5m41s insert into regressspace (reftable, reftableid, cl, cldate, clowner) values (?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 06 04 189 3m49s 1s214ms 05 158 1m46s 672ms 06 10 5s671ms 567ms 08 1 371ms 371ms [ User: lfriedman - Total duration: 5m41s - Times executed: 358 ]
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('cublassmoketests', '28970731', '14523510', '2012/12/04', 'builder');
Date: 2012-12-06 05:18:14 Duration: 9s839ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('cublassmoketests', '28970731', '14524023', '2012/12/04', 'builder');
Date: 2012-12-06 05:18:29 Duration: 7s894ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('cublassmoketests', '28971536', '14536746', '2012/12/05', 'builder');
Date: 2012-12-06 05:18:11 Duration: 7s154ms Database: nightly User: lfriedman
13 300ms 10s997ms 940ms 1,857 29m7s update gpu set dd_date = ?, last_update = ( select date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 06 23 11 8s468ms 769ms 00 2 777ms 388ms 01 4 2s468ms 617ms 04 679 11m35s 1s24ms 05 482 6m25s 799ms 06 145 1m42s 707ms 07 44 27s148ms 617ms 08 315 6m55s 1s317ms 09 52 23s432ms 450ms 10 18 7s76ms 393ms 11 58 40s244ms 693ms 12 10 5s874ms 587ms 13 13 11s255ms 865ms 15 1 326ms 326ms 18 2 839ms 419ms 19 11 8s471ms 770ms 20 5 9s974ms 1s994ms 22 5 2s598ms 519ms [ User: lfriedman - Total duration: 29m7s - Times executed: 1857 ]
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win764-test7';
Date: 2012-12-06 09:06:28 Duration: 10s997ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win7-gputest12';
Date: 2012-12-06 09:06:28 Duration: 10s881ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win864-test12';
Date: 2012-12-06 05:18:15 Duration: 10s794ms Database: nightly User: lfriedman
14 300ms 10s375ms 914ms 105 1m36s update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 06 01 1 300ms 300ms 04 14 9s419ms 672ms 05 25 14s594ms 583ms 06 7 5s699ms 814ms 07 6 4s543ms 757ms 08 29 47s201ms 1s627ms 09 8 5s250ms 656ms 10 2 784ms 392ms 11 8 4s788ms 598ms 13 1 646ms 646ms 19 4 2s846ms 711ms [ User: lfriedman - Total duration: 1m36s - Times executed: 105 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test1'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test1';
Date: 2012-12-06 09:06:28 Duration: 10s375ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win764-test50'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win764-test50';
Date: 2012-12-06 09:06:26 Duration: 9s994ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test24'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test24';
Date: 2012-12-06 09:06:28 Duration: 5s4ms Database: nightly User: lfriedman
15 322ms 20s485ms 910ms 51 46s459ms 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 #15
Day Hour Count Duration Avg duration Dec 06 03 11 4s11ms 364ms 04 10 27s34ms 2s703ms 05 9 6s515ms 723ms 06 6 2s300ms 383ms 07 4 1s536ms 384ms 08 3 1s544ms 514ms 09 1 332ms 332ms 10 2 826ms 413ms 11 3 1s648ms 549ms 16 2 708ms 354ms [ User: lfriedman - Total duration: 46s459ms - Times executed: 51 ]
-
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-06 05:18:39 Duration: 20s485ms 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-06 05:36:34 Duration: 2s90ms 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-06 06:25:30 Duration: 1s612ms Database: pvs User: lfriedman
16 300ms 10s743ms 906ms 550 8m18s update gpu set dd_date = ?, last_update = (date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 06 02 1 398ms 398ms 03 1 693ms 693ms 04 241 3m32s 883ms 05 158 2m8s 814ms 06 31 18s937ms 610ms 07 14 10s98ms 721ms 08 73 1m46s 1s461ms 09 13 6s462ms 497ms 10 3 1s478ms 492ms 11 10 8s403ms 840ms 12 1 372ms 372ms 17 1 333ms 333ms 19 1 2s149ms 2s149ms 22 2 953ms 476ms [ User: lfriedman - Total duration: 8m18s - Times executed: 550 ]
-
UPDATE gpu SET dd_date = 'Thu Dec 6 00:27:45 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux64-cvs22';
Date: 2012-12-06 09:06:28 Duration: 10s743ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs4';
Date: 2012-12-06 09:06:28 Duration: 10s258ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/02', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs9';
Date: 2012-12-06 05:18:30 Duration: 9s721ms Database: nightly User: lfriedman
17 318ms 3s354ms 831ms 1,068 14m48s insert into proccheck (hostname, process, subtestid) values (?, ?, ?); delete from proccheck where age(now(), datestamp) > interval ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 06 23 2 1s627ms 813ms 00 6 4s876ms 812ms 01 2 1s613ms 806ms 03 236 3m8s 798ms 04 148 2m11s 887ms 05 54 51s689ms 957ms 06 70 57s280ms 818ms 07 104 1m26s 830ms 08 97 1m21s 835ms 09 120 1m37s 814ms 10 90 1m13s 814ms 11 9 7s289ms 809ms 12 5 4s34ms 806ms 13 4 3s747ms 936ms 17 6 4s901ms 816ms 18 30 24s282ms 809ms 19 5 4s28ms 805ms 20 48 38s688ms 806ms 21 1 823ms 823ms 22 31 25s222ms 813ms [ User: lfriedman - Total duration: 14m48s - Times executed: 1068 ]
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test96', '/home/lfriedman/cuda-stuff/sw/gpgpu/opencl/conformance_1.1/nvidia/tests/test_conformance/../../../../../bin/x86_64_Linux_release/conformance_test_image_streams use_pitches CL_FILTER_NEAREST CL_RGBA 2D NO_HOST_PTR', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-06 06:29:32 Duration: 3s354ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux32-test23', 'sh -c /home/lfriedman/cuda-stuff/sw/gpgpu/bin/i686_Linux_release/memcpy_sysdev > memcpy_sysdev.output', '177'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-06 05:42:06 Duration: 2s183ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test16', './TestNPP -q -f npp-filterlist -r', '76'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-06 05:20:07 Duration: 2s46ms Database: nightly User: lfriedman
18 302ms 10s728ms 816ms 422 5m44s update gpu set daemon_update = now(), activated = ? where system = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 06 23 1 513ms 513ms 02 1 585ms 585ms 03 1 746ms 746ms 04 173 2m45s 954ms 05 127 1m40s 793ms 06 34 19s153ms 563ms 07 16 12s301ms 768ms 08 49 34s455ms 703ms 09 8 3s349ms 418ms 10 2 1s64ms 532ms 11 10 6s191ms 619ms [ User: lfriedman - Total duration: 5m44s - Times executed: 422 ]
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs24';
Date: 2012-12-06 05:18:15 Duration: 10s728ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs3';
Date: 2012-12-06 05:18:14 Duration: 9s422ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win7-cvs5';
Date: 2012-12-06 05:18:13 Duration: 8s457ms Database: nightly User: lfriedman
19 304ms 9s988ms 745ms 140 1m44s update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 06 23 1 643ms 643ms 00 1 414ms 414ms 02 1 914ms 914ms 04 7 4s389ms 627ms 05 17 11s429ms 672ms 06 12 6s954ms 579ms 07 6 2s799ms 466ms 08 56 57s804ms 1s32ms 09 18 7s925ms 440ms 10 3 1s296ms 432ms 11 8 3s807ms 475ms 12 2 806ms 403ms 13 1 559ms 559ms 15 1 426ms 426ms 18 2 1s60ms 530ms 19 2 1s521ms 760ms 22 2 1s563ms 781ms [ User: lfriedman - Total duration: 1m44s - Times executed: 140 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac64-test8'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test8';
Date: 2012-12-06 09:06:26 Duration: 9s988ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac64-test1'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test1';
Date: 2012-12-06 09:06:28 Duration: 5s987ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac64-test20'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test20';
Date: 2012-12-06 09:05:50 Duration: 2s67ms Database: nightly User: lfriedman
20 305ms 2s137ms 724ms 47 34s46ms select testname, category, bug from filterout where os = ? and osversion = ? and arch = ? and gpu = ? and branch = ? and build = ? and vc = ? and script = ? and active = ? and last_update = ? and farm = ? order by testname;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 06 10 11 9s240ms 840ms 14 1 618ms 618ms 19 3 3s655ms 1s218ms 20 32 20s531ms 641ms [ User: lfriedman - Total duration: 34s46ms - Times executed: 47 ]
-
SELECT testname, category, bug FROM filterout WHERE os = 'Darwin' AND osversion = '10.7' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'npp-smoke.sh' AND active = 't' AND last_update = '2012-12-06' AND farm = '0' ORDER BY testname;
Date: 2012-12-06 11:00:49 Duration: 2s137ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.x86_64' AND arch = 'x86_64' AND gpu = '304' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'memcheck_sparse_cublas.sh' AND active = 't' AND last_update = '2012-12-06' AND farm = '0' ORDER BY testname;
Date: 2012-12-06 20:59:20 Duration: 1s674ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.x86_64' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'npp-smoke.sh' AND active = 't' AND last_update = '2012-12-06' AND farm = '0' ORDER BY testname;
Date: 2012-12-06 20:21:43 Duration: 1s561ms Database: nightly User: lfriedman Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 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 #1
Day Hour Count Duration Avg duration Dec 06 00 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
2 2s142ms 1 2s142ms 2s142ms 2s142ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmoke WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 23 1 2s142ms 2s142ms [ 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 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
3 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 #3
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
4 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 #4
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
5 1s558ms 1 1s558ms 1s558ms 1s558ms 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 #5
Day Hour Count Duration Avg duration 08 1 1s558ms 1s558ms [ 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 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
6 1s378ms 2 461ms 916ms 689ms 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 #6
Day Hour Count Duration Avg duration 23 1 916ms 916ms 08 1 461ms 461ms [ 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 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-06 10:01:22 Duration: 461ms Database: postgres User: pvs Remote: lfriedman
7 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 #7
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'
8 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 #8
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
9 898ms 1 898ms 898ms 898ms 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 #9
Day Hour Count Duration Avg duration 08 1 898ms 898ms [ User: lfriedman - Total duration: 10ms - Times executed: 1 ]
-
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
10 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 #10
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
11 758ms 1 758ms 758ms 758ms 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 #11
Day Hour Count Duration Avg duration 23 1 758ms 758ms [ User: lfriedman - Total duration: 0ms - Times executed: 1 ]
-
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
12 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 #12
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
13 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 #13
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
14 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 #14
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
15 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 #15
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
16 504ms 1 504ms 504ms 504ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM sparse_cublas WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 18 1 504ms 504ms [ 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 sparse_cublas 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 20:59:11 Duration: 504ms Database: postgres User: nightly Remote: lfriedman
17 496ms 1 496ms 496ms 496ms 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 #17
Day Hour Count Duration Avg duration 14 1 496ms 496ms [ User: lfriedman - Total duration: 0ms - Times executed: 1 ]
-
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
18 411ms 1 411ms 411ms 411ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM njcublas 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 411ms 411ms [ User: lfriedman - Total duration: 4ms - Times executed: 1 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM njcublas 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:37 Duration: 411ms Database: postgres User: pvs Remote: lfriedman
19 409ms 1 409ms 409ms 409ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM interop 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 22 1 409ms 409ms [ 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 interop 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 00:19:40 Duration: 409ms Database: postgres User: nightly Remote: lfriedman
20 329ms 1 329ms 329ms 329ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM cufftbigmem 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 #20
Day Hour Count Duration Avg duration 08 1 329ms 329ms [ 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 cufftbigmem 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:34 Duration: 329ms Database: postgres User: pvs Remote: lfriedman
-
pgBouncer
Request Throughput
Key values
- 3,362 queries/s Request Peak
- 2012-12-06 07:38:19 Date
Bytes I/O Throughput
Key values
- 5,150,593 Bytes/s In Bytes Peak
- 2012-12-06 07:16:19 Date
- 531,164 Bytes/s Out Bytes Peak
- 2012-12-06 15:41:19 Date
Queries Average duration
Key values
- 17ms Average Duration Peak
- 2012-12-06 13:15:19 Date
Established Connections
Key values
- 164 connections Connection Peak
- 2012-12-06 17:55:25 Date
Connections per database
Key values
- nightly Main Database
- 654,655 connections Total
Database User Count gasworks2 31 lfriedman 31 grinderman 2,005 lfriedman 2,005 intranet 11,499 lfriedman 11,499 intranet_test 1,022 lfriedman 1,022 jdb 25 lfriedman 25 lfriedman_test 408 lfriedman 408 nightly 633,881 lfriedman 633,881 optique_production 199 lfriedman 199 pgbouncer 409 dalibo 409 sterne_production 230 lfriedman 230 vangard_prod 1,089 lfriedman 1,089 webmail 3,857 lfriedman 3,857 Connections per user
Key values
- lfriedman Main User
- 654,655 connections Total
Connections per host
Key values
- 10.10.10.22.13 Main host with 629312 connections
- 654,655 Total connections
Simultaneous sessions
Key values
- 308 sessions Session Peak
- 2012-12-06 19:00:24 Date
Histogram of session times
Key values
- 608,228 0-500ms duration
Sessions per database
Key values
- nightly Main Database
- 656,384 sessions Total
Database User Count Total Duration Average Duration gasworks2 56 26m43s 28s625ms grinderman 2,005 1s 0ms intranet 11,566 1d5h9m39s 9s76ms intranet_test 1,021 11h20m32s 39s992ms jdb 48 24m23s 30s479ms lfriedman_test 408 0ms 0ms nightly 635,199 16d5h21m53s 2s206ms optique_production 200 1m 300ms pgbouncer 409 0ms 0ms sterne_production 453 3h46m14s 29s964ms vangard_prod 1,121 1d4h51m31s 1m32s webmail 3,898 17h59m29s 16s615ms Sessions per user
Key values
- lfriedman Main User
- 656,384 sessions Total
Sessions per host
Key values
- 10.10.10.22.13 Main Host
- 656,384 sessions Total
Most used reserved pools
Key values
- lfriedman@nightly Most used reserved pool
- 508 Time used
- 508 Total time reserved pools was used
Rank Times used Reserved pool 1 508 lfriedman@nightlyTimes Reported Most used reserved pools #1
Day Hour Count Dec 06 06 30 07 30 08 30 09 30 10 30 11 30 12 30 13 30 14 30 15 30 16 28 17 30 18 30 19 30 20 30 21 30 22 30 Most Frequent Errors/Events
Key values
- 508 Max number of times the same event was reported
- 508 Total events found
Rank Times reported Error 1 508 WARNING: Taking connection from reserve_poolTimes Reported Most Frequent Error / Event #1
Day Hour Count Dec 06 06 30 07 30 08 30 09 30 10 30 11 30 12 30 13 30 14 30 15 30 16 28 17 30 18 30 19 30 20 30 21 30 22 30 - WARNING: Taking connection from reserve_pool
- WARNING: Taking connection from reserve_pool
- WARNING: Taking connection from reserve_pool
Date: 2012-12-06 07:00:29 Database: nightly User: lfriedman Remote: 10.10.10.22.13
Date: 2012-12-06 07:00:29 Database: nightly User: lfriedman Remote: 10.10.10.22.13
Date: 2012-12-06 07:00:29 Database: nightly User: lfriedman Remote: 10.10.10.22.13
-
Events
Log levels
Key values
- 30,694,639 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 15 ERROR entries
- 1 WARNING entries
Most Frequent Errors/Events
Key values
- 8 Max number of times the same event was reported
- 16 Total events found
Rank Times reported Error 1 8 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 06 04 8 - ERROR: process 12718 still waiting for ExclusiveLock on extension of relation 485660 of database 16413 after 1000.101 ms
- ERROR: process 12952 still waiting for ExclusiveLock on extension of relation 485660 of database 16413 after 1000.120 ms
- ERROR: process 12718 still waiting for ExclusiveLock on extension of relation 485660 of database 16413 after 1000.097 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 57563: ""2012-12-06 05:15:28","Root/Functional/Image/AlphaComposition/ImageAlphaComp_AC4R_Tests/AlphaComp_8u..."
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-06 05:16:55 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 44347: ""2012-12-06 05:15:40","Root/Functional/Image/Arithmetic/ImageDiv_Round_C4R_Tests/Div_Round_Near_16s_..."
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-06 05:16:57 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 57874: ""2012-12-06 05:15:28","Root/Functional/Image/AlphaComposition/ImageAlphaPremulC_C1R_Tests/AlphaPremu..."
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-06 05:16:57 Database: nightly Application: User: lfriedman Remote:
2 6 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Dec 06 07 1 08 1 09 1 17 1 18 2 - ERROR: syntax error at or near "udpate" at character 1
- ERROR: syntax error at or near "select" at character 41
- ERROR: syntax error at or near "fromgpu" at character 10
Statement: udpate systems set active='t' where vm='cuda-mac64-build11' ;
Date: 2012-12-06 18:13:28 Database: cbs Application: User: lfriedman Remote:
Statement: select * from locations where hostname= select * from locations where hostname='cuda-linux64-test90';
Date: 2012-12-06 19:23:56 Database: inventory Application: User: lfriedman Remote:
Statement: select * fromgpu where canary='f';
Date: 2012-12-06 09:58:00 Database: nightly Application: User: lfriedman Remote:
3 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Dec 06 17 1 - ERROR: column "system" does not exist at character 82
Statement: update systems set active='f',comment='AP: turning off to assess capacity' where system='cuda-mac64-test0' ;
Date: 2012-12-06 18:15:41 Database: cbs Application: User: lfriedman Remote:
4 1 WARNING: pgstat wait timeout
Times Reported Most Frequent Error / Event #4
Day Hour Count Dec 06 08 1 - WARNING: pgstat wait timeout
Date: 2012-12-06 09:06:25
- 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