pgBadger-
Global information
- Generated on Fri Mar 27 04:10:04 2026
- Log file: /project/archive/log/postgres/dbdev51/postgresql.log-20260326
- Parsed 3,307 log entries in 2s
- Log start from 2026-03-26 00:08:00 to 2026-03-26 23:41:33
-
Overview
Global Stats
- 5 Number of unique normalized queries
- 11 Number of queries
- 9m58s Total query duration
- 2026-03-26 14:09:47 First query
- 2026-03-26 16:28:40 Last query
- 1 queries/s at 2026-03-26 16:14:08 Query peak
- 9m58s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9m58s Execute total duration
- 29 Number of events
- 5 Number of unique normalized events
- 25 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 403 Total number of sessions
- 10 sessions at 2026-03-26 15:57:02 Session peak
- 8d4h47m42s Total duration of sessions
- 29m17s Average duration of sessions
- 0 Average queries per session
- 1s484ms Average queries duration per session
- 29m16s Average idle time per session
- 403 Total number of connections
- 3 connections/s at 2026-03-26 05:15:00 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-03-26 16:14:08 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-03-26 16:14:08 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 9m58s 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) Mar 26 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 1 0ms 47s724ms 47s724ms 47s724ms 47s724ms 47s724ms 15 1 0ms 1m18s 1m18s 1m18s 1m18s 1m18s 16 9 0ms 1m41s 52s451ms 1m41s 2m12s 2m12s 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 26 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 1 0 47s724ms 0ms 47s724ms 47s724ms 15 1 0 1m18s 0ms 1m18s 1m18s 16 9 0 52s451ms 1m19s 1m41s 2m12s 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 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) Mar 26 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 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 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 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 Mar 26 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 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 0 0.00 0.00% 14 0 1 1.00 0.00% 15 0 1 1.00 0.00% 16 0 9 9.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Mar 26 00 16 0.00/s 01 16 0.00/s 02 16 0.00/s 03 16 0.00/s 04 16 0.00/s 05 16 0.00/s 06 16 0.00/s 07 16 0.00/s 08 16 0.00/s 09 16 0.00/s 10 25 0.01/s 11 22 0.01/s 12 16 0.00/s 13 18 0.01/s 14 20 0.01/s 15 17 0.00/s 16 13 0.00/s 17 16 0.00/s 18 16 0.00/s 19 16 0.00/s 20 16 0.00/s 21 16 0.00/s 22 16 0.00/s 23 16 0.00/s Day Hour Count Average Duration Average idle time Mar 26 00 16 30m41s 30m41s 01 16 30m37s 30m37s 02 16 30m41s 30m41s 03 16 30m41s 30m41s 04 16 30m37s 30m37s 05 16 30m41s 30m41s 06 16 30m41s 30m41s 07 16 30m37s 30m37s 08 16 30m41s 30m41s 09 16 30m41s 30m41s 10 25 19m36s 19m36s 11 22 22m19s 22m19s 12 16 30m41s 30m41s 13 18 27m13s 27m13s 14 19 24m17s 24m14s 15 17 27m9s 27m4s 16 13 24m15s 23m39s 17 16 30m41s 30m41s 18 17 44m23s 44m23s 19 16 30m41s 30m41s 20 16 30m41s 30m41s 21 16 30m37s 30m37s 22 16 30m41s 30m41s 23 16 30m41s 30m41s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2026-03-26 05:15:00 Date
Connections per database
Key values
- ctddev51 Main Database
- 403 connections Total
Connections per user
Key values
- editeu Main User
- 403 connections Total
-
Sessions
Simultaneous sessions
Key values
- 10 sessions Session Peak
- 2026-03-26 15:57:02 Date
Histogram of session times
Key values
- 376 1800000-3600000ms duration
Sessions per database
Key values
- ctddev51 Main Database
- 403 sessions Total
Sessions per user
Key values
- editeu Main User
- 403 sessions Total
Sessions per host
Key values
- 10.12.5.47 Main Host
- 403 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 0 buffers Checkpoint Peak
- Date
- seconds Highest write time
- seconds Sync time
Checkpoint write buffers (5 minutes period)
NO DATASET
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- Date
Checkpoint Wal files usage (5 minutes period)
NO DATASET
Checkpoints distance
Key values
- 0 Mo Distance Peak
- Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 26 00 0 0s 0s 0s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0s 0s 0s 04 0 0s 0s 0s 05 0 0s 0s 0s 06 0 0s 0s 0s 07 0 0s 0s 0s 08 0 0s 0s 0s 09 0 0s 0s 0s 10 0 0s 0s 0s 11 0 0s 0s 0s 12 0 0s 0s 0s 13 0 0s 0s 0s 14 0 0s 0s 0s 15 0 0s 0s 0s 16 0 0s 0s 0s 17 0 0s 0s 0s 18 0 0s 0s 0s 19 0 0s 0s 0s 20 0 0s 0s 0s 21 0 0s 0s 0s 22 0 0s 0s 0s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 26 00 0 0 0 0 0s 0s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 0 0s 0s 04 0 0 0 0 0s 0s 05 0 0 0 0 0s 0s 06 0 0 0 0 0s 0s 07 0 0 0 0 0s 0s 08 0 0 0 0 0s 0s 09 0 0 0 0 0s 0s 10 0 0 0 0 0s 0s 11 0 0 0 0 0s 0s 12 0 0 0 0 0s 0s 13 0 0 0 0 0s 0s 14 0 0 0 0 0s 0s 15 0 0 0 0 0s 0s 16 0 0 0 0 0s 0s 17 0 0 0 0 0s 0s 18 0 0 0 0 0s 0s 19 0 0 0 0 0s 0s 20 0 0 0 0 0s 0s 21 0 0 0 0 0s 0s 22 0 0 0 0 0s 0s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Mar 26 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 Mar 26 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 Mar 26 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
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 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 Mar 26 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 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
- 11 Total read queries
- 0 Total write queries
Queries by database
Key values
- unknown Main database
- 6 Requests
- 5m30s (ctddev51)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 6 Requests
User Request type Count Duration pub1 Total 5 5m30s select 5 5m30s unknown Total 6 4m27s select 6 4m27s Duration by user
Key values
- 5m30s (pub1) Main time consuming user
User Request type Count Duration pub1 Total 5 5m30s select 5 5m30s unknown Total 6 4m27s select 6 4m27s Queries by host
Key values
- unknown Main host
- 11 Requests
- 9m58s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 11 Requests
- 9m58s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-26 22:08:03 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 11 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 1m41s select distinct geneTerm.acc_txt # 015, geneTerm.nm # 015, 'gene' # 015, goTerm.acc_txt # 015, goTerm.nm # 015, 'phenotype' # 015, 'C' from pub1.GENE_GO_ANNOT gga # 015, pub1.TERM geneTerm # 015, pub1.TERM goTerm # 015 where gga.gene_id = geneTerm.id # 015 and gga.go_term_id = goTerm.id # 015;[ Date: 2026-03-26 16:22:04 - Bind query: yes ]
2 1m38s select distinct geneTerm.acc_txt # 015, geneTerm.nm # 015, 'gene' # 015, goTerm.acc_txt # 015, goTerm.nm # 015, 'phenotype' # 015, 'C' from pub1.GENE_GO_ANNOT gga # 015, pub1.TERM geneTerm # 015, pub1.TERM goTerm # 015 where gga.gene_id = geneTerm.id # 015 and gga.go_term_id = goTerm.id # 015;[ Date: 2026-03-26 16:28:03 - Bind query: yes ]
3 1m19s select distinct geneTerm.acc_txt, geneTerm.nm, 'gene', chemTerm.acc_txt, chemTerm.nm, 'chemical', 'C' from pub1.GENE_CHEM_REFERENCE gcr, pub1.TERM geneTerm, pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id;[ Date: 2026-03-26 16:13:53 - Database: ctddev51 - User: pub1 - Bind query: yes ]
4 1m18s select distinct geneTerm.acc_txt, geneTerm.nm, 'gene', chemTerm.acc_txt, chemTerm.nm, 'chemical', 'C' from pub1.GENE_CHEM_REFERENCE gcr, pub1.TERM geneTerm, pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id;[ Date: 2026-03-26 15:58:24 - Database: ctddev51 - User: pub1 - Bind query: yes ]
5 1m3s select distinct geneTerm.acc_txt, geneTerm.nm, 'gene', chemTerm.acc_txt, chemTerm.nm, 'chemical', 'C' from pub1.GENE_CHEM_REFERENCE gcr, pub1.TERM geneTerm, pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id;[ Date: 2026-03-26 16:26:08 - Database: ctddev51 - User: pub1 - Bind query: yes ]
6 1m1s select distinct geneTerm.acc_txt, geneTerm.nm, 'gene', chemTerm.acc_txt, chemTerm.nm, 'chemical', 'C' from pub1.GENE_CHEM_REFERENCE gcr, pub1.TERM geneTerm, pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id;[ Date: 2026-03-26 16:20:08 - Database: ctddev51 - User: pub1 - Bind query: yes ]
7 47s724ms select distinct geneTerm.acc_txt # 015, geneTerm.nm # 015, 'gene' # 015, diseaseTerm.acc_txt # 015, diseaseTerm.nm # 015, 'disease' # 015 from pub1.GENE_DISEASE_REFERENCE cdr # 015, pub1.TERM geneTerm # 015, pub1.TERM diseaseTerm # 015 where cdr.disease_id = diseaseTerm.id # 015 and cdr.gene_id = geneTerm.id # 015 and diseaseTerm.id in ( select descendant_object_id from pub1.DAG_PATH where ancestor_object_id = # 015 ( select id from pub1.TERM where nm = 'Amyotrophic Lateral Sclerosis' and object_type_id = 3)) # 015;[ Date: 2026-03-26 14:09:47 - Database: ctddev51 - User: pub1 - Bind query: yes ]
8 33s820ms select distinct geneTermFrom.acc_txt # 015, geneTermFrom.nm # 015, 'from gene' # 015, geneTermTo.acc_txt # 015, geneTermTo.nm # 015, 'to gene' # 015, 'C' from pub1.GENE_GENE gg # 015, pub1.TERM geneTermFrom # 015, pub1.TERM geneTermTo # 015 where gg.from_gene_id = geneTermFrom.id # 015 and gg.to_gene_id = geneTermTo.id # 015;[ Date: 2026-03-26 16:28:40 - Bind query: yes ]
9 12s132ms select distinct chemTerm.acc_txt # 015, chemTerm.nm # 015, 'chemical' # 015, phenotypeTerm.acc_txt # 015, phenotypeTerm.nm # 015, 'phenotype' # 015, ptr.source_cd # 015 from pub1.PHENOTYPE_TERM_REFERENCE ptr # 015, pub1.TERM chemTerm # 015, pub1.TERM phenotypeTerm # 015 where ptr.phenotype_id = phenotypeTerm.id # 015 and ptr.term_id = chemTerm.id # 015 and term_object_type_id = 2 --chemical #015;[ Date: 2026-03-26 16:26:23 - Bind query: yes ]
10 10s935ms select distinct chemTerm.acc_txt # 015, chemTerm.nm # 015, 'chemical' # 015, phenotypeTerm.acc_txt # 015, phenotypeTerm.nm # 015, 'phenotype' # 015, ptr.source_cd # 015 from pub1.PHENOTYPE_TERM_REFERENCE ptr # 015, pub1.TERM chemTerm # 015, pub1.TERM phenotypeTerm # 015 where ptr.phenotype_id = phenotypeTerm.id # 015 and ptr.term_id = chemTerm.id # 015 and term_object_type_id = 2 --chemical #015;[ Date: 2026-03-26 16:20:22 - Bind query: yes ]
11 10s879ms select distinct chemTerm.acc_txt # 015, chemTerm.nm # 015, 'chemical' # 015, phenotypeTerm.acc_txt # 015, phenotypeTerm.nm # 015, 'phenotype' # 015, ptr.source_cd # 015 from pub1.PHENOTYPE_TERM_REFERENCE ptr # 015, pub1.TERM chemTerm # 015, pub1.TERM phenotypeTerm # 015 where ptr.phenotype_id = phenotypeTerm.id # 015 and ptr.term_id = chemTerm.id # 015 and term_object_type_id = 2 --chemical #015;[ Date: 2026-03-26 16:14:08 - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 4m42s 4 1m1s 1m19s 1m10s select distinct geneterm.acc_txt, geneterm.nm, ?, chemterm.acc_txt, chemterm.nm, ?, ? from pub1.gene_chem_reference gcr, pub1.term geneterm, pub1.term chemterm where gcr.gene_id = geneterm.id and gcr.chem_id = chemterm.id;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 26 15 1 1m18s 1m18s 16 3 3m24s 1m8s [ User: pub1 - Total duration: 4m42s - Times executed: 4 ]
-
select distinct geneTerm.acc_txt, geneTerm.nm, 'gene', chemTerm.acc_txt, chemTerm.nm, 'chemical', 'C' from pub1.GENE_CHEM_REFERENCE gcr, pub1.TERM geneTerm, pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id;
Date: 2026-03-26 16:13:53 Duration: 1m19s Database: ctddev51 User: pub1 Bind query: yes
-
select distinct geneTerm.acc_txt, geneTerm.nm, 'gene', chemTerm.acc_txt, chemTerm.nm, 'chemical', 'C' from pub1.GENE_CHEM_REFERENCE gcr, pub1.TERM geneTerm, pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id;
Date: 2026-03-26 15:58:24 Duration: 1m18s Database: ctddev51 User: pub1 Bind query: yes
-
select distinct geneTerm.acc_txt, geneTerm.nm, 'gene', chemTerm.acc_txt, chemTerm.nm, 'chemical', 'C' from pub1.GENE_CHEM_REFERENCE gcr, pub1.TERM geneTerm, pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id;
Date: 2026-03-26 16:26:08 Duration: 1m3s Database: ctddev51 User: pub1 Bind query: yes
2 3m19s 2 1m38s 1m41s 1m39s select distinct geneterm.acc_txt # ?, geneterm.nm # ?, ? # ?, goterm.acc_txt # ?, goterm.nm # ?, ? # ?, ? from pub1.gene_go_annot gga # ?, pub1.term geneterm # ?, pub1.term goterm # ? where gga.gene_id = geneterm.id # ? and gga.go_term_id = goterm.id # ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 26 16 2 3m19s 1m39s -
select distinct geneTerm.acc_txt # 015, geneTerm.nm # 015, 'gene' # 015, goTerm.acc_txt # 015, goTerm.nm # 015, 'phenotype' # 015, 'C' from pub1.GENE_GO_ANNOT gga # 015, pub1.TERM geneTerm # 015, pub1.TERM goTerm # 015 where gga.gene_id = geneTerm.id # 015 and gga.go_term_id = goTerm.id # 015;
Date: 2026-03-26 16:22:04 Duration: 1m41s Bind query: yes
-
select distinct geneTerm.acc_txt # 015, geneTerm.nm # 015, 'gene' # 015, goTerm.acc_txt # 015, goTerm.nm # 015, 'phenotype' # 015, 'C' from pub1.GENE_GO_ANNOT gga # 015, pub1.TERM geneTerm # 015, pub1.TERM goTerm # 015 where gga.gene_id = geneTerm.id # 015 and gga.go_term_id = goTerm.id # 015;
Date: 2026-03-26 16:28:03 Duration: 1m38s Bind query: yes
3 47s724ms 1 47s724ms 47s724ms 47s724ms select distinct geneterm.acc_txt # ?, geneterm.nm # ?, ? # ?, diseaseterm.acc_txt # ?, diseaseterm.nm # ?, ? # ? from pub1.gene_disease_reference cdr # ?, pub1.term geneterm # ?, pub1.term diseaseterm # ? where cdr.disease_id = diseaseterm.id # ? and cdr.gene_id = geneterm.id # ? and diseaseterm.id in ( select descendant_object_id from pub1.dag_path where ancestor_object_id = # ? ( select id from pub1.term where nm = ? and object_type_id = ?)) # ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 26 14 1 47s724ms 47s724ms [ User: pub1 - Total duration: 47s724ms - Times executed: 1 ]
-
select distinct geneTerm.acc_txt # 015, geneTerm.nm # 015, 'gene' # 015, diseaseTerm.acc_txt # 015, diseaseTerm.nm # 015, 'disease' # 015 from pub1.GENE_DISEASE_REFERENCE cdr # 015, pub1.TERM geneTerm # 015, pub1.TERM diseaseTerm # 015 where cdr.disease_id = diseaseTerm.id # 015 and cdr.gene_id = geneTerm.id # 015 and diseaseTerm.id in ( select descendant_object_id from pub1.DAG_PATH where ancestor_object_id = # 015 ( select id from pub1.TERM where nm = 'Amyotrophic Lateral Sclerosis' and object_type_id = 3)) # 015;
Date: 2026-03-26 14:09:47 Duration: 47s724ms Database: ctddev51 User: pub1 Bind query: yes
4 33s947ms 3 10s879ms 12s132ms 11s315ms select distinct chemterm.acc_txt # ?, chemterm.nm # ?, ? # ?, phenotypeterm.acc_txt # ?, phenotypeterm.nm # ?, ? # ?, ptr.source_cd # ? from pub1.phenotype_term_reference ptr # ?, pub1.term chemterm # ?, pub1.term phenotypeterm # ? where ptr.phenotype_id = phenotypeterm.id # ? and ptr.term_id = chemterm.id # ? and term_object_type_id = ? --chemical #?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 26 16 3 33s947ms 11s315ms -
select distinct chemTerm.acc_txt # 015, chemTerm.nm # 015, 'chemical' # 015, phenotypeTerm.acc_txt # 015, phenotypeTerm.nm # 015, 'phenotype' # 015, ptr.source_cd # 015 from pub1.PHENOTYPE_TERM_REFERENCE ptr # 015, pub1.TERM chemTerm # 015, pub1.TERM phenotypeTerm # 015 where ptr.phenotype_id = phenotypeTerm.id # 015 and ptr.term_id = chemTerm.id # 015 and term_object_type_id = 2 --chemical #015;
Date: 2026-03-26 16:26:23 Duration: 12s132ms Bind query: yes
-
select distinct chemTerm.acc_txt # 015, chemTerm.nm # 015, 'chemical' # 015, phenotypeTerm.acc_txt # 015, phenotypeTerm.nm # 015, 'phenotype' # 015, ptr.source_cd # 015 from pub1.PHENOTYPE_TERM_REFERENCE ptr # 015, pub1.TERM chemTerm # 015, pub1.TERM phenotypeTerm # 015 where ptr.phenotype_id = phenotypeTerm.id # 015 and ptr.term_id = chemTerm.id # 015 and term_object_type_id = 2 --chemical #015;
Date: 2026-03-26 16:20:22 Duration: 10s935ms Bind query: yes
-
select distinct chemTerm.acc_txt # 015, chemTerm.nm # 015, 'chemical' # 015, phenotypeTerm.acc_txt # 015, phenotypeTerm.nm # 015, 'phenotype' # 015, ptr.source_cd # 015 from pub1.PHENOTYPE_TERM_REFERENCE ptr # 015, pub1.TERM chemTerm # 015, pub1.TERM phenotypeTerm # 015 where ptr.phenotype_id = phenotypeTerm.id # 015 and ptr.term_id = chemTerm.id # 015 and term_object_type_id = 2 --chemical #015;
Date: 2026-03-26 16:14:08 Duration: 10s879ms Bind query: yes
5 33s820ms 1 33s820ms 33s820ms 33s820ms select distinct genetermfrom.acc_txt # ?, genetermfrom.nm # ?, ? # ?, genetermto.acc_txt # ?, genetermto.nm # ?, ? # ?, ? from pub1.gene_gene gg # ?, pub1.term genetermfrom # ?, pub1.term genetermto # ? where gg.from_gene_id = genetermfrom.id # ? and gg.to_gene_id = genetermto.id # ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 26 16 1 33s820ms 33s820ms -
select distinct geneTermFrom.acc_txt # 015, geneTermFrom.nm # 015, 'from gene' # 015, geneTermTo.acc_txt # 015, geneTermTo.nm # 015, 'to gene' # 015, 'C' from pub1.GENE_GENE gg # 015, pub1.TERM geneTermFrom # 015, pub1.TERM geneTermTo # 015 where gg.from_gene_id = geneTermFrom.id # 015 and gg.to_gene_id = geneTermTo.id # 015;
Date: 2026-03-26 16:28:40 Duration: 33s820ms Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 4 4m42s 1m1s 1m19s 1m10s select distinct geneterm.acc_txt, geneterm.nm, ?, chemterm.acc_txt, chemterm.nm, ?, ? from pub1.gene_chem_reference gcr, pub1.term geneterm, pub1.term chemterm where gcr.gene_id = geneterm.id and gcr.chem_id = chemterm.id;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 26 15 1 1m18s 1m18s 16 3 3m24s 1m8s [ User: pub1 - Total duration: 4m42s - Times executed: 4 ]
-
select distinct geneTerm.acc_txt, geneTerm.nm, 'gene', chemTerm.acc_txt, chemTerm.nm, 'chemical', 'C' from pub1.GENE_CHEM_REFERENCE gcr, pub1.TERM geneTerm, pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id;
Date: 2026-03-26 16:13:53 Duration: 1m19s Database: ctddev51 User: pub1 Bind query: yes
-
select distinct geneTerm.acc_txt, geneTerm.nm, 'gene', chemTerm.acc_txt, chemTerm.nm, 'chemical', 'C' from pub1.GENE_CHEM_REFERENCE gcr, pub1.TERM geneTerm, pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id;
Date: 2026-03-26 15:58:24 Duration: 1m18s Database: ctddev51 User: pub1 Bind query: yes
-
select distinct geneTerm.acc_txt, geneTerm.nm, 'gene', chemTerm.acc_txt, chemTerm.nm, 'chemical', 'C' from pub1.GENE_CHEM_REFERENCE gcr, pub1.TERM geneTerm, pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id;
Date: 2026-03-26 16:26:08 Duration: 1m3s Database: ctddev51 User: pub1 Bind query: yes
2 3 33s947ms 10s879ms 12s132ms 11s315ms select distinct chemterm.acc_txt # ?, chemterm.nm # ?, ? # ?, phenotypeterm.acc_txt # ?, phenotypeterm.nm # ?, ? # ?, ptr.source_cd # ? from pub1.phenotype_term_reference ptr # ?, pub1.term chemterm # ?, pub1.term phenotypeterm # ? where ptr.phenotype_id = phenotypeterm.id # ? and ptr.term_id = chemterm.id # ? and term_object_type_id = ? --chemical #?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 26 16 3 33s947ms 11s315ms -
select distinct chemTerm.acc_txt # 015, chemTerm.nm # 015, 'chemical' # 015, phenotypeTerm.acc_txt # 015, phenotypeTerm.nm # 015, 'phenotype' # 015, ptr.source_cd # 015 from pub1.PHENOTYPE_TERM_REFERENCE ptr # 015, pub1.TERM chemTerm # 015, pub1.TERM phenotypeTerm # 015 where ptr.phenotype_id = phenotypeTerm.id # 015 and ptr.term_id = chemTerm.id # 015 and term_object_type_id = 2 --chemical #015;
Date: 2026-03-26 16:26:23 Duration: 12s132ms Bind query: yes
-
select distinct chemTerm.acc_txt # 015, chemTerm.nm # 015, 'chemical' # 015, phenotypeTerm.acc_txt # 015, phenotypeTerm.nm # 015, 'phenotype' # 015, ptr.source_cd # 015 from pub1.PHENOTYPE_TERM_REFERENCE ptr # 015, pub1.TERM chemTerm # 015, pub1.TERM phenotypeTerm # 015 where ptr.phenotype_id = phenotypeTerm.id # 015 and ptr.term_id = chemTerm.id # 015 and term_object_type_id = 2 --chemical #015;
Date: 2026-03-26 16:20:22 Duration: 10s935ms Bind query: yes
-
select distinct chemTerm.acc_txt # 015, chemTerm.nm # 015, 'chemical' # 015, phenotypeTerm.acc_txt # 015, phenotypeTerm.nm # 015, 'phenotype' # 015, ptr.source_cd # 015 from pub1.PHENOTYPE_TERM_REFERENCE ptr # 015, pub1.TERM chemTerm # 015, pub1.TERM phenotypeTerm # 015 where ptr.phenotype_id = phenotypeTerm.id # 015 and ptr.term_id = chemTerm.id # 015 and term_object_type_id = 2 --chemical #015;
Date: 2026-03-26 16:14:08 Duration: 10s879ms Bind query: yes
3 2 3m19s 1m38s 1m41s 1m39s select distinct geneterm.acc_txt # ?, geneterm.nm # ?, ? # ?, goterm.acc_txt # ?, goterm.nm # ?, ? # ?, ? from pub1.gene_go_annot gga # ?, pub1.term geneterm # ?, pub1.term goterm # ? where gga.gene_id = geneterm.id # ? and gga.go_term_id = goterm.id # ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 26 16 2 3m19s 1m39s -
select distinct geneTerm.acc_txt # 015, geneTerm.nm # 015, 'gene' # 015, goTerm.acc_txt # 015, goTerm.nm # 015, 'phenotype' # 015, 'C' from pub1.GENE_GO_ANNOT gga # 015, pub1.TERM geneTerm # 015, pub1.TERM goTerm # 015 where gga.gene_id = geneTerm.id # 015 and gga.go_term_id = goTerm.id # 015;
Date: 2026-03-26 16:22:04 Duration: 1m41s Bind query: yes
-
select distinct geneTerm.acc_txt # 015, geneTerm.nm # 015, 'gene' # 015, goTerm.acc_txt # 015, goTerm.nm # 015, 'phenotype' # 015, 'C' from pub1.GENE_GO_ANNOT gga # 015, pub1.TERM geneTerm # 015, pub1.TERM goTerm # 015 where gga.gene_id = geneTerm.id # 015 and gga.go_term_id = goTerm.id # 015;
Date: 2026-03-26 16:28:03 Duration: 1m38s Bind query: yes
4 1 47s724ms 47s724ms 47s724ms 47s724ms select distinct geneterm.acc_txt # ?, geneterm.nm # ?, ? # ?, diseaseterm.acc_txt # ?, diseaseterm.nm # ?, ? # ? from pub1.gene_disease_reference cdr # ?, pub1.term geneterm # ?, pub1.term diseaseterm # ? where cdr.disease_id = diseaseterm.id # ? and cdr.gene_id = geneterm.id # ? and diseaseterm.id in ( select descendant_object_id from pub1.dag_path where ancestor_object_id = # ? ( select id from pub1.term where nm = ? and object_type_id = ?)) # ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 26 14 1 47s724ms 47s724ms [ User: pub1 - Total duration: 47s724ms - Times executed: 1 ]
-
select distinct geneTerm.acc_txt # 015, geneTerm.nm # 015, 'gene' # 015, diseaseTerm.acc_txt # 015, diseaseTerm.nm # 015, 'disease' # 015 from pub1.GENE_DISEASE_REFERENCE cdr # 015, pub1.TERM geneTerm # 015, pub1.TERM diseaseTerm # 015 where cdr.disease_id = diseaseTerm.id # 015 and cdr.gene_id = geneTerm.id # 015 and diseaseTerm.id in ( select descendant_object_id from pub1.DAG_PATH where ancestor_object_id = # 015 ( select id from pub1.TERM where nm = 'Amyotrophic Lateral Sclerosis' and object_type_id = 3)) # 015;
Date: 2026-03-26 14:09:47 Duration: 47s724ms Database: ctddev51 User: pub1 Bind query: yes
5 1 33s820ms 33s820ms 33s820ms 33s820ms select distinct genetermfrom.acc_txt # ?, genetermfrom.nm # ?, ? # ?, genetermto.acc_txt # ?, genetermto.nm # ?, ? # ?, ? from pub1.gene_gene gg # ?, pub1.term genetermfrom # ?, pub1.term genetermto # ? where gg.from_gene_id = genetermfrom.id # ? and gg.to_gene_id = genetermto.id # ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 26 16 1 33s820ms 33s820ms -
select distinct geneTermFrom.acc_txt # 015, geneTermFrom.nm # 015, 'from gene' # 015, geneTermTo.acc_txt # 015, geneTermTo.nm # 015, 'to gene' # 015, 'C' from pub1.GENE_GENE gg # 015, pub1.TERM geneTermFrom # 015, pub1.TERM geneTermTo # 015 where gg.from_gene_id = geneTermFrom.id # 015 and gg.to_gene_id = geneTermTo.id # 015;
Date: 2026-03-26 16:28:40 Duration: 33s820ms Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1m38s 1m41s 1m39s 2 3m19s select distinct geneterm.acc_txt # ?, geneterm.nm # ?, ? # ?, goterm.acc_txt # ?, goterm.nm # ?, ? # ?, ? from pub1.gene_go_annot gga # ?, pub1.term geneterm # ?, pub1.term goterm # ? where gga.gene_id = geneterm.id # ? and gga.go_term_id = goterm.id # ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 26 16 2 3m19s 1m39s -
select distinct geneTerm.acc_txt # 015, geneTerm.nm # 015, 'gene' # 015, goTerm.acc_txt # 015, goTerm.nm # 015, 'phenotype' # 015, 'C' from pub1.GENE_GO_ANNOT gga # 015, pub1.TERM geneTerm # 015, pub1.TERM goTerm # 015 where gga.gene_id = geneTerm.id # 015 and gga.go_term_id = goTerm.id # 015;
Date: 2026-03-26 16:22:04 Duration: 1m41s Bind query: yes
-
select distinct geneTerm.acc_txt # 015, geneTerm.nm # 015, 'gene' # 015, goTerm.acc_txt # 015, goTerm.nm # 015, 'phenotype' # 015, 'C' from pub1.GENE_GO_ANNOT gga # 015, pub1.TERM geneTerm # 015, pub1.TERM goTerm # 015 where gga.gene_id = geneTerm.id # 015 and gga.go_term_id = goTerm.id # 015;
Date: 2026-03-26 16:28:03 Duration: 1m38s Bind query: yes
2 1m1s 1m19s 1m10s 4 4m42s select distinct geneterm.acc_txt, geneterm.nm, ?, chemterm.acc_txt, chemterm.nm, ?, ? from pub1.gene_chem_reference gcr, pub1.term geneterm, pub1.term chemterm where gcr.gene_id = geneterm.id and gcr.chem_id = chemterm.id;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 26 15 1 1m18s 1m18s 16 3 3m24s 1m8s [ User: pub1 - Total duration: 4m42s - Times executed: 4 ]
-
select distinct geneTerm.acc_txt, geneTerm.nm, 'gene', chemTerm.acc_txt, chemTerm.nm, 'chemical', 'C' from pub1.GENE_CHEM_REFERENCE gcr, pub1.TERM geneTerm, pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id;
Date: 2026-03-26 16:13:53 Duration: 1m19s Database: ctddev51 User: pub1 Bind query: yes
-
select distinct geneTerm.acc_txt, geneTerm.nm, 'gene', chemTerm.acc_txt, chemTerm.nm, 'chemical', 'C' from pub1.GENE_CHEM_REFERENCE gcr, pub1.TERM geneTerm, pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id;
Date: 2026-03-26 15:58:24 Duration: 1m18s Database: ctddev51 User: pub1 Bind query: yes
-
select distinct geneTerm.acc_txt, geneTerm.nm, 'gene', chemTerm.acc_txt, chemTerm.nm, 'chemical', 'C' from pub1.GENE_CHEM_REFERENCE gcr, pub1.TERM geneTerm, pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id;
Date: 2026-03-26 16:26:08 Duration: 1m3s Database: ctddev51 User: pub1 Bind query: yes
3 47s724ms 47s724ms 47s724ms 1 47s724ms select distinct geneterm.acc_txt # ?, geneterm.nm # ?, ? # ?, diseaseterm.acc_txt # ?, diseaseterm.nm # ?, ? # ? from pub1.gene_disease_reference cdr # ?, pub1.term geneterm # ?, pub1.term diseaseterm # ? where cdr.disease_id = diseaseterm.id # ? and cdr.gene_id = geneterm.id # ? and diseaseterm.id in ( select descendant_object_id from pub1.dag_path where ancestor_object_id = # ? ( select id from pub1.term where nm = ? and object_type_id = ?)) # ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 26 14 1 47s724ms 47s724ms [ User: pub1 - Total duration: 47s724ms - Times executed: 1 ]
-
select distinct geneTerm.acc_txt # 015, geneTerm.nm # 015, 'gene' # 015, diseaseTerm.acc_txt # 015, diseaseTerm.nm # 015, 'disease' # 015 from pub1.GENE_DISEASE_REFERENCE cdr # 015, pub1.TERM geneTerm # 015, pub1.TERM diseaseTerm # 015 where cdr.disease_id = diseaseTerm.id # 015 and cdr.gene_id = geneTerm.id # 015 and diseaseTerm.id in ( select descendant_object_id from pub1.DAG_PATH where ancestor_object_id = # 015 ( select id from pub1.TERM where nm = 'Amyotrophic Lateral Sclerosis' and object_type_id = 3)) # 015;
Date: 2026-03-26 14:09:47 Duration: 47s724ms Database: ctddev51 User: pub1 Bind query: yes
4 33s820ms 33s820ms 33s820ms 1 33s820ms select distinct genetermfrom.acc_txt # ?, genetermfrom.nm # ?, ? # ?, genetermto.acc_txt # ?, genetermto.nm # ?, ? # ?, ? from pub1.gene_gene gg # ?, pub1.term genetermfrom # ?, pub1.term genetermto # ? where gg.from_gene_id = genetermfrom.id # ? and gg.to_gene_id = genetermto.id # ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 26 16 1 33s820ms 33s820ms -
select distinct geneTermFrom.acc_txt # 015, geneTermFrom.nm # 015, 'from gene' # 015, geneTermTo.acc_txt # 015, geneTermTo.nm # 015, 'to gene' # 015, 'C' from pub1.GENE_GENE gg # 015, pub1.TERM geneTermFrom # 015, pub1.TERM geneTermTo # 015 where gg.from_gene_id = geneTermFrom.id # 015 and gg.to_gene_id = geneTermTo.id # 015;
Date: 2026-03-26 16:28:40 Duration: 33s820ms Bind query: yes
5 10s879ms 12s132ms 11s315ms 3 33s947ms select distinct chemterm.acc_txt # ?, chemterm.nm # ?, ? # ?, phenotypeterm.acc_txt # ?, phenotypeterm.nm # ?, ? # ?, ptr.source_cd # ? from pub1.phenotype_term_reference ptr # ?, pub1.term chemterm # ?, pub1.term phenotypeterm # ? where ptr.phenotype_id = phenotypeterm.id # ? and ptr.term_id = chemterm.id # ? and term_object_type_id = ? --chemical #?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 26 16 3 33s947ms 11s315ms -
select distinct chemTerm.acc_txt # 015, chemTerm.nm # 015, 'chemical' # 015, phenotypeTerm.acc_txt # 015, phenotypeTerm.nm # 015, 'phenotype' # 015, ptr.source_cd # 015 from pub1.PHENOTYPE_TERM_REFERENCE ptr # 015, pub1.TERM chemTerm # 015, pub1.TERM phenotypeTerm # 015 where ptr.phenotype_id = phenotypeTerm.id # 015 and ptr.term_id = chemTerm.id # 015 and term_object_type_id = 2 --chemical #015;
Date: 2026-03-26 16:26:23 Duration: 12s132ms Bind query: yes
-
select distinct chemTerm.acc_txt # 015, chemTerm.nm # 015, 'chemical' # 015, phenotypeTerm.acc_txt # 015, phenotypeTerm.nm # 015, 'phenotype' # 015, ptr.source_cd # 015 from pub1.PHENOTYPE_TERM_REFERENCE ptr # 015, pub1.TERM chemTerm # 015, pub1.TERM phenotypeTerm # 015 where ptr.phenotype_id = phenotypeTerm.id # 015 and ptr.term_id = chemTerm.id # 015 and term_object_type_id = 2 --chemical #015;
Date: 2026-03-26 16:20:22 Duration: 10s935ms Bind query: yes
-
select distinct chemTerm.acc_txt # 015, chemTerm.nm # 015, 'chemical' # 015, phenotypeTerm.acc_txt # 015, phenotypeTerm.nm # 015, 'phenotype' # 015, ptr.source_cd # 015 from pub1.PHENOTYPE_TERM_REFERENCE ptr # 015, pub1.TERM chemTerm # 015, pub1.TERM phenotypeTerm # 015 where ptr.phenotype_id = phenotypeTerm.id # 015 and ptr.term_id = chemTerm.id # 015 and term_object_type_id = 2 --chemical #015;
Date: 2026-03-26 16:14:08 Duration: 10s879ms Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 1,655 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 1 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
- 27 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 25 Max number of times the same event was reported
- 29 Total events found
Rank Times reported Error 1 25 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 26 10 9 11 6 13 2 14 4 15 1 16 3 2 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 26 10 1 - ERROR: syntax error at or near ")" at character 837
Statement: select distinct chemTerm.acc_txt #015 ,chemTerm.nm #015 ,'chemical' #015 ,diseaseTerm.acc_txt #015 ,diseaseTerm.nm #015 ,'disease' #015 ,cdr.source_cd #015 from pub1.CHEM_DISEASE_REFERENCE cdr #015 ,pub1.TERM chemTerm #015 ,pub1.TERM diseaseTerm #015 where cdr.disease_id = diseaseTerm.id #015 and cdr.chem_id = chemTerm.id #015 and diseaseTerm.id in ( select descendant_object_id from pub1.DAG_PATH where ancestor_object_id = #015 )#015
Date: 2026-03-26 10:24:24 Database: ctddev51 Application: User: pub1 Remote:
3 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 26 15 1 - FATAL: connection to client lost
Statement: select distinct geneTerm.acc_txt ,geneTerm.nm ,'gene' ,chemTerm.acc_txt ,chemTerm.nm ,'chemical' , 'C' from pub1.GENE_CHEM_REFERENCE gcr ,pub1.TERM geneTerm ,pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id
Date: 2026-03-26 15:54:50
4 1 LOG: could not send data to client: Connection reset by peer
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 26 15 1 - LOG: could not send data to client: Connection reset by peer
Statement: select distinct geneTerm.acc_txt ,geneTerm.nm ,'gene' ,chemTerm.acc_txt ,chemTerm.nm ,'chemical' , 'C' from pub1.GENE_CHEM_REFERENCE gcr ,pub1.TERM geneTerm ,pub1.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id
Date: 2026-03-26 15:54:50 Database: ctddev51 Application: User: pub1 Remote:
5 1 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 26 18 1