pgBadger-
Global information
- Generated on Tue May 17 09:18:14 2022
- Log file: /data/pglog/huge_log_test/pgbouncer.log.1, ..., /data/pglog/huge_log_test/postgresql-Tue.log
- Parsed 85,027,818 log entries in 15m9s
- Log start from 2012-12-10 00:00:00 to 2012-12-12 00:00:00
-
Overview
Global Stats
- 444 Number of unique normalized queries
- 19,372,167 Number of queries
- 2d23h20m24s Total query duration
- 2012-12-10 00:00:00 First query
- 2012-12-12 00:00:00 Last query
- 787 queries/s at 2012-12-11 02:02:02 Query peak
- 2d23h20m24s Total query duration
- 0ms Prepare/parse total duration
- 37s771ms Bind total duration
- 2d23h19m46s Execute total duration
- 4 Number of events
- 3 Number of unique normalized events
- 2 Max number of times the same event was reported
- 0 Number of cancellation
- 9 Total number of automatic vacuums
- 41 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 4,019,562 Total number of sessions
- 49 sessions at 2012-12-11 10:49:54 Session peak
- 299d18h45m50s Total duration of sessions
- 6s443ms Average duration of sessions
- 4 Average queries per session
- 63ms Average queries duration per session
- 6s379ms Average idle time per session
- 4,019,564 Total number of connections
- 233 connections/s at 2012-12-11 02:02:02 Connection peak
- 6 Total number of databases
SQL Traffic
Key values
- 787 queries/s Query Peak
- 2012-12-11 02:02:02 Date
SELECT Traffic
Key values
- 108 queries/s Query Peak
- 2012-12-11 10:49:56 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 46 queries/s Query Peak
- 2012-12-11 07:20:23 Date
Queries duration
Key values
- 2d23h20m24s 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 10 00 1 0ms 0ms 0ms 0ms 0ms 0ms Dec 11 00 906,958 0ms 25s161ms 12ms 3m33s 3m41s 3m45s 01 844,781 0ms 1s726ms 12ms 3m18s 3m21s 3m27s 02 903,811 0ms 1s772ms 12ms 3m19s 3m25s 3m46s 03 949,068 0ms 1s767ms 11ms 3m31s 3m34s 3m38s 04 331,983 0ms 2s381ms 11ms 1m53s 2m58s 3m30s 05 312,191 0ms 2m37s 20ms 4m1s 5m1s 6m50s 06 474,822 0ms 2m30s 17ms 4m7s 4m48s 8m9s 07 630,441 0ms 3m8s 19ms 5m13s 13m14s 16m29s 08 778,196 0ms 1m55s 14ms 4m8s 5m28s 6m35s 09 821,616 0ms 1m29s 13ms 4m19s 4m48s 7m3s 10 846,054 0ms 1m19s 15ms 3m55s 9m17s 22m11s 11 897,361 0ms 7s135ms 12ms 3m17s 3m28s 4m11s 12 944,294 0ms 1s786ms 13ms 3m47s 3m51s 4m3s 13 935,923 0ms 1m25s 12ms 3m52s 4m21s 4m25s 14 947,364 0ms 1m13s 12ms 3m27s 3m36s 4m17s 15 927,313 0ms 2s585ms 12ms 3m24s 3m27s 3m30s 16 951,387 0ms 1m26s 13ms 3m55s 4m21s 6m1s 17 930,853 0ms 2s486ms 12ms 3m32s 3m44s 4m13s 18 870,350 0ms 1m7s 12ms 3m18s 3m37s 4m42s 19 803,912 0ms 1s782ms 11ms 2m48s 2m52s 3m3s 20 815,588 0ms 2s519ms 12ms 2m56s 2m59s 3m10s 21 840,466 0ms 1s770ms 12ms 3m15s 3m18s 3m24s 22 835,036 0ms 1s866ms 12ms 3m 3m11s 3m19s 23 872,397 0ms 58s994ms 13ms 3m14s 6m51s 13m24s Dec 12 00 1 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 10 00 0 0 0ms 0ms 0ms 0ms Dec 11 00 78 0 596ms 1s110ms 2s167ms 2s988ms 01 81 0 574ms 1s205ms 1s872ms 3s279ms 02 76 0 590ms 1s130ms 1s730ms 3s191ms 03 58 0 722ms 1s195ms 1s767ms 3s430ms 04 8 0 895ms 0ms 422ms 1s455ms 05 279 0 767ms 3s825ms 10s606ms 23s782ms 06 155 0 1s128ms 4s161ms 8s516ms 27s764ms 07 440 0 1s215ms 8s133ms 27s923ms 1m34s 08 800 0 795ms 3s251ms 34s364ms 2m12s 09 274 0 1s120ms 2s187ms 3s276ms 1m24s 10 1,072 0 1s812ms 3s81ms 52s637ms 6m15s 11 212 0 740ms 1s723ms 2s156ms 46s561ms 12 80 0 631ms 1s493ms 2s387ms 3s94ms 13 99 0 706ms 1s987ms 2s721ms 3s916ms 14 150 0 614ms 2s630ms 3s379ms 4s925ms 15 198 0 644ms 3s483ms 4s776ms 7s19ms 16 479 0 617ms 3s674ms 14s416ms 42s291ms 17 145 0 630ms 2s146ms 3s295ms 9s59ms 18 224 0 657ms 1s698ms 2s232ms 40s631ms 19 44 0 662ms 1s41ms 1s718ms 2s153ms 20 145 0 640ms 1s125ms 1s764ms 21s696ms 21 59 0 720ms 1s499ms 2s184ms 2s471ms 22 53 0 808ms 1s731ms 2s165ms 2s596ms 23 429 0 2s180ms 1s456ms 2s534ms 3m48s Dec 12 00 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 10 00 0 0 0 0 0ms 0ms 0ms 0ms Dec 11 00 18 0 1 1 2s16ms 0ms 796ms 1s601ms 01 21 0 0 0 803ms 0ms 794ms 1s612ms 02 10 1 0 0 815ms 0ms 0ms 945ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 250 0 0 8 782ms 3s48ms 4s802ms 15s947ms 05 187 1,538 30 96 1s336ms 19s805ms 1m22s 3m12s 06 132 1,640 26 71 1s78ms 17s17ms 1m12s 2m30s 07 60 2,146 23 59 1s525ms 15s320ms 1m26s 6m19s 08 73 468 12 27 1s302ms 3s894ms 13s557ms 1m21s 09 88 440 0 19 1s588ms 4s18ms 19s187ms 1m23s 10 96 381 1 13 1s124ms 2s387ms 3s298ms 1m1s 11 34 11 0 12 657ms 448ms 1s584ms 2s310ms 12 11 0 0 6 668ms 0ms 0ms 1s617ms 13 3 122 0 6 1s834ms 0ms 641ms 23s25ms 14 15 20 0 1 2s730ms 0ms 781ms 2s599ms 15 25 17 2 1 712ms 371ms 1s572ms 1s628ms 16 16 51 8 3 2s603ms 372ms 1s609ms 4s466ms 17 21 7 2 1 710ms 0ms 815ms 1s605ms 18 21 17 3 3 2s145ms 0ms 818ms 3s202ms 19 64 14 0 1 783ms 791ms 1s608ms 5s625ms 20 60 23 1 2 807ms 809ms 1s611ms 6s332ms 21 63 0 0 0 802ms 796ms 1s617ms 3s221ms 22 57 0 0 0 801ms 0ms 1s601ms 3s987ms 23 60 136 1 2 1s115ms 813ms 1s636ms 35s337ms Dec 12 00 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Dec 10 00 0 0 0.00 0.00% Dec 11 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 4 4.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 2 2.00 0.00% 07 0 4 4.00 0.00% 08 0 82 82.00 0.00% 09 0 24 24.00 0.00% 10 0 8 8.00 0.00% 11 0 18 18.00 0.00% 12 0 1 1.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 51 51.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 1 1.00 0.00% 23 0 19 19.00 0.00% Dec 12 00 0 0 0.00 0.00% Day Hour Count Average / Second Dec 10 00 0 0.00/s Dec 11 00 185,352 51.49/s 01 173,266 48.13/s 02 194,052 53.90/s 03 198,828 55.23/s 04 60,161 16.71/s 05 60,950 16.93/s 06 100,550 27.93/s 07 126,610 35.17/s 08 154,868 43.02/s 09 173,458 48.18/s 10 174,471 48.46/s 11 188,763 52.43/s 12 196,860 54.68/s 13 198,287 55.08/s 14 204,929 56.92/s 15 200,100 55.58/s 16 198,888 55.25/s 17 195,206 54.22/s 18 182,668 50.74/s 19 168,365 46.77/s 20 166,504 46.25/s 21 171,068 47.52/s 22 169,710 47.14/s 23 175,650 48.79/s Dec 12 00 0 0.00/s Day Hour Count Average Duration Average idle time Dec 10 00 0 0ms 0ms Dec 11 00 185,350 5s822ms 5s760ms 01 173,266 6s229ms 6s167ms 02 194,052 5s555ms 5s499ms 03 198,829 5s431ms 5s374ms 04 60,160 17s724ms 17s663ms 05 60,950 17s851ms 17s744ms 06 100,550 10s755ms 10s673ms 07 126,610 8s543ms 8s443ms 08 154,868 6s969ms 6s897ms 09 173,458 6s225ms 6s158ms 10 174,471 6s176ms 6s103ms 11 188,763 5s725ms 5s666ms 12 196,862 5s481ms 5s417ms 13 198,285 5s445ms 5s385ms 14 204,929 5s261ms 5s204ms 15 200,100 5s393ms 5s336ms 16 198,888 5s428ms 5s363ms 17 195,207 5s522ms 5s461ms 18 182,667 5s907ms 5s848ms 19 168,365 6s410ms 6s354ms 20 166,504 6s488ms 6s429ms 21 171,068 6s307ms 6s243ms 22 169,711 6s356ms 6s296ms 23 175,649 6s143ms 6s77ms Dec 12 00 0 0ms 0ms -
Connections
Established Connections
Key values
- 233 connections Connection Peak
- 2012-12-11 02:02:02 Date
Connections per database
Key values
- nightly Main Database
- 4,019,564 connections Total
Connections per user
Key values
- lfriedman Main User
- 4,019,564 connections Total
-
Sessions
Simultaneous sessions
Key values
- 49 sessions Session Peak
- 2012-12-11 10:49:54 Date
Histogram of session times
Key values
- 2,595,751 1000-30000ms duration
Sessions per database
Key values
- nightly Main Database
- 4,019,562 sessions Total
Sessions per user
Key values
- lfriedman Main User
- 4,019,562 sessions Total
Sessions per host
Key values
- 10.31.96.124 Main Host
- 4,019,562 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 166,164 buffers Checkpoint Peak
- 2012-12-11 07:30:50 Date
- 210.037 seconds Highest write time
- 156.589 seconds Sync time
Checkpoints Wal files
Key values
- 123 files Wal files usage Peak
- 2012-12-11 06:18:16 Date
Checkpoints distance
Key values
- 0.00 Mo Distance Peak
- 2012-12-11 14:29:51 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Dec 10 00 0 0s 0s 0s Dec 11 00 63,024 2,254.767s 0.219s 2,255.043s 01 19,880 1,984.949s 0.161s 1,985.182s 02 19,295 1,926.493s 0.097s 1,926.641s 03 20,824 2,061.877s 0.092s 2,062.028s 04 47,397 2,438.661s 0.596s 2,439.313s 05 1,140,619 2,510.347s 289.766s 2,800.705s 06 1,024,206 2,321.88s 414.408s 2,736.526s 07 933,045 2,064.504s 277.526s 2,342.497s 08 795,342 2,424.867s 27.603s 2,452.6s 09 734,795 2,166.703s 19.068s 2,185.926s 10 328,745 2,514.236s 8.971s 2,523.28s 11 45,715 2,518.49s 0.294s 2,518.837s 12 31,194 2,431.612s 0.157s 2,431.835s 13 275,381 2,182.86s 5.614s 2,188.588s 14 171,974 2,575.419s 0.567s 2,576.065s 15 22,613 2,239.675s 0.128s 2,239.869s 16 168,417 2,294.679s 0.188s 2,294.95s 17 169,386 2,342.118s 0.263s 2,342.451s 18 27,690 2,241.387s 0.141s 2,241.592s 19 167,529 2,264.875s 0.29s 2,265.23s 20 21,839 2,150.257s 0.128s 2,150.441s 21 22,781 2,221.403s 0.122s 2,221.579s 22 21,831 2,174.802s 0.121s 2,174.989s 23 23,924 2,262.219s 0.106s 2,262.384s Dec 12 00 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Dec 10 00 0 0 0 0 0s 0s Dec 11 00 0 0 75 3,460 0.019s 0s 01 0 0 58 2,750 0.007s 0s 02 0 0 59 1,172 0.002s 0s 03 0 0 60 809 0.005s 0s 04 0 0 59 12,805 0.008s 0s 05 0 0 590 19,436 31.639s 0.304s 06 0 0 441 13,862 26.033s 0.365s 07 0 0 454 10,620 45.205s 0.694s 08 0 0 359 9,071 4.726s 0.038s 09 0 0 396 6,337 5.391s 0.043s 10 0 0 135 5,373 5.109s 0.025s 11 0 0 59 4,474 0.007s 0s 12 0 0 59 3,233 0.005s 0s 13 0 0 175 2,654 1.714s 0.028s 14 0 0 123 1,895 0.145s 0.006s 15 0 0 59 1,343 0.007s 0s 16 0 0 147 1,391 0.027s 0.001s 17 0 0 90 2,510 0.029s 0s 18 0 0 58 1,567 0.002s 0s 19 0 0 120 1,171 0.087s 0.001s 20 0 0 58 874 0.003s 0s 21 0 0 59 998 0.007s 0s 22 0 0 59 781 0.008s 0s 23 0 0 60 890 0.004s 0s Dec 12 00 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Dec 10 00 0 0s Dec 11 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 12 00 0 0s Day Hour Mean distance Mean estimate Dec 10 00 0.00 kB 0.00 kB Dec 11 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 12 00 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 10 00 0 0 0 Dec 11 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 12 00 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 4.73 sec Highest CPU-cost vacuum
Table public.gpu
Database nightly - 2012-12-11 18:33:15 Date
- 190.11 sec Highest CPU-cost analyze
Table public.nppsmoketests_2012_12
Database nightly - 2012-12-11 05:36:03 Date
Analyzes per table
Key values
- public.cufftsmoketests_2012_12 (2) Main table analyzed (database pvs)
- 41 analyzes Total
Table Number of analyzes pvs.public.cufftsmoketests_2012_12 2 pvs.public.cublassmoketests_2012_12 2 pvs.public.dblamodeltests_2012_12 2 nightly.public.profsmokenewtests_2012_12 2 pvs.public.dblcublastests_2012_12 2 pvs.public.nppsmoketests_2012_12 2 nightly.public.dblcublastests_2012_12 2 nightly.public.njsmoketests_2012_12 2 nightly.public.thrusttests_2012_12 2 nightly.public.nppsmoketests_2012_12 2 nightly.public.nvproftests_2012_12 1 nightly.public.mc_cublastests_2012_12 1 pvs.public.cudasmoketests_2012_12 1 pvs.public.mc_cublastests_2012_12 1 nightly.public.mathsmokesm2xtests_2012_12 1 nightly.public.mc_dblcublastests_2012_12 1 nightly.public.cupti 1 nightly.public.nvprof32on64tests_2012_12 1 nightly.public.cufftsmoketests_2012_12 1 nightly.public.curandtests_2012_12 1 nightly.public.cublassmoketests_2012_12 1 nightly.public.sparse_cublastests_2012_12 1 nightly.public.dblamodeltests_2012_12 1 nightly.public.cudasmoketests_2012_12 1 pvs.public.mc_dblcublastests_2012_12 1 pvs.public.njsmoketests_2012_12 1 nightly.public.smoke32on64tests_2012_12 1 nightly.public.dblcuffttests_2012_12 1 nightly.public.mc_cusparsetests_2012_12 1 pvs.public.sparse_cublastests_2012_12 1 pvs.public.thrusttests_2012_12 1 Total 41 Vacuums per table
Key values
- public.gpu (5) Main table vacuumed on database nightly
- 9 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes nightly.public.gpu 5 5 48,803 0 1,300 0 0 0 0 0 pvs.public.curand_2012_12 1 1 565 0 46 0 0 0 0 0 pvs.pg_catalog.pg_statistic 1 1 3,186 0 942 0 0 0 0 0 cbs.pg_catalog.pg_statistic 1 1 303 0 94 0 0 0 0 0 cbs.public.systems 1 1 2,157 0 28 0 0 0 0 0 Total 9 9 55,014 469 2,410 0 0 0 0 0 Tuples removed per table
Key values
- public.gpu (5806) Main table with removed tuples on database nightly
- 7775 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain nightly.public.gpu 5 5 5,806 6,706 0 0 18,025 pvs.pg_catalog.pg_statistic 1 1 1,742 20,943 0 0 1,452 cbs.pg_catalog.pg_statistic 1 1 149 1,117 0 0 115 cbs.public.systems 1 1 74 82 0 0 114 pvs.public.curand_2012_12 1 1 4 197 0 0 19 Total 9 9 7,775 29,045 0 0 19,725 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 10 00 0 0 Dec 11 00 0 0 01 0 0 02 0 0 03 0 0 04 0 4 05 2 8 06 0 6 07 1 4 08 0 6 09 2 1 10 2 2 11 0 3 12 0 1 13 0 2 14 0 0 15 0 0 16 1 1 17 0 1 18 1 0 19 0 1 20 0 0 21 0 0 22 0 1 23 0 0 Dec 12 00 0 0 - 4.73 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 5,638 Total read queries
- 8,861 Total write queries
Queries by database
Key values
- nightly Main database
- 18,271,795 Requests
- 2d21h39m50s (nightly)
- Main time consuming database
Database Request type Count Duration cbs Total 492,160 42m20s select 117 1m55s update 1,124 16m35s inventory Total 369,815 12m5s copy from 4 3s20ms delete 58 33s766ms insert 3 2s349ms select 14 13s187ms update 82 53s190ms mbm Total 126,459 3m10s select 1 348ms nightly Total 18,271,795 2d21h39m50s copy from 264 1h4m2s delete 48 54s insert 1,367 18m9s select 5,440 1h39m3s tcl 2 2s120ms update 5,794 1h17m6s postgres Total 432 886ms pvs Total 111,506 42m18s copy from 64 14m19s delete 4 1s837ms insert 15 13s602ms select 66 1m38s update 32 38s980ms Queries by user
Key values
- lfriedman Main user
- 130,505,298 Requests
User Request type Count Duration lfriedman Total 130,505,298 16d20h54m copy from 1,954 7h51m23s ddl 5,928 0ms delete 802 17m6s insert 8,050 1h52m56s select 33,652 11h57m38s tcl 8 6s931ms update 39,400 9h39m15s postgres Total 4,688 9s501ms select 2 661ms Duration by user
Key values
- 16d20h54m (lfriedman) Main time consuming user
User Request type Count Duration lfriedman Total 130,505,298 16d20h54m copy from 1,954 7h51m23s ddl 5,928 0ms delete 802 17m6s insert 8,050 1h52m56s select 33,652 11h57m38s tcl 8 6s931ms update 39,400 9h39m15s postgres Total 4,688 9s501ms select 2 661ms Queries by host
Key values
- unknown Main host
- 130,509,986 Requests
- 16d20h54m10s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 19,372,167 Requests
- 2d23h19m46s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2012-12-11 21:54:03 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 10,367,313 0-1ms duration
Slowest individual queries
Rank Duration Query 1 3m8s 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-11 07:21:40 - Database: nightly - User: lfriedman ]
2 2m37s 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-11 05:51:12 - Database: nightly - User: lfriedman ]
3 2m30s 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-11 06:29:12 - Database: pvs - User: lfriedman ]
4 2m25s 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-11 07:26:46 - Database: nightly - User: lfriedman ]
5 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-11 07:20:23 - Database: nightly - User: lfriedman ]
6 2m16s 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-11 07:27:16 - Database: nightly - User: lfriedman ]
7 2m10s 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-11 06:17:10 - Database: nightly - User: lfriedman ]
8 2m2s 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-11 05:39:19 - Database: nightly - User: lfriedman ]
9 2m1s 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-11 06:23:44 - Database: nightly - User: lfriedman ]
10 1m59s 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-11 06:23:44 - Database: nightly - User: lfriedman ]
11 1m55s 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-11 08:13:40 - Database: nightly - User: lfriedman ]
12 1m52s 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-11 06:20:29 - Database: nightly - User: lfriedman ]
13 1m50s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-11 07:19:13 - Database: nightly - User: lfriedman ]
14 1m48s 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-11 05:17:52 - Database: nightly - User: lfriedman ]
15 1m47s 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-11 05:58:46 - Database: nightly - User: lfriedman ]
16 1m44s 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-11 05:48:20 - Database: nightly - User: lfriedman ]
17 1m42s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-11 05:17:52 - Database: nightly - User: lfriedman ]
18 1m38s 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-11 05:32:29 - Database: nightly - User: lfriedman ]
19 1m32s COPY nppsmoketests (last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion) FROM STDIN with CSV HEADER ESCAPE '~';[ Date: 2012-12-11 07:12:31 - Database: nightly - User: lfriedman ]
20 1m30s 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-11 05:32:25 - Database: nightly - User: lfriedman ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h14m46s 45 1m7s 3m8s 1m39s 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 11 04 11 19m3s 1m43s 05 7 13m18s 1m54s 06 10 19m20s 1m56s 07 4 6m2s 1m30s 08 6 8m5s 1m20s 09 1 1m19s 1m19s 12 2 2m35s 1m17s 13 1 1m13s 1m13s 15 2 2m39s 1m19s 17 1 1m7s 1m7s [ User: lfriedman - Total duration: 1h14m46s - Times executed: 45 ]
-
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-11 07:21:40 Duration: 3m8s 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-11 05:51:12 Duration: 2m37s 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-11 06:29:12 Duration: 2m30s Database: pvs User: lfriedman
2 1h6m52s 3,639 300ms 13s887ms 1s102ms select count(*) from pg_catalog.pg_class as c where c.oid = pgpool_regclass (?) and c.relpersistence = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 11 01 6 4s326ms 721ms 04 248 2m39s 642ms 05 108 55s941ms 517ms 06 315 3m5s 587ms 07 557 6m28s 697ms 08 148 2m3s 835ms 09 965 29m35s 1s840ms 10 118 1m8s 583ms 12 11 7s563ms 687ms 13 69 38s954ms 564ms 14 119 1m7s 565ms 15 392 4m 613ms 16 51 28s205ms 553ms 17 98 49s581ms 505ms 19 85 58s108ms 683ms 22 349 12m41s 2s181ms [ User: lfriedman - Total duration: 1h6m52s - Times executed: 3639 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('nvproxytests') AND c.relpersistence = 'u';
Date: 2012-12-11 10:49:56 Duration: 13s887ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('keplercublastests') AND c.relpersistence = 'u';
Date: 2012-12-11 10:49:46 Duration: 12s137ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('dblamodeltests') AND c.relpersistence = 'u';
Date: 2012-12-11 10:49:56 Duration: 11s814ms Database: nightly User: lfriedman
3 32m34s 2,371 300ms 9s151ms 824ms 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 11 01 1 945ms 945ms 04 445 5m7s 690ms 05 452 4m47s 635ms 06 780 13m27s 1s35ms 07 166 1m48s 655ms 08 176 2m5s 714ms 09 168 2m53s 1s30ms 10 8 4s170ms 521ms 12 49 31s57ms 633ms 13 11 6s926ms 629ms 14 8 5s767ms 720ms 15 14 6s683ms 477ms 16 4 1s741ms 435ms 17 7 3s299ms 471ms 18 9 5s985ms 665ms 19 8 8s190ms 1s23ms 22 65 1m9s 1s66ms [ User: lfriedman - Total duration: 32m34s - Times executed: 2371 ]
-
UPDATE gpu SET dd_date = '2012/12/10', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win7-test23';
Date: 2012-12-11 07:20:23 Duration: 9s151ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/10', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win7-gputest6';
Date: 2012-12-11 07:20:23 Duration: 9s117ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/10', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win8-test5';
Date: 2012-12-11 07:20:23 Duration: 9s40ms Database: nightly User: lfriedman
4 16m35s 1,124 300ms 9s97ms 885ms update systems set daemon_update = now(), activated = ? where vm = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 11 04 240 2m59s 746ms 05 295 3m11s 647ms 06 331 6m40s 1s209ms 07 69 52s771ms 764ms 08 69 43s121ms 624ms 09 64 1m12s 1s137ms 10 1 521ms 521ms 12 15 10s961ms 730ms 13 3 2s125ms 708ms 14 1 474ms 474ms 15 8 4s616ms 577ms 17 3 1s631ms 543ms 18 1 973ms 973ms 19 5 3s406ms 681ms 22 19 31s339ms 1s649ms [ User: lfriedman - Total duration: 16m35s - Times executed: 1124 ]
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-win732-build14';
Date: 2012-12-11 07:20:23 Duration: 9s97ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-linux32-build2';
Date: 2012-12-11 07:20:22 Duration: 8s837ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-mac64-build6';
Date: 2012-12-11 07:20:23 Duration: 8s469ms Database: cbs User: lfriedman
5 16m10s 1,188 300ms 9s268ms 817ms 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 11 04 301 3m30s 700ms 05 313 3m28s 665ms 06 356 6m32s 1s103ms 07 78 50s826ms 651ms 08 60 39s428ms 657ms 09 32 22s647ms 707ms 12 18 11s756ms 653ms 14 3 1s961ms 653ms 15 8 4s806ms 600ms 17 1 393ms 393ms 18 2 1s493ms 746ms 19 2 1s321ms 660ms 22 14 24s194ms 1s728ms [ User: lfriedman - Total duration: 16m10s - Times executed: 1188 ]
-
UPDATE gpu SET dd_date = 'Tue Dec 11 00:43:33 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux64-cvs32';
Date: 2012-12-11 07:21:28 Duration: 9s268ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = 'Tue Dec 11 00:43:33 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux64-cvs13';
Date: 2012-12-11 07:20:23 Duration: 9s221ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = 'Mon Dec 10 07:57:21 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux64-cvs24';
Date: 2012-12-11 07:21:29 Duration: 9s121ms Database: nightly User: lfriedman
6 16m4s 1,176 671ms 3s247ms 820ms 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 11 23 18 14s419ms 801ms 00 21 16s868ms 803ms 01 10 8s23ms 802ms 03 250 3m17s 791ms 04 88 1m18s 886ms 05 45 40s504ms 900ms 06 44 36s841ms 837ms 07 68 58s818ms 864ms 08 87 1m15s 863ms 09 96 1m18s 815ms 10 34 27s147ms 798ms 11 11 8s851ms 804ms 12 3 2s433ms 811ms 13 15 12s154ms 810ms 14 25 20s20ms 800ms 15 16 12s845ms 802ms 16 20 16s41ms 802ms 17 21 16s823ms 801ms 18 64 51s282ms 801ms 19 60 48s234ms 803ms 20 63 50s542ms 802ms 21 57 45s657ms 801ms 22 60 48s98ms 801ms [ User: lfriedman - Total duration: 16m4s - Times executed: 1176 ]
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test17', '[thrust_test] <defunct>', '2'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-11 08:12:13 Duration: 3s247ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-mac64-test14', '/usr/libexec/xpcd', '37'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-11 09:30:40 Duration: 2s910ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux32-test51', '/home/lfriedman/cuda-stuff/sw/gpgpu/bin/i686_Linux_release/memcpy_devsys', '177'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-11 05:50:16 Duration: 2s621ms Database: nightly User: lfriedman
7 11m33s 788 399ms 8s336ms 879ms 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 11 23 36 29s854ms 829ms 00 37 29s480ms 796ms 01 29 24s368ms 840ms 02 35 32s82ms 916ms 03 2 883ms 441ms 04 2 1s105ms 552ms 05 3 1s637ms 545ms 06 24 27s384ms 1s141ms 07 35 30s277ms 865ms 08 31 29s385ms 947ms 09 40 38s283ms 957ms 10 37 35s930ms 971ms 11 38 32s530ms 856ms 12 57 48s175ms 845ms 13 48 39s674ms 826ms 14 48 47s263ms 984ms 15 36 31s163ms 865ms 16 53 45s825ms 864ms 17 42 32s643ms 777ms 18 24 21s793ms 908ms 19 24 17s855ms 743ms 20 36 33s369ms 926ms 21 41 37s412ms 912ms 22 30 24s947ms 831ms [ User: lfriedman - Total duration: 11m33s - Times executed: 788 ]
-
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-11 07:04:12 Duration: 8s336ms Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux64-test61') AND os = 'Linux' AND arch = 'x86_64' AND osversion = '3.1.0-1.2-desktop' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 13:31:46 Duration: 3s68ms 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-11 13:58:17 Duration: 2s721ms Database: nightly User: lfriedman
8 6m25s 564 300ms 9s370ms 684ms update gpu set daemon_update = now(), activated = ? where system = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 11 04 139 1m24s 611ms 05 151 1m35s 631ms 06 174 2m17s 788ms 07 32 17s886ms 558ms 08 28 16s730ms 597ms 09 16 19s796ms 1s237ms 12 8 3s711ms 463ms 14 2 1s88ms 544ms 15 4 1s912ms 478ms 16 1 373ms 373ms 22 9 6s808ms 756ms [ User: lfriedman - Total duration: 6m25s - Times executed: 564 ]
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs24';
Date: 2012-12-11 07:20:23 Duration: 9s370ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win7-cvs2';
Date: 2012-12-11 07:21:28 Duration: 9s270ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs19';
Date: 2012-12-11 10:49:46 Duration: 6s666ms Database: nightly User: lfriedman
9 6m19s 536 300ms 8s616ms 707ms update gpu set daemon_update = now() where system = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 11 04 140 1m34s 671ms 05 151 1m32s 615ms 06 165 2m26s 888ms 07 27 16s623ms 615ms 08 24 12s703ms 529ms 09 8 3s889ms 486ms 12 10 6s814ms 681ms 13 1 367ms 367ms 15 1 300ms 300ms 17 1 315ms 315ms 22 8 4s711ms 588ms [ User: lfriedman - Total duration: 6m19s - Times executed: 536 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-cvs1';
Date: 2012-12-11 07:20:22 Duration: 8s616ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-cvs9';
Date: 2012-12-11 07:20:39 Duration: 4s668ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-cvs24';
Date: 2012-12-11 07:20:39 Duration: 4s663ms Database: nightly User: lfriedman
10 5m49s 441 300ms 8s362ms 793ms 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 11 04 26 21s771ms 837ms 05 70 51s662ms 738ms 06 174 2m38s 913ms 07 54 33s409ms 618ms 08 50 34s545ms 690ms 09 36 26s522ms 736ms 12 10 5s958ms 595ms 13 2 1s868ms 934ms 14 1 625ms 625ms 15 6 3s114ms 519ms 17 1 350ms 350ms 18 1 714ms 714ms 19 3 1s536ms 512ms 22 7 8s871ms 1s267ms [ User: lfriedman - Total duration: 5m49s - Times executed: 441 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac-gputest4'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac-gputest4';
Date: 2012-12-11 07:20:23 Duration: 8s362ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test21'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-linux32-test21';
Date: 2012-12-11 07:21:29 Duration: 7s484ms 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-11 10:50:30 Duration: 5s609ms Database: nightly User: lfriedman
11 4m9s 623 300ms 1s814ms 400ms select count(id) from thrusttests where regressioncl = ? and current_status = ? and (active is null or active = ?) and os = ? and arch = ? and osversion = ? and branch = ? and (gpu = ? or gpu = ?) and age(now(), last_update) < interval ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 11 23 42 16s644ms 396ms 00 44 17s58ms 387ms 01 41 16s159ms 394ms 02 19 7s391ms 389ms 03 1 390ms 390ms 04 2 2s201ms 1s100ms 05 9 4s195ms 466ms 06 12 4s747ms 395ms 07 27 11s56ms 409ms 08 46 18s320ms 398ms 09 31 12s294ms 396ms 10 29 12s243ms 422ms 11 37 14s613ms 394ms 12 28 12s91ms 431ms 13 31 12s298ms 396ms 14 27 10s906ms 403ms 15 35 13s841ms 395ms 16 37 14s903ms 402ms 17 27 10s783ms 399ms 18 19 6s940ms 365ms 19 27 10s133ms 375ms 20 23 9s161ms 398ms 21 9 3s535ms 392ms 22 20 7s846ms 392ms [ User: lfriedman - Total duration: 4m9s - Times executed: 623 ]
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win764-test5') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 05:33:32 Duration: 1s814ms Database: nightly User: lfriedman
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win32-test8') AND os = 'WINXP' AND arch = 'i686' AND osversion = 'WINXP' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 13:30:51 Duration: 1s459ms Database: nightly User: lfriedman
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win764-test49') 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-11 06:51:08 Duration: 943ms Database: nightly User: lfriedman
12 2m33s 15 465ms 1m25s 10s216ms select count(id) from cudasmoketests 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 11 05 1 1s616ms 1s616ms 06 6 2m22s 23s768ms 07 1 502ms 502ms 08 2 5s30ms 2s515ms 10 2 1s660ms 830ms 11 1 484ms 484ms 16 1 869ms 869ms 19 1 465ms 465ms [ User: lfriedman - Total duration: 2m33s - Times executed: 15 ]
-
SELECT count(id) FROM cudasmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win7-test31') AND os = 'WIN7' AND arch = 'i686' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 07:26:20 Duration: 1m25s Database: nightly User: lfriedman
-
SELECT count(id) FROM cudasmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac64-test4') AND os = 'Darwin' AND arch = 'x86_64' 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-11 07:25:45 Duration: 49s226ms Database: nightly User: lfriedman
-
SELECT count(id) FROM cudasmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux32-test47') AND os = 'Linux' AND arch = 'i686' AND osversion = '2.6.32-279.el6.i686' AND branch = 'cuda_a' AND (gpu = '307' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 07:26:20 Duration: 3s971ms Database: nightly User: lfriedman
13 2m17s 182 303ms 5s936ms 753ms 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 11 04 18 13s820ms 767ms 05 30 18s597ms 619ms 06 61 45s136ms 739ms 07 18 11s534ms 640ms 08 16 10s366ms 647ms 09 25 28s728ms 1s149ms 10 1 450ms 450ms 12 7 5s625ms 803ms 14 2 746ms 373ms 15 1 621ms 621ms 17 1 639ms 639ms 22 2 857ms 428ms [ User: lfriedman - Total duration: 2m17s - Times executed: 182 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win864-test10'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win864-test10';
Date: 2012-12-11 10:49:56 Duration: 5s936ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test6'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test6';
Date: 2012-12-11 10:49:51 Duration: 4s304ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test32'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test32';
Date: 2012-12-11 07:20:23 Duration: 3s859ms Database: nightly User: lfriedman
14 1m47s 108 304ms 8s292ms 996ms 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 11 04 22 13s272ms 603ms 05 22 13s117ms 596ms 06 12 17s582ms 1s465ms 07 10 6s893ms 689ms 08 3 1s868ms 622ms 09 15 28s993ms 1s932ms 10 1 621ms 621ms 13 2 906ms 453ms 15 9 4s438ms 493ms 16 1 680ms 680ms 17 2 661ms 330ms 19 4 4s485ms 1s121ms 22 5 14s61ms 2s812ms [ User: lfriedman - Total duration: 1m47s - Times executed: 108 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-test28' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-11 23:58:42 Duration: 8s292ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac64-test3' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-11 10:49:41 Duration: 7s789ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-test12' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-11 10:49:41 Duration: 6s669ms Database: nightly User: lfriedman
15 1m41s 10 309ms 1m20s 10s110ms select count(id) from cublassmoketests 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 #15
Day Hour Count Duration Avg duration Dec 11 05 2 804ms 402ms 06 2 10s326ms 5s163ms 08 1 1m20s 1m20s 09 1 7s747ms 7s747ms 12 1 710ms 710ms 14 1 367ms 367ms 18 1 417ms 417ms 19 1 309ms 309ms [ User: lfriedman - Total duration: 1m41s - Times executed: 10 ]
-
SELECT count(id) FROM cublassmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win764-test32') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 09:31:41 Duration: 1m20s Database: nightly User: lfriedman
-
SELECT count(id) FROM cublassmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac-test2') 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-11 07:13:34 Duration: 9s892ms Database: nightly User: lfriedman
-
SELECT count(id) FROM cublassmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac64-test13') AND os = 'Darwin' AND arch = 'x86_64' AND osversion = '10.8' AND branch = 'cuda_a' AND (gpu = '304' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 10:00:28 Duration: 7s747ms Database: nightly User: lfriedman
16 1m30s 12 308ms 58s994ms 7s519ms select testname from thrusttests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 11 07 3 979ms 326ms 09 4 14s14ms 3s503ms 22 5 1m15s 15s48ms [ User: lfriedman - Total duration: 1m30s - Times executed: 12 ]
-
SELECT testname FROM thrusttests WHERE suiteid = '105462' AND current_status = 'FAILED' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 23:59:02 Duration: 58s994ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname FROM thrusttests WHERE suiteid = '105525' AND current_status = 'FAILED' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 23:59:19 Duration: 13s237ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname FROM thrusttests WHERE suiteid = '105467' AND current_status = 'FAILED' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 10:00:03 Duration: 7s701ms Database: nightly User: lfriedman Bind query: yes
17 1m27s 55 311ms 7s135ms 1s597ms select testname from nppsmoketests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 11 07 19 34s364ms 1s808ms 10 11 30s45ms 2s731ms 17 25 23s451ms 938ms [ User: lfriedman - Total duration: 1m27s - Times executed: 55 ]
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4637' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 11:21:11 Duration: 7s135ms Database: pvs User: lfriedman Bind query: yes
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 08:41:26 Duration: 5s770ms Database: pvs User: lfriedman Bind query: yes
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 11:20:52 Duration: 5s203ms Database: pvs User: lfriedman Bind query: yes
18 1m21s 104 300ms 5s469ms 779ms 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 #18
Day Hour Count Duration Avg duration Dec 11 04 9 8s515ms 946ms 05 3 1s91ms 363ms 06 31 15s67ms 486ms 07 32 20s806ms 650ms 08 6 3s542ms 590ms 09 4 4s747ms 1s186ms 14 1 581ms 581ms 15 6 4s388ms 731ms 17 3 1s577ms 525ms 19 3 1s867ms 622ms 22 6 18s835ms 3s139ms [ User: lfriedman - Total duration: 1m21s - Times executed: 104 ]
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('oclappstests') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-11 23:58:16 Duration: 5s469ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('ddtracker') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-11 23:59:10 Duration: 4s184ms Database: inventory User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('smoke32on64tests') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-11 23:58:24 Duration: 3s836ms Database: nightly User: lfriedman
19 1m17s 57 329ms 9s547ms 1s365ms select testname, category, bug from filterout where os = ? and osversion = ? and arch = ? and gpu = ? and branch = ? and build = ? and vc = ? and script = ? and active = ? and last_update = ? and farm = ? order by testname;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 11 02 4 2s455ms 613ms 05 2 5s769ms 2s884ms 07 16 24s374ms 1s523ms 08 6 8s6ms 1s334ms 11 1 393ms 393ms 17 21 24s300ms 1s157ms 21 1 370ms 370ms 22 6 12s137ms 2s22ms [ User: lfriedman - Total duration: 1m17s - Times executed: 57 ]
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.i686' AND arch = 'i686' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'samples.sh' AND active = 't' AND last_update = '2012-12-11' AND farm = '0' ORDER BY testname;
Date: 2012-12-11 08:40:00 Duration: 9s547ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.x86_64' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'nvprof_32on64.sh' AND active = 't' AND last_update = '2012-12-11' AND farm = '0' ORDER BY testname;
Date: 2012-12-11 23:57:55 Duration: 7s813ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.i686' AND arch = 'i686' AND gpu = '307' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'viper.sh' AND active = 't' AND last_update = '2012-12-11' AND farm = '0' ORDER BY testname;
Date: 2012-12-11 09:59:54 Duration: 5s488ms Database: nightly User: lfriedman Bind query: yes
20 59s811ms 102 306ms 2s302ms 586ms insert into regressspace (reftable, reftableid, cl, cldate, clowner) values (?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 11 04 46 27s559ms 599ms 05 55 31s902ms 580ms 06 1 350ms 350ms [ User: lfriedman - Total duration: 59s811ms - Times executed: 102 ]
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('vipertests', '121123', '14561769', '2012/12/10', 'njuffa');
Date: 2012-12-11 05:23:32 Duration: 2s302ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('vipertests', '121143', '14555619', '2012/12/09', 'rod');
Date: 2012-12-11 05:23:32 Duration: 2s205ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('vipertests', '121257', '14550429', '2012/12/07', 'builder');
Date: 2012-12-11 06:24:58 Duration: 2s79ms Database: nightly User: lfriedman
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 3,639 1h6m52s 300ms 13s887ms 1s102ms 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 11 01 6 4s326ms 721ms 04 248 2m39s 642ms 05 108 55s941ms 517ms 06 315 3m5s 587ms 07 557 6m28s 697ms 08 148 2m3s 835ms 09 965 29m35s 1s840ms 10 118 1m8s 583ms 12 11 7s563ms 687ms 13 69 38s954ms 564ms 14 119 1m7s 565ms 15 392 4m 613ms 16 51 28s205ms 553ms 17 98 49s581ms 505ms 19 85 58s108ms 683ms 22 349 12m41s 2s181ms [ User: lfriedman - Total duration: 1h6m52s - Times executed: 3639 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('nvproxytests') AND c.relpersistence = 'u';
Date: 2012-12-11 10:49:56 Duration: 13s887ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('keplercublastests') AND c.relpersistence = 'u';
Date: 2012-12-11 10:49:46 Duration: 12s137ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('dblamodeltests') AND c.relpersistence = 'u';
Date: 2012-12-11 10:49:56 Duration: 11s814ms Database: nightly User: lfriedman
2 2,371 32m34s 300ms 9s151ms 824ms 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 11 01 1 945ms 945ms 04 445 5m7s 690ms 05 452 4m47s 635ms 06 780 13m27s 1s35ms 07 166 1m48s 655ms 08 176 2m5s 714ms 09 168 2m53s 1s30ms 10 8 4s170ms 521ms 12 49 31s57ms 633ms 13 11 6s926ms 629ms 14 8 5s767ms 720ms 15 14 6s683ms 477ms 16 4 1s741ms 435ms 17 7 3s299ms 471ms 18 9 5s985ms 665ms 19 8 8s190ms 1s23ms 22 65 1m9s 1s66ms [ User: lfriedman - Total duration: 32m34s - Times executed: 2371 ]
-
UPDATE gpu SET dd_date = '2012/12/10', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win7-test23';
Date: 2012-12-11 07:20:23 Duration: 9s151ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/10', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win7-gputest6';
Date: 2012-12-11 07:20:23 Duration: 9s117ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/10', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win8-test5';
Date: 2012-12-11 07:20:23 Duration: 9s40ms Database: nightly User: lfriedman
3 1,188 16m10s 300ms 9s268ms 817ms update gpu set dd_date = ?, last_update = (date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 11 04 301 3m30s 700ms 05 313 3m28s 665ms 06 356 6m32s 1s103ms 07 78 50s826ms 651ms 08 60 39s428ms 657ms 09 32 22s647ms 707ms 12 18 11s756ms 653ms 14 3 1s961ms 653ms 15 8 4s806ms 600ms 17 1 393ms 393ms 18 2 1s493ms 746ms 19 2 1s321ms 660ms 22 14 24s194ms 1s728ms [ User: lfriedman - Total duration: 16m10s - Times executed: 1188 ]
-
UPDATE gpu SET dd_date = 'Tue Dec 11 00:43:33 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux64-cvs32';
Date: 2012-12-11 07:21:28 Duration: 9s268ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = 'Tue Dec 11 00:43:33 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux64-cvs13';
Date: 2012-12-11 07:20:23 Duration: 9s221ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = 'Mon Dec 10 07:57:21 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux64-cvs24';
Date: 2012-12-11 07:21:29 Duration: 9s121ms Database: nightly User: lfriedman
4 1,176 16m4s 671ms 3s247ms 820ms insert into proccheck (hostname, process, subtestid) values (?, ?, ?); delete from proccheck where age(now(), datestamp) > interval ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 11 23 18 14s419ms 801ms 00 21 16s868ms 803ms 01 10 8s23ms 802ms 03 250 3m17s 791ms 04 88 1m18s 886ms 05 45 40s504ms 900ms 06 44 36s841ms 837ms 07 68 58s818ms 864ms 08 87 1m15s 863ms 09 96 1m18s 815ms 10 34 27s147ms 798ms 11 11 8s851ms 804ms 12 3 2s433ms 811ms 13 15 12s154ms 810ms 14 25 20s20ms 800ms 15 16 12s845ms 802ms 16 20 16s41ms 802ms 17 21 16s823ms 801ms 18 64 51s282ms 801ms 19 60 48s234ms 803ms 20 63 50s542ms 802ms 21 57 45s657ms 801ms 22 60 48s98ms 801ms [ User: lfriedman - Total duration: 16m4s - Times executed: 1176 ]
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test17', '[thrust_test] <defunct>', '2'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-11 08:12:13 Duration: 3s247ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-mac64-test14', '/usr/libexec/xpcd', '37'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-11 09:30:40 Duration: 2s910ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux32-test51', '/home/lfriedman/cuda-stuff/sw/gpgpu/bin/i686_Linux_release/memcpy_devsys', '177'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-11 05:50:16 Duration: 2s621ms Database: nightly User: lfriedman
5 1,124 16m35s 300ms 9s97ms 885ms update systems set daemon_update = now(), activated = ? where vm = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 11 04 240 2m59s 746ms 05 295 3m11s 647ms 06 331 6m40s 1s209ms 07 69 52s771ms 764ms 08 69 43s121ms 624ms 09 64 1m12s 1s137ms 10 1 521ms 521ms 12 15 10s961ms 730ms 13 3 2s125ms 708ms 14 1 474ms 474ms 15 8 4s616ms 577ms 17 3 1s631ms 543ms 18 1 973ms 973ms 19 5 3s406ms 681ms 22 19 31s339ms 1s649ms [ User: lfriedman - Total duration: 16m35s - Times executed: 1124 ]
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-win732-build14';
Date: 2012-12-11 07:20:23 Duration: 9s97ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-linux32-build2';
Date: 2012-12-11 07:20:22 Duration: 8s837ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-mac64-build6';
Date: 2012-12-11 07:20:23 Duration: 8s469ms Database: cbs User: lfriedman
6 788 11m33s 399ms 8s336ms 879ms 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 11 23 36 29s854ms 829ms 00 37 29s480ms 796ms 01 29 24s368ms 840ms 02 35 32s82ms 916ms 03 2 883ms 441ms 04 2 1s105ms 552ms 05 3 1s637ms 545ms 06 24 27s384ms 1s141ms 07 35 30s277ms 865ms 08 31 29s385ms 947ms 09 40 38s283ms 957ms 10 37 35s930ms 971ms 11 38 32s530ms 856ms 12 57 48s175ms 845ms 13 48 39s674ms 826ms 14 48 47s263ms 984ms 15 36 31s163ms 865ms 16 53 45s825ms 864ms 17 42 32s643ms 777ms 18 24 21s793ms 908ms 19 24 17s855ms 743ms 20 36 33s369ms 926ms 21 41 37s412ms 912ms 22 30 24s947ms 831ms [ User: lfriedman - Total duration: 11m33s - Times executed: 788 ]
-
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-11 07:04:12 Duration: 8s336ms Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux64-test61') AND os = 'Linux' AND arch = 'x86_64' AND osversion = '3.1.0-1.2-desktop' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 13:31:46 Duration: 3s68ms 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-11 13:58:17 Duration: 2s721ms Database: nightly User: lfriedman
7 623 4m9s 300ms 1s814ms 400ms 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 11 23 42 16s644ms 396ms 00 44 17s58ms 387ms 01 41 16s159ms 394ms 02 19 7s391ms 389ms 03 1 390ms 390ms 04 2 2s201ms 1s100ms 05 9 4s195ms 466ms 06 12 4s747ms 395ms 07 27 11s56ms 409ms 08 46 18s320ms 398ms 09 31 12s294ms 396ms 10 29 12s243ms 422ms 11 37 14s613ms 394ms 12 28 12s91ms 431ms 13 31 12s298ms 396ms 14 27 10s906ms 403ms 15 35 13s841ms 395ms 16 37 14s903ms 402ms 17 27 10s783ms 399ms 18 19 6s940ms 365ms 19 27 10s133ms 375ms 20 23 9s161ms 398ms 21 9 3s535ms 392ms 22 20 7s846ms 392ms [ User: lfriedman - Total duration: 4m9s - Times executed: 623 ]
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win764-test5') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 05:33:32 Duration: 1s814ms Database: nightly User: lfriedman
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win32-test8') AND os = 'WINXP' AND arch = 'i686' AND osversion = 'WINXP' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 13:30:51 Duration: 1s459ms Database: nightly User: lfriedman
-
SELECT count(id) FROM thrusttests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win764-test49') 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-11 06:51:08 Duration: 943ms Database: nightly User: lfriedman
8 564 6m25s 300ms 9s370ms 684ms update gpu set daemon_update = now(), activated = ? where system = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 11 04 139 1m24s 611ms 05 151 1m35s 631ms 06 174 2m17s 788ms 07 32 17s886ms 558ms 08 28 16s730ms 597ms 09 16 19s796ms 1s237ms 12 8 3s711ms 463ms 14 2 1s88ms 544ms 15 4 1s912ms 478ms 16 1 373ms 373ms 22 9 6s808ms 756ms [ User: lfriedman - Total duration: 6m25s - Times executed: 564 ]
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs24';
Date: 2012-12-11 07:20:23 Duration: 9s370ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win7-cvs2';
Date: 2012-12-11 07:21:28 Duration: 9s270ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs19';
Date: 2012-12-11 10:49:46 Duration: 6s666ms Database: nightly User: lfriedman
9 536 6m19s 300ms 8s616ms 707ms update gpu set daemon_update = now() where system = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 11 04 140 1m34s 671ms 05 151 1m32s 615ms 06 165 2m26s 888ms 07 27 16s623ms 615ms 08 24 12s703ms 529ms 09 8 3s889ms 486ms 12 10 6s814ms 681ms 13 1 367ms 367ms 15 1 300ms 300ms 17 1 315ms 315ms 22 8 4s711ms 588ms [ User: lfriedman - Total duration: 6m19s - Times executed: 536 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-cvs1';
Date: 2012-12-11 07:20:22 Duration: 8s616ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-cvs9';
Date: 2012-12-11 07:20:39 Duration: 4s668ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-cvs24';
Date: 2012-12-11 07:20:39 Duration: 4s663ms Database: nightly User: lfriedman
10 441 5m49s 300ms 8s362ms 793ms 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 11 04 26 21s771ms 837ms 05 70 51s662ms 738ms 06 174 2m38s 913ms 07 54 33s409ms 618ms 08 50 34s545ms 690ms 09 36 26s522ms 736ms 12 10 5s958ms 595ms 13 2 1s868ms 934ms 14 1 625ms 625ms 15 6 3s114ms 519ms 17 1 350ms 350ms 18 1 714ms 714ms 19 3 1s536ms 512ms 22 7 8s871ms 1s267ms [ User: lfriedman - Total duration: 5m49s - Times executed: 441 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac-gputest4'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac-gputest4';
Date: 2012-12-11 07:20:23 Duration: 8s362ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test21'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-linux32-test21';
Date: 2012-12-11 07:21:29 Duration: 7s484ms 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-11 10:50:30 Duration: 5s609ms Database: nightly User: lfriedman
11 182 2m17s 303ms 5s936ms 753ms 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 11 04 18 13s820ms 767ms 05 30 18s597ms 619ms 06 61 45s136ms 739ms 07 18 11s534ms 640ms 08 16 10s366ms 647ms 09 25 28s728ms 1s149ms 10 1 450ms 450ms 12 7 5s625ms 803ms 14 2 746ms 373ms 15 1 621ms 621ms 17 1 639ms 639ms 22 2 857ms 428ms [ User: lfriedman - Total duration: 2m17s - Times executed: 182 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win864-test10'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win864-test10';
Date: 2012-12-11 10:49:56 Duration: 5s936ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test6'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test6';
Date: 2012-12-11 10:49:51 Duration: 4s304ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test32'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test32';
Date: 2012-12-11 07:20:23 Duration: 3s859ms Database: nightly User: lfriedman
12 108 1m47s 304ms 8s292ms 996ms update gpu set daemon_update = now() where system = ? and age(now(), daemon_update) > interval ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 11 04 22 13s272ms 603ms 05 22 13s117ms 596ms 06 12 17s582ms 1s465ms 07 10 6s893ms 689ms 08 3 1s868ms 622ms 09 15 28s993ms 1s932ms 10 1 621ms 621ms 13 2 906ms 453ms 15 9 4s438ms 493ms 16 1 680ms 680ms 17 2 661ms 330ms 19 4 4s485ms 1s121ms 22 5 14s61ms 2s812ms [ User: lfriedman - Total duration: 1m47s - Times executed: 108 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-test28' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-11 23:58:42 Duration: 8s292ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac64-test3' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-11 10:49:41 Duration: 7s789ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-test12' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-11 10:49:41 Duration: 6s669ms Database: nightly User: lfriedman
13 104 1m21s 300ms 5s469ms 779ms 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 11 04 9 8s515ms 946ms 05 3 1s91ms 363ms 06 31 15s67ms 486ms 07 32 20s806ms 650ms 08 6 3s542ms 590ms 09 4 4s747ms 1s186ms 14 1 581ms 581ms 15 6 4s388ms 731ms 17 3 1s577ms 525ms 19 3 1s867ms 622ms 22 6 18s835ms 3s139ms [ User: lfriedman - Total duration: 1m21s - Times executed: 104 ]
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('oclappstests') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-11 23:58:16 Duration: 5s469ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('ddtracker') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-11 23:59:10 Duration: 4s184ms Database: inventory User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('smoke32on64tests') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-11 23:58:24 Duration: 3s836ms Database: nightly User: lfriedman
14 102 59s811ms 306ms 2s302ms 586ms insert into regressspace (reftable, reftableid, cl, cldate, clowner) values (?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 11 04 46 27s559ms 599ms 05 55 31s902ms 580ms 06 1 350ms 350ms [ User: lfriedman - Total duration: 59s811ms - Times executed: 102 ]
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('vipertests', '121123', '14561769', '2012/12/10', 'njuffa');
Date: 2012-12-11 05:23:32 Duration: 2s302ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('vipertests', '121143', '14555619', '2012/12/09', 'rod');
Date: 2012-12-11 05:23:32 Duration: 2s205ms Database: nightly User: lfriedman
-
INSERT INTO regressspace (reftable, reftableid, cl, cldate, clowner) VALUES ('vipertests', '121257', '14550429', '2012/12/07', 'builder');
Date: 2012-12-11 06:24:58 Duration: 2s79ms Database: nightly User: lfriedman
15 68 55s972ms 301ms 4s405ms 823ms update gpu set daemon_update = now(), running = ? where system = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 11 04 18 13s274ms 737ms 05 14 9s403ms 671ms 06 17 14s368ms 845ms 08 3 1s320ms 440ms 09 2 1s258ms 629ms 12 5 4s141ms 828ms 17 1 315ms 315ms 19 1 346ms 346ms 22 7 11s543ms 1s649ms [ User: lfriedman - Total duration: 55s972ms - Times executed: 68 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win764-test22';
Date: 2012-12-11 23:58:22 Duration: 4s405ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win764-test22';
Date: 2012-12-11 07:19:29 Duration: 4s246ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac-test0';
Date: 2012-12-11 23:58:20 Duration: 3s545ms Database: nightly User: lfriedman
16 57 1m17s 329ms 9s547ms 1s365ms select testname, category, bug from filterout where os = ? and osversion = ? and arch = ? and gpu = ? and branch = ? and build = ? and vc = ? and script = ? and active = ? and last_update = ? and farm = ? order by testname;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 11 02 4 2s455ms 613ms 05 2 5s769ms 2s884ms 07 16 24s374ms 1s523ms 08 6 8s6ms 1s334ms 11 1 393ms 393ms 17 21 24s300ms 1s157ms 21 1 370ms 370ms 22 6 12s137ms 2s22ms [ User: lfriedman - Total duration: 1m17s - Times executed: 57 ]
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.i686' AND arch = 'i686' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'samples.sh' AND active = 't' AND last_update = '2012-12-11' AND farm = '0' ORDER BY testname;
Date: 2012-12-11 08:40:00 Duration: 9s547ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.x86_64' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'nvprof_32on64.sh' AND active = 't' AND last_update = '2012-12-11' AND farm = '0' ORDER BY testname;
Date: 2012-12-11 23:57:55 Duration: 7s813ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.i686' AND arch = 'i686' AND gpu = '307' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'viper.sh' AND active = 't' AND last_update = '2012-12-11' AND farm = '0' ORDER BY testname;
Date: 2012-12-11 09:59:54 Duration: 5s488ms Database: nightly User: lfriedman Bind query: yes
17 55 1m27s 311ms 7s135ms 1s597ms select testname from nppsmoketests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 11 07 19 34s364ms 1s808ms 10 11 30s45ms 2s731ms 17 25 23s451ms 938ms [ User: lfriedman - Total duration: 1m27s - Times executed: 55 ]
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4637' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 11:21:11 Duration: 7s135ms Database: pvs User: lfriedman Bind query: yes
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 08:41:26 Duration: 5s770ms Database: pvs User: lfriedman Bind query: yes
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 11:20:52 Duration: 5s203ms Database: pvs User: lfriedman Bind query: yes
18 50 29s681ms 300ms 2s56ms 593ms 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 #18
Day Hour Count Duration Avg duration Dec 11 05 29 15s880ms 547ms 07 5 2s704ms 540ms 09 14 9s698ms 692ms 16 1 493ms 493ms 18 1 904ms 904ms [ User: lfriedman - Total duration: 29s681ms - Times executed: 50 ]
-
UPDATE disks SET update = date_trunc('second', now()), size = '724', used = '47' WHERE hostname = 'cuda-linux64-cvs31'; INSERT into disks (hostname, size, used, update) ( select 'cuda-linux64-cvs31', '724', '47', date_trunc('second', now()) WHERE NOT EXISTS ( select 1 FROM disks WHERE hostname = 'cuda-linux64-cvs31'));
Date: 2012-12-11 06:00:30 Duration: 2s56ms Database: inventory User: lfriedman
-
UPDATE disks SET update = date_trunc('second', now()), size = '243', used = '51' WHERE hostname = 'cuda-linux64-test41'; INSERT into disks (hostname, size, used, update) ( select 'cuda-linux64-test41', '243', '51', date_trunc('second', now()) WHERE NOT EXISTS ( select 1 FROM disks WHERE hostname = 'cuda-linux64-test41'));
Date: 2012-12-11 06:00:44 Duration: 1s752ms Database: inventory User: lfriedman
-
UPDATE disks SET update = date_trunc('second', now()), size = '155', used = '47' WHERE hostname = 'cuda-linux32-cvs0'; INSERT into disks (hostname, size, used, update) ( select 'cuda-linux32-cvs0', '155', '47', date_trunc('second', now()) WHERE NOT EXISTS ( select 1 FROM disks WHERE hostname = 'cuda-linux32-cvs0'));
Date: 2012-12-11 10:00:03 Duration: 1s681ms Database: inventory User: lfriedman
19 50 26s716ms 300ms 1s663ms 534ms delete from cuhc where system = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 11 04 12 6s983ms 581ms 05 6 2s892ms 482ms 06 4 1s403ms 350ms 07 12 6s861ms 571ms 09 1 413ms 413ms 14 1 481ms 481ms 15 8 3s664ms 458ms 16 2 1s535ms 767ms 17 3 1s325ms 441ms 19 1 1s155ms 1s155ms [ User: lfriedman - Total duration: 26s716ms - Times executed: 50 ]
-
DELETE FROM cuhc WHERE system = 'cuda-linux32-cvs3';
Date: 2012-12-11 05:57:15 Duration: 1s663ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-win764-cvs1';
Date: 2012-12-11 08:42:22 Duration: 1s245ms Database: inventory User: lfriedman
-
DELETE FROM cuhc WHERE system = 'cuda-win32-test0';
Date: 2012-12-11 20:02:12 Duration: 1s155ms Database: inventory User: lfriedman
20 49 28s988ms 322ms 1s647ms 591ms delete from tests where id = ? and active = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 11 04 18 10s301ms 572ms 05 20 11s3ms 550ms 06 11 7s682ms 698ms [ User: lfriedman - Total duration: 28s988ms - Times executed: 49 ]
-
DELETE FROM tests WHERE id = '2423465' AND active = 'cuda-linux32-test33';
Date: 2012-12-11 07:20:39 Duration: 1s647ms Database: nightly User: lfriedman
-
DELETE FROM tests WHERE id = '2422895' AND active = 'cuda-win32-test13';
Date: 2012-12-11 06:24:51 Duration: 1s109ms Database: nightly User: lfriedman
-
DELETE FROM tests WHERE id = '2422421' AND active = 'cuda-win7-test1';
Date: 2012-12-11 07:20:45 Duration: 1s49ms Database: nightly User: lfriedman
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1m7s 3m8s 1m39s 45 1h14m46s 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 11 04 11 19m3s 1m43s 05 7 13m18s 1m54s 06 10 19m20s 1m56s 07 4 6m2s 1m30s 08 6 8m5s 1m20s 09 1 1m19s 1m19s 12 2 2m35s 1m17s 13 1 1m13s 1m13s 15 2 2m39s 1m19s 17 1 1m7s 1m7s [ User: lfriedman - Total duration: 1h14m46s - Times executed: 45 ]
-
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-11 07:21:40 Duration: 3m8s 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-11 05:51:12 Duration: 2m37s 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-11 06:29:12 Duration: 2m30s Database: pvs User: lfriedman
2 465ms 1m25s 10s216ms 15 2m33s select count(id) from cudasmoketests 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 #2
Day Hour Count Duration Avg duration Dec 11 05 1 1s616ms 1s616ms 06 6 2m22s 23s768ms 07 1 502ms 502ms 08 2 5s30ms 2s515ms 10 2 1s660ms 830ms 11 1 484ms 484ms 16 1 869ms 869ms 19 1 465ms 465ms [ User: lfriedman - Total duration: 2m33s - Times executed: 15 ]
-
SELECT count(id) FROM cudasmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win7-test31') AND os = 'WIN7' AND arch = 'i686' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 07:26:20 Duration: 1m25s Database: nightly User: lfriedman
-
SELECT count(id) FROM cudasmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac64-test4') AND os = 'Darwin' AND arch = 'x86_64' 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-11 07:25:45 Duration: 49s226ms Database: nightly User: lfriedman
-
SELECT count(id) FROM cudasmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux32-test47') AND os = 'Linux' AND arch = 'i686' AND osversion = '2.6.32-279.el6.i686' AND branch = 'cuda_a' AND (gpu = '307' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 07:26:20 Duration: 3s971ms Database: nightly User: lfriedman
3 309ms 1m20s 10s110ms 10 1m41s select count(id) from cublassmoketests 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 #3
Day Hour Count Duration Avg duration Dec 11 05 2 804ms 402ms 06 2 10s326ms 5s163ms 08 1 1m20s 1m20s 09 1 7s747ms 7s747ms 12 1 710ms 710ms 14 1 367ms 367ms 18 1 417ms 417ms 19 1 309ms 309ms [ User: lfriedman - Total duration: 1m41s - Times executed: 10 ]
-
SELECT count(id) FROM cublassmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-win764-test32') AND os = 'WIN7' AND arch = 'x86_64' AND osversion = 'WIN7' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 09:31:41 Duration: 1m20s Database: nightly User: lfriedman
-
SELECT count(id) FROM cublassmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac-test2') 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-11 07:13:34 Duration: 9s892ms Database: nightly User: lfriedman
-
SELECT count(id) FROM cublassmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-mac64-test13') AND os = 'Darwin' AND arch = 'x86_64' AND osversion = '10.8' AND branch = 'cuda_a' AND (gpu = '304' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 10:00:28 Duration: 7s747ms Database: nightly User: lfriedman
4 308ms 58s994ms 7s519ms 12 1m30s select testname from thrusttests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 11 07 3 979ms 326ms 09 4 14s14ms 3s503ms 22 5 1m15s 15s48ms [ User: lfriedman - Total duration: 1m30s - Times executed: 12 ]
-
SELECT testname FROM thrusttests WHERE suiteid = '105462' AND current_status = 'FAILED' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 23:59:02 Duration: 58s994ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname FROM thrusttests WHERE suiteid = '105525' AND current_status = 'FAILED' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 23:59:19 Duration: 13s237ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname FROM thrusttests WHERE suiteid = '105467' AND current_status = 'FAILED' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 10:00:03 Duration: 7s701ms Database: nightly User: lfriedman Bind query: yes
5 311ms 7s135ms 1s597ms 55 1m27s select testname from nppsmoketests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 11 07 19 34s364ms 1s808ms 10 11 30s45ms 2s731ms 17 25 23s451ms 938ms [ User: lfriedman - Total duration: 1m27s - Times executed: 55 ]
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4637' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 11:21:11 Duration: 7s135ms Database: pvs User: lfriedman Bind query: yes
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 08:41:26 Duration: 5s770ms Database: pvs User: lfriedman Bind query: yes
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-11 11:20:52 Duration: 5s203ms Database: pvs User: lfriedman Bind query: yes
6 329ms 9s547ms 1s365ms 57 1m17s select testname, category, bug from filterout where os = ? and osversion = ? and arch = ? and gpu = ? and branch = ? and build = ? and vc = ? and script = ? and active = ? and last_update = ? and farm = ? order by testname;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 11 02 4 2s455ms 613ms 05 2 5s769ms 2s884ms 07 16 24s374ms 1s523ms 08 6 8s6ms 1s334ms 11 1 393ms 393ms 17 21 24s300ms 1s157ms 21 1 370ms 370ms 22 6 12s137ms 2s22ms [ User: lfriedman - Total duration: 1m17s - Times executed: 57 ]
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.i686' AND arch = 'i686' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'samples.sh' AND active = 't' AND last_update = '2012-12-11' AND farm = '0' ORDER BY testname;
Date: 2012-12-11 08:40:00 Duration: 9s547ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.x86_64' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'nvprof_32on64.sh' AND active = 't' AND last_update = '2012-12-11' AND farm = '0' ORDER BY testname;
Date: 2012-12-11 23:57:55 Duration: 7s813ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Linux' AND osversion = '2.6.32-279.el6.i686' AND arch = 'i686' AND gpu = '307' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'viper.sh' AND active = 't' AND last_update = '2012-12-11' AND farm = '0' ORDER BY testname;
Date: 2012-12-11 09:59:54 Duration: 5s488ms Database: nightly User: lfriedman Bind query: yes
7 300ms 13s887ms 1s102ms 3,639 1h6m52s select count(*) from pg_catalog.pg_class as c where c.oid = pgpool_regclass (?) and c.relpersistence = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 11 01 6 4s326ms 721ms 04 248 2m39s 642ms 05 108 55s941ms 517ms 06 315 3m5s 587ms 07 557 6m28s 697ms 08 148 2m3s 835ms 09 965 29m35s 1s840ms 10 118 1m8s 583ms 12 11 7s563ms 687ms 13 69 38s954ms 564ms 14 119 1m7s 565ms 15 392 4m 613ms 16 51 28s205ms 553ms 17 98 49s581ms 505ms 19 85 58s108ms 683ms 22 349 12m41s 2s181ms [ User: lfriedman - Total duration: 1h6m52s - Times executed: 3639 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('nvproxytests') AND c.relpersistence = 'u';
Date: 2012-12-11 10:49:56 Duration: 13s887ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('keplercublastests') AND c.relpersistence = 'u';
Date: 2012-12-11 10:49:46 Duration: 12s137ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('dblamodeltests') AND c.relpersistence = 'u';
Date: 2012-12-11 10:49:56 Duration: 11s814ms Database: nightly User: lfriedman
8 304ms 8s292ms 996ms 108 1m47s update gpu set daemon_update = now() where system = ? and age(now(), daemon_update) > interval ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 11 04 22 13s272ms 603ms 05 22 13s117ms 596ms 06 12 17s582ms 1s465ms 07 10 6s893ms 689ms 08 3 1s868ms 622ms 09 15 28s993ms 1s932ms 10 1 621ms 621ms 13 2 906ms 453ms 15 9 4s438ms 493ms 16 1 680ms 680ms 17 2 661ms 330ms 19 4 4s485ms 1s121ms 22 5 14s61ms 2s812ms [ User: lfriedman - Total duration: 1m47s - Times executed: 108 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-test28' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-11 23:58:42 Duration: 8s292ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-mac64-test3' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-11 10:49:41 Duration: 7s789ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-test12' AND age(now(), daemon_update) > INTERVAL '15 minutes';
Date: 2012-12-11 10:49:41 Duration: 6s669ms Database: nightly User: lfriedman
9 300ms 9s97ms 885ms 1,124 16m35s update systems set daemon_update = now(), activated = ? where vm = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 11 04 240 2m59s 746ms 05 295 3m11s 647ms 06 331 6m40s 1s209ms 07 69 52s771ms 764ms 08 69 43s121ms 624ms 09 64 1m12s 1s137ms 10 1 521ms 521ms 12 15 10s961ms 730ms 13 3 2s125ms 708ms 14 1 474ms 474ms 15 8 4s616ms 577ms 17 3 1s631ms 543ms 18 1 973ms 973ms 19 5 3s406ms 681ms 22 19 31s339ms 1s649ms [ User: lfriedman - Total duration: 16m35s - Times executed: 1124 ]
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-win732-build14';
Date: 2012-12-11 07:20:23 Duration: 9s97ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-linux32-build2';
Date: 2012-12-11 07:20:22 Duration: 8s837ms Database: cbs User: lfriedman
-
UPDATE systems SET daemon_update = now(), activated = '1' WHERE vm = 'cuda-mac64-build6';
Date: 2012-12-11 07:20:23 Duration: 8s469ms Database: cbs User: lfriedman
10 399ms 8s336ms 879ms 788 11m33s 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 #10
Day Hour Count Duration Avg duration Dec 11 23 36 29s854ms 829ms 00 37 29s480ms 796ms 01 29 24s368ms 840ms 02 35 32s82ms 916ms 03 2 883ms 441ms 04 2 1s105ms 552ms 05 3 1s637ms 545ms 06 24 27s384ms 1s141ms 07 35 30s277ms 865ms 08 31 29s385ms 947ms 09 40 38s283ms 957ms 10 37 35s930ms 971ms 11 38 32s530ms 856ms 12 57 48s175ms 845ms 13 48 39s674ms 826ms 14 48 47s263ms 984ms 15 36 31s163ms 865ms 16 53 45s825ms 864ms 17 42 32s643ms 777ms 18 24 21s793ms 908ms 19 24 17s855ms 743ms 20 36 33s369ms 926ms 21 41 37s412ms 912ms 22 30 24s947ms 831ms [ User: lfriedman - Total duration: 11m33s - Times executed: 788 ]
-
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-11 07:04:12 Duration: 8s336ms Database: nightly User: lfriedman
-
SELECT count(id) FROM nppsmoketests WHERE regressioncl = '0' AND current_status = 'FAILED' AND (active IS NULL OR active = 'cuda-linux64-test61') AND os = 'Linux' AND arch = 'x86_64' AND osversion = '3.1.0-1.2-desktop' AND branch = 'cuda_a' AND (gpu = '200' OR gpu = 'H') AND age(now(), last_update) < INTERVAL '24 hours';
Date: 2012-12-11 13:31:46 Duration: 3s68ms 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-11 13:58:17 Duration: 2s721ms Database: nightly User: lfriedman
11 300ms 9s151ms 824ms 2,371 32m34s update gpu set dd_date = ?, last_update = ( select date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 11 01 1 945ms 945ms 04 445 5m7s 690ms 05 452 4m47s 635ms 06 780 13m27s 1s35ms 07 166 1m48s 655ms 08 176 2m5s 714ms 09 168 2m53s 1s30ms 10 8 4s170ms 521ms 12 49 31s57ms 633ms 13 11 6s926ms 629ms 14 8 5s767ms 720ms 15 14 6s683ms 477ms 16 4 1s741ms 435ms 17 7 3s299ms 471ms 18 9 5s985ms 665ms 19 8 8s190ms 1s23ms 22 65 1m9s 1s66ms [ User: lfriedman - Total duration: 32m34s - Times executed: 2371 ]
-
UPDATE gpu SET dd_date = '2012/12/10', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win7-test23';
Date: 2012-12-11 07:20:23 Duration: 9s151ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/10', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win7-gputest6';
Date: 2012-12-11 07:20:23 Duration: 9s117ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = '2012/12/10', last_update = ( SELECT date_trunc('second', now())) WHERE system = 'cuda-win8-test5';
Date: 2012-12-11 07:20:23 Duration: 9s40ms Database: nightly User: lfriedman
12 301ms 4s405ms 823ms 68 55s972ms update gpu set daemon_update = now(), running = ? where system = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 11 04 18 13s274ms 737ms 05 14 9s403ms 671ms 06 17 14s368ms 845ms 08 3 1s320ms 440ms 09 2 1s258ms 629ms 12 5 4s141ms 828ms 17 1 315ms 315ms 19 1 346ms 346ms 22 7 11s543ms 1s649ms [ User: lfriedman - Total duration: 55s972ms - Times executed: 68 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win764-test22';
Date: 2012-12-11 23:58:22 Duration: 4s405ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win764-test22';
Date: 2012-12-11 07:19:29 Duration: 4s246ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac-test0';
Date: 2012-12-11 23:58:20 Duration: 3s545ms Database: nightly User: lfriedman
13 671ms 3s247ms 820ms 1,176 16m4s insert into proccheck (hostname, process, subtestid) values (?, ?, ?); delete from proccheck where age(now(), datestamp) > interval ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 11 23 18 14s419ms 801ms 00 21 16s868ms 803ms 01 10 8s23ms 802ms 03 250 3m17s 791ms 04 88 1m18s 886ms 05 45 40s504ms 900ms 06 44 36s841ms 837ms 07 68 58s818ms 864ms 08 87 1m15s 863ms 09 96 1m18s 815ms 10 34 27s147ms 798ms 11 11 8s851ms 804ms 12 3 2s433ms 811ms 13 15 12s154ms 810ms 14 25 20s20ms 800ms 15 16 12s845ms 802ms 16 20 16s41ms 802ms 17 21 16s823ms 801ms 18 64 51s282ms 801ms 19 60 48s234ms 803ms 20 63 50s542ms 802ms 21 57 45s657ms 801ms 22 60 48s98ms 801ms [ User: lfriedman - Total duration: 16m4s - Times executed: 1176 ]
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux64-test17', '[thrust_test] <defunct>', '2'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-11 08:12:13 Duration: 3s247ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-mac64-test14', '/usr/libexec/xpcd', '37'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-11 09:30:40 Duration: 2s910ms Database: nightly User: lfriedman
-
INSERT INTO proccheck (hostname, process, subtestid) VALUES ('cuda-linux32-test51', '/home/lfriedman/cuda-stuff/sw/gpgpu/bin/i686_Linux_release/memcpy_devsys', '177'); DELETE FROM proccheck WHERE age(now(), datestamp) > INTERVAL '12 months';
Date: 2012-12-11 05:50:16 Duration: 2s621ms Database: nightly User: lfriedman
14 300ms 9s268ms 817ms 1,188 16m10s update gpu set dd_date = ?, last_update = (date_trunc(?, now())) where system = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 11 04 301 3m30s 700ms 05 313 3m28s 665ms 06 356 6m32s 1s103ms 07 78 50s826ms 651ms 08 60 39s428ms 657ms 09 32 22s647ms 707ms 12 18 11s756ms 653ms 14 3 1s961ms 653ms 15 8 4s806ms 600ms 17 1 393ms 393ms 18 2 1s493ms 746ms 19 2 1s321ms 660ms 22 14 24s194ms 1s728ms [ User: lfriedman - Total duration: 16m10s - Times executed: 1188 ]
-
UPDATE gpu SET dd_date = 'Tue Dec 11 00:43:33 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux64-cvs32';
Date: 2012-12-11 07:21:28 Duration: 9s268ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = 'Tue Dec 11 00:43:33 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux64-cvs13';
Date: 2012-12-11 07:20:23 Duration: 9s221ms Database: nightly User: lfriedman
-
UPDATE gpu SET dd_date = 'Mon Dec 10 07:57:21 PST 2012', last_update = (date_trunc('second', now())) WHERE system = 'cuda-linux64-cvs24';
Date: 2012-12-11 07:21:29 Duration: 9s121ms Database: nightly User: lfriedman
15 300ms 8s362ms 793ms 441 5m49s update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 11 04 26 21s771ms 837ms 05 70 51s662ms 738ms 06 174 2m38s 913ms 07 54 33s409ms 618ms 08 50 34s545ms 690ms 09 36 26s522ms 736ms 12 10 5s958ms 595ms 13 2 1s868ms 934ms 14 1 625ms 625ms 15 6 3s114ms 519ms 17 1 350ms 350ms 18 1 714ms 714ms 19 3 1s536ms 512ms 22 7 8s871ms 1s267ms [ User: lfriedman - Total duration: 5m49s - Times executed: 441 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-mac-gputest4'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-mac-gputest4';
Date: 2012-12-11 07:20:23 Duration: 8s362ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-linux32-test21'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-linux32-test21';
Date: 2012-12-11 07:21:29 Duration: 7s484ms 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-11 10:50:30 Duration: 5s609ms Database: nightly User: lfriedman
16 300ms 5s469ms 779ms 104 1m21s 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 #16
Day Hour Count Duration Avg duration Dec 11 04 9 8s515ms 946ms 05 3 1s91ms 363ms 06 31 15s67ms 486ms 07 32 20s806ms 650ms 08 6 3s542ms 590ms 09 4 4s747ms 1s186ms 14 1 581ms 581ms 15 6 4s388ms 731ms 17 3 1s577ms 525ms 19 3 1s867ms 622ms 22 6 18s835ms 3s139ms [ User: lfriedman - Total duration: 1m21s - Times executed: 104 ]
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('oclappstests') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-11 23:58:16 Duration: 5s469ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('ddtracker') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-11 23:59:10 Duration: 4s184ms Database: inventory User: lfriedman
-
SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pgpool_regclass ('smoke32on64tests') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog';
Date: 2012-12-11 23:58:24 Duration: 3s836ms Database: nightly User: lfriedman
17 303ms 5s936ms 753ms 182 2m17s update gpu set daemon_update = now(), running = ? where system = ?; select count(hostname) from reservation where hostname = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 11 04 18 13s820ms 767ms 05 30 18s597ms 619ms 06 61 45s136ms 739ms 07 18 11s534ms 640ms 08 16 10s366ms 647ms 09 25 28s728ms 1s149ms 10 1 450ms 450ms 12 7 5s625ms 803ms 14 2 746ms 373ms 15 1 621ms 621ms 17 1 639ms 639ms 22 2 857ms 428ms [ User: lfriedman - Total duration: 2m17s - Times executed: 182 ]
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win864-test10'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win864-test10';
Date: 2012-12-11 10:49:56 Duration: 5s936ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test6'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test6';
Date: 2012-12-11 10:49:51 Duration: 4s304ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), running = '_IDLE_' WHERE system = 'cuda-win7-test32'; SELECT count(hostname) FROM reservation WHERE hostname = 'cuda-win7-test32';
Date: 2012-12-11 07:20:23 Duration: 3s859ms Database: nightly User: lfriedman
18 300ms 8s616ms 707ms 536 6m19s update gpu set daemon_update = now() where system = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 11 04 140 1m34s 671ms 05 151 1m32s 615ms 06 165 2m26s 888ms 07 27 16s623ms 615ms 08 24 12s703ms 529ms 09 8 3s889ms 486ms 12 10 6s814ms 681ms 13 1 367ms 367ms 15 1 300ms 300ms 17 1 315ms 315ms 22 8 4s711ms 588ms [ User: lfriedman - Total duration: 6m19s - Times executed: 536 ]
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-cvs1';
Date: 2012-12-11 07:20:22 Duration: 8s616ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux32-cvs9';
Date: 2012-12-11 07:20:39 Duration: 4s668ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now() WHERE system = 'cuda-linux64-cvs24';
Date: 2012-12-11 07:20:39 Duration: 4s663ms Database: nightly User: lfriedman
19 300ms 9s370ms 684ms 564 6m25s update gpu set daemon_update = now(), activated = ? where system = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 11 04 139 1m24s 611ms 05 151 1m35s 631ms 06 174 2m17s 788ms 07 32 17s886ms 558ms 08 28 16s730ms 597ms 09 16 19s796ms 1s237ms 12 8 3s711ms 463ms 14 2 1s88ms 544ms 15 4 1s912ms 478ms 16 1 373ms 373ms 22 9 6s808ms 756ms [ User: lfriedman - Total duration: 6m25s - Times executed: 564 ]
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs24';
Date: 2012-12-11 07:20:23 Duration: 9s370ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win7-cvs2';
Date: 2012-12-11 07:21:28 Duration: 9s270ms Database: nightly User: lfriedman
-
UPDATE gpu SET daemon_update = now(), activated = '1' WHERE system = 'cuda-win764-cvs19';
Date: 2012-12-11 10:49:46 Duration: 6s666ms Database: nightly User: lfriedman
20 300ms 2s56ms 593ms 50 29s681ms update disks set update = date_trunc(?, now()), size = ?, used = ? where hostname = ?; insert into disks (hostname, size, used, update) ( select ?, ?, ?, date_trunc(?, now()) where not exists ( select ? from disks where hostname = ?));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 11 05 29 15s880ms 547ms 07 5 2s704ms 540ms 09 14 9s698ms 692ms 16 1 493ms 493ms 18 1 904ms 904ms [ User: lfriedman - Total duration: 29s681ms - Times executed: 50 ]
-
UPDATE disks SET update = date_trunc('second', now()), size = '724', used = '47' WHERE hostname = 'cuda-linux64-cvs31'; INSERT into disks (hostname, size, used, update) ( select 'cuda-linux64-cvs31', '724', '47', date_trunc('second', now()) WHERE NOT EXISTS ( select 1 FROM disks WHERE hostname = 'cuda-linux64-cvs31'));
Date: 2012-12-11 06:00:30 Duration: 2s56ms Database: inventory User: lfriedman
-
UPDATE disks SET update = date_trunc('second', now()), size = '243', used = '51' WHERE hostname = 'cuda-linux64-test41'; INSERT into disks (hostname, size, used, update) ( select 'cuda-linux64-test41', '243', '51', date_trunc('second', now()) WHERE NOT EXISTS ( select 1 FROM disks WHERE hostname = 'cuda-linux64-test41'));
Date: 2012-12-11 06:00:44 Duration: 1s752ms Database: inventory User: lfriedman
-
UPDATE disks SET update = date_trunc('second', now()), size = '155', used = '47' WHERE hostname = 'cuda-linux32-cvs0'; INSERT into disks (hostname, size, used, update) ( select 'cuda-linux32-cvs0', '155', '47', date_trunc('second', now()) WHERE NOT EXISTS ( select 1 FROM disks WHERE hostname = 'cuda-linux32-cvs0'));
Date: 2012-12-11 10:00:03 Duration: 1s681ms Database: inventory 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 12 07 2 1s346ms 673ms Dec 12 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 27s868ms 6 1s51ms 6s441ms 4s644ms 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 12 22 2 2s102ms 1s51ms Dec 12 22 4 25s765ms 6s441ms [ User: lfriedman - Total duration: 2ms - Times executed: 6 ]
-
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 18s613ms 14 407ms 3s192ms 1s329ms 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 #2
Day Hour Count Duration Avg duration 08 2 814ms 407ms 14 2 1s584ms 792ms 13 2 1s390ms 695ms 14 2 1s199ms 599ms 09 2 852ms 426ms 21 4 12s771ms 3s192ms [ User: lfriedman - Total duration: 15ms - Times executed: 14 ]
-
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
3 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 #3
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
4 13s227ms 18 370ms 1s558ms 734ms 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 #4
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 2 1s124ms 562ms [ User: lfriedman - Total duration: 4ms - Times executed: 18 ]
-
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
5 10s621ms 14 390ms 1s388ms 758ms 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 4 5s552ms 1s388ms [ User: lfriedman - Total duration: 10s891ms - Times executed: 14 ]
-
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 10s127ms 2 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 #6
Day Hour Count Duration Avg duration 06 2 10s127ms 5s63ms [ User: lfriedman - Total duration: 461ms - Times executed: 2 ]
-
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
7 8s932ms 4 504ms 3s961ms 2s233ms 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 #7
Day Hour Count Duration Avg duration 18 2 1s9ms 504ms 06 2 7s923ms 3s961ms [ User: lfriedman - Total duration: 914ms - Times executed: 4 ]
-
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
8 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 #8
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
9 6s368ms 8 308ms 1s292ms 796ms 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 #9
Day Hour Count Duration Avg duration 23 2 2s584ms 1s292ms 03 2 761ms 380ms 11 2 616ms 308ms 09 2 2s405ms 1s202ms [ User: lfriedman - Total duration: 0ms - Times executed: 8 ]
-
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
10 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 #10
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
11 5s912ms 8 308ms 1s688ms 739ms 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 #11
Day Hour Count Duration Avg duration 13 2 1s302ms 651ms 04 2 3s376ms 1s688ms 21 4 1s233ms 308ms [ User: lfriedman - Total duration: 15ms - Times executed: 8 ]
-
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
12 5s539ms 8 461ms 916ms 692ms 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 2 1s759ms 879ms [ User: lfriedman - Total duration: 1ms - Times executed: 8 ]
-
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 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 #13
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
14 4s732ms 8 342ms 959ms 591ms 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 #14
Day Hour Count Duration Avg duration 10 2 1s63ms 531ms 19 2 1s919ms 959ms 21 2 685ms 342ms 06 2 1s64ms 532ms [ User: lfriedman - Total duration: 1ms - Times executed: 8 ]
-
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
15 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 #15
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
16 4s22ms 4 529ms 1s481ms 1s5ms 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 #16
Day Hour Count Duration Avg duration 07 2 2s963ms 1s481ms 09 2 1s58ms 529ms [ 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 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
17 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 #17
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
18 3s843ms 4 556ms 1s365ms 960ms 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 2 1s112ms 556ms [ User: lfriedman - Total duration: 2s355ms - Times executed: 4 ]
-
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 3s818ms 4 411ms 1s497ms 954ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM njcublas WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 08 2 823ms 411ms 06 2 2s995ms 1s497ms [ User: lfriedman - Total duration: 19ms - Times executed: 4 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM njcublas WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-11 08:19:24 Duration: 1s497ms 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 njcublas WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 10:00:37 Duration: 411ms Database: postgres User: pvs Remote: lfriedman
20 3s722ms 8 334ms 636ms 465ms 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 4 1s713ms 428ms [ User: lfriedman - Total duration: 1s479ms - Times executed: 8 ]
-
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,238 queries/s Request Peak
- 2012-12-11 20:41:22 Date
Bytes I/O Throughput
Key values
- 998,669 Bytes/s In Bytes Peak
- 2012-12-10 07:46:21 Date
- 965,171 Bytes/s Out Bytes Peak
- 2012-12-10 00:01:21 Date
Queries Average duration
Key values
- 91ms Average Duration Peak
- 2012-12-10 23:01:21 Date
Established Connections
Key values
- 210 connections Connection Peak
- 2012-12-10 19:10:31 Date
Connections per database
Key values
- nightly Main Database
- 2,491,937 connections Total
Database User Count gasworks2 1,195 lfriedman 1,195 grinderman 5,665 lfriedman 5,665 intranet 186,767 lfriedman 186,767 intranet_test 2,877 lfriedman 2,877 jdb 796 lfriedman 796 lfriedman_test 1,152 lfriedman 1,152 nightly 1,971,082 lfriedman 1,971,082 optique_production 599 lfriedman 599 pgbouncer 1,154 dalibo 1,154 sterne_production 1,379 lfriedman 1,379 vangard_prod 9,943 lfriedman 9,943 webmail 309,328 lfriedman 309,328 Connections per user
Key values
- lfriedman Main User
- 2,491,937 connections Total
Connections per host
Key values
- 10.10.10.22.13 Main host with 1805011 connections
- 2,491,937 Total connections
Simultaneous sessions
Key values
- 486 sessions Session Peak
- 2012-12-10 23:01:01 Date
Histogram of session times
Key values
- 2,166,999 0-500ms duration
Sessions per database
Key values
- nightly Main Database
- 2,503,444 sessions Total
Database User Count Total Duration Average Duration gasworks2 1,689 11h7m51s 23s724ms grinderman 5,665 27m54s 295ms intranet 188,613 8d4h6m58s 3s743ms intranet_test 2,876 1d10h30m54s 43s203ms jdb 1,264 10h6s 28s485ms lfriedman_test 1,152 0ms 0ms nightly 1,976,283 59d6h19m58s 2s590ms optique_production 661 1h8m44s 6s239ms pgbouncer 1,154 0ms 0ms sterne_production 2,232 18h13m57s 29s407ms vangard_prod 10,477 4d6h51m27s 35s342ms webmail 311,378 8d12h4m2s 2s359ms Sessions per user
Key values
- lfriedman Main User
- 2,503,444 sessions Total
Sessions per host
Key values
- 10.10.10.22.13 Main Host
- 2,503,444 sessions Total
Most used reserved pools
Key values
- lfriedman@nightly Most used reserved pool
- 3,260 Time used
- 3,282 Total time reserved pools was used
Rank Times used Reserved pool 1 3,260 lfriedman@nightlyTimes Reported Most used reserved pools #1
Day Hour Count Dec 10 23 63 00 45 01 41 02 57 03 59 04 63 05 83 06 82 07 69 08 83 09 80 10 59 11 56 12 46 13 50 14 73 15 69 16 82 17 86 18 86 19 84 20 84 21 77 22 79 Dec 11 23 64 00 54 01 57 02 42 03 47 04 75 05 76 06 80 07 77 08 83 09 78 10 60 11 49 12 32 13 45 14 55 15 72 16 81 17 87 18 84 19 85 20 84 21 70 22 67 2 12 lfriedman@intranetTimes Reported Most used reserved pools #2
Day Hour Count Dec 10 07 4 09 1 Dec 11 07 2 08 5 3 10 lfriedman@webmailTimes Reported Most used reserved pools #3
Day Hour Count Dec 10 09 10 Most Frequent Errors/Events
Key values
- 3,282 Max number of times the same event was reported
- 3,282 Total events found
Rank Times reported Error 1 3,282 WARNING: Taking connection from reserve_poolTimes Reported Most Frequent Error / Event #1
Day Hour Count Dec 10 23 63 00 45 01 41 02 57 03 59 04 63 05 83 06 82 07 73 08 83 09 91 10 59 11 56 12 46 13 50 14 73 15 69 16 82 17 86 18 86 19 84 20 84 21 77 22 79 Dec 11 23 64 00 54 01 57 02 42 03 47 04 75 05 76 06 80 07 79 08 88 09 78 10 60 11 49 12 32 13 45 14 55 15 72 16 81 17 87 18 84 19 85 20 84 21 70 22 67 - WARNING: Taking connection from reserve_pool
- WARNING: Taking connection from reserve_pool
- WARNING: Taking connection from reserve_pool
Date: 2012-12-10 04:50:20 Database: nightly User: lfriedman Remote: 10.10.10.22.13
Date: 2012-12-10 04:50:20 Database: nightly User: lfriedman Remote: 10.10.10.22.13
Date: 2012-12-10 04:50:20 Database: nightly User: lfriedman Remote: 10.10.10.22.13
-
Events
Log levels
Key values
- 31,431,768 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 3 ERROR entries
- 1 WARNING entries
Most Frequent Errors/Events
Key values
- 2 Max number of times the same event was reported
- 4 Total events found
Rank Times reported Error 1 2 ERROR: invalid input syntax for integer: ...
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 11 19 2 - ERROR: invalid input syntax for integer: "Root/Functional/Signal/ArithmeticTests/SignalLnTests/Ln_32f_Test/Sink/Size_1" at character 46
- ERROR: invalid input syntax for integer: "Root/Functional/Signal/ArithmeticTests/SignalLnTests/Ln_32f_Test/Sink/Size_1" at character 126
Statement: select count(id) from filterout WHERE (bug = 'Root/Functional/Signal/ArithmeticTests/SignalLnTests/Ln_32f_Test/Sink/Size_1') AND last_update='2012-12-11';
Date: 2012-12-11 20:46:28 Database: nightly Application: User: lfriedman Remote:
Statement: select id,last_update,active,script,os,osversion,arch,gpu,branch,build,vc,testname,category,bug from filterout WHERE (bug = 'Root/Functional/Signal/ArithmeticTests/SignalLnTests/Ln_32f_Test/Sink/Size_1') AND last_update='2012-12-11' order by id desc offset 0 limit 500;
Date: 2012-12-11 20:46:28 Database: nightly Application: User: lfriedman Remote:
2 1 WARNING: pgstat wait timeout
Times Reported Most Frequent Error / Event #2
Day Hour Count Dec 11 06 1 - WARNING: pgstat wait timeout
Date: 2012-12-11 07:21:27
3 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Dec 11 19 1 - ERROR: syntax error at or near "selct" at character 1
Statement: selct * from disks;
Date: 2012-12-11 20:15:26 Database: inventory Application: User: lfriedman Remote:
- Overview
- Connections
- Sessions
- Checkpoints
- Temp Files
- Vacuums
- Locks
- Queries
- Top
- Events
- PgBouncer
- Request Throughput
- Bytes I/O Throughput
- Queries Average duration
- Simultaneous sessions
- Histogram of sessions times
- Sessions per database
- Sessions per user
- Sessions per host
- Established connections
- Connections per database
- Connections per user
- Connections per host
- Most used reserved pools
- Most Frequent Errors/Events