pgBadger-
Global information
- Generated on Tue May 17 09:17:50 2022
- Log file: /data/pglog/huge_log_test/pgbouncer.log.1, ..., /data/pglog/huge_log_test/postgresql-Tue.log
- Parsed 162,896,462 log entries in 14m45s
- Log start from 2012-12-06 00:00:00 to 2012-12-09 23:59:59
-
Overview
Global Stats
- 3,453 Number of unique normalized queries
- 40,994,798 Number of queries
- 4d21h19m51s Total query duration
- 2012-12-06 00:00:00 First query
- 2012-12-09 23:59:59 Last query
- 744 queries/s at 2012-12-07 02:02:02 Query peak
- 4d21h19m51s Total query duration
- 1s974ms Prepare/parse total duration
- 1m Bind total duration
- 4d21h18m49s Execute total duration
- 3,961 Number of events
- 6 Number of unique normalized events
- 3,930 Max number of times the same event was reported
- 0 Number of cancellation
- 70 Total number of automatic vacuums
- 108 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 6,808,774 Total number of sessions
- 80 sessions at 2012-12-06 05:18:33 Session peak
- 1194d22h26m37s Total duration of sessions
- 15s163ms Average duration of sessions
- 6 Average queries per session
- 62ms Average queries duration per session
- 15s101ms Average idle time per session
- 6,808,776 Total number of connections
- 266 connections/s at 2012-12-07 02:02:02 Connection peak
- 6 Total number of databases
SQL Traffic
Key values
- 744 queries/s Query Peak
- 2012-12-07 02:02:02 Date
SELECT Traffic
Key values
- 98 queries/s Query Peak
- 2012-12-07 05:33:25 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 72 queries/s Query Peak
- 2012-12-06 09:06:28 Date
Queries duration
Key values
- 4d21h19m51s 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 Dec 07 00 922,072 0ms 41s106ms 12ms 3m28s 3m31s 3m56s 01 905,558 0ms 1s757ms 11ms 3m16s 3m19s 3m30s 02 942,735 0ms 56s896ms 13ms 3m43s 4m5s 24m6s 03 988,647 0ms 1s760ms 13ms 4m43s 5m8s 5m15s 04 378,360 0ms 3s355ms 11ms 2m7s 3m1s 3m25s 05 286,447 0ms 3m46s 29ms 3m52s 8m42s 31m10s 06 335,553 0ms 4m6s 26ms 6m20s 12m11s 22m3s 07 529,065 0ms 2m38s 19ms 5m9s 5m47s 15m37s 08 637,734 0ms 2m11s 14ms 3m45s 5m53s 7m31s 09 768,156 0ms 1m16s 12ms 3m 3m45s 5m54s 10 849,464 0ms 1m27s 14ms 3m59s 4m17s 6m23s 11 874,876 0ms 1s773ms 12ms 3m7s 3m11s 3m27s 12 881,041 0ms 1m11s 12ms 3m17s 4m4s 5m6s 13 884,404 0ms 1s960ms 11ms 3m9s 3m11s 3m14s 14 322,633 0ms 1s753ms 11ms 2m57s 3m7s 3m14s 15 81,443 0ms 462ms 10ms 43s251ms 45s520ms 1m6s 16 108,381 0ms 797ms 10ms 56s272ms 58s339ms 1m 17 124,660 0ms 238ms 10ms 55s155ms 56s873ms 1m 18 120,542 0ms 820ms 5ms 23s363ms 34s834ms 58s748ms 19 123,359 0ms 184ms 3ms 20s279ms 26s295ms 44s707ms 20 128,255 0ms 2s102ms 3ms 18s695ms 31s505ms 35s13ms 21 137,780 0ms 103ms 3ms 18s2ms 29s502ms 37s888ms 22 148,728 0ms 117ms 2ms 20s172ms 36s28ms 39s157ms 23 173,454 0ms 114ms 3ms 28s761ms 31s699ms 41s691ms Dec 08 00 168,402 0ms 40s841ms 2ms 16s53ms 31s136ms 1m3s 01 180,904 0ms 3s20ms 2ms 14s26ms 32s865ms 48s785ms 02 187,450 0ms 102ms 1ms 14s139ms 29s33ms 32s773ms 03 197,609 0ms 101ms 1ms 14s403ms 29s879ms 36s18ms 04 207,838 0ms 101ms 1ms 14s558ms 30s56ms 36s550ms 05 214,571 0ms 111ms 1ms 14s910ms 31s305ms 35s711ms 06 216,098 0ms 121ms 1ms 14s733ms 24s967ms 43s541ms 07 217,873 0ms 4s543ms 1ms 14s519ms 35s175ms 38s149ms 08 220,227 0ms 583ms 1ms 14s524ms 27s468ms 41s241ms 09 218,055 0ms 938ms 1ms 14s955ms 31s662ms 34s569ms 10 217,777 0ms 102ms 1ms 14s421ms 26s940ms 30s336ms 11 218,436 0ms 248ms 1ms 14s594ms 27s312ms 30s46ms 12 222,356 0ms 794ms 1ms 14s748ms 28s872ms 44s547ms 13 217,762 0ms 112ms 1ms 13s687ms 26s817ms 33s73ms 14 217,832 0ms 100ms 1ms 14s344ms 28s704ms 31s661ms 15 219,920 0ms 446ms 1ms 14s318ms 27s890ms 39s381ms 16 217,308 0ms 101ms 1ms 13s915ms 23s667ms 28s731ms 17 218,902 0ms 951ms 1ms 16s249ms 34s769ms 39s736ms 18 220,504 0ms 767ms 1ms 13s72ms 28s443ms 32s775ms 19 217,747 0ms 107ms 1ms 13s742ms 18s373ms 29s590ms 20 217,177 0ms 101ms 1ms 14s379ms 27s366ms 32s273ms 21 219,995 0ms 3s603ms 1ms 14s295ms 23s133ms 27s990ms 22 218,289 0ms 105ms 1ms 15s771ms 25s260ms 33s727ms 23 234,387 0ms 967ms 2ms 21s88ms 28s434ms 42s283ms Dec 09 00 224,464 0ms 32s330ms 1ms 16s376ms 36s907ms 40s820ms 01 218,852 0ms 1s445ms 1ms 15s660ms 30s551ms 36s810ms 02 219,274 0ms 1s339ms 1ms 15s28ms 26s906ms 32s410ms 03 218,465 0ms 108ms 1ms 15s57ms 27s69ms 35s141ms 04 220,672 0ms 109ms 1ms 21s76ms 36s221ms 39s733ms 05 219,088 0ms 251ms 1ms 16s615ms 26s246ms 34s523ms 06 224,657 0ms 1s69ms 1ms 17s883ms 40s800ms 44s872ms 07 218,425 0ms 101ms 1ms 14s567ms 29s499ms 32s960ms 08 218,426 0ms 753ms 1ms 15s157ms 29s837ms 35s305ms 09 218,366 0ms 535ms 1ms 14s583ms 25s300ms 34s39ms 10 217,778 0ms 104ms 1ms 14s37ms 29s980ms 33s331ms 11 218,625 0ms 107ms 1ms 15s224ms 30s740ms 31s620ms 12 217,713 0ms 732ms 1ms 14s986ms 25s584ms 32s343ms 13 236,743 0ms 3s583ms 1ms 16s599ms 35s193ms 39s783ms 14 235,121 0ms 115ms 1ms 15s658ms 30s607ms 39s125ms 15 232,745 0ms 119ms 1ms 15s539ms 30s648ms 34s274ms 16 235,057 0ms 763ms 1ms 15s426ms 32s703ms 38s279ms 17 235,315 0ms 147ms 1ms 15s888ms 31s211ms 36s114ms 18 234,222 0ms 1s326ms 1ms 16s144ms 31s833ms 33s618ms 19 233,028 0ms 100ms 1ms 15s497ms 30s699ms 33s276ms 20 233,668 0ms 100ms 1ms 15s730ms 33s679ms 35s20ms 21 233,971 0ms 104ms 1ms 15s443ms 27s770ms 32s516ms 22 234,753 0ms 105ms 1ms 15s968ms 30s681ms 33s452ms 23 247,072 0ms 107ms 2ms 21s984ms 30s875ms 36s273ms 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 Dec 07 00 94 0 767ms 1s695ms 2s136ms 10s588ms 01 146 0 590ms 2s176ms 4s26ms 8s400ms 02 634 0 2s331ms 3s493ms 10s643ms 3m50s 03 86 0 679ms 2s28ms 2s831ms 3s436ms 04 13 0 1s77ms 0ms 1s1ms 2s384ms 05 1,330 0 1s815ms 3s151ms 27s54ms 13m35s 06 963 0 806ms 3s132ms 31s129ms 3m15s 07 322 0 661ms 6s600ms 8s414ms 13s431ms 08 482 0 555ms 3s732ms 9s405ms 41s202ms 09 297 0 756ms 1s364ms 2s105ms 33s787ms 10 73 0 864ms 1s720ms 2s522ms 3s173ms 11 89 0 633ms 1s717ms 2s537ms 3s892ms 12 428 0 688ms 2s530ms 9s904ms 54s14ms 13 61 0 790ms 1s737ms 2s350ms 3s420ms 14 29 0 590ms 483ms 1s75ms 2s154ms 15 1 0 462ms 0ms 0ms 0ms 16 3 0 354ms 0ms 0ms 305ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 10 0 652ms 0ms 0ms 2s590ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Dec 08 00 0 0 0ms 0ms 0ms 0ms 01 5 0 1s312ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 2 0 4s80ms 0ms 0ms 0ms 08 1 0 583ms 0ms 0ms 0ms 09 4 0 585ms 0ms 0ms 357ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 2 0 680ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 1 0 446ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 63 0 546ms 663ms 1s426ms 7s566ms 18 1 0 767ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 6 0 1s248ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 1 0 967ms 0ms 0ms 0ms Dec 09 00 2 0 570ms 0ms 0ms 440ms 01 1 0 1s445ms 0ms 0ms 0ms 02 4 0 601ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 7 0 577ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 19 0 514ms 337ms 639ms 1s252ms 09 5 0 432ms 0ms 0ms 535ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 11 0 526ms 0ms 0ms 1s419ms 13 2 0 2s101ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 3 0 601ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 4 0 598ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 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 Dec 07 00 1 1 1 1 10s868ms 0ms 0ms 795ms 01 2 8 4 1 568ms 0ms 0ms 1s20ms 02 0 120 1 0 1s339ms 0ms 328ms 2s21ms 03 24 0 0 1 792ms 0ms 802ms 1s628ms 04 251 0 0 13 782ms 2s426ms 6s422ms 11s974ms 05 132 1,434 61 94 1s619ms 21s392ms 1m27s 4m1s 06 328 2,152 47 62 1s581ms 33s91ms 1m36s 7m22s 07 50 2,542 19 56 1s230ms 28s814ms 1m21s 3m15s 08 55 1,033 10 27 1s36ms 3s727ms 14s257ms 2m10s 09 31 93 1 22 1s562ms 1s433ms 2s290ms 14s732ms 10 43 187 0 16 1s536ms 1s612ms 2s464ms 1m9s 11 19 0 0 6 723ms 0ms 453ms 1s630ms 12 2 61 2 5 1s679ms 0ms 809ms 7s22ms 13 0 0 0 2 345ms 0ms 0ms 0ms 14 0 0 0 3 396ms 0ms 0ms 328ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 4 0 0 3 623ms 0ms 0ms 421ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 4 0 0 1 782ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Dec 08 00 0 0 1 0 40s841ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 1 0 0 418ms 0ms 0ms 0ms 09 1 0 0 0 705ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 4 1 0 471ms 0ms 0ms 435ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 2 0 0 682ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Dec 09 00 0 0 1 0 32s330ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 1 713ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 2 0 1 479ms 0ms 0ms 345ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 1 718ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Dec 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% Dec 07 00 0 3 3.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 1 20 20.00 0.03% 07 0 0 0.00 0.00% 08 0 1 1.00 0.00% 09 0 26 26.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 14 14.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 10 10.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Dec 08 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 2 2.00 0.00% 08 1 0 0.00 50.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Dec 09 00 1 0 0.00 33.33% 01 0 1 1.00 0.00% 02 0 4 4.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 1 1.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 4 4.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Dec 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 Dec 07 00 194,869 54.13/s 01 192,356 53.43/s 02 205,311 57.03/s 03 205,475 57.08/s 04 62,092 17.25/s 05 46,561 12.93/s 06 51,599 14.33/s 07 110,626 30.73/s 08 132,129 36.70/s 09 157,066 43.63/s 10 171,138 47.54/s 11 184,797 51.33/s 12 175,268 48.69/s 13 177,802 49.39/s 14 58,427 16.23/s 15 11,147 3.10/s 16 16,497 4.58/s 17 21,217 5.89/s 18 13,482 3.75/s 19 8,668 2.41/s 20 8,637 2.40/s 21 8,801 2.44/s 22 8,873 2.46/s 23 9,163 2.55/s Dec 08 00 8,799 2.44/s 01 8,900 2.47/s 02 9,118 2.53/s 03 9,174 2.55/s 04 9,455 2.63/s 05 9,753 2.71/s 06 9,954 2.77/s 07 9,426 2.62/s 08 9,426 2.62/s 09 9,628 2.67/s 10 9,519 2.64/s 11 9,626 2.67/s 12 9,578 2.66/s 13 9,451 2.63/s 14 9,593 2.66/s 15 9,303 2.58/s 16 9,394 2.61/s 17 9,820 2.73/s 18 9,247 2.57/s 19 9,454 2.63/s 20 9,334 2.59/s 21 9,508 2.64/s 22 9,616 2.67/s 23 9,983 2.77/s Dec 09 00 9,705 2.70/s 01 9,706 2.70/s 02 9,613 2.67/s 03 9,683 2.69/s 04 9,779 2.72/s 05 9,826 2.73/s 06 9,957 2.77/s 07 9,557 2.65/s 08 9,588 2.66/s 09 9,810 2.73/s 10 9,543 2.65/s 11 9,523 2.65/s 12 9,634 2.68/s 13 22,225 6.17/s 14 23,709 6.59/s 15 23,617 6.56/s 16 23,314 6.48/s 17 23,887 6.64/s 18 23,265 6.46/s 19 23,135 6.43/s 20 22,842 6.34/s 21 22,921 6.37/s 22 23,016 6.39/s 23 23,121 6.42/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 Dec 07 00 194,869 5s546ms 5s489ms 01 192,356 5s610ms 5s553ms 02 205,311 5s258ms 5s195ms 03 205,476 5s245ms 5s178ms 04 62,091 17s218ms 17s150ms 05 46,561 23s166ms 22s982ms 06 51,599 21s49ms 20s878ms 07 110,628 9s811ms 9s718ms 08 132,127 8s168ms 8s99ms 09 157,066 6s871ms 6s810ms 10 171,138 6s305ms 6s233ms 11 184,797 5s834ms 5s777ms 12 175,269 6s160ms 6s98ms 13 177,801 6s74ms 6s14ms 14 58,497 16s499ms 16s436ms 15 11,079 1m28s 1m28s 16 16,504 1m4s 1m4s 17 21,211 50s68ms 50s9ms 18 13,488 1m16s 1m16s 19 8,662 2m1s 2m1s 20 8,640 2m3s 2m3s 21 8,796 2m 2m 22 8,872 2m2s 2m2s 23 9,165 1m57s 1m57s Dec 08 00 8,797 2m 2m 01 8,900 2m1s 2m1s 02 9,118 1m58s 1m58s 03 9,174 1m57s 1m57s 04 9,455 1m54s 1m54s 05 9,753 1m51s 1m51s 06 9,954 1m50s 1m50s 07 9,426 1m51s 1m51s 08 9,426 1m54s 1m54s 09 9,628 1m52s 1m52s 10 9,519 1m53s 1m53s 11 9,626 1m52s 1m52s 12 9,578 1m52s 1m52s 13 9,451 1m54s 1m54s 14 9,593 1m52s 1m52s 15 9,303 1m55s 1m55s 16 9,394 1m54s 1m54s 17 9,820 1m49s 1m49s 18 9,247 1m56s 1m56s 19 9,454 1m54s 1m54s 20 9,334 1m56s 1m56s 21 9,508 1m52s 1m52s 22 9,616 1m51s 1m51s 23 9,983 1m48s 1m48s Dec 09 00 9,704 1m50s 1m50s 01 9,706 1m51s 1m51s 02 9,613 1m52s 1m52s 03 9,683 1m50s 1m50s 04 9,779 1m51s 1m51s 05 9,826 1m49s 1m49s 06 9,957 1m50s 1m50s 07 9,557 1m49s 1m49s 08 9,589 1m53s 1m53s 09 9,809 1m50s 1m50s 10 9,543 1m52s 1m52s 11 9,523 1m53s 1m53s 12 9,634 1m52s 1m52s 13 22,225 49s897ms 49s878ms 14 23,709 45s483ms 45s465ms 15 23,617 45s802ms 45s785ms 16 23,315 46s197ms 46s180ms 17 23,886 45s275ms 45s256ms 18 23,265 46s356ms 46s337ms 19 23,135 46s670ms 46s653ms 20 22,842 47s417ms 47s400ms 21 22,921 47s93ms 47s76ms 22 23,017 46s837ms 46s818ms 23 23,120 46s662ms 46s639ms -
Connections
Established Connections
Key values
- 266 connections Connection Peak
- 2012-12-07 02:02:02 Date
Connections per database
Key values
- nightly Main Database
- 6,808,776 connections Total
Connections per user
Key values
- lfriedman Main User
- 6,808,776 connections Total
-
Sessions
Simultaneous sessions
Key values
- 80 sessions Session Peak
- 2012-12-06 05:18:33 Date
Histogram of session times
Key values
- 4,165,693 1000-30000ms duration
Sessions per database
Key values
- nightly Main Database
- 6,808,774 sessions Total
Sessions per user
Key values
- lfriedman Main User
- 6,808,774 sessions Total
Sessions per host
Key values
- 10.31.96.124 Main Host
- 6,808,774 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 182,507 buffers Checkpoint Peak
- 2012-12-07 06:24:34 Date
- 210.072 seconds Highest write time
- 153.739 seconds Sync time
Checkpoints Wal files
Key values
- 115 files Wal files usage Peak
- 2012-12-07 05:50:58 Date
Checkpoints distance
Key values
- 0.00 Mo Distance Peak
- 2012-12-09 09:33:32 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 Dec 07 00 74,555 2,406.294s 0.413s 2,406.77s 01 20,961 2,063.76s 0.178s 2,063.994s 02 22,195 2,093.686s 0.104s 2,093.848s 03 21,316 2,116.301s 0.102s 2,116.454s 04 47,433 2,299.988s 0.58s 2,300.619s 05 1,338,294 2,571.408s 305.761s 2,877.4s 06 1,286,860 2,278.729s 287.058s 2,566.084s 07 1,219,145 2,551.646s 241.282s 2,793.739s 08 693,279 2,227.931s 132.918s 2,360.936s 09 366,456 2,428.615s 14.108s 2,442.803s 10 463,863 2,468.153s 12.607s 2,480.866s 11 33,262 2,457.584s 0.274s 2,457.915s 12 174,737 2,225.872s 2.732s 2,228.68s 13 22,747 2,225.218s 0.15s 2,225.436s 14 13,376 1,244.215s 0.14s 1,244.415s 15 3,035 303.536s 0.189s 303.781s 16 5,222 522.161s 0.187s 522.403s 17 3,290 328.902s 0.126s 329.079s 18 2,860 285.789s 0.135s 285.979s 19 2,108 210.939s 0.095s 211.091s 20 2,398 239.411s 0.087s 239.552s 21 1,611 161.002s 0.092s 161.146s 22 1,619 161.854s 0.09s 161.998s 23 1,723 172.261s 0.107s 172.423s Dec 08 00 52,573 334.335s 0.145s 334.536s 01 1,869 186.691s 0.1s 186.847s 02 1,500 149.768s 0.092s 149.916s 03 2,283 228.231s 0.111s 228.396s 04 1,965 196.373s 0.106s 196.534s 05 1,805 180.342s 0.108s 180.504s 06 1,740 173.927s 0.111s 174.089s 07 2,058 205.73s 0.114s 205.9s 08 1,776 177.659s 0.109s 177.823s 09 1,702 170.255s 0.106s 170.412s 10 1,735 173.258s 0.108s 173.419s 11 1,784 178.24s 0.107s 178.402s 12 1,908 190.664s 0.108s 190.827s 13 1,789 178.74s 0.109s 178.9s 14 1,784 178.333s 0.109s 178.498s 15 2,085 208.498s 0.106s 208.655s 16 1,719 171.726s 0.105s 171.886s 17 1,774 177.328s 0.11s 177.493s 18 1,784 178.334s 0.11s 178.494s 19 1,794 179.372s 0.113s 179.539s 20 1,755 175.363s 0.108s 175.525s 21 1,742 174.049s 0.105s 174.21s 22 1,815 181.478s 0.109s 181.639s 23 2,006 200.307s 0.122s 200.485s Dec 09 00 53,399 355.011s 0.154s 355.219s 01 1,832 183.281s 0.101s 183.434s 02 2,532 253.023s 0.099s 253.173s 03 1,769 176.971s 0.109s 177.139s 04 1,813 181.278s 0.11s 181.442s 05 1,779 177.968s 0.111s 178.132s 06 2,676 267.737s 0.104s 267.897s 07 1,765 176.569s 0.105s 176.731s 08 1,797 179.77s 0.112s 179.938s 09 1,791 179.071s 0.108s 179.231s 10 1,743 174.358s 0.108s 174.519s 11 1,789 178.967s 0.107s 179.125s 12 2,419 241.684s 0.103s 241.836s 13 4,380 437.866s 0.119s 438.039s 14 4,658 465.715s 0.121s 465.888s 15 4,637 463.92s 0.117s 464.104s 16 4,620 461.422s 0.126s 461.6s 17 4,694 469.532s 0.121s 469.712s 18 5,399 539.881s 0.119s 540.05s 19 4,663 466.24s 0.142s 466.434s 20 4,621 461.913s 0.139s 462.105s 21 4,650 464.52s 0.131s 464.709s 22 4,670 467.236s 0.125s 467.416s 23 4,495 449.517s 0.125s 449.694s 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 Dec 07 00 0 0 81 3,852 0.026s 0s 01 0 0 59 2,372 0.008s 0s 02 0 0 58 1,071 0.003s 0s 03 0 0 59 764 0.003s 0s 04 0 0 55 12,289 0.007s 0s 05 0 0 642 17,498 31.633s 0.277s 06 0 0 586 13,744 24.497s 0.33s 07 0 0 607 11,501 22.186s 0.336s 08 0 0 289 11,595 22.709s 0.144s 09 0 0 171 9,028 3.071s 0.017s 10 0 0 229 6,135 3.763s 0.019s 11 0 0 59 4,267 0.002s 0s 12 0 0 113 4,381 2.218s 0.005s 13 0 0 59 2,730 0.007s 0s 14 0 0 60 1,447 0.002s 0s 15 0 0 60 1,030 0.002s 0s 16 0 0 59 1,350 0.007s 0s 17 0 0 59 654 0.002s 0s 18 0 0 59 548 0.009s 0s 19 0 0 59 521 0.001s 0s 20 0 0 58 410 0.003s 0s 21 0 0 59 441 0.004s 0s 22 0 0 59 442 0.001s 0s 23 0 0 59 478 0.001s 0s Dec 08 00 0 0 80 471 0.029s 0s 01 0 0 59 513 0.001s 0s 02 0 0 59 429 0.001s 0s 03 0 0 59 490 0.005s 0s 04 0 0 59 507 0.002s 0s 05 0 0 59 489 0.002s 0s 06 0 0 59 499 0.002s 0s 07 0 0 59 587 0.001s 0s 08 0 0 59 502 0.001s 0s 09 0 0 59 481 0.001s 0s 10 0 0 59 487 0.001s 0s 11 0 0 59 489 0.001s 0s 12 0 0 59 521 0.001s 0s 13 0 0 59 493 0.001s 0s 14 0 0 59 497 0.001s 0s 15 0 0 59 534 0.002s 0s 16 0 0 59 490 0.001s 0s 17 0 0 59 494 0.001s 0s 18 0 0 59 492 0.001s 0s 19 0 0 59 492 0.008s 0s 20 0 0 59 486 0.002s 0s 21 0 0 58 490 0.001s 0s 22 0 0 59 499 0s 0s 23 0 0 60 549 0.002s 0s Dec 09 00 0 0 80 522 0.008s 0s 01 0 0 59 481 0s 0s 02 0 0 59 502 0.002s 0s 03 0 0 59 483 0.001s 0s 04 0 0 59 500 0.001s 0s 05 0 0 59 489 0.002s 0s 06 0 0 59 553 0.002s 0s 07 0 0 59 488 0.001s 0s 08 0 0 59 499 0.002s 0s 09 0 0 59 484 0.002s 0s 10 0 0 59 493 0.001s 0s 11 0 0 59 488 0.001s 0s 12 0 0 59 542 0.001s 0s 13 0 0 60 634 0.001s 0s 14 0 0 58 625 0.002s 0s 15 0 0 59 629 0.001s 0s 16 0 0 59 646 0.001s 0s 17 0 0 59 665 0.002s 0s 18 0 0 59 720 0.001s 0s 19 0 0 59 628 0.002s 0s 20 0 0 59 639 0.002s 0s 21 0 0 59 650 0.001s 0s 22 0 0 59 641 0.002s 0s 23 0 0 54 632 0.002s 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 Dec 07 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Dec 08 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Dec 09 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 Dec 07 00 0.00 kB 0.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 0.00 kB 04 0.00 kB 0.00 kB 05 0.00 kB 0.00 kB 06 0.00 kB 0.00 kB 07 0.00 kB 0.00 kB 08 0.00 kB 0.00 kB 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB 11 0.00 kB 0.00 kB 12 0.00 kB 0.00 kB 13 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 0.00 kB 0.00 kB 16 0.00 kB 0.00 kB 17 0.00 kB 0.00 kB 18 0.00 kB 0.00 kB 19 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB 21 0.00 kB 0.00 kB 22 0.00 kB 0.00 kB 23 0.00 kB 0.00 kB Dec 08 00 0.00 kB 0.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 0.00 kB 04 0.00 kB 0.00 kB 05 0.00 kB 0.00 kB 06 0.00 kB 0.00 kB 07 0.00 kB 0.00 kB 08 0.00 kB 0.00 kB 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB 11 0.00 kB 0.00 kB 12 0.00 kB 0.00 kB 13 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 0.00 kB 0.00 kB 16 0.00 kB 0.00 kB 17 0.00 kB 0.00 kB 18 0.00 kB 0.00 kB 19 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB 21 0.00 kB 0.00 kB 22 0.00 kB 0.00 kB 23 0.00 kB 0.00 kB Dec 09 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 Dec 07 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Dec 08 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Dec 09 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 18.12 sec Highest CPU-cost vacuum
Table public.gpu
Database nightly - 2012-12-07 05:33:26 Date
- 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.cudasmoketests_2012_12 (4) Main table analyzed (database nightly)
- 108 analyzes Total
Table Number of analyzes nightly.public.cudasmoketests_2012_12 4 pvs.public.njsmoketests_2012_12 4 nightly.public.smoke32on64tests_2012_12 4 nightly.public.njsmoketests_2012_12 4 nightly.public.dblcublastests_2012_12 4 nightly.public.thrusttests_2012_12 4 nightly.public.nppsmoketests_2012_12 4 pvs.public.thrusttests_2012_12 4 pvs.public.cudasmoketests_2012_12 4 nightly.public.nvproftests_2012_12 4 nightly.public.mc_dblcublastests_2012_12 4 nightly.public.mathsmokesm2xtests_2012_12 4 nightly.public.cufftsmoketests_2012_12 4 nightly.public.curandtests_2012_12 4 pvs.public.nppsmoketests_2012_12 4 nightly.public.cublassmoketests_2012_12 4 nightly.public.sparse_cublastests_2012_12 4 nightly.public.dblamodeltests_2012_12 4 nightly.public.dblcuffttests_2012_12 3 nightly.public.mc_cusparsetests_2012_12 3 pvs.public.sparse_cublastests_2012_12 3 nightly.public.mc_cublastests_2012_12 3 pvs.public.cublassmoketests_2012_12 3 nightly.public.profsmokenewtests_2012_12 3 pvs.public.dblcublastests_2012_12 3 inventory.public.user_preferences 2 cbs.public.systems 2 pvs.public.dblamodeltests_2012_12 2 pvs.public.mc_dblcublastests_2012_12 1 nightly.public.interop32on64tests 1 nightly.public.debuggertests_2012_12 1 pvs.public.njdblcublastests_2012_12 1 nightly.public.samplestests_2012_12 1 nightly.public.gpu 1 pvs.public.cufftsmoketests_2012_12 1 nightly.public.oclconformance11tests_2012_12 1 pvs.public.dblcuffttests_2012_12 1 Total 108 Vacuums per table
Key values
- public.gpu (62) Main table vacuumed on database nightly
- 70 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes nightly.public.gpu 62 52 480,827 0 7,965 0 0 0 0 0 cbs.public.systems 5 2 10,569 0 111 0 0 0 0 0 nightly.pg_catalog.pg_statistic 1 1 5,289 0 1,794 0 0 0 0 0 nightly.public.cudasmoke_2012_12 1 1 876 0 159 0 0 0 0 0 inventory.public.user_preferences 1 1 11,283 0 1,976 0 0 0 0 0 Total 70 57 508,844 124,181 12,005 0 0 0 0 0 Tuples removed per table
Key values
- public.gpu (27646) Main table with removed tuples on database nightly
- 35585 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain nightly.public.gpu 62 52 27,646 106,377 0 0 223,510 inventory.public.user_preferences 1 1 4,131 45,933 0 0 3,067 nightly.pg_catalog.pg_statistic 1 1 3,567 31,992 0 0 2,951 cbs.public.systems 5 2 143 1,525 0 0 1,560 nightly.public.cudasmoke_2012_12 1 1 98 813 0 0 75 Total 70 57 35,585 186,640 0 0 231,163 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 Dec 07 00 0 0 01 0 0 02 1 0 03 0 0 04 0 2 05 3 13 06 1 7 07 1 8 08 3 5 09 1 4 10 0 5 11 0 0 12 0 3 13 0 1 14 0 1 15 0 0 16 0 2 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Dec 08 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Dec 09 00 0 0 01 0 1 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 1 0 - 18.12 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ExclusiveLock Main Lock Type
- 15 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 15 31s382ms 1s284ms 4s564ms 2s92ms 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 4s564ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:32:25 - Database: nightly - User: lfriedman ]
2 3s213ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:33:28 - Database: nightly - User: lfriedman ]
3 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 ]
4 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 ]
5 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 ]
6 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 ]
7 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 ]
8 1s912ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 06:17:24 - Database: nightly - User: lfriedman ]
9 1s681ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:32:06 - Database: nightly - User: lfriedman ]
10 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 ]
11 1s460ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:31:20 - Database: nightly - User: lfriedman ]
12 1s284ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:31:49 - Database: nightly - User: lfriedman ]
13 1s210ms COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 07:52:33 - Database: nightly - User: lfriedman ]
14 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 ]
15 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
- 10,578 Total read queries
- 18,905 Total write queries
Queries by database
Key values
- nightly Main database
- 28,860,112 Requests
- 4d16h43m5s (nightly)
- Main time consuming database
Database Request type Count Duration cbs Total 956,573 1h28m37s delete 1 517ms insert 1 607ms select 366 7m38s update 2,287 36m36s inventory Total 10,614,095 1h33m27s copy from 11 8s124ms delete 170 2m59s insert 17 15s454ms select 147 2m38s update 226 3m6s mbm Total 287,211 7m30s select 18 12s446ms update 6 4s554ms nightly Total 28,860,112 4d16h43m5s copy from 515 2h14m50s ddl 2,964 0ms delete 108 3m55s insert 2,436 35m14s select 9,910 3h42m26s tcl 2 1s345ms update 9,935 2h30m28s postgres Total 1,645 3s455ms select 1 330ms pvs Total 275,162 1h26m4s copy from 110 21m5s delete 11 7s362ms insert 39 34s631ms select 136 5m26s update 66 1m7s Queries by user
Key values
- lfriedman Main user
- 109,078,426 Requests
User Request type Count Duration lfriedman Total 109,078,426 13d15h33m7s copy from 1,620 6h32m57s ddl 5,928 0ms delete 691 15m36s insert 6,558 1h33m5s select 27,538 9h58m32s tcl 6 4s810ms update 32,232 8h1m10s postgres Total 4,193 8s517ms select 2 661ms Duration by user
Key values
- 13d15h33m7s (lfriedman) Main time consuming user
User Request type Count Duration lfriedman Total 109,078,426 13d15h33m7s copy from 1,620 6h32m57s ddl 5,928 0ms delete 691 15m36s insert 6,558 1h33m5s select 27,538 9h58m32s tcl 6 4s810ms update 32,232 8h1m10s postgres Total 4,193 8s517ms select 2 661ms Queries by host
Key values
- unknown Main host
- 109,082,619 Requests
- 13d15h33m16s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 40,994,798 Requests
- 4d21h18m49s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2012-12-08 15:41:36 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 26,099,054 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 4m6s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 06:20:48 - Database: nightly - User: lfriedman ]
5 4m5s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 06:20:53 - Database: nightly - User: lfriedman ]
6 4m5s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 06:20:10 - Database: nightly - User: lfriedman ]
7 3m46s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:33:45 - Database: nightly - User: lfriedman ]
8 3m40s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 06:21:04 - Database: nightly - User: lfriedman ]
9 3m36s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:34:02 - Database: nightly - User: lfriedman ]
10 2m38s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 07:38:14 - Database: nightly - User: lfriedman ]
11 2m36s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 06:17:29 - Database: nightly - User: lfriedman ]
12 2m23s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 05:03:25 - Database: nightly - User: lfriedman ]
13 2m19s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 07:52:51 - Database: nightly - User: lfriedman ]
14 2m11s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 08:37:24 - Database: nightly - User: lfriedman ]
15 2m11s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-07 07:53:28 - Database: nightly - User: lfriedman ]
16 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 ]
17 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 ]
18 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 ]
19 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 ]
20 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 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 3h2m47s 7,496 300ms 23s855ms 1s463ms 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 Dec 07 23 8 7s53ms 881ms 00 75 40s844ms 544ms 01 540 21m26s 2s383ms 04 1,272 38m15s 1s804ms 05 902 11m35s 770ms 06 252 2m19s 552ms 07 405 3m28s 513ms 08 213 2m18s 652ms 10 11 6s55ms 550ms 11 343 3m45s 657ms Dec 08 00 3 2s905ms 968ms 07 1 583ms 583ms 08 4 2s340ms 585ms 11 2 1s361ms 680ms 16 58 31s227ms 538ms 17 1 767ms 767ms 20 4 3s176ms 794ms 22 1 967ms 967ms Dec 09 23 2 1s141ms 570ms 05 7 4s41ms 577ms 07 19 9s774ms 514ms 08 5 2s163ms 432ms 11 11 5s794ms 526ms 12 1 620ms 620ms 15 3 1s805ms 601ms [ User: lfriedman - Total duration: 3h2m47s - Times executed: 7496 ]
-
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 2h27m31s 87 30s641ms 4m28s 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 ?;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 Dec 07 04 11 21m8s 1m55s 05 12 27m43s 2m18s 06 9 15m5s 1m40s 07 5 7m46s 1m33s 08 2 2m22s 1m11s 09 3 3m52s 1m17s 11 1 1m11s 1m11s [ User: lfriedman - Total duration: 2h27m31s - Times executed: 87 ]
-
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 1h8m2s 4,524 300ms 10s997ms 902ms 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 Dec 07 23 1 820ms 820ms 00 4 2s201ms 550ms 01 61 1m23s 1s376ms 04 380 5m7s 809ms 05 728 12m22s 1s20ms 06 982 15m1s 917ms 07 360 3m32s 589ms 08 40 22s535ms 563ms 09 75 39s352ms 524ms 11 35 22s689ms 648ms Dec 08 16 1 341ms 341ms [ User: lfriedman - Total duration: 1h8m2s - Times executed: 4524 ]
-
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 36m32s 2,282 300ms 11s30ms 960ms 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 Dec 07 01 14 21s250ms 1s517ms 04 293 4m48s 983ms 05 402 6m18s 940ms 06 385 5m35s 871ms 07 157 1m43s 657ms 08 14 7s21ms 501ms 09 25 13s899ms 555ms 11 4 3s105ms 776ms [ User: lfriedman - Total duration: 36m32s - Times executed: 2282 ]
-
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-win732-build12';
Date: 2012-12-07 07:52:28 Duration: 9s564ms Database: cbs User: lfriedman
5 26m54s 1,798 300ms 10s743ms 898ms update gpu set dd_date = ?, last_update = (date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 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 Dec 07 00 1 569ms 569ms 01 5 2s895ms 579ms 04 255 3m29s 820ms 05 387 6m18s 979ms 06 402 6m52s 1s24ms 07 154 1m29s 582ms 08 11 5s57ms 459ms 09 28 14s309ms 511ms 11 5 3s191ms 638ms [ User: lfriedman - Total duration: 26m54s - Times executed: 1798 ]
-
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/06', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs17';
Date: 2012-12-07 07:52:28 Duration: 9s896ms Database: nightly User: lfriedman
6 23m17s 1,640 318ms 15s37ms 852ms insert into proccheck (hostname, process, subtestid) values (?, ?, ?); delete from proccheck where age(now(), datestamp) > interval ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 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 Dec 07 23 1 795ms 795ms 00 2 1s615ms 807ms 02 24 19s416ms 809ms 03 251 3m20s 800ms 04 86 1m39s 1s154ms 05 38 42s396ms 1s115ms 06 29 25s892ms 892ms 07 41 37s363ms 911ms 08 29 23s346ms 805ms 09 42 35s254ms 839ms 10 19 15s373ms 809ms 11 2 1s616ms 808ms 15 4 3s186ms 796ms 17 4 3s204ms 801ms [ User: lfriedman - Total duration: 23m17s - Times executed: 1640 ]
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test35', '/usr/lib64/scim-1.0/scim-helper-manager', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 05:33:26 Duration: 15s37ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-win764-test29', 'cmd', '113'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 06:17:19 Duration: 7s32ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test35', '/usr/lib64/scim-1.0/scim-launcher -d -c simple -e all -f socket --no-stay', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 05:30:56 Duration: 3s430ms Database: nightly User: lfriedman
7 20m9s 1,234 397ms 2m2s 980ms 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 #7
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 Dec 07 23 44 48s447ms 1s101ms 00 35 30s840ms 881ms 01 35 30s910ms 883ms 02 54 45s714ms 846ms 03 4 4s490ms 1s122ms 04 1 646ms 646ms 05 2 1s109ms 554ms 06 24 30s77ms 1s253ms 07 23 23s640ms 1s27ms 08 19 17s134ms 901ms 09 34 32s233ms 948ms 10 48 37s172ms 774ms 11 30 27s919ms 930ms 12 36 38s212ms 1s61ms 13 15 11s872ms 791ms 14 1 462ms 462ms 15 1 457ms 457ms [ User: lfriedman - Total duration: 20m9s - Times executed: 1234 ]
-
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-win764-test55') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '310' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 00:37:14 Duration: 13s184ms Database: nightly User: lfriedman
8 12m7s 951 302ms 10s728ms 764ms 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 Dec 07 01 2 755ms 377ms 04 123 1m33s 760ms 05 159 2m2s 767ms 06 157 1m55s 733ms 07 63 38s125ms 605ms 08 6 3s762ms 627ms 09 17 8s373ms 492ms 11 2 1s 500ms [ User: lfriedman - Total duration: 12m7s - Times executed: 951 ]
-
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 9m42s 783 300ms 9s209ms 744ms update gpu set daemon_update = now() where system = ?;Times Reported Time consuming queries #9
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 Dec 07 04 124 1m39s 805ms 05 191 2m47s 875ms 06 227 2m40s 707ms 07 82 47s804ms 582ms 08 5 2s370ms 474ms 09 7 4s316ms 616ms 11 4 2s405ms 601ms [ User: lfriedman - Total duration: 9m42s - Times executed: 783 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac64-cvs3';
Date: 2012-12-07 07:52:28 Duration: 9s209ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-cvs21';
Date: 2012-12-07 06:19:49 Duration: 7s645ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-cvs0';
Date: 2012-12-07 06:19:49 Duration: 7s643ms Database: nightly User: lfriedman
10 9m7s 632 300ms 9s839ms 866ms insert into regressspace (reftable, reftableid, cl, cldate, clowner) values (?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 06 04 189 3m49s 1s214ms 05 158 1m46s 672ms 06 10 5s671ms 567ms 08 1 371ms 371ms Dec 07 04 14 11s20ms 787ms 05 260 3m14s 748ms [ User: lfriedman - Total duration: 9m7s - Times executed: 632 ]
-
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 ('nvprof32on64tests', '342824', '14523179', '2012/12/04', 'builder');
Date: 2012-12-07 06:19:47 Duration: 7s464ms Database: nightly User: lfriedman
11 7m34s 257 301ms 20s369ms 1s769ms 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 #11
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 Dec 07 01 2 1s 500ms 04 37 1m28s 2s378ms 05 41 42s559ms 1s38ms 06 1 432ms 432ms 07 2 1s197ms 598ms 11 2 1s775ms 887ms [ User: lfriedman - Total duration: 7m34s - Times executed: 257 ]
-
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
12 7m1s 1,050 300ms 4s333ms 401ms 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 #12
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 Dec 07 23 39 15s293ms 392ms 00 34 13s286ms 390ms 01 36 13s370ms 371ms 02 32 12s701ms 396ms 03 3 1s123ms 374ms 05 4 1s391ms 347ms 06 18 7s732ms 429ms 07 21 8s639ms 411ms 08 27 11s243ms 416ms 09 30 11s851ms 395ms 10 26 10s106ms 388ms 11 28 11s240ms 401ms 12 24 9s582ms 399ms 13 14 5s256ms 375ms 15 2 607ms 303ms [ User: lfriedman - Total duration: 7m1s - Times executed: 1050 ]
-
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
13 5m59s 440 300ms 9s988ms 816ms 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 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 Dec 07 01 12 20s406ms 1s700ms 04 5 2s531ms 506ms 05 17 16s972ms 998ms 06 140 2m18s 991ms 07 87 55s75ms 633ms 08 9 5s388ms 598ms 09 25 12s806ms 512ms 11 5 2s927ms 585ms [ User: lfriedman - Total duration: 5m59s - Times executed: 440 ]
-
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-test11'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test11';
Date: 2012-12-07 07:52:28 Duration: 9s519ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test13'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-linux32-test13';
Date: 2012-12-07 07:52:28 Duration: 7s501ms Database: nightly User: lfriedman
14 4m32s 281 300ms 10s375ms 970ms 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 Dec 07 01 5 9s114ms 1s822ms 04 16 13s266ms 829ms 05 34 41s477ms 1s219ms 06 82 1m25s 1s39ms 07 32 23s750ms 742ms 09 5 2s902ms 580ms 11 2 818ms 409ms [ User: lfriedman - Total duration: 4m32s - Times executed: 281 ]
-
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-test28'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test28';
Date: 2012-12-07 07:52:28 Duration: 7s945ms Database: nightly User: lfriedman
15 3m57s 232 302ms 16s750ms 1s21ms update gpu set daemon_update = now() where system = ? and age(now(), daemon_update) > interval ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 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 Dec 07 00 3 1s266ms 422ms 01 10 15s49ms 1s504ms 04 27 28s496ms 1s55ms 05 42 32s187ms 766ms 06 34 27s766ms 816ms 07 16 9s204ms 575ms 08 2 1s612ms 806ms 11 3 1s611ms 537ms [ User: lfriedman - Total duration: 3m57s - Times executed: 232 ]
-
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
16 2m38s 4 32s330ms 44s462ms 39s685ms delete from filterout where last_update = ?; insert into filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) select script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion from filterout where last_update = ( select max(last_update) from filterout where last_update != now()::date);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 06 23 1 44s462ms 44s462ms Dec 07 23 1 41s106ms 41s106ms Dec 08 23 1 40s841ms 40s841ms Dec 09 23 1 32s330ms 32s330ms [ User: lfriedman - Total duration: 2m38s - Times executed: 4 ]
-
DELETE FROM filterout WHERE last_update = '2012-12-06'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);
Date: 2012-12-06 00:00:45 Duration: 44s462ms Database: nightly User: lfriedman
-
DELETE FROM filterout WHERE last_update = '2012-12-07'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);
Date: 2012-12-07 00:00:42 Duration: 41s106ms Database: nightly User: lfriedman
-
DELETE FROM filterout WHERE last_update = '2012-12-08'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);
Date: 2012-12-08 00:00:42 Duration: 40s841ms Database: nightly User: lfriedman
17 2m33s 151 301ms 9s412ms 1s14ms delete from cuhc where system = ?;Times Reported Time consuming queries #17
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 Dec 07 00 4 2s562ms 640ms 04 36 39s738ms 1s103ms 05 21 15s945ms 759ms 06 12 5s915ms 492ms 07 3 1s953ms 651ms 08 1 734ms 734ms 11 2 1s493ms 746ms [ User: lfriedman - Total duration: 2m33s - Times executed: 151 ]
-
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
18 2m15s 200 309ms 3s391ms 678ms update gpu set daemon_update = now(), running = ? where system = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 06 00 1 922ms 922ms 01 1 468ms 468ms 02 1 379ms 379ms 03 1 320ms 320ms 04 15 11s930ms 795ms 05 8 4s893ms 611ms 06 1 696ms 696ms 07 1 1s818ms 1s818ms 08 4 2s48ms 512ms 09 3 1s341ms 447ms 13 2 1s907ms 953ms 22 1 829ms 829ms Dec 07 01 6 4s692ms 782ms 04 35 22s942ms 655ms 05 52 39s785ms 765ms 06 60 36s199ms 603ms 07 6 3s390ms 565ms 09 1 445ms 445ms 11 1 714ms 714ms [ User: lfriedman - Total duration: 2m15s - Times executed: 200 ]
-
UPDATE gpu SET daemon_update = now(), running = 'sparse_cublas.sh' WHERE system = 'cuda-win864-test13';
Date: 2012-12-06 05:19:07 Duration: 3s391ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test17';
Date: 2012-12-07 06:19:37 Duration: 3s333ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test20';
Date: 2012-12-07 06:19:34 Duration: 2s856ms Database: nightly User: lfriedman
19 2m14s 2 45s765ms 1m28s 1m7s select suiteid from nppsmoketests where last_update > ? group by suiteid order by suiteid;Times Reported Time consuming queries #19
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
20 1m37s 4 303ms 1m19s 24s370ms 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 #20
Day Hour Count Duration Avg duration Dec 06 04 3 1m37s 32s357ms Dec 07 03 1 411ms 411ms [ User: lfriedman - Total duration: 1m37s - Times executed: 4 ]
-
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 = '200' AND branch = 'cuda_a' AND vc = 'g' AND last_update = '2012-12-07' AND active = 't' and category = 1;
Date: 2012-12-07 04:16:18 Duration: 411ms Database: nightly User: lfriedman
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 7,496 3h2m47s 300ms 23s855ms 1s463ms 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 Dec 07 23 8 7s53ms 881ms 00 75 40s844ms 544ms 01 540 21m26s 2s383ms 04 1,272 38m15s 1s804ms 05 902 11m35s 770ms 06 252 2m19s 552ms 07 405 3m28s 513ms 08 213 2m18s 652ms 10 11 6s55ms 550ms 11 343 3m45s 657ms Dec 08 00 3 2s905ms 968ms 07 1 583ms 583ms 08 4 2s340ms 585ms 11 2 1s361ms 680ms 16 58 31s227ms 538ms 17 1 767ms 767ms 20 4 3s176ms 794ms 22 1 967ms 967ms Dec 09 23 2 1s141ms 570ms 05 7 4s41ms 577ms 07 19 9s774ms 514ms 08 5 2s163ms 432ms 11 11 5s794ms 526ms 12 1 620ms 620ms 15 3 1s805ms 601ms [ User: lfriedman - Total duration: 3h2m47s - Times executed: 7496 ]
-
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 4,524 1h8m2s 300ms 10s997ms 902ms 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 Dec 07 23 1 820ms 820ms 00 4 2s201ms 550ms 01 61 1m23s 1s376ms 04 380 5m7s 809ms 05 728 12m22s 1s20ms 06 982 15m1s 917ms 07 360 3m32s 589ms 08 40 22s535ms 563ms 09 75 39s352ms 524ms 11 35 22s689ms 648ms Dec 08 16 1 341ms 341ms [ User: lfriedman - Total duration: 1h8m2s - Times executed: 4524 ]
-
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 2,282 36m32s 300ms 11s30ms 960ms update systems set daemon_update = now(), activated = ? where vm = ?;Times Reported Time consuming queries #3
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 Dec 07 01 14 21s250ms 1s517ms 04 293 4m48s 983ms 05 402 6m18s 940ms 06 385 5m35s 871ms 07 157 1m43s 657ms 08 14 7s21ms 501ms 09 25 13s899ms 555ms 11 4 3s105ms 776ms [ User: lfriedman - Total duration: 36m32s - Times executed: 2282 ]
-
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-win732-build12';
Date: 2012-12-07 07:52:28 Duration: 9s564ms Database: cbs User: lfriedman
4 1,798 26m54s 300ms 10s743ms 898ms update gpu set dd_date = ?, last_update = (date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 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 Dec 07 00 1 569ms 569ms 01 5 2s895ms 579ms 04 255 3m29s 820ms 05 387 6m18s 979ms 06 402 6m52s 1s24ms 07 154 1m29s 582ms 08 11 5s57ms 459ms 09 28 14s309ms 511ms 11 5 3s191ms 638ms [ User: lfriedman - Total duration: 26m54s - Times executed: 1798 ]
-
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/06', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs17';
Date: 2012-12-07 07:52:28 Duration: 9s896ms Database: nightly User: lfriedman
5 1,640 23m17s 318ms 15s37ms 852ms 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 Dec 07 23 1 795ms 795ms 00 2 1s615ms 807ms 02 24 19s416ms 809ms 03 251 3m20s 800ms 04 86 1m39s 1s154ms 05 38 42s396ms 1s115ms 06 29 25s892ms 892ms 07 41 37s363ms 911ms 08 29 23s346ms 805ms 09 42 35s254ms 839ms 10 19 15s373ms 809ms 11 2 1s616ms 808ms 15 4 3s186ms 796ms 17 4 3s204ms 801ms [ User: lfriedman - Total duration: 23m17s - Times executed: 1640 ]
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test35', '/usr/lib64/scim-1.0/scim-helper-manager', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 05:33:26 Duration: 15s37ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-win764-test29', 'cmd', '113'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 06:17:19 Duration: 7s32ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test35', '/usr/lib64/scim-1.0/scim-launcher -d -c simple -e all -f socket --no-stay', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 05:30:56 Duration: 3s430ms Database: nightly User: lfriedman
6 1,234 20m9s 397ms 2m2s 980ms 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 Dec 07 23 44 48s447ms 1s101ms 00 35 30s840ms 881ms 01 35 30s910ms 883ms 02 54 45s714ms 846ms 03 4 4s490ms 1s122ms 04 1 646ms 646ms 05 2 1s109ms 554ms 06 24 30s77ms 1s253ms 07 23 23s640ms 1s27ms 08 19 17s134ms 901ms 09 34 32s233ms 948ms 10 48 37s172ms 774ms 11 30 27s919ms 930ms 12 36 38s212ms 1s61ms 13 15 11s872ms 791ms 14 1 462ms 462ms 15 1 457ms 457ms [ User: lfriedman - Total duration: 20m9s - Times executed: 1234 ]
-
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-win764-test55') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '310' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 00:37:14 Duration: 13s184ms Database: nightly User: lfriedman
7 1,050 7m1s 300ms 4s333ms 401ms 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 #7
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 Dec 07 23 39 15s293ms 392ms 00 34 13s286ms 390ms 01 36 13s370ms 371ms 02 32 12s701ms 396ms 03 3 1s123ms 374ms 05 4 1s391ms 347ms 06 18 7s732ms 429ms 07 21 8s639ms 411ms 08 27 11s243ms 416ms 09 30 11s851ms 395ms 10 26 10s106ms 388ms 11 28 11s240ms 401ms 12 24 9s582ms 399ms 13 14 5s256ms 375ms 15 2 607ms 303ms [ User: lfriedman - Total duration: 7m1s - Times executed: 1050 ]
-
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
8 951 12m7s 302ms 10s728ms 764ms 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 Dec 07 01 2 755ms 377ms 04 123 1m33s 760ms 05 159 2m2s 767ms 06 157 1m55s 733ms 07 63 38s125ms 605ms 08 6 3s762ms 627ms 09 17 8s373ms 492ms 11 2 1s 500ms [ User: lfriedman - Total duration: 12m7s - Times executed: 951 ]
-
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 783 9m42s 300ms 9s209ms 744ms update gpu set daemon_update = now() where system = ?;Times Reported Time consuming queries #9
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 Dec 07 04 124 1m39s 805ms 05 191 2m47s 875ms 06 227 2m40s 707ms 07 82 47s804ms 582ms 08 5 2s370ms 474ms 09 7 4s316ms 616ms 11 4 2s405ms 601ms [ User: lfriedman - Total duration: 9m42s - Times executed: 783 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac64-cvs3';
Date: 2012-12-07 07:52:28 Duration: 9s209ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-cvs21';
Date: 2012-12-07 06:19:49 Duration: 7s645ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-cvs0';
Date: 2012-12-07 06:19:49 Duration: 7s643ms Database: nightly User: lfriedman
10 632 9m7s 300ms 9s839ms 866ms insert into regressspace (reftable, reftableid, cl, cldate, clowner) values (?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 06 04 189 3m49s 1s214ms 05 158 1m46s 672ms 06 10 5s671ms 567ms 08 1 371ms 371ms Dec 07 04 14 11s20ms 787ms 05 260 3m14s 748ms [ User: lfriedman - Total duration: 9m7s - Times executed: 632 ]
-
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 ('nvprof32on64tests', '342824', '14523179', '2012/12/04', 'builder');
Date: 2012-12-07 06:19:47 Duration: 7s464ms Database: nightly User: lfriedman
11 440 5m59s 300ms 9s988ms 816ms update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #11
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 Dec 07 01 12 20s406ms 1s700ms 04 5 2s531ms 506ms 05 17 16s972ms 998ms 06 140 2m18s 991ms 07 87 55s75ms 633ms 08 9 5s388ms 598ms 09 25 12s806ms 512ms 11 5 2s927ms 585ms [ User: lfriedman - Total duration: 5m59s - Times executed: 440 ]
-
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-test11'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test11';
Date: 2012-12-07 07:52:28 Duration: 9s519ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test13'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-linux32-test13';
Date: 2012-12-07 07:52:28 Duration: 7s501ms Database: nightly User: lfriedman
12 281 4m32s 300ms 10s375ms 970ms 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 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 Dec 07 01 5 9s114ms 1s822ms 04 16 13s266ms 829ms 05 34 41s477ms 1s219ms 06 82 1m25s 1s39ms 07 32 23s750ms 742ms 09 5 2s902ms 580ms 11 2 818ms 409ms [ User: lfriedman - Total duration: 4m32s - Times executed: 281 ]
-
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-test28'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test28';
Date: 2012-12-07 07:52:28 Duration: 7s945ms Database: nightly User: lfriedman
13 257 7m34s 301ms 20s369ms 1s769ms select count(*) from pg_class as c, pg_namespace as n where c.oid = pgpool_regclass (?) and c.relnamespace = n.oid and n.nspname = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 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 Dec 07 01 2 1s 500ms 04 37 1m28s 2s378ms 05 41 42s559ms 1s38ms 06 1 432ms 432ms 07 2 1s197ms 598ms 11 2 1s775ms 887ms [ User: lfriedman - Total duration: 7m34s - Times executed: 257 ]
-
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
14 232 3m57s 302ms 16s750ms 1s21ms 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 Dec 07 00 3 1s266ms 422ms 01 10 15s49ms 1s504ms 04 27 28s496ms 1s55ms 05 42 32s187ms 766ms 06 34 27s766ms 816ms 07 16 9s204ms 575ms 08 2 1s612ms 806ms 11 3 1s611ms 537ms [ User: lfriedman - Total duration: 3m57s - Times executed: 232 ]
-
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 200 2m15s 309ms 3s391ms 678ms update gpu set daemon_update = now(), running = ? where system = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 06 00 1 922ms 922ms 01 1 468ms 468ms 02 1 379ms 379ms 03 1 320ms 320ms 04 15 11s930ms 795ms 05 8 4s893ms 611ms 06 1 696ms 696ms 07 1 1s818ms 1s818ms 08 4 2s48ms 512ms 09 3 1s341ms 447ms 13 2 1s907ms 953ms 22 1 829ms 829ms Dec 07 01 6 4s692ms 782ms 04 35 22s942ms 655ms 05 52 39s785ms 765ms 06 60 36s199ms 603ms 07 6 3s390ms 565ms 09 1 445ms 445ms 11 1 714ms 714ms [ User: lfriedman - Total duration: 2m15s - Times executed: 200 ]
-
UPDATE gpu SET daemon_update = now(), running = 'sparse_cublas.sh' WHERE system = 'cuda-win864-test13';
Date: 2012-12-06 05:19:07 Duration: 3s391ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test17';
Date: 2012-12-07 06:19:37 Duration: 3s333ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test20';
Date: 2012-12-07 06:19:34 Duration: 2s856ms Database: nightly User: lfriedman
16 151 2m33s 301ms 9s412ms 1s14ms delete from cuhc where system = ?;Times Reported Time consuming queries #16
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 Dec 07 00 4 2s562ms 640ms 04 36 39s738ms 1s103ms 05 21 15s945ms 759ms 06 12 5s915ms 492ms 07 3 1s953ms 651ms 08 1 734ms 734ms 11 2 1s493ms 746ms [ User: lfriedman - Total duration: 2m33s - Times executed: 151 ]
-
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
17 112 1m22s 302ms 3s157ms 738ms delete from tests where id = ? and active = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 06 04 37 23s944ms 647ms 05 15 11s406ms 760ms 06 1 2s120ms 2s120ms 08 3 2s752ms 917ms Dec 07 04 23 14s383ms 625ms 05 22 18s815ms 855ms 06 5 4s216ms 843ms 07 6 5s66ms 844ms [ User: lfriedman - Total duration: 1m22s - Times executed: 112 ]
-
DELETE FROM tests WHERE id = '2418081' AND active = 'cuda-vista32-test1';
Date: 2012-12-07 06:19:34 Duration: 3s157ms Database: nightly User: lfriedman
-
DELETE FROM tests WHERE id = '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
18 99 1m19s 322ms 20s485ms 801ms 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 Dec 07 03 6 2s986ms 497ms 04 14 11s758ms 839ms 05 5 3s85ms 617ms 06 2 1s43ms 521ms 07 3 1s549ms 516ms 08 6 3s19ms 503ms 09 4 5s811ms 1s452ms 10 5 2s368ms 473ms 11 1 416ms 416ms 13 2 859ms 429ms [ User: lfriedman - Total duration: 1m19s - Times executed: 99 ]
-
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-07 10:06:19 Duration: 3s968ms Database: pvs User: lfriedman
-
COPY thrusttests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 05:35:21 Duration: 2s217ms Database: nightly User: lfriedman
19 98 1m2s 301ms 4s295ms 634ms 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 #19
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 Dec 07 01 2 1s801ms 900ms 04 6 3s175ms 529ms 07 38 20s508ms 539ms [ User: lfriedman - Total duration: 1m2s - Times executed: 98 ]
-
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
20 93 1m15s 300ms 4s849ms 807ms update tests set active = ? where id = ? and active is null;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 06 04 32 24s32ms 751ms 05 11 7s352ms 668ms Dec 07 04 14 9s377ms 669ms 05 19 18s251ms 960ms 06 8 12s71ms 1s508ms 07 8 3s653ms 456ms 08 1 339ms 339ms [ User: lfriedman - Total duration: 1m15s - Times executed: 93 ]
-
UPDATE tests SET active = 'cuda-linux-gputest16' WHERE id = '2419187' AND active IS NULL;
Date: 2012-12-07 07:37:52 Duration: 4s849ms Database: nightly User: lfriedman
-
UPDATE tests SET active = 'cuda-linux-gputest10' WHERE id = '2418304' AND active IS NULL;
Date: 2012-12-07 06:40:44 Duration: 4s786ms Database: nightly User: lfriedman
-
UPDATE tests SET active = 'cuda-vista32-test1' WHERE id = '2418291' AND active IS NULL;
Date: 2012-12-07 07:37:52 Duration: 3s365ms Database: nightly User: lfriedman
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 30s641ms 4m28s 1m41s 87 2h27m31s 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 Dec 07 04 11 21m8s 1m55s 05 12 27m43s 2m18s 06 9 15m5s 1m40s 07 5 7m46s 1m33s 08 2 2m22s 1m11s 09 3 3m52s 1m17s 11 1 1m11s 1m11s [ User: lfriedman - Total duration: 2h27m31s - Times executed: 87 ]
-
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 32s330ms 44s462ms 39s685ms 4 2m38s delete from filterout where last_update = ?; insert into filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) select script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion from filterout where last_update = ( select max(last_update) from filterout where last_update != now()::date);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 06 23 1 44s462ms 44s462ms Dec 07 23 1 41s106ms 41s106ms Dec 08 23 1 40s841ms 40s841ms Dec 09 23 1 32s330ms 32s330ms [ User: lfriedman - Total duration: 2m38s - Times executed: 4 ]
-
DELETE FROM filterout WHERE last_update = '2012-12-06'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);
Date: 2012-12-06 00:00:45 Duration: 44s462ms Database: nightly User: lfriedman
-
DELETE FROM filterout WHERE last_update = '2012-12-07'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);
Date: 2012-12-07 00:00:42 Duration: 41s106ms Database: nightly User: lfriedman
-
DELETE FROM filterout WHERE last_update = '2012-12-08'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);
Date: 2012-12-08 00:00:42 Duration: 40s841ms Database: nightly User: lfriedman
4 303ms 1m19s 24s370ms 4 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 Dec 07 03 1 411ms 411ms [ User: lfriedman - Total duration: 1m37s - Times executed: 4 ]
-
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 = '200' AND branch = 'cuda_a' AND vc = 'g' AND last_update = '2012-12-07' AND active = 't' and category = 1;
Date: 2012-12-07 04:16:18 Duration: 411ms Database: nightly User: lfriedman
5 301ms 20s369ms 1s769ms 257 7m34s select count(*) from pg_class as c, pg_namespace as n where c.oid = pgpool_regclass (?) and c.relnamespace = n.oid and n.nspname = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 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 Dec 07 01 2 1s 500ms 04 37 1m28s 2s378ms 05 41 42s559ms 1s38ms 06 1 432ms 432ms 07 2 1s197ms 598ms 11 2 1s775ms 887ms [ User: lfriedman - Total duration: 7m34s - Times executed: 257 ]
-
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
6 300ms 23s855ms 1s463ms 7,496 3h2m47s select count(*) from pg_catalog.pg_class as c where c.oid = pgpool_regclass (?) and c.relpersistence = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 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 Dec 07 23 8 7s53ms 881ms 00 75 40s844ms 544ms 01 540 21m26s 2s383ms 04 1,272 38m15s 1s804ms 05 902 11m35s 770ms 06 252 2m19s 552ms 07 405 3m28s 513ms 08 213 2m18s 652ms 10 11 6s55ms 550ms 11 343 3m45s 657ms Dec 08 00 3 2s905ms 968ms 07 1 583ms 583ms 08 4 2s340ms 585ms 11 2 1s361ms 680ms 16 58 31s227ms 538ms 17 1 767ms 767ms 20 4 3s176ms 794ms 22 1 967ms 967ms Dec 09 23 2 1s141ms 570ms 05 7 4s41ms 577ms 07 19 9s774ms 514ms 08 5 2s163ms 432ms 11 11 5s794ms 526ms 12 1 620ms 620ms 15 3 1s805ms 601ms [ User: lfriedman - Total duration: 3h2m47s - Times executed: 7496 ]
-
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
7 302ms 16s750ms 1s21ms 232 3m57s update gpu set daemon_update = now() where system = ? and age(now(), daemon_update) > interval ?;Times Reported Time consuming queries #7
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 Dec 07 00 3 1s266ms 422ms 01 10 15s49ms 1s504ms 04 27 28s496ms 1s55ms 05 42 32s187ms 766ms 06 34 27s766ms 816ms 07 16 9s204ms 575ms 08 2 1s612ms 806ms 11 3 1s611ms 537ms [ User: lfriedman - Total duration: 3m57s - Times executed: 232 ]
-
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
8 301ms 9s412ms 1s14ms 151 2m33s delete from cuhc where system = ?;Times Reported Time consuming queries #8
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 Dec 07 00 4 2s562ms 640ms 04 36 39s738ms 1s103ms 05 21 15s945ms 759ms 06 12 5s915ms 492ms 07 3 1s953ms 651ms 08 1 734ms 734ms 11 2 1s493ms 746ms [ User: lfriedman - Total duration: 2m33s - Times executed: 151 ]
-
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
9 397ms 2m2s 980ms 1,234 20m9s select count(id) from nppsmoketests where regressioncl = ? and current_status = ? and (active is null or active = ?) and os = ? and arch = ? and osversion = ? and branch = ? and (gpu = ? or gpu = ?) and age(now(), last_update) < interval ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 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 Dec 07 23 44 48s447ms 1s101ms 00 35 30s840ms 881ms 01 35 30s910ms 883ms 02 54 45s714ms 846ms 03 4 4s490ms 1s122ms 04 1 646ms 646ms 05 2 1s109ms 554ms 06 24 30s77ms 1s253ms 07 23 23s640ms 1s27ms 08 19 17s134ms 901ms 09 34 32s233ms 948ms 10 48 37s172ms 774ms 11 30 27s919ms 930ms 12 36 38s212ms 1s61ms 13 15 11s872ms 791ms 14 1 462ms 462ms 15 1 457ms 457ms [ User: lfriedman - Total duration: 20m9s - Times executed: 1234 ]
-
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-win764-test55') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '310' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-07 00:37:14 Duration: 13s184ms Database: nightly User: lfriedman
10 300ms 10s375ms 970ms 281 4m32s update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 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 Dec 07 01 5 9s114ms 1s822ms 04 16 13s266ms 829ms 05 34 41s477ms 1s219ms 06 82 1m25s 1s39ms 07 32 23s750ms 742ms 09 5 2s902ms 580ms 11 2 818ms 409ms [ User: lfriedman - Total duration: 4m32s - Times executed: 281 ]
-
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-test28'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test28';
Date: 2012-12-07 07:52:28 Duration: 7s945ms Database: nightly User: lfriedman
11 300ms 11s30ms 960ms 2,282 36m32s update systems set daemon_update = now(), activated = ? where vm = ?;Times Reported Time consuming queries #11
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 Dec 07 01 14 21s250ms 1s517ms 04 293 4m48s 983ms 05 402 6m18s 940ms 06 385 5m35s 871ms 07 157 1m43s 657ms 08 14 7s21ms 501ms 09 25 13s899ms 555ms 11 4 3s105ms 776ms [ User: lfriedman - Total duration: 36m32s - Times executed: 2282 ]
-
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-win732-build12';
Date: 2012-12-07 07:52:28 Duration: 9s564ms Database: cbs User: lfriedman
12 300ms 10s997ms 902ms 4,524 1h8m2s update gpu set dd_date = ?, last_update = ( select date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 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 Dec 07 23 1 820ms 820ms 00 4 2s201ms 550ms 01 61 1m23s 1s376ms 04 380 5m7s 809ms 05 728 12m22s 1s20ms 06 982 15m1s 917ms 07 360 3m32s 589ms 08 40 22s535ms 563ms 09 75 39s352ms 524ms 11 35 22s689ms 648ms Dec 08 16 1 341ms 341ms [ User: lfriedman - Total duration: 1h8m2s - Times executed: 4524 ]
-
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
13 300ms 10s743ms 898ms 1,798 26m54s update gpu set dd_date = ?, last_update = (date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #13
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 Dec 07 00 1 569ms 569ms 01 5 2s895ms 579ms 04 255 3m29s 820ms 05 387 6m18s 979ms 06 402 6m52s 1s24ms 07 154 1m29s 582ms 08 11 5s57ms 459ms 09 28 14s309ms 511ms 11 5 3s191ms 638ms [ User: lfriedman - Total duration: 26m54s - Times executed: 1798 ]
-
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/06', last_update = (date_trunc('second', now())) WHERE system = 'cuda-win764-cvs17';
Date: 2012-12-07 07:52:28 Duration: 9s896ms Database: nightly User: lfriedman
14 300ms 9s839ms 866ms 632 9m7s insert into regressspace (reftable, reftableid, cl, cldate, clowner) values (?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 06 04 189 3m49s 1s214ms 05 158 1m46s 672ms 06 10 5s671ms 567ms 08 1 371ms 371ms Dec 07 04 14 11s20ms 787ms 05 260 3m14s 748ms [ User: lfriedman - Total duration: 9m7s - Times executed: 632 ]
-
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 ('nvprof32on64tests', '342824', '14523179', '2012/12/04', 'builder');
Date: 2012-12-07 06:19:47 Duration: 7s464ms Database: nightly User: lfriedman
15 318ms 15s37ms 852ms 1,640 23m17s insert into proccheck (hostname, process, subtestid) values (?, ?, ?); delete from proccheck where age(now(), datestamp) > interval ?;Times Reported Time consuming queries #15
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 Dec 07 23 1 795ms 795ms 00 2 1s615ms 807ms 02 24 19s416ms 809ms 03 251 3m20s 800ms 04 86 1m39s 1s154ms 05 38 42s396ms 1s115ms 06 29 25s892ms 892ms 07 41 37s363ms 911ms 08 29 23s346ms 805ms 09 42 35s254ms 839ms 10 19 15s373ms 809ms 11 2 1s616ms 808ms 15 4 3s186ms 796ms 17 4 3s204ms 801ms [ User: lfriedman - Total duration: 23m17s - Times executed: 1640 ]
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test35', '/usr/lib64/scim-1.0/scim-helper-manager', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 05:33:26 Duration: 15s37ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-win764-test29', 'cmd', '113'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 06:17:19 Duration: 7s32ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test35', '/usr/lib64/scim-1.0/scim-launcher -d -c simple -e all -f socket --no-stay', '6'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-07 05:30:56 Duration: 3s430ms Database: nightly User: lfriedman
16 300ms 9s988ms 816ms 440 5m59s update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 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 Dec 07 01 12 20s406ms 1s700ms 04 5 2s531ms 506ms 05 17 16s972ms 998ms 06 140 2m18s 991ms 07 87 55s75ms 633ms 08 9 5s388ms 598ms 09 25 12s806ms 512ms 11 5 2s927ms 585ms [ User: lfriedman - Total duration: 5m59s - Times executed: 440 ]
-
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-test11'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac64-test11';
Date: 2012-12-07 07:52:28 Duration: 9s519ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test13'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-linux32-test13';
Date: 2012-12-07 07:52:28 Duration: 7s501ms Database: nightly User: lfriedman
17 300ms 4s849ms 807ms 93 1m15s update tests set active = ? where id = ? and active is null;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 06 04 32 24s32ms 751ms 05 11 7s352ms 668ms Dec 07 04 14 9s377ms 669ms 05 19 18s251ms 960ms 06 8 12s71ms 1s508ms 07 8 3s653ms 456ms 08 1 339ms 339ms [ User: lfriedman - Total duration: 1m15s - Times executed: 93 ]
-
UPDATE tests SET active = 'cuda-linux-gputest16' WHERE id = '2419187' AND active IS NULL;
Date: 2012-12-07 07:37:52 Duration: 4s849ms Database: nightly User: lfriedman
-
UPDATE tests SET active = 'cuda-linux-gputest10' WHERE id = '2418304' AND active IS NULL;
Date: 2012-12-07 06:40:44 Duration: 4s786ms Database: nightly User: lfriedman
-
UPDATE tests SET active = 'cuda-vista32-test1' WHERE id = '2418291' AND active IS NULL;
Date: 2012-12-07 07:37:52 Duration: 3s365ms Database: nightly User: lfriedman
18 322ms 20s485ms 801ms 99 1m19s 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 Dec 07 03 6 2s986ms 497ms 04 14 11s758ms 839ms 05 5 3s85ms 617ms 06 2 1s43ms 521ms 07 3 1s549ms 516ms 08 6 3s19ms 503ms 09 4 5s811ms 1s452ms 10 5 2s368ms 473ms 11 1 416ms 416ms 13 2 859ms 429ms [ User: lfriedman - Total duration: 1m19s - Times executed: 99 ]
-
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-07 10:06:19 Duration: 3s968ms Database: pvs User: lfriedman
-
COPY thrusttests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';
Date: 2012-12-07 05:35:21 Duration: 2s217ms Database: nightly User: lfriedman
19 302ms 10s728ms 764ms 951 12m7s update gpu set daemon_update = now(), activated = ? where system = ?;Times Reported Time consuming queries #19
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 Dec 07 01 2 755ms 377ms 04 123 1m33s 760ms 05 159 2m2s 767ms 06 157 1m55s 733ms 07 63 38s125ms 605ms 08 6 3s762ms 627ms 09 17 8s373ms 492ms 11 2 1s 500ms [ User: lfriedman - Total duration: 12m7s - Times executed: 951 ]
-
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
20 300ms 9s209ms 744ms 783 9m42s update gpu set daemon_update = now() where system = ?;Times Reported Time consuming queries #20
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 Dec 07 04 124 1m39s 805ms 05 191 2m47s 875ms 06 227 2m40s 707ms 07 82 47s804ms 582ms 08 5 2s370ms 474ms 09 7 4s316ms 616ms 11 4 2s405ms 601ms [ User: lfriedman - Total duration: 9m42s - Times executed: 783 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac64-cvs3';
Date: 2012-12-07 07:52:28 Duration: 9s209ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-cvs21';
Date: 2012-12-07 06:19:49 Duration: 7s645ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-cvs0';
Date: 2012-12-07 06:19:49 Duration: 7s643ms Database: nightly User: lfriedman
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2s806ms 4 673ms 729ms 701ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM cider WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Dec 09 07 2 1s346ms 673ms Dec 09 23 2 1s459ms 729ms [ User: lfriedman - Total duration: 139ms - Times executed: 4 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM cider WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-09 00:39:37 Duration: 729ms 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 cider WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 08:59:32 Duration: 673ms Database: postgres User: nightly Remote: lfriedman
2 1s142ms 2 571ms 571ms 571ms UPDATE saved_searches SET last_used = NOW() WHERE LOWER(title) = LOWER($1);Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 04 2 1s142ms 571ms [ User: lfriedman - Total duration: 3ms - Times executed: 2 ]
-
UPDATE saved_searches SET last_used = NOW() WHERE LOWER(title) = LOWER($1);
Date: 2012-12-07 06:19:28 Duration: 571ms Database: postgres User: inventory Remote: lfriedman
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 14s985ms 4 1s51ms 6s441ms 3s746ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM nvprof32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Dec 09 22 2 2s102ms 1s51ms Dec 09 22 2 12s882ms 6s441ms [ User: lfriedman - Total duration: 1ms - Times executed: 4 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM nvprof32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-11 23:57:33 Duration: 6s441ms 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 nvprof32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 23:19:35 Duration: 1s51ms Database: postgres User: nightly Remote: lfriedman
2 13s610ms 14 378ms 2s142ms 972ms 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 2 4s285ms 2s142ms 07 2 2s491ms 1s245ms 16 2 756ms 378ms 19 2 1s100ms 550ms 04 4 3s805ms 951ms 11 2 1s171ms 585ms [ User: lfriedman - Total duration: 3ms - Times executed: 14 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmoke WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 01:40:34 Duration: 2s142ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmoke WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:41:30 Duration: 1s245ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmoke WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-09 06:19:58 Duration: 1s39ms Database: postgres User: nightly Remote: lfriedman
3 12s665ms 17 370ms 1s558ms 745ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM viper WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 08 2 3s117ms 1s558ms 07 2 1s417ms 708ms 09 2 1s124ms 562ms 13 2 1s410ms 705ms 19 2 740ms 370ms 21 2 1s416ms 708ms 11 2 1s442ms 721ms 14 2 1s433ms 716ms 06 1 562ms 562ms [ User: lfriedman - Total duration: 3ms - Times executed: 17 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM viper WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 10:01:16 Duration: 1s558ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM viper WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-09 13:00:24 Duration: 721ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM viper WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-09 16:59:49 Duration: 716ms Database: postgres User: nightly Remote: lfriedman
4 11s801ms 11 407ms 3s192ms 1s72ms 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 #4
Day Hour Count Duration Avg duration 08 2 814ms 407ms 14 2 1s584ms 792ms 13 2 1s390ms 695ms 14 2 1s199ms 599ms 09 1 426ms 426ms 21 2 6s385ms 3s192ms [ User: lfriedman - Total duration: 14ms - Times executed: 11 ]
-
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-11 23:59:06 Duration: 3s192ms 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 16:39:41 Duration: 792ms Database: postgres User: nightly Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM thrust WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 15:20:05 Duration: 695ms Database: postgres User: nightly Remote: lfriedman
5 7s845ms 12 390ms 1s388ms 653ms SELECT testname FROM thrusttests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 14 2 993ms 496ms 07 2 781ms 390ms 09 2 1s159ms 579ms 21 2 1s 500ms 22 2 1s133ms 566ms 21 2 2s776ms 1s388ms [ User: lfriedman - Total duration: 8s884ms - Times executed: 12 ]
-
SELECT testname FROM thrusttests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 23:58:02 Duration: 1s388ms Database: postgres User: nightly Remote: lfriedman parameters: $1 = '105490', $2 = 'FAILED'
-
SELECT testname FROM thrusttests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 11:20:08 Duration: 579ms Database: postgres User: nightly Remote: lfriedman
-
SELECT testname FROM thrusttests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-09 00:39:38 Duration: 566ms Database: postgres User: nightly Remote: lfriedman
6 6s478ms 4 726ms 2s512ms 1s619ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr30 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 23 2 5s25ms 2s512ms 19 2 1s452ms 726ms [ User: lfriedman - Total duration: 0ms - Times executed: 4 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr30 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 01:40:42 Duration: 2s512ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr30 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 21:40:29 Duration: 726ms Database: postgres User: pvs Remote: lfriedman
7 6s349ms 10 480ms 811ms 634ms SELECT testname FROM curandtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 23 2 1s517ms 758ms 07 2 1s90ms 545ms 09 2 961ms 480ms 19 2 1s623ms 811ms 21 2 1s156ms 578ms [ User: lfriedman - Total duration: 155ms - Times executed: 10 ]
-
SELECT testname FROM curandtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 21:40:10 Duration: 811ms Database: postgres User: pvs Remote: lfriedman
-
SELECT testname FROM curandtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-06 01:40:25 Duration: 758ms Database: postgres User: pvs Remote: lfriedman
-
SELECT testname FROM curandtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 23:19:31 Duration: 578ms Database: postgres User: nightly Remote: lfriedman
8 5s165ms 7 308ms 1s292ms 737ms 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 #8
Day Hour Count Duration Avg duration 23 2 2s584ms 1s292ms 03 2 761ms 380ms 11 2 616ms 308ms 09 1 1s202ms 1s202ms [ User: lfriedman - Total duration: 0ms - Times executed: 7 ]
-
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-11 11:21:30 Duration: 1s202ms 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
9 5s63ms 1 5s63ms 5s63ms 5s63ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM mc_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 #9
Day Hour Count Duration Avg duration 06 1 5s63ms 5s63ms [ User: lfriedman - Total duration: 230ms - Times executed: 1 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM mc_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-11 08:19:21 Duration: 5s63ms Database: postgres User: nightly Remote: lfriedman
10 4s970ms 3 504ms 3s961ms 1s656ms 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 #10
Day Hour Count Duration Avg duration 18 2 1s9ms 504ms 06 1 3s961ms 3s961ms [ User: lfriedman - Total duration: 457ms - Times executed: 3 ]
-
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-11 08:19:39 Duration: 3s961ms Database: postgres User: nightly Remote: lfriedman parameters: $1 = '2012-12-11 04:00:00', $2 = '2012-12-12 04:00:00', $3 = 'Linux', $4 = 'x86_64', $5 = 'cuda_a', $6 = 'release', $7 = 'SPARSE_CUBLAS NIGHTLY', $8 = '2.6.32-279.el6.x86_64', $9 = '304'
-
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
11 4s932ms 10 310ms 684ms 493ms SELECT testname FROM toolssharedtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 23 2 737ms 368ms 13 2 1s135ms 567ms 21 2 621ms 310ms 22 2 1s368ms 684ms 14 2 1s68ms 534ms [ User: lfriedman - Total duration: 4ms - Times executed: 10 ]
-
SELECT testname FROM toolssharedtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-09 00:39:41 Duration: 684ms Database: postgres User: nightly Remote: lfriedman
-
SELECT testname FROM toolssharedtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 15:20:09 Duration: 567ms Database: postgres User: nightly Remote: lfriedman
-
SELECT testname FROM toolssharedtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-09 16:59:53 Duration: 534ms Database: postgres User: nightly Remote: lfriedman
12 4s659ms 7 461ms 916ms 665ms 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 #12
Day Hour Count Duration Avg duration 23 2 1s833ms 916ms 08 2 923ms 461ms 07 2 1s23ms 511ms 06 1 879ms 879ms [ User: lfriedman - Total duration: 1ms - Times executed: 7 ]
-
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-11 08:42:12 Duration: 879ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM oclapps WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:20:13 Duration: 511ms Database: postgres User: nightly Remote: lfriedman
13 4s200ms 7 342ms 959ms 600ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmokenew WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 10 2 1s63ms 531ms 19 2 1s919ms 959ms 21 2 685ms 342ms 06 1 532ms 532ms [ User: lfriedman - Total duration: 1ms - Times executed: 7 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmokenew WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 21:40:22 Duration: 959ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmokenew WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-11 08:20:12 Duration: 532ms 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 profsmokenew WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 12:41:11 Duration: 531ms Database: postgres User: pvs Remote: lfriedman
14 4s179ms 6 432ms 917ms 696ms SELECT testname FROM memchecktests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 23 2 1s835ms 917ms 04 2 865ms 432ms 14 2 1s478ms 739ms [ User: lfriedman - Total duration: 1ms - Times executed: 6 ]
-
SELECT testname FROM memchecktests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 01:19:44 Duration: 917ms Database: postgres User: nightly Remote: lfriedman
-
SELECT testname FROM memchecktests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-09 16:59:52 Duration: 739ms Database: postgres User: nightly Remote: lfriedman
-
SELECT testname FROM memchecktests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-09 06:39:21 Duration: 432ms Database: postgres User: nightly Remote: lfriedman
15 3s897ms 2 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 #15
Day Hour Count Duration Avg duration 23 2 3s897ms 1s948ms [ 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_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
16 3s607ms 5 308ms 1s688ms 721ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger 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 13 2 1s302ms 651ms 04 1 1s688ms 1s688ms 21 2 616ms 308ms [ User: lfriedman - Total duration: 7ms - Times executed: 5 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger 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-11 06:59:56 Duration: 1s688ms 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 debugger WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 15:20:07 Duration: 651ms 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 debugger 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-11 23:38:16 Duration: 308ms Database: postgres User: nightly Remote: lfriedman
17 3s492ms 3 529ms 1s481ms 1s164ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 07 2 2s963ms 1s481ms 09 1 529ms 529ms [ User: lfriedman - Total duration: 0ms - Times executed: 3 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:41:42 Duration: 1s481ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-11 11:21:25 Duration: 529ms Database: postgres User: pvs Remote: lfriedman
18 3s287ms 3 556ms 1s365ms 1s95ms 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 #18
Day Hour Count Duration Avg duration 08 2 2s731ms 1s365ms 09 1 556ms 556ms [ User: lfriedman - Total duration: 2s345ms - Times executed: 3 ]
-
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'
-
SELECT testname FROM njcublastests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 11:20:32 Duration: 556ms Database: postgres User: pvs Remote: lfriedman
19 3s236ms 4 720ms 898ms 809ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM interop32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 08 2 1s796ms 898ms 07 2 1s440ms 720ms [ User: lfriedman - Total duration: 21ms - Times executed: 4 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM interop32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 10:01:09 Duration: 898ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM interop32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:41:27 Duration: 720ms Database: postgres User: pvs Remote: lfriedman
20 2s866ms 6 334ms 636ms 477ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM memcheck 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 10 2 737ms 368ms 11 2 1s272ms 636ms 06 2 856ms 428ms [ User: lfriedman - Total duration: 739ms - Times executed: 6 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM memcheck 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-09 13:00:26 Duration: 636ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM memcheck 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-11 08:42:10 Duration: 521ms Database: postgres User: pvs Remote: lfriedman parameters: $1 = '2012-11-11 04:00:00', $2 = '2012-12-11 04:00:00', $3 = 'WIN7', $4 = 'i686', $5 = 'cuda_a', $6 = 'release', $7 = 'memcheck', $8 = 'WIN7', $9 = '200'
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM memcheck WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 12:41:16 Duration: 368ms Database: postgres User: pvs Remote: lfriedman
-
pgBouncer
Request Throughput
Key values
- 3,530 queries/s Request Peak
- 2012-12-09 20:41:21 Date
Bytes I/O Throughput
Key values
- 5,150,593 Bytes/s In Bytes Peak
- 2012-12-06 07:16:19 Date
- 1,061,373 Bytes/s Out Bytes Peak
- 2012-12-09 00:01:20 Date
Queries Average duration
Key values
- 113ms Average Duration Peak
- 2012-12-07 07:10:19 Date
Established Connections
Key values
- 224 connections Connection Peak
- 2012-12-09 19:30:34 Date
Connections per database
Key values
- nightly Main Database
- 4,420,005 connections Total
Database User Count albatros_dimp_test 35 lfriedman 35 gasworks2 1,681 lfriedman 1,681 grinderman 10,505 lfriedman 10,505 intranet 306,893 lfriedman 306,893 intranet_test 5,334 lfriedman 5,334 jdb 1,199 lfriedman 1,199 lfriedman_test 2,136 lfriedman 2,136 nightly 3,591,978 lfriedman 3,591,978 optique_production 1,063 lfriedman 1,063 pgbouncer 2,130 dalibo 2,130 sterne_production 2,326 lfriedman 2,326 vangard_prod 18,487 lfriedman 18,487 webmail 476,238 lfriedman 476,238 Connections per user
Key values
- lfriedman Main User
- 4,420,005 connections Total
Connections per host
Key values
- 10.10.10.22.13 Main host with 3322534 connections
- 4,420,005 Total connections
Simultaneous sessions
Key values
- 548 sessions Session Peak
- 2012-12-09 20:41:26 Date
Histogram of session times
Key values
- 3,921,591 0-500ms duration
Sessions per database
Key values
- nightly Main Database
- 4,438,535 sessions Total
Database User Count Total Duration Average Duration albatros_dimp_test 43 10m44s 14s976ms gasworks2 2,465 17h27m40s 25s501ms grinderman 10,505 52m6s 297ms intranet 309,864 13d6h22m25s 3s698ms intranet_test 5,334 2d14h14s 41s847ms jdb 1,936 15h38m44s 29s92ms lfriedman_test 2,136 3s 1ms nightly 3,600,599 100d5h43m26s 2s405ms optique_production 1,160 1h38m44s 5s106ms pgbouncer 2,130 0ms 0ms sterne_production 3,810 1d7h4m9s 29s356ms vangard_prod 19,395 7d19h29m12s 34s800ms webmail 479,158 14d6h42m32s 2s574ms Sessions per user
Key values
- lfriedman Main User
- 4,438,535 sessions Total
Sessions per host
Key values
- 10.10.10.22.13 Main Host
- 4,438,535 sessions Total
Most used reserved pools
Key values
- lfriedman@nightly Most used reserved pool
- 4,898 Time used
- 4,940 Total time reserved pools was used
Rank Times used Reserved pool 1 4,898 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 Dec 07 23 30 00 30 01 30 02 30 03 30 04 32 05 55 06 74 07 75 08 84 09 60 10 50 11 26 12 27 13 35 14 60 15 64 16 78 17 84 18 75 19 76 20 82 21 76 22 59 Dec 08 23 55 00 36 01 34 02 41 03 44 04 62 05 72 06 75 07 80 08 76 09 79 10 61 11 40 12 27 13 40 14 58 15 78 16 68 17 76 18 85 19 85 20 83 21 73 22 79 Dec 09 23 56 00 53 01 55 02 48 03 51 04 63 05 83 06 81 07 75 08 79 09 70 10 48 11 45 12 32 13 41 14 66 15 86 16 78 17 68 18 67 19 77 20 85 21 81 22 73 2 26 lfriedman@webmailTimes Reported Most used reserved pools #2
Day Hour Count Dec 07 09 7 Dec 08 09 9 12 10 3 16 lfriedman@intranetTimes Reported Most used reserved pools #3
Day Hour Count Dec 07 07 5 08 2 09 1 14 3 Dec 08 07 1 10 2 Dec 09 06 1 07 1 Most Frequent Errors/Events
Key values
- 4,940 Max number of times the same event was reported
- 4,940 Total events found
Rank Times reported Error 1 4,940 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 Dec 07 23 30 00 30 01 30 02 30 03 30 04 32 05 55 06 74 07 80 08 86 09 68 10 50 11 26 12 27 13 35 14 63 15 64 16 78 17 84 18 75 19 76 20 82 21 76 22 59 Dec 08 23 55 00 36 01 34 02 41 03 44 04 62 05 72 06 75 07 81 08 76 09 88 10 63 11 40 12 37 13 40 14 58 15 78 16 68 17 76 18 85 19 85 20 83 21 73 22 79 Dec 09 23 56 00 53 01 55 02 48 03 51 04 63 05 83 06 82 07 76 08 79 09 70 10 48 11 45 12 32 13 41 14 66 15 86 16 78 17 68 18 67 19 77 20 85 21 81 22 73 - 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
- 61,431,928 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 3960 ERROR entries
- 1 WARNING entries
Most Frequent Errors/Events
Key values
- 3,930 Max number of times the same event was reported
- 3,961 Total events found
Rank Times reported Error 1 3,930 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 07 10 7 11 80 12 80 13 80 14 80 15 80 16 80 17 80 18 80 19 80 20 80 21 80 22 80 Dec 08 23 80 00 80 01 80 02 80 03 80 04 80 05 80 06 80 07 80 08 80 09 80 10 80 11 80 12 80 13 80 14 80 15 80 16 80 17 80 18 80 19 80 20 80 21 80 22 80 Dec 09 23 80 00 80 01 80 02 80 03 80 04 80 05 80 06 80 07 80 08 80 09 80 10 80 11 80 12 3 - ERROR: invalid input syntax for type date: "" at character 32
Statement: UPDATE ddtracker SET datestamp='' WHERE os='WIN8' AND arch='x86_64' AND branch='cuda_a' AND dbname='nightly';
Date: 2012-12-07 12:05:38 Database: inventory Application: User: lfriedman Remote:
2 15 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #2
Day Hour Count Dec 06 04 8 Dec 07 04 5 05 1 06 1 - 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:
3 12 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Dec 06 07 1 08 1 09 1 17 1 18 2 Dec 07 00 1 08 1 09 1 11 2 12 1 - 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:
4 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Dec 06 17 1 Dec 07 10 1 - ERROR: column "system" does not exist at character 82
- ERROR: column "system" does not exist at character 63
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:
Statement: update systems set active='f',comment='AP:reallocating' where system='cuda-mac64-build11' ;
Date: 2012-12-07 11:33:14 Database: cbs Application: User: lfriedman Remote:
5 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Dec 07 10 1 - ERROR: relation "bulds" does not exist at character 13
Statement: delete from bulds where active='disabled' ;
Date: 2012-12-07 11:56:13 Database: cbs Application: User: lfriedman Remote:
6 1 WARNING: pgstat wait timeout
Times Reported Most Frequent Error / Event #6
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