pgBadger-
Global information
- Generated on Tue May 17 09:17:26 2022
- Log file: /data/pglog/huge_log_test/pgbouncer.log.1, ..., /data/pglog/huge_log_test/postgresql-Tue.log
- Parsed 18,312,196 log entries in 14m21s
- Log start from 2012-12-09 00:00:00 to 2012-12-09 23:59:59
-
Overview
Global Stats
- 6 Number of unique normalized queries
- 5,446,500 Number of queries
- 2h40m9s Total query duration
- 2012-12-09 00:00:00 First query
- 2012-12-09 23:59:59 Last query
- 459 queries/s at 2012-12-09 16:59:47 Query peak
- 2h40m9s Total query duration
- 729ms Prepare/parse total duration
- 10s631ms Bind total duration
- 2h39m58s Execute total duration
- 1,043 Number of events
- 1 Number of unique normalized events
- 1,043 Max number of times the same event was reported
- 0 Number of cancellation
- 1 Total number of automatic vacuums
- 1 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 380,975 Total number of sessions
- 6 sessions at 2012-12-09 21:24:15 Session peak
- 300d4h16m54s Total duration of sessions
- 1m8s Average duration of sessions
- 14 Average queries per session
- 25ms Average queries duration per session
- 1m8s Average idle time per session
- 380,976 Total number of connections
- 53 connections/s at 2012-12-09 19:04:14 Connection peak
- 6 Total number of databases
SQL Traffic
Key values
- 459 queries/s Query Peak
- 2012-12-09 16:59:47 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2012-12-09 02:40:30 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2012-12-09 06:02:20 Date
Queries duration
Key values
- 2h40m9s 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 09 00 224,464 0ms 32s330ms 1ms 16s376ms 36s907ms 40s820ms 01 218,852 0ms 1s445ms 1ms 15s660ms 30s551ms 36s810ms 02 219,274 0ms 1s339ms 1ms 15s28ms 26s906ms 32s410ms 03 218,465 0ms 108ms 1ms 15s57ms 27s69ms 35s141ms 04 220,672 0ms 109ms 1ms 21s76ms 36s221ms 39s733ms 05 219,088 0ms 251ms 1ms 16s615ms 26s246ms 34s523ms 06 224,657 0ms 1s69ms 1ms 17s883ms 40s800ms 44s872ms 07 218,425 0ms 101ms 1ms 14s567ms 29s499ms 32s960ms 08 218,426 0ms 753ms 1ms 15s157ms 29s837ms 35s305ms 09 218,366 0ms 535ms 1ms 14s583ms 25s300ms 34s39ms 10 217,778 0ms 104ms 1ms 14s37ms 29s980ms 33s331ms 11 218,625 0ms 107ms 1ms 15s224ms 30s740ms 31s620ms 12 217,713 0ms 732ms 1ms 14s986ms 25s584ms 32s343ms 13 236,743 0ms 3s583ms 1ms 16s599ms 35s193ms 39s783ms 14 235,121 0ms 115ms 1ms 15s658ms 30s607ms 39s125ms 15 232,745 0ms 119ms 1ms 15s539ms 30s648ms 34s274ms 16 235,057 0ms 763ms 1ms 15s426ms 32s703ms 38s279ms 17 235,315 0ms 147ms 1ms 15s888ms 31s211ms 36s114ms 18 234,222 0ms 1s326ms 1ms 16s144ms 31s833ms 33s618ms 19 233,028 0ms 100ms 1ms 15s497ms 30s699ms 33s276ms 20 233,668 0ms 100ms 1ms 15s730ms 33s679ms 35s20ms 21 233,971 0ms 104ms 1ms 15s443ms 27s770ms 32s516ms 22 234,753 0ms 105ms 1ms 15s968ms 30s681ms 33s452ms 23 247,072 0ms 107ms 2ms 21s984ms 30s875ms 36s273ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 09 00 2 0 570ms 0ms 0ms 440ms 01 1 0 1s445ms 0ms 0ms 0ms 02 4 0 601ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 7 0 577ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 19 0 514ms 337ms 639ms 1s252ms 09 5 0 432ms 0ms 0ms 535ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 11 0 526ms 0ms 0ms 1s419ms 13 2 0 2s101ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 3 0 601ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 4 0 598ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 09 00 0 0 1 0 32s330ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 1 713ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 2 0 1 479ms 0ms 0ms 345ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 1 718ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Dec 09 00 1 0 0.00 33.33% 01 0 1 1.00 0.00% 02 0 4 4.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 1 1.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 4 4.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Dec 09 00 9,705 2.70/s 01 9,706 2.70/s 02 9,613 2.67/s 03 9,683 2.69/s 04 9,779 2.72/s 05 9,826 2.73/s 06 9,957 2.77/s 07 9,557 2.65/s 08 9,588 2.66/s 09 9,810 2.73/s 10 9,543 2.65/s 11 9,523 2.65/s 12 9,634 2.68/s 13 22,225 6.17/s 14 23,709 6.59/s 15 23,617 6.56/s 16 23,314 6.48/s 17 23,887 6.64/s 18 23,265 6.46/s 19 23,135 6.43/s 20 22,842 6.34/s 21 22,921 6.37/s 22 23,016 6.39/s 23 23,121 6.42/s Day Hour Count Average Duration Average idle time Dec 09 00 9,704 1m50s 1m50s 01 9,706 1m51s 1m51s 02 9,613 1m52s 1m52s 03 9,683 1m50s 1m50s 04 9,779 1m51s 1m51s 05 9,826 1m49s 1m49s 06 9,957 1m50s 1m50s 07 9,557 1m49s 1m49s 08 9,589 1m53s 1m53s 09 9,809 1m50s 1m50s 10 9,543 1m52s 1m52s 11 9,523 1m53s 1m53s 12 9,634 1m52s 1m52s 13 22,225 49s897ms 49s878ms 14 23,709 45s483ms 45s465ms 15 23,617 45s802ms 45s785ms 16 23,315 46s197ms 46s180ms 17 23,886 45s275ms 45s256ms 18 23,265 46s356ms 46s337ms 19 23,135 46s670ms 46s653ms 20 22,842 47s417ms 47s400ms 21 22,921 47s93ms 47s76ms 22 23,017 46s837ms 46s818ms 23 23,120 46s662ms 46s639ms -
Connections
Established Connections
Key values
- 53 connections Connection Peak
- 2012-12-09 19:04:14 Date
Connections per database
Key values
- inventory Main Database
- 380,976 connections Total
Connections per user
Key values
- lfriedman Main User
- 380,976 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2012-12-09 21:24:15 Date
Histogram of session times
Key values
- 107,711 60000-600000ms duration
Sessions per database
Key values
- inventory Main Database
- 380,975 sessions Total
Sessions per user
Key values
- lfriedman Main User
- 380,975 sessions Total
Sessions per host
Key values
- 10.31.96.124 Main Host
- 380,975 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 51,940 buffers Checkpoint Peak
- 2012-12-09 00:06:43 Date
- 209.064 seconds Highest write time
- 0.058 seconds Sync time
Checkpoints Wal files
Key values
- 30 files Wal files usage Peak
- 2012-12-09 00:06:43 Date
Checkpoints distance
Key values
- 0.00 Mo Distance Peak
- 2012-12-09 13:28:54 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Dec 09 00 53,399 355.011s 0.154s 355.219s 01 1,832 183.281s 0.101s 183.434s 02 2,532 253.023s 0.099s 253.173s 03 1,769 176.971s 0.109s 177.139s 04 1,813 181.278s 0.11s 181.442s 05 1,779 177.968s 0.111s 178.132s 06 2,676 267.737s 0.104s 267.897s 07 1,765 176.569s 0.105s 176.731s 08 1,797 179.77s 0.112s 179.938s 09 1,791 179.071s 0.108s 179.231s 10 1,743 174.358s 0.108s 174.519s 11 1,789 178.967s 0.107s 179.125s 12 2,419 241.684s 0.103s 241.836s 13 4,380 437.866s 0.119s 438.039s 14 4,658 465.715s 0.121s 465.888s 15 4,637 463.92s 0.117s 464.104s 16 4,620 461.422s 0.126s 461.6s 17 4,694 469.532s 0.121s 469.712s 18 5,399 539.881s 0.119s 540.05s 19 4,663 466.24s 0.142s 466.434s 20 4,621 461.913s 0.139s 462.105s 21 4,650 464.52s 0.131s 464.709s 22 4,670 467.236s 0.125s 467.416s 23 4,495 449.517s 0.125s 449.694s Day Hour Added Removed Recycled Synced files Longest sync Average sync Dec 09 00 0 0 80 522 0.008s 0s 01 0 0 59 481 0s 0s 02 0 0 59 502 0.002s 0s 03 0 0 59 483 0.001s 0s 04 0 0 59 500 0.001s 0s 05 0 0 59 489 0.002s 0s 06 0 0 59 553 0.002s 0s 07 0 0 59 488 0.001s 0s 08 0 0 59 499 0.002s 0s 09 0 0 59 484 0.002s 0s 10 0 0 59 493 0.001s 0s 11 0 0 59 488 0.001s 0s 12 0 0 59 542 0.001s 0s 13 0 0 60 634 0.001s 0s 14 0 0 58 625 0.002s 0s 15 0 0 59 629 0.001s 0s 16 0 0 59 646 0.001s 0s 17 0 0 59 665 0.002s 0s 18 0 0 59 720 0.001s 0s 19 0 0 59 628 0.002s 0s 20 0 0 59 639 0.002s 0s 21 0 0 59 650 0.001s 0s 22 0 0 59 641 0.002s 0s 23 0 0 54 632 0.002s 0s Day Hour Count Avg time (sec) Dec 09 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Dec 09 00 0.00 kB 0.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 0.00 kB 04 0.00 kB 0.00 kB 05 0.00 kB 0.00 kB 06 0.00 kB 0.00 kB 07 0.00 kB 0.00 kB 08 0.00 kB 0.00 kB 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB 11 0.00 kB 0.00 kB 12 0.00 kB 0.00 kB 13 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 0.00 kB 0.00 kB 16 0.00 kB 0.00 kB 17 0.00 kB 0.00 kB 18 0.00 kB 0.00 kB 19 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB 21 0.00 kB 0.00 kB 22 0.00 kB 0.00 kB 23 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Dec 09 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 11.19 sec Highest CPU-cost vacuum
Table public.user_preferences
Database inventory - 2012-12-09 23:56:50 Date
- 5.25 sec Highest CPU-cost analyze
Table public.user_preferences
Database inventory - 2012-12-09 01:40:04 Date
Analyzes per table
Key values
- public.user_preferences (1) Main table analyzed (database inventory)
- 1 analyzes Total
Vacuums per table
Key values
- public.user_preferences (1) Main table vacuumed on database inventory
- 1 vacuums Total
Tuples removed per table
Key values
- public.user_preferences (4131) Main table with removed tuples on database inventory
- 4131 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Dec 09 00 0 0 01 0 1 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 1 0 - 11.19 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
- 58 Total read queries
- 6 Total write queries
Queries by database
Key values
- inventory Main database
- 4,642,440 Requests
- 1h53m29s (nightly)
- Main time consuming database
Queries by user
Key values
- lfriedman Main user
- 43,825,777 Requests
User Request type Count Duration lfriedman Total 43,825,777 5d5h6m7s copy from 643 2h37m15s ddl 2,964 0ms delete 290 7m2s insert 2,533 36m37s select 10,712 3h59m42s tcl 2 1s345ms update 12,532 3h11m32s postgres Total 1,849 3s766ms select 1 330ms Duration by user
Key values
- 5d5h6m7s (lfriedman) Main time consuming user
User Request type Count Duration lfriedman Total 43,825,777 5d5h6m7s copy from 643 2h37m15s ddl 2,964 0ms delete 290 7m2s insert 2,533 36m37s select 10,712 3h59m42s tcl 2 1s345ms update 12,532 3h11m32s postgres Total 1,849 3s766ms select 1 330ms Queries by host
Key values
- unknown Main host
- 43,827,626 Requests
- 5d5h6m10s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 5,446,500 Requests
- 2h39m58s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2012-12-09 11:27:27 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 4,819,860 0-1ms duration
Slowest individual queries
Rank Duration Query 1 32s330ms DELETE FROM filterout WHERE last_update = '2012-12-09'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);[ Date: 2012-12-09 00:00:34 - Database: nightly - User: lfriedman ]
2 3s583ms SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;[ Date: 2012-12-09 13:00:15 - Database: pvs - User: lfriedman - Bind query: yes ]
3 1s445ms 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 = 'i' AND script = 'thrust.sh' AND active = 't' AND last_update = '2012-12-09' AND farm = '0' ORDER BY testname;[ Date: 2012-12-09 01:20:09 - Database: nightly - User: lfriedman - Bind query: yes ]
4 1s339ms SELECT testname, category, bug FROM filterout WHERE os = 'Darwin' AND osversion = '10.7' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'npp-smoke.sh' AND active = 't' AND last_update = '2012-12-09' AND farm = '0' ORDER BY testname;[ Date: 2012-12-09 02:40:29 - Database: nightly - User: lfriedman - Bind query: yes ]
5 1s326ms SELECT testname, category, bug FROM filterout WHERE os = 'Darwin' AND osversion = '10.7' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'npp-smoke.sh' AND active = 't' AND last_update = '2012-12-09' AND farm = '0' ORDER BY testname;[ Date: 2012-12-09 18:00:25 - Database: nightly - User: lfriedman - Bind query: yes ]
6 1s69ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';[ Date: 2012-12-09 06:39:14 - Database: nightly - User: lfriedman ]
7 844ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';[ Date: 2012-12-09 06:39:13 - Database: inventory - User: lfriedman ]
8 763ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';[ Date: 2012-12-09 16:59:52 - Database: inventory - User: lfriedman ]
9 753ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('ddupdate') AND c.relpersistence = 'u';[ Date: 2012-12-09 08:52:35 - Database: nightly - User: lfriedman ]
10 732ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';[ Date: 2012-12-09 12:54:10 - Database: inventory - User: lfriedman ]
11 726ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';[ Date: 2012-12-09 12:54:12 - Database: nightly - User: lfriedman ]
12 726ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';[ Date: 2012-12-09 08:37:40 - Database: inventory - User: lfriedman ]
13 724ms COPY test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) FROM STDIN WITH CSV HEADER;[ Date: 2012-12-09 12:02:18 - Database: inventory - User: lfriedman ]
14 718ms COPY test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) FROM STDIN WITH CSV HEADER;[ Date: 2012-12-09 18:02:18 - Database: inventory - User: lfriedman ]
15 715ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';[ Date: 2012-12-09 08:48:58 - Database: nightly - User: lfriedman ]
16 713ms COPY test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) FROM STDIN WITH CSV HEADER;[ Date: 2012-12-09 06:02:20 - Database: inventory - User: lfriedman ]
17 712ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';[ Date: 2012-12-09 12:54:02 - Database: nightly - User: lfriedman ]
18 701ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('ddupdate') AND c.relpersistence = 'u';[ Date: 2012-12-09 00:39:38 - Database: nightly - User: lfriedman ]
19 700ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';[ Date: 2012-12-09 08:54:12 - Database: nightly - User: lfriedman ]
20 685ms SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';[ Date: 2012-12-09 08:48:59 - Database: inventory - User: lfriedman ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 32s330ms 1 32s330ms 32s330ms 32s330ms delete from filterout where last_update = ?; insert into filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) select script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion from filterout where last_update = ( select max(last_update) from filterout where last_update != now()::date);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 09 23 1 32s330ms 32s330ms [ User: lfriedman - Total duration: 32s330ms - Times executed: 1 ]
-
DELETE FROM filterout WHERE last_update = '2012-12-09'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);
Date: 2012-12-09 00:00:34 Duration: 32s330ms Database: nightly User: lfriedman
2 25s341ms 48 302ms 1s69ms 527ms 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 09 23 2 1s141ms 570ms 05 7 4s41ms 577ms 07 19 9s774ms 514ms 08 5 2s163ms 432ms 11 11 5s794ms 526ms 12 1 620ms 620ms 15 3 1s805ms 601ms [ User: lfriedman - Total duration: 25s341ms - Times executed: 48 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';
Date: 2012-12-09 06:39:14 Duration: 1s69ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';
Date: 2012-12-09 06:39:13 Duration: 844ms Database: inventory User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';
Date: 2012-12-09 16:59:52 Duration: 763ms Database: inventory User: lfriedman
3 6s246ms 9 329ms 1s445ms 694ms select testname, category, bug from filterout where os = ? and osversion = ? and arch = ? and gpu = ? and branch = ? and build = ? and vc = ? and script = ? and active = ? and last_update = ? and farm = ? order by testname;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 09 00 1 1s445ms 1s445ms 01 4 2s406ms 601ms 17 4 2s394ms 598ms [ User: lfriedman - Total duration: 6s246ms - Times executed: 9 ]
-
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 = 'i' AND script = 'thrust.sh' AND active = 't' AND last_update = '2012-12-09' AND farm = '0' ORDER BY testname;
Date: 2012-12-09 01:20:09 Duration: 1s445ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Darwin' AND osversion = '10.7' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'npp-smoke.sh' AND active = 't' AND last_update = '2012-12-09' AND farm = '0' ORDER BY testname;
Date: 2012-12-09 02:40:29 Duration: 1s339ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Darwin' AND osversion = '10.7' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'npp-smoke.sh' AND active = 't' AND last_update = '2012-12-09' AND farm = '0' ORDER BY testname;
Date: 2012-12-09 18:00:25 Duration: 1s326ms Database: nightly User: lfriedman Bind query: yes
4 3s583ms 1 3s583ms 3s583ms 3s583ms select testname from nppsmoketests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 09 12 1 3s583ms 3s583ms [ User: lfriedman - Total duration: 3s583ms - Times executed: 1 ]
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-09 13:00:15 Duration: 3s583ms Database: pvs User: lfriedman Bind query: yes
5 2s156ms 3 713ms 724ms 718ms copy test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) from stdin with csv header;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 09 05 1 713ms 713ms 11 1 724ms 724ms 17 1 718ms 718ms [ User: lfriedman - Total duration: 2s156ms - Times executed: 3 ]
-
COPY test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) FROM STDIN WITH CSV HEADER;
Date: 2012-12-09 12:02:18 Duration: 724ms Database: inventory User: lfriedman
-
COPY test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) FROM STDIN WITH CSV HEADER;
Date: 2012-12-09 18:02:18 Duration: 718ms Database: inventory User: lfriedman
-
COPY test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) FROM STDIN WITH CSV HEADER;
Date: 2012-12-09 06:02:20 Duration: 713ms Database: inventory User: lfriedman
6 713ms 2 345ms 367ms 356ms update cuhc set count = ? where system = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 09 11 2 713ms 356ms [ User: lfriedman - Total duration: 713ms - Times executed: 2 ]
-
UPDATE cuhc SET count = '555' WHERE system = 'cuda-linux64-test26';
Date: 2012-12-09 12:44:31 Duration: 367ms Database: inventory User: lfriedman
-
UPDATE cuhc SET count = '547' WHERE system = 'cuda-win864-test5';
Date: 2012-12-09 12:47:56 Duration: 345ms Database: inventory User: lfriedman
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 48 25s341ms 302ms 1s69ms 527ms 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 09 23 2 1s141ms 570ms 05 7 4s41ms 577ms 07 19 9s774ms 514ms 08 5 2s163ms 432ms 11 11 5s794ms 526ms 12 1 620ms 620ms 15 3 1s805ms 601ms [ User: lfriedman - Total duration: 25s341ms - Times executed: 48 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';
Date: 2012-12-09 06:39:14 Duration: 1s69ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';
Date: 2012-12-09 06:39:13 Duration: 844ms Database: inventory User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';
Date: 2012-12-09 16:59:52 Duration: 763ms Database: inventory User: lfriedman
2 9 6s246ms 329ms 1s445ms 694ms 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 #2
Day Hour Count Duration Avg duration Dec 09 00 1 1s445ms 1s445ms 01 4 2s406ms 601ms 17 4 2s394ms 598ms [ User: lfriedman - Total duration: 6s246ms - Times executed: 9 ]
-
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 = 'i' AND script = 'thrust.sh' AND active = 't' AND last_update = '2012-12-09' AND farm = '0' ORDER BY testname;
Date: 2012-12-09 01:20:09 Duration: 1s445ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Darwin' AND osversion = '10.7' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'npp-smoke.sh' AND active = 't' AND last_update = '2012-12-09' AND farm = '0' ORDER BY testname;
Date: 2012-12-09 02:40:29 Duration: 1s339ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Darwin' AND osversion = '10.7' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'npp-smoke.sh' AND active = 't' AND last_update = '2012-12-09' AND farm = '0' ORDER BY testname;
Date: 2012-12-09 18:00:25 Duration: 1s326ms Database: nightly User: lfriedman Bind query: yes
3 3 2s156ms 713ms 724ms 718ms copy test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) from stdin with csv header;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 09 05 1 713ms 713ms 11 1 724ms 724ms 17 1 718ms 718ms [ User: lfriedman - Total duration: 2s156ms - Times executed: 3 ]
-
COPY test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) FROM STDIN WITH CSV HEADER;
Date: 2012-12-09 12:02:18 Duration: 724ms Database: inventory User: lfriedman
-
COPY test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) FROM STDIN WITH CSV HEADER;
Date: 2012-12-09 18:02:18 Duration: 718ms Database: inventory User: lfriedman
-
COPY test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) FROM STDIN WITH CSV HEADER;
Date: 2012-12-09 06:02:20 Duration: 713ms Database: inventory User: lfriedman
4 2 713ms 345ms 367ms 356ms update cuhc set count = ? where system = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 09 11 2 713ms 356ms [ User: lfriedman - Total duration: 713ms - Times executed: 2 ]
-
UPDATE cuhc SET count = '555' WHERE system = 'cuda-linux64-test26';
Date: 2012-12-09 12:44:31 Duration: 367ms Database: inventory User: lfriedman
-
UPDATE cuhc SET count = '547' WHERE system = 'cuda-win864-test5';
Date: 2012-12-09 12:47:56 Duration: 345ms Database: inventory User: lfriedman
5 1 32s330ms 32s330ms 32s330ms 32s330ms delete from filterout where last_update = ?; insert into filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) select script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion from filterout where last_update = ( select max(last_update) from filterout where last_update != now()::date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 09 23 1 32s330ms 32s330ms [ User: lfriedman - Total duration: 32s330ms - Times executed: 1 ]
-
DELETE FROM filterout WHERE last_update = '2012-12-09'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);
Date: 2012-12-09 00:00:34 Duration: 32s330ms Database: nightly User: lfriedman
6 1 3s583ms 3s583ms 3s583ms 3s583ms select testname from nppsmoketests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 09 12 1 3s583ms 3s583ms [ User: lfriedman - Total duration: 3s583ms - Times executed: 1 ]
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-09 13:00:15 Duration: 3s583ms Database: pvs User: lfriedman Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 32s330ms 32s330ms 32s330ms 1 32s330ms delete from filterout where last_update = ?; insert into filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) select script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion from filterout where last_update = ( select max(last_update) from filterout where last_update != now()::date);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 09 23 1 32s330ms 32s330ms [ User: lfriedman - Total duration: 32s330ms - Times executed: 1 ]
-
DELETE FROM filterout WHERE last_update = '2012-12-09'; INSERT INTO filterout (script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion) SELECT script, os, arch, build, gpu, branch, testname, bug, active, category, vc, farm, osversion FROM filterout where last_update = ( SELECT max(last_update) FROM filterout WHERE last_update != now()::date);
Date: 2012-12-09 00:00:34 Duration: 32s330ms Database: nightly User: lfriedman
2 3s583ms 3s583ms 3s583ms 1 3s583ms select testname from nppsmoketests where suiteid = ? and current_status = ? and regressioncl != ? order by testname asc limit ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 09 12 1 3s583ms 3s583ms [ User: lfriedman - Total duration: 3s583ms - Times executed: 1 ]
-
SELECT testname FROM nppsmoketests WHERE suiteid = '4639' AND current_status = 'ERROR' AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-09 13:00:15 Duration: 3s583ms Database: pvs User: lfriedman Bind query: yes
3 713ms 724ms 718ms 3 2s156ms copy test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) from stdin with csv header;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 09 05 1 713ms 713ms 11 1 724ms 724ms 17 1 718ms 718ms [ User: lfriedman - Total duration: 2s156ms - Times executed: 3 ]
-
COPY test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) FROM STDIN WITH CSV HEADER;
Date: 2012-12-09 12:02:18 Duration: 724ms Database: inventory User: lfriedman
-
COPY test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) FROM STDIN WITH CSV HEADER;
Date: 2012-12-09 18:02:18 Duration: 718ms Database: inventory User: lfriedman
-
COPY test_map (os, osversion, arch, gpu, testtype, vc, amodel, drvpath, cudaroot, totdriver, script, active, dispbranch, p4cl, email, bug, dbname) FROM STDIN WITH CSV HEADER;
Date: 2012-12-09 06:02:20 Duration: 713ms Database: inventory User: lfriedman
4 329ms 1s445ms 694ms 9 6s246ms 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 #4
Day Hour Count Duration Avg duration Dec 09 00 1 1s445ms 1s445ms 01 4 2s406ms 601ms 17 4 2s394ms 598ms [ User: lfriedman - Total duration: 6s246ms - Times executed: 9 ]
-
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 = 'i' AND script = 'thrust.sh' AND active = 't' AND last_update = '2012-12-09' AND farm = '0' ORDER BY testname;
Date: 2012-12-09 01:20:09 Duration: 1s445ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Darwin' AND osversion = '10.7' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'npp-smoke.sh' AND active = 't' AND last_update = '2012-12-09' AND farm = '0' ORDER BY testname;
Date: 2012-12-09 02:40:29 Duration: 1s339ms Database: nightly User: lfriedman Bind query: yes
-
SELECT testname, category, bug FROM filterout WHERE os = 'Darwin' AND osversion = '10.7' AND arch = 'x86_64' AND gpu = '200' AND branch = 'cuda_a' AND build = 'release' AND vc = 'g' AND script = 'npp-smoke.sh' AND active = 't' AND last_update = '2012-12-09' AND farm = '0' ORDER BY testname;
Date: 2012-12-09 18:00:25 Duration: 1s326ms Database: nightly User: lfriedman Bind query: yes
5 302ms 1s69ms 527ms 48 25s341ms select count(*) from pg_catalog.pg_class as c where c.oid = pgpool_regclass (?) and c.relpersistence = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 09 23 2 1s141ms 570ms 05 7 4s41ms 577ms 07 19 9s774ms 514ms 08 5 2s163ms 432ms 11 11 5s794ms 526ms 12 1 620ms 620ms 15 3 1s805ms 601ms [ User: lfriedman - Total duration: 25s341ms - Times executed: 48 ]
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('gpu') AND c.relpersistence = 'u';
Date: 2012-12-09 06:39:14 Duration: 1s69ms Database: nightly User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';
Date: 2012-12-09 06:39:13 Duration: 844ms Database: inventory User: lfriedman
-
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass ('vms') AND c.relpersistence = 'u';
Date: 2012-12-09 16:59:52 Duration: 763ms Database: inventory User: lfriedman
6 345ms 367ms 356ms 2 713ms update cuhc set count = ? where system = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 09 11 2 713ms 356ms [ User: lfriedman - Total duration: 713ms - Times executed: 2 ]
-
UPDATE cuhc SET count = '555' WHERE system = 'cuda-linux64-test26';
Date: 2012-12-09 12:44:31 Duration: 367ms Database: inventory User: lfriedman
-
UPDATE cuhc SET count = '547' WHERE system = 'cuda-win864-test5';
Date: 2012-12-09 12:47:56 Duration: 345ms Database: inventory User: lfriedman
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1s403ms 2 673ms 729ms 701ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM cider WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Dec 09 07 1 673ms 673ms Dec 09 23 1 729ms 729ms [ User: lfriedman - Total duration: 69ms - Times executed: 2 ]
-
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 571ms 1 571ms 571ms 571ms UPDATE saved_searches SET last_used = NOW() WHERE LOWER(title) = LOWER($1);Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 04 1 571ms 571ms [ User: lfriedman - Total duration: 1ms - Times executed: 1 ]
-
UPDATE saved_searches SET last_used = NOW() WHERE LOWER(title) = LOWER($1);
Date: 2012-12-07 06:19:28 Duration: 571ms Database: postgres User: inventory Remote: lfriedman
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 6s805ms 7 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 #1
Day Hour Count Duration Avg duration Dec 09 00 1 2s142ms 2s142ms Dec 09 08 1 1s245ms 1s245ms Dec 09 17 1 378ms 378ms 20 1 550ms 550ms Dec 09 05 2 1s902ms 951ms 12 1 585ms 585ms [ User: lfriedman - Total duration: 1ms - Times executed: 7 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM 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
2 6s51ms 8 370ms 1s558ms 756ms 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 #2
Day Hour Count Duration Avg duration 08 1 1s558ms 1s558ms 07 1 708ms 708ms 09 1 562ms 562ms 13 1 705ms 705ms 19 1 370ms 370ms 21 1 708ms 708ms 11 1 721ms 721ms 14 1 716ms 716ms [ 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 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
3 3s239ms 2 726ms 2s512ms 1s619ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr30 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 23 1 2s512ms 2s512ms 19 1 726ms 726ms [ User: lfriedman - Total duration: 0ms - Times executed: 2 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr30 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 01:40:42 Duration: 2s512ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr30 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 21:40:29 Duration: 726ms Database: postgres User: pvs Remote: lfriedman
4 3s174ms 5 480ms 811ms 634ms SELECT testname FROM curandtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 23 1 758ms 758ms 07 1 545ms 545ms 09 1 480ms 480ms 19 1 811ms 811ms 21 1 578ms 578ms [ User: lfriedman - Total duration: 77ms - Times executed: 5 ]
-
SELECT testname FROM curandtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 21:40:10 Duration: 811ms Database: postgres User: pvs Remote: lfriedman
-
SELECT testname FROM curandtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-06 01:40:25 Duration: 758ms Database: postgres User: pvs Remote: lfriedman
-
SELECT testname FROM curandtests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 23:19:31 Duration: 578ms Database: postgres User: nightly Remote: lfriedman
5 2s534ms 5 390ms 579ms 506ms SELECT testname FROM thrusttests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 14 1 496ms 496ms 07 1 390ms 390ms 09 1 579ms 579ms 21 1 500ms 500ms 22 1 566ms 566ms [ User: lfriedman - Total duration: 3s438ms - Times executed: 5 ]
-
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
-
SELECT testname FROM thrusttests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-08 23:19:37 Duration: 500ms Database: postgres User: nightly Remote: lfriedman
6 2s494ms 4 407ms 792ms 623ms 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 #6
Day Hour Count Duration Avg duration 08 1 407ms 407ms 14 1 792ms 792ms 13 1 695ms 695ms 14 1 599ms 599ms [ User: lfriedman - Total duration: 6ms - Times executed: 4 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM thrust WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 16:39:41 Duration: 792ms Database: postgres User: nightly Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM thrust WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 15:20:05 Duration: 695ms Database: postgres User: nightly Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM thrust WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-09 16:59:50 Duration: 599ms Database: postgres User: nightly Remote: lfriedman
7 2s466ms 5 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 #7
Day Hour Count Duration Avg duration 23 1 368ms 368ms 13 1 567ms 567ms 21 1 310ms 310ms 22 1 684ms 684ms 14 1 534ms 534ms [ User: lfriedman - Total duration: 2ms - Times executed: 5 ]
-
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
8 2s89ms 3 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 #8
Day Hour Count Duration Avg duration 23 1 917ms 917ms 04 1 432ms 432ms 14 1 739ms 739ms [ User: lfriedman - Total duration: 0ms - Times executed: 3 ]
-
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
9 1s981ms 3 308ms 1s292ms 660ms 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 1 1s292ms 1s292ms 03 1 380ms 380ms 11 1 308ms 308ms [ User: lfriedman - Total duration: 0ms - Times executed: 3 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr32 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 01:40:44 Duration: 1s292ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr32 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 05:00:43 Duration: 380ms Database: postgres User: pvs Remote: lfriedman
-
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-09 13:00:28 Duration: 308ms Database: postgres User: pvs Remote: lfriedman
10 1s948ms 1 1s948ms 1s948ms 1s948ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr40 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 23 1 1s948ms 1s948ms [ User: lfriedman - Total duration: 0ms - Times executed: 1 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger_bcr40 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 01:40:46 Duration: 1s948ms Database: postgres User: pvs Remote: lfriedman
11 1s889ms 3 461ms 916ms 629ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM oclapps WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 23 1 916ms 916ms 08 1 461ms 461ms 07 1 511ms 511ms [ User: lfriedman - Total duration: 0ms - Times executed: 3 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM oclapps WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 01:40:38 Duration: 916ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM oclapps WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:20:13 Duration: 511ms Database: postgres User: nightly Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM oclapps WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 10:01:22 Duration: 461ms Database: postgres User: pvs Remote: lfriedman
12 1s834ms 3 342ms 959ms 611ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmokenew WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 10 1 531ms 531ms 19 1 959ms 959ms 21 1 342ms 342ms [ User: lfriedman - Total duration: 0ms - Times executed: 3 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmokenew WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 21:40:22 Duration: 959ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmokenew WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 12:41:11 Duration: 531ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM profsmokenew WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 23:19:32 Duration: 342ms Database: postgres User: nightly Remote: lfriedman
13 1s618ms 2 720ms 898ms 809ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM interop32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 08 1 898ms 898ms 07 1 720ms 720ms [ User: lfriedman - Total duration: 10ms - Times executed: 2 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM interop32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-06 10:01:09 Duration: 898ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM interop32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:41:27 Duration: 720ms Database: postgres User: pvs Remote: lfriedman
14 1s481ms 1 1s481ms 1s481ms 1s481ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 07 1 1s481ms 1s481ms [ User: lfriedman - Total duration: 0ms - Times executed: 1 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM debugger32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:41:42 Duration: 1s481ms Database: postgres User: pvs Remote: lfriedman
15 1s365ms 1 1s365ms 1s365ms 1s365ms SELECT testname FROM njcublastests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 08 1 1s365ms 1s365ms [ User: lfriedman - Total duration: 1s167ms - Times executed: 1 ]
-
SELECT testname FROM njcublastests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-06 10:00:38 Duration: 1s365ms Database: postgres User: pvs Remote: lfriedman parameters: $1 = '4110', $2 = 'FAILED'
16 1s175ms 2 483ms 691ms 587ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM samples WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 07 1 483ms 483ms 19 1 691ms 691ms [ User: lfriedman - Total duration: 9ms - Times executed: 2 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM samples WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 21:40:21 Duration: 691ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM samples WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 09:41:28 Duration: 483ms Database: postgres User: pvs Remote: lfriedman
17 1s166ms 2 423ms 743ms 583ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM memcheck_bcr32 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 10 1 423ms 423ms 05 1 743ms 743ms [ User: lfriedman - Total duration: 0ms - Times executed: 2 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM memcheck_bcr32 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 07:40:53 Duration: 743ms Database: postgres User: pvs Remote: lfriedman
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM memcheck_bcr32 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-07 12:41:20 Duration: 423ms Database: postgres User: pvs Remote: lfriedman
18 1s93ms 2 372ms 720ms 546ms SELECT testname FROM debuggertests 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 22 1 372ms 372ms 04 1 720ms 720ms [ User: lfriedman - Total duration: 1ms - Times executed: 2 ]
-
SELECT testname FROM debuggertests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-09 06:39:19 Duration: 720ms Database: postgres User: nightly Remote: lfriedman
-
SELECT testname FROM debuggertests WHERE suiteid = $1 AND current_status = $2 AND regressioncl != '3' ORDER BY testname ASC LIMIT 5000;
Date: 2012-12-09 00:59:28 Duration: 372ms Database: postgres User: nightly Remote: lfriedman
19 1s51ms 1 1s51ms 1s51ms 1s51ms SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM nvprof32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 21 1 1s51ms 1s51ms [ User: lfriedman - Total duration: 0ms - Times executed: 1 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM nvprof32on64 WHERE (last_update > $1 AND last_update < $2) AND os = $3 AND arch = $4 AND branch = $5 AND build_type = $6 AND subtest = $7 AND osversion = $8 AND gpu = $9 ORDER BY last_update DESC LIMIT 1;
Date: 2012-12-08 23:19:35 Duration: 1s51ms Database: postgres User: nightly Remote: lfriedman
20 1s4ms 2 368ms 636ms 502ms 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 1 368ms 368ms 11 1 636ms 636ms [ User: lfriedman - Total duration: 0ms - Times executed: 2 ]
-
SELECT id, pass, fail, filtercount, info, current_status, last_update, os, arch, branch, gpu, build_type, subtest, osversion FROM memcheck 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-07 12:41:16 Duration: 368ms Database: postgres User: pvs Remote: lfriedman
-
pgBouncer
Request Throughput
Key values
- 3,530 queries/s Request Peak
- 2012-12-09 20:41:21 Date
Bytes I/O Throughput
Key values
- 1,125,622 Bytes/s In Bytes Peak
- 2012-12-09 01:01:20 Date
- 1,061,373 Bytes/s Out Bytes Peak
- 2012-12-09 00:01:20 Date
Queries Average duration
Key values
- 54ms Average Duration Peak
- 2012-12-09 20:42:21 Date
Established Connections
Key values
- 224 connections Connection Peak
- 2012-12-09 19:30:34 Date
Connections per database
Key values
- nightly Main Database
- 1,258,618 connections Total
Database User Count gasworks2 600 lfriedman 600 grinderman 2,832 lfriedman 2,832 intranet 99,271 lfriedman 99,271 intranet_test 1,440 lfriedman 1,440 jdb 368 lfriedman 368 lfriedman_test 576 lfriedman 576 nightly 986,435 lfriedman 986,435 optique_production 288 lfriedman 288 pgbouncer 577 dalibo 577 sterne_production 666 lfriedman 666 vangard_prod 5,835 lfriedman 5,835 webmail 159,730 lfriedman 159,730 Connections per user
Key values
- lfriedman Main User
- 1,258,618 connections Total
Connections per host
Key values
- 10.10.10.22.13 Main host with 897389 connections
- 1,258,618 Total connections
Simultaneous sessions
Key values
- 548 sessions Session Peak
- 2012-12-09 20:41:26 Date
Histogram of session times
Key values
- 1,098,513 0-500ms duration
Sessions per database
Key values
- nightly Main Database
- 1,264,319 sessions Total
Database User Count Total Duration Average Duration gasworks2 847 5h34m11s 23s672ms grinderman 2,832 13m55s 294ms intranet 100,262 4d2h59m26s 3s554ms intranet_test 1,441 17h15m20s 43s108ms jdb 593 4h46m55s 29s30ms lfriedman_test 576 0ms 0ms nightly 988,947 29d6h26m13s 2s557ms optique_production 320 32m14s 6s43ms pgbouncer 577 0ms 0ms sterne_production 1,091 8h56m1s 29s478ms vangard_prod 6,132 2d5h38m38s 31s493ms webmail 160,701 4d11h55m35s 2s417ms Sessions per user
Key values
- lfriedman Main User
- 1,264,319 sessions Total
Sessions per host
Key values
- 10.10.10.22.13 Main Host
- 1,264,319 sessions Total
Most used reserved pools
Key values
- lfriedman@nightly Most used reserved pool
- 1,561 Time used
- 1,563 Total time reserved pools was used
Rank Times used Reserved pool 1 1,561 lfriedman@nightlyTimes Reported Most used reserved pools #1
Day Hour Count Dec 09 23 56 00 53 01 55 02 48 03 51 04 63 05 83 06 81 07 75 08 79 09 70 10 48 11 45 12 32 13 41 14 66 15 86 16 78 17 68 18 67 19 77 20 85 21 81 22 73 2 2 lfriedman@intranetTimes Reported Most used reserved pools #2
Day Hour Count Dec 09 06 1 07 1 Most Frequent Errors/Events
Key values
- 1,563 Max number of times the same event was reported
- 1,563 Total events found
Rank Times reported Error 1 1,563 WARNING: Taking connection from reserve_poolTimes Reported Most Frequent Error / Event #1
Day Hour Count Dec 09 23 56 00 53 01 55 02 48 03 51 04 63 05 83 06 82 07 76 08 79 09 70 10 48 11 45 12 32 13 41 14 66 15 86 16 78 17 68 18 67 19 77 20 85 21 81 22 73 - WARNING: Taking connection from reserve_pool
- WARNING: Taking connection from reserve_pool
- WARNING: Taking connection from reserve_pool
Date: 2012-12-09 00:00:22 Database: nightly User: lfriedman Remote: 10.10.10.22.13
Date: 2012-12-09 00:00:22 Database: nightly User: lfriedman Remote: 10.10.10.22.13
Date: 2012-12-09 00:00:22 Database: nightly User: lfriedman Remote: 10.10.10.22.13
-
Events
Log levels
Key values
- 6,592,135 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1043 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1,043 Max number of times the same event was reported
- 1,043 Total events found
Rank Times reported Error 1 1,043 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 09 23 80 00 80 01 80 02 80 03 80 04 80 05 80 06 80 07 80 08 80 09 80 10 80 11 80 12 3 - ERROR: invalid input syntax for type date: "" at character 32
Statement: UPDATE ddtracker SET datestamp='' WHERE os='WINXP' AND arch='i686' AND branch='cuda_a' AND dbname='nightly';
Date: 2012-12-09 04:30:41 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