pgBadger-
Global information
- Generated on Thu Feb 26 04:15:03 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260225
- Parsed 26,615 log entries in 2s
- Log start from 2026-02-25 00:00:01 to 2026-02-25 23:59:59
-
Overview
Global Stats
- 101 Number of unique normalized queries
- 186 Number of queries
- 5h41m18s Total query duration
- 2026-02-25 00:09:09 First query
- 2026-02-25 23:59:29 Last query
- 1 queries/s at 2026-02-25 04:33:34 Query peak
- 5h41m18s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 5h41m18s Execute total duration
- 15 Number of events
- 6 Number of unique normalized events
- 4 Max number of times the same event was reported
- 0 Number of cancellation
- 70 Total number of automatic vacuums
- 85 Total number of automatic analyzes
- 2,038 Number temporary file
- 28.49 GiB Max size of temporary file
- 210.00 MiB Average size of temporary file
- 2,156 Total number of sessions
- 189 sessions at 2026-02-25 23:59:05 Session peak
- 46d16h4m45s Total duration of sessions
- 31m10s Average duration of sessions
- 0 Average queries per session
- 9s498ms Average queries duration per session
- 31m Average idle time per session
- 2,168 Total number of connections
- 9 connections/s at 2026-02-25 05:40:08 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-02-25 04:33:34 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-02-25 04:33:34 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-02-25 21:24:48 Date
Queries duration
Key values
- 5h41m18s 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) Feb 25 00 2 0ms 9m7s 4m37s 0ms 0ms 9m14s 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 1 0ms 6s50ms 6s50ms 0ms 0ms 6s50ms 05 4 0ms 7s98ms 7s47ms 0ms 7s18ms 14s116ms 06 10 0ms 1m50s 22s560ms 20s727ms 45s707ms 1m50s 07 3 0ms 10s629ms 10s423ms 0ms 0ms 31s270ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 12 0ms 1m50s 19s450ms 12s685ms 39s9ms 1m50s 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 1 0ms 7s286ms 7s286ms 0ms 0ms 7s286ms 13 24 0ms 4m52s 29s117ms 38s23ms 1m51s 5m9s 14 33 0ms 2m58s 49s911ms 1m57s 2m24s 3m33s 15 5 0ms 2m12s 37s103ms 6s522ms 37s765ms 2m12s 16 4 0ms 8s90ms 6s881ms 0ms 5s706ms 8s90ms 17 10 0ms 27m 5m39s 1m55s 4m42s 27m 18 15 0ms 34m25s 3m19s 47s242ms 10m36s 34m25s 19 5 0ms 46s951ms 45s672ms 45s877ms 46s419ms 46s951ms 20 1 0ms 45m29s 45m29s 0ms 0ms 45m29s 21 36 0ms 51m37s 2m42s 3m30s 4m59s 51m37s 22 3 0ms 32s330ms 20s289ms 0ms 28s539ms 32s330ms 23 17 0ms 12m58s 1m33s 2m25s 3m30s 12m58s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Feb 25 00 1 0 9m7s 0ms 0ms 9m7s 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 1 0 6s50ms 0ms 0ms 6s50ms 05 4 0 7s47ms 0ms 0ms 14s116ms 06 1 9 22s560ms 0ms 20s727ms 1m50s 07 3 0 10s423ms 0ms 0ms 31s270ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 3 9 19s450ms 0ms 12s685ms 1m50s 11 0 0 0ms 0ms 0ms 0ms 12 1 0 7s286ms 0ms 0ms 7s286ms 13 23 0 29s993ms 0ms 38s23ms 5m9s 14 24 9 49s911ms 1m25s 1m42s 2m22s 15 1 0 6s522ms 0ms 0ms 6s522ms 16 4 0 6s881ms 0ms 0ms 8s90ms 17 0 0 0ms 0ms 0ms 0ms 18 6 9 3m19s 20s802ms 47s242ms 34m25s 19 5 0 45s672ms 0ms 45s877ms 46s951ms 20 1 0 45m29s 0ms 0ms 45m29s 21 11 0 6m30s 12s173ms 1m47s 51m37s 22 3 0 20s289ms 0ms 0ms 32s330ms 23 14 0 34s122ms 17s962ms 41s493ms 2m57s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Feb 25 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 1 0 0 0 8s967ms 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 10 0 0 0 5m39s 0ms 0ms 15m37s 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 Feb 25 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 1 1.00 0.00% 05 0 4 4.00 0.00% 06 0 1 1.00 0.00% 07 0 3 3.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 3 3.00 0.00% 11 0 0 0.00 0.00% 12 0 1 1.00 0.00% 13 0 23 23.00 0.00% 14 0 24 24.00 0.00% 15 0 0 0.00 0.00% 16 0 4 4.00 0.00% 17 0 10 10.00 0.00% 18 0 6 6.00 0.00% 19 0 5 5.00 0.00% 20 0 1 1.00 0.00% 21 0 36 36.00 0.00% 22 0 3 3.00 0.00% 23 0 17 17.00 0.00% Day Hour Count Average / Second Feb 25 00 82 0.02/s 01 84 0.02/s 02 83 0.02/s 03 77 0.02/s 04 90 0.03/s 05 110 0.03/s 06 81 0.02/s 07 89 0.02/s 08 76 0.02/s 09 77 0.02/s 10 105 0.03/s 11 76 0.02/s 12 76 0.02/s 13 164 0.05/s 14 127 0.04/s 15 83 0.02/s 16 75 0.02/s 17 81 0.02/s 18 89 0.02/s 19 80 0.02/s 20 78 0.02/s 21 89 0.02/s 22 85 0.02/s 23 111 0.03/s Day Hour Count Average Duration Average idle time Feb 25 00 82 29m37s 29m30s 01 84 28m44s 28m44s 02 83 29m33s 29m33s 03 77 30m3s 30m3s 04 90 25m13s 25m13s 05 110 22m54s 22m53s 06 81 29m11s 29m9s 07 89 28m14s 28m14s 08 76 31m19s 31m19s 09 77 31m9s 31m9s 10 97 24m53s 24m50s 11 76 31m33s 31m33s 12 76 32m 32m 13 163 15m9s 15m5s 14 125 19m26s 19m13s 15 83 29m53s 29m51s 16 74 31m24s 31m24s 17 81 30m13s 29m31s 18 89 26m37s 26m3s 19 80 30m19s 30m16s 20 78 30m4s 29m29s 21 89 2h6m15s 2h5m9s 22 85 29m22s 29m22s 23 111 25m51s 25m37s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-02-25 05:40:08 Date
Connections per database
Key values
- ctdprd51 Main Database
- 2,168 connections Total
Connections per user
Key values
- pubeu Main User
- 2,168 connections Total
-
Sessions
Simultaneous sessions
Key values
- 189 sessions Session Peak
- 2026-02-25 23:59:05 Date
Histogram of session times
Key values
- 1,802 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 2,156 sessions Total
Sessions per user
Key values
- pubeu Main User
- 2,156 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 2,156 sessions Total
Host Count Total Duration Average Duration 10.12.5.45 381 7d23h59m5s 30m14s 10.12.5.46 376 8d10m53s 30m40s 10.12.5.52 33 58s278ms 1s766ms 10.12.5.53 433 8d11m33s 26m37s 10.12.5.54 377 8d4m35s 30m34s 10.12.5.55 367 8d2m53s 31m23s 10.12.5.56 174 8h15m5s 2m50s 192.168.201.10 1 721ms 721ms 192.168.201.14 2 1s387ms 693ms ::1 12 6d7h19m36s 12h36m38s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 798,752 buffers Checkpoint Peak
- 2026-02-25 18:18:10 Date
- 1620.010 seconds Highest write time
- 0.429 seconds Sync time
Checkpoints Wal files
Key values
- 571 files Wal files usage Peak
- 2026-02-25 23:32:54 Date
Checkpoints distance
Key values
- 17,282.69 Mo Distance Peak
- 2026-02-25 21:23:45 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Feb 25 00 295 29.737s 0.003s 29.748s 01 85 8.687s 0.002s 8.698s 02 87 8.887s 0.002s 8.896s 03 71 7.28s 0.002s 7.288s 04 48,479 1,626.35s 0.003s 1,626.425s 05 108,603 1,622.863s 0.002s 1,622.944s 06 136 13.817s 0.002s 13.827s 07 34,560 1,628.509s 0.002s 1,628.565s 08 167 16.908s 0.002s 16.917s 09 1,268 127.204s 0.002s 127.252s 10 2,872 287.672s 0.092s 287.911s 11 346 34.866s 0.002s 34.895s 12 374 37.653s 0.002s 37.662s 13 295,764 1,771.106s 0.582s 1,773.353s 14 6,063 535.161s 0.752s 541.185s 15 86,322 1,705.251s 0.075s 1,708.743s 16 30 3.177s 0.002s 3.186s 17 3,238,279 2,822.652s 0.898s 2,828.679s 18 798,752 1,619.095s 0.009s 1,620.152s 19 219,287 1,622.426s 0.011s 1,622.888s 20 69 7.082s 0.002s 7.091s 21 61,178 194.308s 0.761s 204.19s 22 778,090 1,621.486s 0.009s 1,622.507s 23 685,365 2,870.787s 0.012s 2,875.843s Day Hour Added Removed Recycled Synced files Longest sync Average sync Feb 25 00 0 0 0 58 0.001s 0.002s 01 0 0 0 20 0.001s 0.002s 02 0 0 0 19 0.001s 0.002s 03 0 0 0 22 0.001s 0.002s 04 0 0 32 48 0.001s 0.002s 05 0 0 34 44 0.001s 0.002s 06 0 0 0 33 0.001s 0.002s 07 0 0 23 88 0.001s 0.002s 08 0 0 0 30 0.001s 0.002s 09 0 0 1 141 0.001s 0.002s 10 0 0 1 767 0.001s 0.002s 11 0 0 0 119 0.001s 0.002s 12 0 0 0 111 0.001s 0.002s 13 0 176 537 1,324 0.306s 0.004s 14 0 2 2,152 388 0.422s 0.012s 15 0 0 1,492 294 0.058s 0.004s 16 0 0 0 17 0.001s 0.002s 17 0 31 2,691 310 0.197s 0.019s 18 0 0 538 130 0.001s 0.001s 19 0 0 120 231 0.001s 0.003s 20 0 0 0 16 0.001s 0.002s 21 0 34 3,198 201 0.428s 0.037s 22 0 0 440 102 0.001s 0.002s 23 0 1 1,689 135 0.001s 0.003s Day Hour Count Avg time (sec) Feb 25 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 Feb 25 00 1,182.50 kB 4,126.50 kB 01 176.50 kB 3,476.50 kB 02 172.50 kB 2,849.50 kB 03 186.50 kB 2,343.50 kB 04 265,805.50 kB 266,650.00 kB 05 274,986.00 kB 514,028.50 kB 06 391.00 kB 470,243.50 kB 07 187,993.50 kB 416,600.50 kB 08 448.00 kB 337,528.50 kB 09 3,718.00 kB 273,971.00 kB 10 8,175.50 kB 222,919.00 kB 11 1,057.50 kB 181,414.00 kB 12 1,296.50 kB 147,189.50 kB 13 3,722,851.00 kB 3,764,686.67 kB 14 8,820,801.75 kB 8,822,940.00 kB 15 6,240,479.00 kB 8,568,601.75 kB 16 38.00 kB 6,792,490.00 kB 17 8,815,756.00 kB 8,817,817.20 kB 18 8,809,548.00 kB 8,816,638.00 kB 19 831,689.00 kB 7,393,312.00 kB 20 78.50 kB 5,668,174.50 kB 21 8,820,708.17 kB 8,841,461.50 kB 22 3,618,465.00 kB 8,241,345.50 kB 23 8,018,464.50 kB 8,745,589.50 kB -
Temporary Files
Size of temporary files
Key values
- 22.00 GiB Temp Files size Peak
- 2026-02-25 21:04:21 Date
Number of temporary files
Key values
- 22 per second Temp Files Peak
- 2026-02-25 21:04:21 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Feb 25 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 671 20.46 GiB 31.22 MiB 14 557 46.54 GiB 85.55 MiB 15 115 6.55 GiB 58.34 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 29 28.49 GiB 1005.83 MiB 20 60 59.23 GiB 1010.91 MiB 21 356 210.74 GiB 606.16 MiB 22 0 0 0 23 250 45.94 GiB 188.16 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 1,413 92.32 GiB 8.00 KiB 1.00 GiB 66.90 MiB select * from pgbulkload.pg_bulkload (?);-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.GENE_DISEASE_REFERENCE,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.log,parse-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.DUPE}');
Date: 2026-02-25 21:16:50 Duration: 7m22s Database: ctdprd51 User: load Application: pg_bulkload
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.DAG_PATH,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.log,parse-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.DUPE}');
Date: 2026-02-25 21:52:56 Duration: 4m59s
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}');
Date: 2026-02-25 13:53:40 Duration: 4m52s
2 89 88.33 GiB 339.07 MiB 1.00 GiB 1016.30 MiB select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.object_type where cd = ?), ( select current_date) from pub2.gene_chem_reference gcr, pub2.gene_go_annot gga, pub2.phenotype_term_reference ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in;-
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.GENE_GO_ANNOT gga, pub2.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in;
Date: 2026-02-25 21:04:19 Duration: 0ms
3 60 59.23 GiB 238.76 MiB 1.00 GiB 1010.91 MiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.object_type where cd = ?), ptr.term_id, ( select id from pub2.object_type where cd = ?), ( select current_date) from pub2.gene_chem_reference gcr, pub2.phenotype_term_reference ptr, pub2.phenotype_term_reference ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;-
select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;
Date: 2026-02-25 20:12:35 Duration: 0ms
4 35 1.22 GiB 24.79 MiB 54.78 MiB 35.73 MiB vacuum full analyze ixn_actor;-
vacuum FULL analyze ixn_actor;
Date: 2026-02-25 15:16:50 Duration: 26s483ms
-
vacuum FULL analyze ixn_actor;
Date: 2026-02-25 15:16:31 Duration: 0ms
5 35 4.72 GiB 80.06 MiB 202.34 MiB 138.15 MiB vacuum full analyze db_link;-
vacuum FULL analyze db_link;
Date: 2026-02-25 15:19:28 Duration: 2m12s
-
vacuum FULL analyze db_link;
Date: 2026-02-25 15:17:40 Duration: 0ms
6 25 402.95 MiB 11.72 MiB 22.47 MiB 16.12 MiB vacuum full analyze ixn;-
vacuum FULL analyze ixn;
Date: 2026-02-25 15:17:06 Duration: 8s371ms
-
vacuum FULL analyze ixn;
Date: 2026-02-25 15:17:01 Duration: 0ms
7 25 16.10 GiB 8.00 KiB 1.00 GiB 659.32 MiB alter table pub2.term_enrichment_agent add constraint term_enrichment_agent_pk primary key (term_id, enriched_term_id, agent_term_id);-
ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-02-25 23:56:58 Duration: 3m30s
-
ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-02-25 23:56:57 Duration: 0ms
8 20 13.88 GiB 8.00 KiB 1.00 GiB 710.66 MiB create unique index gene_disease_reference_ak1 on pub2.gene_disease_reference using btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);-
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub2.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-02-25 21:24:48 Duration: 4m3s
-
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub2.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-02-25 21:24:47 Duration: 0ms
9 20 219.98 MiB 7.20 MiB 22.52 MiB 11.00 MiB vacuum full analyze term;-
vacuum FULL analyze TERM;
Date: 2026-02-25 15:16:48 Duration: 11s282ms
-
vacuum FULL analyze TERM;
Date: 2026-02-25 15:16:40 Duration: 0ms Database: ctdprd51 User: load Application: pgAdmin 4 - CONN:9021031
10 15 11.50 GiB 261.86 MiB 1.00 GiB 784.89 MiB create index ix_term_enrich_agent_enr_term on pub2.term_enrichment_agent using btree (enriched_term_id);-
CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);
Date: 2026-02-25 23:59:05 Duration: 2m7s
-
CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);
Date: 2026-02-25 23:59:05 Duration: 0ms
11 15 7.71 GiB 8.00 KiB 1.00 GiB 526.42 MiB alter table pub2.gene_disease_reference add constraint gene_disease_reference_pk primary key (id);-
ALTER TABLE pub2.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-02-25 21:20:44 Duration: 2m31s
-
ALTER TABLE pub2.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-02-25 21:20:44 Duration: 0ms Database: ctdprd51 User: pub2
12 10 153.54 MiB 8.00 KiB 31.43 MiB 15.35 MiB alter table pub2.term_enrichment add constraint term_enrichment_pk primary key (term_id, enriched_term_id);-
ALTER TABLE pub2.term_enrichment ADD CONSTRAINT term_enrichment_pk PRIMARY KEY (term_id, enriched_term_id);
Date: 2026-02-25 23:40:16 Duration: 0ms Database: ctdprd51 User: pub2
13 10 7.71 GiB 513.72 MiB 1.00 GiB 789.62 MiB create index ix_gene_disease_reference_ixn on pub2.gene_disease_reference using btree (ixn_id);-
CREATE INDEX ix_gene_disease_reference_ixn ON pub2.gene_disease_reference USING btree (ixn_id);
Date: 2026-02-25 21:36:38 Duration: 1m44s
-
CREATE INDEX ix_gene_disease_reference_ixn ON pub2.gene_disease_reference USING btree (ixn_id);
Date: 2026-02-25 21:36:37 Duration: 0ms
14 10 7.71 GiB 530.93 MiB 1.00 GiB 789.62 MiB create index ix_gene_disease_ref_net_sc on pub2.gene_disease_reference using btree (network_score);-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score);
Date: 2026-02-25 21:41:15 Duration: 2m51s
-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score);
Date: 2026-02-25 21:41:14 Duration: 0ms
15 10 7.71 GiB 467.02 MiB 1.00 GiB 789.62 MiB create index ix_gene_disease_ref_src_db on pub2.gene_disease_reference using btree (source_acc_db_id);-
CREATE INDEX ix_gene_disease_ref_src_db ON pub2.gene_disease_reference USING btree (source_acc_db_id);
Date: 2026-02-25 21:25:52 Duration: 1m4s
-
CREATE INDEX ix_gene_disease_ref_src_db ON pub2.gene_disease_reference USING btree (source_acc_db_id);
Date: 2026-02-25 21:25:52 Duration: 0ms
16 10 258.93 MiB 8.00 KiB 53.37 MiB 25.89 MiB alter table pub2.chem_disease_reference add constraint chem_disease_reference_pk primary key (id);-
ALTER TABLE pub2.chem_disease_reference ADD CONSTRAINT chem_disease_reference_pk PRIMARY KEY (id);
Date: 2026-02-25 21:43:46 Duration: 0ms
17 10 7.71 GiB 515.71 MiB 1.00 GiB 789.62 MiB create index ix_gene_disease_ref_mod_tm on pub2.gene_disease_reference using btree (mod_tm);-
CREATE INDEX ix_gene_disease_ref_mod_tm ON pub2.gene_disease_reference USING btree (mod_tm);
Date: 2026-02-25 21:38:23 Duration: 1m45s
-
CREATE INDEX ix_gene_disease_ref_mod_tm ON pub2.gene_disease_reference USING btree (mod_tm);
Date: 2026-02-25 21:38:23 Duration: 0ms
18 10 7.71 GiB 440.10 MiB 1.00 GiB 789.62 MiB create index ix_gene_disease_ref_source_cd on pub2.gene_disease_reference using btree (source_cd);-
CREATE INDEX ix_gene_disease_ref_source_cd ON pub2.gene_disease_reference USING btree (source_cd);
Date: 2026-02-25 21:27:13 Duration: 1m20s
-
CREATE INDEX ix_gene_disease_ref_source_cd ON pub2.gene_disease_reference USING btree (source_cd);
Date: 2026-02-25 21:27:13 Duration: 0ms
19 10 471.79 MiB 8.00 KiB 95.59 MiB 47.18 MiB create unique index chem_disease_reference_ak1 on pub2.chem_disease_reference using btree (chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id);-
CREATE UNIQUE INDEX chem_disease_reference_ak1 ON pub2.chem_disease_reference USING btree (chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id);
Date: 2026-02-25 21:43:53 Duration: 7s709ms
-
CREATE UNIQUE INDEX chem_disease_reference_ak1 ON pub2.chem_disease_reference USING btree (chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id);
Date: 2026-02-25 21:43:53 Duration: 0ms
20 10 7.71 GiB 513.72 MiB 1.00 GiB 789.62 MiB create index ix_gene_disease_ref_chem on pub2.gene_disease_reference using btree (via_chem_id);-
CREATE INDEX ix_gene_disease_ref_chem ON pub2.gene_disease_reference USING btree (via_chem_id);
Date: 2026-02-25 21:29:05 Duration: 1m51s
-
CREATE INDEX ix_gene_disease_ref_chem ON pub2.gene_disease_reference USING btree (via_chem_id);
Date: 2026-02-25 21:29:05 Duration: 0ms
21 10 7.71 GiB 537.00 MiB 1.00 GiB 789.62 MiB create index ix_gene_disease_ref_reference on pub2.gene_disease_reference using btree (reference_id);-
CREATE INDEX ix_gene_disease_ref_reference ON pub2.gene_disease_reference USING btree (reference_id);
Date: 2026-02-25 21:32:34 Duration: 1m40s
-
CREATE INDEX ix_gene_disease_ref_reference ON pub2.gene_disease_reference USING btree (reference_id);
Date: 2026-02-25 21:32:34 Duration: 0ms
22 10 1.16 GiB 8.00 KiB 244.16 MiB 119.20 MiB alter table pub2.phenotype_term_reference add constraint phenotype_term_reference_pk primary key (id);-
ALTER TABLE pub2.phenotype_term_reference ADD CONSTRAINT phenotype_term_reference_pk PRIMARY KEY (id);
Date: 2026-02-25 21:41:32 Duration: 16s449ms
-
ALTER TABLE pub2.phenotype_term_reference ADD CONSTRAINT phenotype_term_reference_pk PRIMARY KEY (id);
Date: 2026-02-25 21:41:32 Duration: 0ms
23 10 7.71 GiB 513.72 MiB 1.00 GiB 789.62 MiB create index ix_gene_disease_ref_dis_gene on pub2.gene_disease_reference using btree (disease_id, gene_id);-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub2.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-02-25 21:34:53 Duration: 2m18s
-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub2.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-02-25 21:34:53 Duration: 0ms
24 10 7.71 GiB 513.72 MiB 1.00 GiB 789.62 MiB create index ix_gene_disease_ref_disease on pub2.gene_disease_reference using btree (disease_id);-
CREATE INDEX ix_gene_disease_ref_disease ON pub2.gene_disease_reference USING btree (disease_id);
Date: 2026-02-25 21:30:54 Duration: 1m48s
-
CREATE INDEX ix_gene_disease_ref_disease ON pub2.gene_disease_reference USING btree (disease_id);
Date: 2026-02-25 21:30:53 Duration: 0ms
25 7 6.25 GiB 251.09 MiB 1.00 GiB 913.58 MiB select distinct ptr.phenotype_id, cdr.disease_id, ( select id from pub2.object_type where cd = ?), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub2.object_type where cd = ?), cdr.mod_tm from pub2.chem_disease_reference cdr, pub2.phenotype_term_reference ptr where cdr.chem_id = ptr.term_id;-
SELECT DISTINCT ptr.phenotype_id, cdr.disease_id, ( select id from pub2.OBJECT_TYPE where cd = 'disease'), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), cdr.mod_tm FROM pub2.CHEM_DISEASE_REFERENCE cdr, pub2.PHENOTYPE_TERM_REFERENCE ptr WHERE cdr.chem_id = ptr.term_id;
Date: 2026-02-25 21:08:33 Duration: 0ms
26 5 1.16 GiB 233.63 MiB 245.41 MiB 238.38 MiB create index ix_phenotype_term_ref_reference_id on pub2.phenotype_term_reference using btree (reference_id);-
CREATE INDEX ix_phenotype_term_ref_reference_id ON pub2.phenotype_term_reference USING btree (reference_id);
Date: 2026-02-25 21:42:18 Duration: 13s160ms
-
CREATE INDEX ix_phenotype_term_ref_reference_id ON pub2.phenotype_term_reference USING btree (reference_id);
Date: 2026-02-25 21:42:18 Duration: 0ms
27 5 153.50 MiB 29.74 MiB 31.33 MiB 30.70 MiB create index ix_term_enrich_enr_obj_type on pub2.term_enrichment using btree (enriched_object_type_id);-
CREATE INDEX ix_term_enrich_enr_obj_type ON pub2.term_enrichment USING btree (enriched_object_type_id);
Date: 2026-02-25 23:40:20 Duration: 0ms
28 5 258.90 MiB 49.98 MiB 53.38 MiB 51.78 MiB create index ix_chem_disease_reference_gene on pub2.chem_disease_reference using btree (via_gene_id);-
CREATE INDEX ix_chem_disease_reference_gene ON pub2.chem_disease_reference USING btree (via_gene_id);
Date: 2026-02-25 21:44:07 Duration: 0ms
29 5 1.16 GiB 233.88 MiB 241.22 MiB 238.38 MiB create index ix_phenotype_term_ref_taxon_id on pub2.phenotype_term_reference using btree (taxon_id);-
CREATE INDEX ix_phenotype_term_ref_taxon_id ON pub2.phenotype_term_reference USING btree (taxon_id);
Date: 2026-02-25 21:42:27 Duration: 8s972ms
-
CREATE INDEX ix_phenotype_term_ref_taxon_id ON pub2.phenotype_term_reference USING btree (taxon_id);
Date: 2026-02-25 21:42:27 Duration: 0ms
30 5 258.90 MiB 49.66 MiB 53.36 MiB 51.78 MiB create index ix_chem_disease_reference_dis on pub2.chem_disease_reference using btree (disease_id);-
CREATE INDEX ix_chem_disease_reference_dis ON pub2.chem_disease_reference USING btree (disease_id);
Date: 2026-02-25 21:43:56 Duration: 0ms
31 5 1.16 GiB 225.41 MiB 252.27 MiB 238.38 MiB create index ix_phenotype_term_reference_ixn_id on pub2.phenotype_term_reference using btree (ixn_id);-
CREATE INDEX ix_phenotype_term_reference_ixn_id ON pub2.phenotype_term_reference USING btree (ixn_id);
Date: 2026-02-25 21:43:13 Duration: 12s432ms
-
CREATE INDEX ix_phenotype_term_reference_ixn_id ON pub2.phenotype_term_reference USING btree (ixn_id);
Date: 2026-02-25 21:43:12 Duration: 0ms
32 5 1.16 GiB 227.97 MiB 247.10 MiB 238.38 MiB create index ix_phenotype_term_ref_phenotype_id on pub2.phenotype_term_reference using btree (phenotype_id);-
CREATE INDEX ix_phenotype_term_ref_phenotype_id ON pub2.phenotype_term_reference USING btree (phenotype_id);
Date: 2026-02-25 21:41:43 Duration: 10s967ms
-
CREATE INDEX ix_phenotype_term_ref_phenotype_id ON pub2.phenotype_term_reference USING btree (phenotype_id);
Date: 2026-02-25 21:41:43 Duration: 0ms
33 5 258.91 MiB 49.73 MiB 53.41 MiB 51.78 MiB create index ix_chem_disease_ref_source_cd on pub2.chem_disease_reference using btree (source_cd);-
CREATE INDEX ix_chem_disease_ref_source_cd ON pub2.chem_disease_reference USING btree (source_cd);
Date: 2026-02-25 21:44:02 Duration: 0ms
34 5 153.49 MiB 24.59 MiB 33.81 MiB 30.70 MiB create index ix_term_enrich_obj_type on pub2.term_enrichment using btree (object_type_id);-
CREATE INDEX ix_term_enrich_obj_type ON pub2.term_enrichment USING btree (object_type_id);
Date: 2026-02-25 23:40:17 Duration: 0ms
35 5 258.91 MiB 50.73 MiB 52.41 MiB 51.78 MiB create index ix_chem_disease_ref_src_db on pub2.chem_disease_reference using btree (source_acc_db_id);-
CREATE INDEX ix_chem_disease_ref_src_db ON pub2.chem_disease_reference USING btree (source_acc_db_id);
Date: 2026-02-25 21:44:04 Duration: 0ms
36 5 258.89 MiB 50.12 MiB 53.74 MiB 51.78 MiB create index ix_chem_disease_ref_mod_tm on pub2.chem_disease_reference using btree (mod_tm);-
CREATE INDEX ix_chem_disease_ref_mod_tm ON pub2.chem_disease_reference USING btree (mod_tm);
Date: 2026-02-25 21:44:13 Duration: 0ms
37 5 1.16 GiB 235.46 MiB 240.18 MiB 238.39 MiB create index ix_phenotype_term_reference_source_acc_db_id on pub2.phenotype_term_reference using btree (source_acc_db_id);-
CREATE INDEX ix_phenotype_term_reference_source_acc_db_id ON pub2.phenotype_term_reference USING btree (source_acc_db_id);
Date: 2026-02-25 21:42:47 Duration: 10s83ms
-
CREATE INDEX ix_phenotype_term_reference_source_acc_db_id ON pub2.phenotype_term_reference USING btree (source_acc_db_id);
Date: 2026-02-25 21:42:47 Duration: 0ms
38 5 258.91 MiB 50.66 MiB 53.52 MiB 51.78 MiB create index ix_chem_disease_reference_ixn on pub2.chem_disease_reference using btree (ixn_id);-
CREATE INDEX ix_chem_disease_reference_ixn ON pub2.chem_disease_reference USING btree (ixn_id);
Date: 2026-02-25 21:44:10 Duration: 0ms
39 5 214.29 MiB 42.27 MiB 43.37 MiB 42.86 MiB create index ix_term_enrich_corr_p_val on pub2.term_enrichment using btree (corrected_p_val);-
CREATE INDEX ix_term_enrich_corr_p_val ON pub2.term_enrichment USING btree (corrected_p_val);
Date: 2026-02-25 23:40:25 Duration: 0ms
40 5 258.90 MiB 50.52 MiB 54.41 MiB 51.78 MiB create index ix_chem_disease_reference_ref on pub2.chem_disease_reference using btree (reference_id);-
CREATE INDEX ix_chem_disease_reference_ref ON pub2.chem_disease_reference USING btree (reference_id);
Date: 2026-02-25 21:43:59 Duration: 0ms
41 5 214.27 MiB 42.07 MiB 43.65 MiB 42.85 MiB create index ix_term_enrich_raw_p_val on pub2.term_enrichment using btree (raw_p_val);-
CREATE INDEX ix_term_enrich_raw_p_val ON pub2.term_enrichment USING btree (raw_p_val);
Date: 2026-02-25 23:40:29 Duration: 0ms
42 5 1.16 GiB 228.69 MiB 244.30 MiB 238.38 MiB create index ix_phenotype_term_reference_term_reference_id on pub2.phenotype_term_reference using btree (term_reference_id);-
CREATE INDEX ix_phenotype_term_reference_term_reference_id ON pub2.phenotype_term_reference USING btree (term_reference_id);
Date: 2026-02-25 21:43:00 Duration: 13s185ms
-
CREATE INDEX ix_phenotype_term_reference_term_reference_id ON pub2.phenotype_term_reference USING btree (term_reference_id);
Date: 2026-02-25 21:43:00 Duration: 0ms
43 5 1.63 GiB 322.03 MiB 351.44 MiB 334.53 MiB create index ix_phenotype_term_ref_ids on pub2.phenotype_term_reference using btree (phenotype_id, term_id, via_term_object_type_id, term_object_type_id);-
CREATE INDEX ix_phenotype_term_ref_ids ON pub2.phenotype_term_reference USING btree (phenotype_id, term_id, via_term_object_type_id, term_object_type_id);
Date: 2026-02-25 21:43:42 Duration: 16s203ms
-
CREATE INDEX ix_phenotype_term_ref_ids ON pub2.phenotype_term_reference USING btree (phenotype_id, term_id, via_term_object_type_id, term_object_type_id);
Date: 2026-02-25 21:43:42 Duration: 0ms
44 5 1.16 GiB 232.45 MiB 242.90 MiB 238.38 MiB create index ix_phenotype_term_ref_object_type_id on pub2.phenotype_term_reference using btree (term_object_type_id);-
CREATE INDEX ix_phenotype_term_ref_object_type_id ON pub2.phenotype_term_reference USING btree (term_object_type_id);
Date: 2026-02-25 21:42:05 Duration: 10s219ms
-
CREATE INDEX ix_phenotype_term_ref_object_type_id ON pub2.phenotype_term_reference USING btree (term_object_type_id);
Date: 2026-02-25 21:42:05 Duration: 0ms
45 5 1.16 GiB 222.64 MiB 248.39 MiB 238.38 MiB create index ix_phenotype_term_ref_via_term_id on pub2.phenotype_term_reference using btree (via_term_id);-
CREATE INDEX ix_phenotype_term_ref_via_term_id ON pub2.phenotype_term_reference USING btree (via_term_id);
Date: 2026-02-25 21:43:26 Duration: 13s427ms
-
CREATE INDEX ix_phenotype_term_ref_via_term_id ON pub2.phenotype_term_reference USING btree (via_term_id);
Date: 2026-02-25 21:43:26 Duration: 0ms
46 5 258.91 MiB 50.26 MiB 53.74 MiB 51.78 MiB create index ix_chem_disease_ref_net_sc on pub2.chem_disease_reference using btree (network_score);-
CREATE INDEX ix_chem_disease_ref_net_sc ON pub2.chem_disease_reference USING btree (network_score);
Date: 2026-02-25 21:44:18 Duration: 5s377ms
-
CREATE INDEX ix_chem_disease_ref_net_sc ON pub2.chem_disease_reference USING btree (network_score);
Date: 2026-02-25 21:44:18 Duration: 0ms
47 5 1.16 GiB 233.23 MiB 243.09 MiB 238.38 MiB create index ix_phenotype_term_ref_term_id on pub2.phenotype_term_reference using btree (term_id);-
CREATE INDEX ix_phenotype_term_ref_term_id ON pub2.phenotype_term_reference USING btree (term_id);
Date: 2026-02-25 21:41:55 Duration: 11s969ms
-
CREATE INDEX ix_phenotype_term_ref_term_id ON pub2.phenotype_term_reference USING btree (term_id);
Date: 2026-02-25 21:41:55 Duration: 0ms
48 5 153.50 MiB 29.63 MiB 31.70 MiB 30.70 MiB create index ix_term_enrich_tgt_match on pub2.term_enrichment using btree (target_match_qty);-
CREATE INDEX ix_term_enrich_tgt_match ON pub2.term_enrichment USING btree (target_match_qty);
Date: 2026-02-25 23:40:19 Duration: 0ms
49 5 1.16 GiB 235.51 MiB 241.48 MiB 238.38 MiB create index ix_phenotype_term_ref_evidence_cd on pub2.phenotype_term_reference using btree (evidence_cd);-
CREATE INDEX ix_phenotype_term_ref_evidence_cd ON pub2.phenotype_term_reference USING btree (evidence_cd);
Date: 2026-02-25 21:42:37 Duration: 9s378ms
-
CREATE INDEX ix_phenotype_term_ref_evidence_cd ON pub2.phenotype_term_reference USING btree (evidence_cd);
Date: 2026-02-25 21:42:37 Duration: 0ms
50 1 28.49 GiB 28.49 GiB 28.49 GiB 28.49 GiB select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = ?);-
select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 19:22:50 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 28.49 GiB select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');[ Date: 2026-02-25 19:22:50 ]
2 1.00 GiB SELECT * FROM pgbulkload.pg_bulkload ($1);[ Date: 2026-02-25 14:30:45 - Database: ctdprd51 - User: load - Application: pg_bulkload ]
3 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:35 ]
4 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:35 ]
5 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:35 ]
6 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:35 ]
7 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:35 ]
8 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:35 ]
9 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:36 ]
10 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:36 ]
11 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:36 ]
12 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:36 ]
13 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:36 ]
14 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:36 ]
15 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:36 ]
16 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:36 ]
17 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:36 ]
18 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:36 ]
19 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:36 ]
20 1.00 GiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;[ Date: 2026-02-25 20:12:36 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 69.59 sec Highest CPU-cost vacuum
Table pub2.gene_go_annot
Database ctdprd51 - 2026-02-25 17:47:19 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 69.59 sec Highest CPU-cost vacuum
Table pub2.gene_go_annot
Database ctdprd51 - 2026-02-25 17:47:19 Date
Analyzes per table
Key values
- pubc.log_query (15) Main table analyzed (database ctdprd51)
- 85 analyzes Total
Table Number of analyzes ctdprd51.pubc.log_query 15 ctdprd51.pg_catalog.pg_class 5 ctdprd51.pg_catalog.pg_trigger 4 ctdprd51.pg_catalog.pg_constraint 4 ctdprd51.pg_catalog.pg_attribute 4 ctdprd51.pg_catalog.pg_description 3 ctdprd51.pg_catalog.pg_index 3 postgres.pg_catalog.pg_shdepend 3 ctdprd51.pg_catalog.pg_depend 3 ctdprd51.pg_catalog.pg_attrdef 3 ctdprd51.pg_catalog.pg_type 3 ctdprd51.pub2.db 2 ctdprd51.pub2.term 2 ctdprd51.edit.db_report 1 ctdprd51.pub2.gene_go_annot 1 ctdprd51.edit.object_note 1 ctdprd51.edit.action_degree 1 ctdprd51.edit.db 1 ctdprd51.pub2.term_label 1 ctdprd51.pub2.term_pathway 1 ctdprd51.edit.list_db_report 1 ctdprd51.pub2.dag_node 1 ctdprd51.pub1.term_set_enrichment 1 ctdprd51.load.data_load 1 ctdprd51.pub1.term_set_enrichment_agent 1 ctdprd51.pub2.db_report_site 1 ctdprd51.edit.db_link 1 ctdprd51.pub2.reference 1 ctdprd51.pub2.img 1 ctdprd51.pub2.db_report 1 ctdprd51.pub2.action_type 1 ctdprd51.edit.action_type_path 1 ctdprd51.pg_catalog.pg_proc 1 ctdprd51.edit.action_type 1 ctdprd51.pub2.dag_edge 1 ctdprd51.pub2.reference_party_role 1 ctdprd51.pub2.reference_party 1 ctdprd51.edit.country 1 ctdprd51.edit.db_report_site 1 ctdprd51.pub2.db_link 1 ctdprd51.pub2.list_db_report 1 ctdprd51.edit.reference_db_link 1 ctdprd51.edit.chem_conc_uom 1 ctdprd51.pub2.gene_taxon 1 Total 85 Vacuums per table
Key values
- pg_catalog.pg_class (5) Main table vacuumed on database ctdprd51
- 70 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes ctdprd51.pg_catalog.pg_class 5 4 1,771 0 97 0 0 636 94 358,455 ctdprd51.pg_catalog.pg_attribute 5 3 3,034 0 243 0 233 1,186 205 1,066,733 ctdprd51.pg_catalog.pg_trigger 5 3 1,406 0 131 0 0 380 106 385,749 ctdprd51.pg_catalog.pg_constraint 5 3 1,168 0 80 0 0 319 60 247,119 ctdprd51.pg_catalog.pg_index 5 3 732 0 70 0 0 271 46 207,064 postgres.pg_catalog.pg_shdepend 5 3 912 0 50 0 0 217 66 299,361 ctdprd51.pg_catalog.pg_shdepend 3 1 402 0 3 0 0 68 3 21,162 ctdprd51.pg_catalog.pg_type 2 2 304 0 16 0 0 106 34 178,284 ctdprd51.pub2.term 2 0 103,299 0 5 0 0 46,776 3 2,779,534 ctdprd51.pg_catalog.pg_description 2 2 438 0 42 0 84 159 39 163,805 ctdprd51.pg_catalog.pg_depend 2 2 1,296 0 106 0 130 426 163 705,435 ctdprd51.pub2.db_link 1 0 313,883 0 131,375 0 0 156,804 6 9,295,287 ctdprd51.pg_toast.pg_toast_2619 1 1 4,602 0 852 0 10,161 3,948 713 426,672 ctdprd51.edit.reference_db_link 1 0 7,445 0 4 0 0 3,710 1 227,216 ctdprd51.pg_catalog.pg_statistic 1 1 871 0 101 0 128 748 102 298,101 ctdprd51.pub2.gene_taxon 1 0 172,471 0 7 0 0 86,176 4 5,111,549 ctdprd51.pg_toast.pg_toast_486223 1 0 48 0 0 0 0 1 0 188 ctdprd51.pub2.reference_party_role 1 0 13,724 0 5 0 0 6,835 2 417,940 ctdprd51.pub2.reference_party 1 0 5,155 0 4 0 0 2,544 2 160,603 ctdprd51.edit.country 1 0 63 0 0 0 0 8 1 9,627 ctdprd51.edit.db_report_site 1 1 74 0 3 0 0 15 2 15,143 ctdprd51.pub2.img 1 0 1,109 0 5 0 0 524 2 41,687 ctdprd51.edit.action_type_path 1 0 48 0 0 0 0 4 1 9,059 ctdprd51.edit.action_type 1 0 174 0 2 0 0 7 2 14,553 ctdprd51.pub2.dag_edge 1 0 1,053 0 5 0 0 482 2 39,501 ctdprd51.pg_toast.pg_toast_10624201 1 0 90,298 0 4 0 0 45,141 2 2,679,842 ctdprd51.edit.db_link 1 0 7,657 0 3 0 0 3,710 1 227,285 ctdprd51.pub2.reference 1 0 78,637 0 5 0 0 39,206 3 2,332,682 ctdprd51.pub2.term_pathway 1 0 3,331 0 4 0 0 1,614 2 106,809 ctdprd51.pg_catalog.pg_attrdef 1 1 91 0 2 0 0 24 3 15,003 ctdprd51.pub2.dag_node 1 0 84,261 0 4 0 0 42,002 2 2,494,734 ctdprd51.pub1.term_set_enrichment 1 0 4,269 0 1,748 0 0 2,082 2 137,789 ctdprd51.pub1.term_set_enrichment_agent 1 0 158,205 0 58,932 0 0 79,031 5 4,697,839 ctdprd51.pubc.log_query 1 1 256 0 43 0 0 84 34 263,574 ctdprd51.edit.object_note 1 1 168 0 1 0 0 12 1 9,817 ctdprd51.edit.action_degree 1 0 45 0 0 0 0 12 1 9,451 ctdprd51.pub2.db 1 1 151 0 13 0 0 20 10 34,631 ctdprd51.pub2.term_label 1 0 209,412 0 59,454 0 0 104,652 5 6,213,734 ctdprd51.edit.db_report 1 0 96 0 2 0 0 9 2 15,404 ctdprd51.pub2.gene_go_annot 1 0 637,737 0 294,407 0 0 318,750 11 18,890,794 Total 70 33 1,910,096 1,396 547,828 0 10,736 948,699 1,743 60,609,215 Tuples removed per table
Key values
- pg_catalog.pg_attribute (6193) Main table with removed tuples on database ctdprd51
- 22854 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain ctdprd51.pg_catalog.pg_attribute 5 3 6,193 50,238 4,318 6 1,174 ctdprd51.pg_toast.pg_toast_2619 1 1 5,042 18,315 0 0 12,592 ctdprd51.pg_catalog.pg_depend 2 2 2,492 30,877 2,439 0 292 ctdprd51.pg_catalog.pg_trigger 5 3 1,480 9,830 1,402 0 265 postgres.pg_catalog.pg_shdepend 5 3 1,468 12,446 1,916 0 109 ctdprd51.pg_catalog.pg_description 2 2 1,207 11,272 656 0 180 ctdprd51.pg_catalog.pg_statistic 1 1 1,073 2,886 0 0 410 ctdprd51.pg_catalog.pg_index 5 3 919 6,661 746 2 188 ctdprd51.pg_catalog.pg_class 5 4 676 10,967 1,857 0 470 ctdprd51.pg_catalog.pg_constraint 5 3 616 5,012 552 0 193 ctdprd51.pg_catalog.pg_shdepend 3 1 534 7,703 1,382 0 66 ctdprd51.pg_catalog.pg_type 2 2 246 2,516 186 0 68 ctdprd51.edit.country 1 0 163 249 0 0 4 ctdprd51.pub2.db 1 1 134 134 0 0 7 ctdprd51.edit.action_type_path 1 0 106 106 0 0 2 ctdprd51.edit.db_report_site 1 1 98 164 0 0 5 ctdprd51.edit.db_report 1 0 97 162 0 0 4 ctdprd51.edit.action_degree 1 0 96 219 0 0 6 ctdprd51.pg_catalog.pg_attrdef 1 1 88 238 0 0 12 ctdprd51.edit.action_type 1 0 64 60 0 0 3 ctdprd51.edit.object_note 1 1 61 33 0 0 3 ctdprd51.pubc.log_query 1 1 1 955 0 0 36 ctdprd51.pub2.db_link 1 0 0 21,631,570 0 0 156,803 ctdprd51.edit.reference_db_link 1 0 0 332,792 0 0 3,709 ctdprd51.pub2.gene_taxon 1 0 0 13,529,440 0 0 86,175 ctdprd51.pg_toast.pg_toast_486223 1 0 0 0 0 0 0 ctdprd51.pub2.reference_party_role 1 0 0 1,264,145 0 0 6,834 ctdprd51.pub2.reference_party 1 0 0 455,308 0 0 2,543 ctdprd51.pub2.img 1 0 0 50,654 0 0 523 ctdprd51.pub2.dag_edge 1 0 0 88,931 0 0 481 ctdprd51.pg_toast.pg_toast_10624201 1 0 0 244,007 0 0 45,140 ctdprd51.edit.db_link 1 0 0 332,792 0 0 3,709 ctdprd51.pub2.reference 1 0 0 201,793 0 0 39,205 ctdprd51.pub2.term 2 0 0 2,250,482 0 0 55,939 ctdprd51.pub2.term_pathway 1 0 0 135,792 0 0 1,613 ctdprd51.pub2.dag_node 1 0 0 1,748,734 0 0 42,001 ctdprd51.pub1.term_set_enrichment 1 0 0 609,365 0 0 10,096 ctdprd51.pub1.term_set_enrichment_agent 1 0 0 37,500,349 0 0 426,141 ctdprd51.pub2.term_label 1 0 0 7,143,670 0 0 104,651 ctdprd51.pub2.gene_go_annot 1 0 0 50,044,761 0 0 318,749 Total 70 33 22,854 137,735,628 15,454 8 1,320,401 Pages removed per table
Key values
- pg_catalog.pg_attribute (6) Main table with removed pages on database ctdprd51
- 8 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed ctdprd51.pg_catalog.pg_attribute 5 3 6193 6 ctdprd51.pg_catalog.pg_index 5 3 919 2 ctdprd51.pub2.db_link 1 0 0 0 ctdprd51.pg_toast.pg_toast_2619 1 1 5042 0 ctdprd51.edit.reference_db_link 1 0 0 0 ctdprd51.pg_catalog.pg_statistic 1 1 1073 0 ctdprd51.pub2.gene_taxon 1 0 0 0 ctdprd51.pg_toast.pg_toast_486223 1 0 0 0 ctdprd51.pub2.reference_party_role 1 0 0 0 ctdprd51.pg_catalog.pg_type 2 2 246 0 ctdprd51.pub2.reference_party 1 0 0 0 ctdprd51.edit.country 1 0 163 0 ctdprd51.edit.db_report_site 1 1 98 0 ctdprd51.pub2.img 1 0 0 0 ctdprd51.edit.action_type_path 1 0 106 0 ctdprd51.pg_catalog.pg_shdepend 3 1 534 0 ctdprd51.pg_catalog.pg_class 5 4 676 0 ctdprd51.edit.action_type 1 0 64 0 ctdprd51.pub2.dag_edge 1 0 0 0 ctdprd51.pg_toast.pg_toast_10624201 1 0 0 0 ctdprd51.edit.db_link 1 0 0 0 ctdprd51.pub2.reference 1 0 0 0 ctdprd51.pub2.term 2 0 0 0 ctdprd51.pub2.term_pathway 1 0 0 0 ctdprd51.pg_catalog.pg_attrdef 1 1 88 0 ctdprd51.pg_catalog.pg_trigger 5 3 1480 0 ctdprd51.pub2.dag_node 1 0 0 0 ctdprd51.pg_catalog.pg_constraint 5 3 616 0 ctdprd51.pub1.term_set_enrichment 1 0 0 0 ctdprd51.pub1.term_set_enrichment_agent 1 0 0 0 ctdprd51.pubc.log_query 1 1 1 0 ctdprd51.edit.object_note 1 1 61 0 ctdprd51.edit.action_degree 1 0 96 0 ctdprd51.pub2.db 1 1 134 0 ctdprd51.pub2.term_label 1 0 0 0 ctdprd51.pg_catalog.pg_description 2 2 1207 0 postgres.pg_catalog.pg_shdepend 5 3 1468 0 ctdprd51.edit.db_report 1 0 97 0 ctdprd51.pg_catalog.pg_depend 2 2 2492 0 ctdprd51.pub2.gene_go_annot 1 0 0 0 Total 70 33 22,854 8 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Feb 25 00 1 1 01 0 1 02 0 1 03 0 1 04 0 1 05 1 5 06 0 0 07 1 1 08 0 1 09 0 2 10 11 13 11 0 1 12 0 0 13 17 23 14 22 11 15 1 1 16 0 0 17 15 19 18 0 1 19 0 0 20 0 0 21 1 2 22 0 0 23 0 0 - 69.59 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 57s124ms 57s124ms 57s124ms 57s124ms select * from pgbulkload.pg_bulkload (?);-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.GENE_DISEASE_REFERENCE,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.log,parse-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.DUPE}');
Date: 2026-02-25 21:16:50 Database: ctdprd51 User: load Application: pg_bulkload Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.DAG_PATH,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.log,parse-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.DUPE}');
Date: 2026-02-25 21:52:56 Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}');
Date: 2026-02-25 13:53:40 Bind query: yes
2 1 3s276ms 3s276ms 3s276ms 3s276ms lock table edit.db_link in access share mode;-
LOCK TABLE edit.db_link IN ACCESS SHARE MODE;
Date: 2026-02-25 14:00:05
Queries that waited the most
Rank Wait time Query 1 57s124ms SELECT * FROM pgbulkload.pg_bulkload ($1);[ Date: 2026-02-25 14:01:20 ]
2 3s276ms LOCK TABLE edit.db_link IN ACCESS SHARE MODE;[ Date: 2026-02-25 14:00:05 ]
-
Queries
Queries by type
Key values
- 106 Total read queries
- 75 Total write queries
Queries by database
Key values
- unknown Main database
- 136 Requests
- 4h4m12s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 176 Requests
User Request type Count Duration edit Total 1 8s967ms insert 1 8s967ms load Total 27 1h1m57s select 27 1h1m57s postgres Total 15 16m52s copy to 15 16m52s pub2 Total 2 15m45s insert 1 15m37s select 1 7s791ms pubc Total 1 9m7s select 1 9m7s pubeu Total 26 3m45s select 26 3m45s qaeu Total 2 12s732ms select 2 12s732ms unknown Total 176 4h15m10s copy to 57 11m57s ddl 28 44m17s insert 9 40m54s others 5 3m5s select 77 2h34m56s Duration by user
Key values
- 4h15m10s (unknown) Main time consuming user
User Request type Count Duration edit Total 1 8s967ms insert 1 8s967ms load Total 27 1h1m57s select 27 1h1m57s postgres Total 15 16m52s copy to 15 16m52s pub2 Total 2 15m45s insert 1 15m37s select 1 7s791ms pubc Total 1 9m7s select 1 9m7s pubeu Total 26 3m45s select 26 3m45s qaeu Total 2 12s732ms select 2 12s732ms unknown Total 176 4h15m10s copy to 57 11m57s ddl 28 44m17s insert 9 40m54s others 5 3m5s select 77 2h34m56s Queries by host
Key values
- unknown Main host
- 250 Requests
- 6h3m1s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 162 Requests
- 5h9m10s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-02-25 20:33:58 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 131 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 51m37s select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.GENE_GO_ANNOT gga, pub2.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub2.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');[ Date: 2026-02-25 21:04:16 - Bind query: yes ]
2 45m29s select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in ( select gene_chem_reference_id from pub2.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');[ Date: 2026-02-25 20:12:33 - Bind query: yes ]
3 34m25s SELECT i.id, edit.get_ixn_xml (i.id), edit.get_ixn_prose (i.id), edit.get_ixn_delimited_actions (i.id), i.ixn_type_id, r.reference_acc_txt, r.taxon_acc_txt, r.create_by, common.break_html_words (edit.get_ixn_prose_html (i.id), false) FROM edit.IXN i, edit.REFERENCE_IXN r where i.id = i.root_id and i.id = r.ixn_id and r.create_by not in ('bogusName') order by i.id asc;[ Date: 2026-02-25 18:28:54 - Database: ctdprd51 - User: load - Bind query: yes ]
4 27m insert into pub2.GENE_GO_ANNOT (gene_id, go_term_id, taxon_id, evidence_cd, is_not) select gene_id, go_term_id, taxon_id, evidence_cd, is_not from load.GENE_GO_ANNOT;[ Date: 2026-02-25 17:45:32 - Bind query: yes ]
5 15m37s insert into pub2.DB_LINK (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary) select object_id, object_type_id, acc_txt, db_id, type_cd, is_primary from edit.DB_LINK;[ Date: 2026-02-25 17:12:49 - Database: ctdprd51 - User: pub2 - Bind query: yes ]
6 12m58s ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enr_agent_term_enr_fk FOREIGN KEY (term_id, enriched_term_id) REFERENCES term_enrichment (term_id, enriched_term_id);[ Date: 2026-02-25 23:53:28 - Bind query: yes ]
7 10m36s select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');[ Date: 2026-02-25 18:42:26 - Database: ctdprd51 - User: load - Bind query: yes ]
8 9m7s /* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();[ Date: 2026-02-25 00:09:09 - Database: ctdprd51 - User: pubc - Application: psql ]
9 7m22s SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.GENE_DISEASE_REFERENCE,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.log,parse-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.DUPE}');[ Date: 2026-02-25 21:16:50 - Database: ctdprd51 - User: load - Application: pg_bulkload - Bind query: yes ]
10 4m59s SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.DAG_PATH,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.log,parse-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.DUPE}');[ Date: 2026-02-25 21:52:56 - Bind query: yes ]
11 4m52s SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}');[ Date: 2026-02-25 13:53:40 - Bind query: yes ]
12 4m42s insert into pub2.GENE_TAXON (gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd) select gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd from load.GENE_TAXON;[ Date: 2026-02-25 17:50:14 - Bind query: yes ]
13 4m3s CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub2.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);[ Date: 2026-02-25 21:24:48 - Bind query: yes ]
14 3m35s INSERT INTO pub2.TERM_LABEL (id, object_type_id, term_id, term_label_type_id, nm) select l.id, t.object_type_id, l.term_id, l.term_label_type_id, l.nm from load.TERM t, load.TERM_LABEL l where t.id = l.term_id and t.id in ( select id from pub2.TERM);[ Date: 2026-02-25 17:18:30 - Bind query: yes ]
15 3m30s ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);[ Date: 2026-02-25 23:56:58 - Bind query: yes ]
16 2m58s SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/misc/uniprot/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/misc/uniprot/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/misc/uniprot/output/dbLink.txt.DUPE}');[ Date: 2026-02-25 14:43:01 - Bind query: yes ]
17 2m57s SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.TERM_ENRICHMENT_AGENT,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/goEnrichment/enrichedTermAgent.txt.log,parse-badfile=/home/load/ctdLoadData/pub/goEnrichment/enrichedTermAgent.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/goEnrichment/enrichedTermAgent.txt.DUPE}');[ Date: 2026-02-25 23:37:40 - Database: ctdprd51 - User: load - Application: pg_bulkload - Bind query: yes ]
18 2m51s CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score);[ Date: 2026-02-25 21:41:15 - Bind query: yes ]
19 2m31s ALTER TABLE pub2.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);[ Date: 2026-02-25 21:20:44 - Bind query: yes ]
20 2m22s SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/voc/termLabelSynonyms/output/uberonDBLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/termLabelSynonyms/output/uberonDBLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/termLabelSynonyms/output/uberonDBLink.txt.DUPE}');[ Date: 2026-02-25 14:02:45 - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 57m46s 62 5s74ms 7m22s 55s915ms select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 25 13 23 11m29s 29s993ms 14 18 22m10s 1m13s 18 3 1m7s 22s412ms 21 6 15m1s 2m30s 22 1 32s330ms 32s330ms 23 11 7m25s 40s513ms [ User: load - Total duration: 14m31s - Times executed: 15 ]
[ Application: pg_bulkload - Total duration: 14m31s - Times executed: 15 ]
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.GENE_DISEASE_REFERENCE,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.log,parse-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.DUPE}');
Date: 2026-02-25 21:16:50 Duration: 7m22s Database: ctdprd51 User: load Application: pg_bulkload Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.DAG_PATH,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.log,parse-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.DUPE}');
Date: 2026-02-25 21:52:56 Duration: 4m59s Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}');
Date: 2026-02-25 13:53:40 Duration: 4m52s Bind query: yes
2 51m37s 1 51m37s 51m37s 51m37s select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.object_type where cd = ?), ( select current_date) from pub2.gene_chem_reference gcr, pub2.gene_go_annot gga, pub2.phenotype_term_reference ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Feb 25 21 1 51m37s 51m37s -
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.GENE_GO_ANNOT gga, pub2.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub2.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 21:04:16 Duration: 51m37s Bind query: yes
3 45m29s 1 45m29s 45m29s 45m29s select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.object_type where cd = ?), ptr.term_id, ( select id from pub2.object_type where cd = ?), ( select current_date) from pub2.gene_chem_reference gcr, pub2.phenotype_term_reference ptr, pub2.phenotype_term_reference ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Feb 25 20 1 45m29s 45m29s -
select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in ( select gene_chem_reference_id from pub2.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 20:12:33 Duration: 45m29s Bind query: yes
4 34m25s 1 34m25s 34m25s 34m25s select i.id, edit.get_ixn_xml (i.id), edit.get_ixn_prose (i.id), edit.get_ixn_delimited_actions (i.id), i.ixn_type_id, r.reference_acc_txt, r.taxon_acc_txt, r.create_by, common.break_html_words (edit.get_ixn_prose_html (i.id), false) from edit.ixn i, edit.reference_ixn r where i.id = i.root_id and i.id = r.ixn_id and r.create_by not in (...) order by i.id asc;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Feb 25 18 1 34m25s 34m25s [ User: load - Total duration: 34m25s - Times executed: 1 ]
-
SELECT i.id, edit.get_ixn_xml (i.id), edit.get_ixn_prose (i.id), edit.get_ixn_delimited_actions (i.id), i.ixn_type_id, r.reference_acc_txt, r.taxon_acc_txt, r.create_by, common.break_html_words (edit.get_ixn_prose_html (i.id), false) FROM edit.IXN i, edit.REFERENCE_IXN r where i.id = i.root_id and i.id = r.ixn_id and r.create_by not in ('bogusName') order by i.id asc;
Date: 2026-02-25 18:28:54 Duration: 34m25s Database: ctdprd51 User: load Bind query: yes
5 27m 1 27m 27m 27m insert into pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) select gene_id, go_term_id, taxon_id, evidence_cd, is_not from load.gene_go_annot;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 25 17 1 27m 27m -
insert into pub2.GENE_GO_ANNOT (gene_id, go_term_id, taxon_id, evidence_cd, is_not) select gene_id, go_term_id, taxon_id, evidence_cd, is_not from load.GENE_GO_ANNOT;
Date: 2026-02-25 17:45:32 Duration: 27m Bind query: yes
6 15m37s 1 15m37s 15m37s 15m37s insert into pub2.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary) select object_id, object_type_id, acc_txt, db_id, type_cd, is_primary from edit.db_link;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Feb 25 17 1 15m37s 15m37s [ User: pub2 - Total duration: 15m37s - Times executed: 1 ]
-
insert into pub2.DB_LINK (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary) select object_id, object_type_id, acc_txt, db_id, type_cd, is_primary from edit.DB_LINK;
Date: 2026-02-25 17:12:49 Duration: 15m37s Database: ctdprd51 User: pub2 Bind query: yes
7 13m41s 5 45s877ms 10m36s 2m44s select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, to_char(cdr.mod_tm, ?) from pub2.gene_chem_reference gcr, pub2.chem_disease_reference cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = ? and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Feb 25 18 1 10m36s 10m36s 19 4 3m5s 46s298ms [ User: load - Total duration: 10m36s - Times executed: 1 ]
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 18:42:26 Duration: 10m36s Database: ctdprd51 User: load Bind query: yes
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 19:02:52 Duration: 46s951ms Bind query: yes
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 19:13:38 Duration: 46s419ms Bind query: yes
8 12m58s 1 12m58s 12m58s 12m58s alter table pub2.term_enrichment_agent add constraint term_enr_agent_term_enr_fk foreign key (term_id, enriched_term_id) references term_enrichment (term_id, enriched_term_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Feb 25 23 1 12m58s 12m58s -
ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enr_agent_term_enr_fk FOREIGN KEY (term_id, enriched_term_id) REFERENCES term_enrichment (term_id, enriched_term_id);
Date: 2026-02-25 23:53:28 Duration: 12m58s Bind query: yes
9 9m7s 1 9m7s 9m7s 9m7s select maint_query_logs_archive ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Feb 25 00 1 9m7s 9m7s [ User: pubc - Total duration: 9m7s - Times executed: 1 ]
[ Application: psql - Total duration: 9m7s - Times executed: 1 ]
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-02-25 00:09:09 Duration: 9m7s Database: ctdprd51 User: pubc Application: psql
10 7m24s 4 1m50s 1m52s 1m51s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Feb 25 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m52s 1m52s 18 1 1m51s 1m51s [ User: postgres - Total duration: 7m24s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m24s - Times executed: 4 ]
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-02-25 14:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-02-25 18:06:52 Duration: 1m51s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-02-25 10:06:51 Duration: 1m50s Database: ctdprd51 User: postgres Application: pg_dump
11 4m42s 1 4m42s 4m42s 4m42s insert into pub2.gene_taxon (gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd) select gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd from load.gene_taxon;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 25 17 1 4m42s 4m42s -
insert into pub2.GENE_TAXON (gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd) select gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd from load.GENE_TAXON;
Date: 2026-02-25 17:50:14 Duration: 4m42s Bind query: yes
12 4m3s 1 4m3s 4m3s 4m3s create unique index gene_disease_reference_ak1 on pub2.gene_disease_reference using btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Feb 25 21 1 4m3s 4m3s -
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub2.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-02-25 21:24:48 Duration: 4m3s Bind query: yes
-
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub2.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-02-25 21:24:47 Duration: 0ms
13 3m35s 1 3m35s 3m35s 3m35s insert into pub2.term_label (id, object_type_id, term_id, term_label_type_id, nm) select l.id, t.object_type_id, l.term_id, l.term_label_type_id, l.nm from load.term t, load.term_label l where t.id = l.term_id and t.id in ( select id from pub2.term);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Feb 25 17 1 3m35s 3m35s -
INSERT INTO pub2.TERM_LABEL (id, object_type_id, term_id, term_label_type_id, nm) select l.id, t.object_type_id, l.term_id, l.term_label_type_id, l.nm from load.TERM t, load.TERM_LABEL l where t.id = l.term_id and t.id in ( select id from pub2.TERM);
Date: 2026-02-25 17:18:30 Duration: 3m35s Bind query: yes
14 3m30s 1 3m30s 3m30s 3m30s alter table pub2.term_enrichment_agent add constraint term_enrichment_agent_pk primary key (term_id, enriched_term_id, agent_term_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Feb 25 23 1 3m30s 3m30s -
ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-02-25 23:56:58 Duration: 3m30s Bind query: yes
-
ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-02-25 23:56:57 Duration: 0ms
15 2m51s 1 2m51s 2m51s 2m51s create index ix_gene_disease_ref_net_sc on pub2.gene_disease_reference using btree (network_score);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Feb 25 21 1 2m51s 2m51s -
CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score);
Date: 2026-02-25 21:41:15 Duration: 2m51s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score);
Date: 2026-02-25 21:41:14 Duration: 0ms
16 2m31s 1 2m31s 2m31s 2m31s alter table pub2.gene_disease_reference add constraint gene_disease_reference_pk primary key (id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 25 21 1 2m31s 2m31s -
ALTER TABLE pub2.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-02-25 21:20:44 Duration: 2m31s Bind query: yes
-
ALTER TABLE pub2.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-02-25 21:20:44 Duration: 0ms Database: ctdprd51 User: pub2
17 2m18s 1 2m18s 2m18s 2m18s create index ix_gene_disease_ref_dis_gene on pub2.gene_disease_reference using btree (disease_id, gene_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 25 21 1 2m18s 2m18s -
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub2.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-02-25 21:34:53 Duration: 2m18s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub2.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-02-25 21:34:53 Duration: 0ms
18 2m12s 1 2m12s 2m12s 2m12s vacuum full analyze db_link;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 25 15 1 2m12s 2m12s -
vacuum FULL analyze db_link;
Date: 2026-02-25 15:19:28 Duration: 2m12s
-
vacuum FULL analyze db_link;
Date: 2026-02-25 15:17:40 Duration: 0ms
19 2m10s 1 2m10s 2m10s 2m10s select distinct ptr.phenotype_id, cdr.disease_id, ( select id from pub2.object_type where cd = ?), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub2.object_type where cd = ?), cdr.mod_tm from pub2.chem_disease_reference cdr, pub2.phenotype_term_reference ptr where cdr.chem_id = ptr.term_id and ptr.source_cd = ? and cdr.source_cd = ? and ptr.ixn_id not in ( select ixn_id from pub2.ixn_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 25 21 1 2m10s 2m10s -
SELECT DISTINCT ptr.phenotype_id, cdr.disease_id, ( select id from pub2.OBJECT_TYPE where cd = 'disease'), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), cdr.mod_tm FROM pub2.CHEM_DISEASE_REFERENCE cdr, pub2.PHENOTYPE_TERM_REFERENCE ptr WHERE cdr.chem_id = ptr.term_id AND ptr.source_cd = 'C' AND cdr.source_cd = 'C' AND ptr.ixn_id NOT IN ( SELECT ixn_id FROM pub2.IXN_AXN WHERE action_degree_type_nm = 'does not affect');
Date: 2026-02-25 21:06:33 Duration: 2m10s Bind query: yes
20 2m7s 1 2m7s 2m7s 2m7s create index ix_term_enrich_agent_enr_term on pub2.term_enrichment_agent using btree (enriched_term_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Feb 25 23 1 2m7s 2m7s -
CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);
Date: 2026-02-25 23:59:05 Duration: 2m7s Bind query: yes
-
CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);
Date: 2026-02-25 23:59:05 Duration: 0ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 62 57m46s 5s74ms 7m22s 55s915ms select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 25 13 23 11m29s 29s993ms 14 18 22m10s 1m13s 18 3 1m7s 22s412ms 21 6 15m1s 2m30s 22 1 32s330ms 32s330ms 23 11 7m25s 40s513ms [ User: load - Total duration: 14m31s - Times executed: 15 ]
[ Application: pg_bulkload - Total duration: 14m31s - Times executed: 15 ]
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.GENE_DISEASE_REFERENCE,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.log,parse-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.DUPE}');
Date: 2026-02-25 21:16:50 Duration: 7m22s Database: ctdprd51 User: load Application: pg_bulkload Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.DAG_PATH,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.log,parse-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.DUPE}');
Date: 2026-02-25 21:52:56 Duration: 4m59s Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}');
Date: 2026-02-25 13:53:40 Duration: 4m52s Bind query: yes
2 6 59s105ms 6s193ms 10s862ms 9s850ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Feb 25 07 3 31s270ms 10s423ms 10 1 6s193ms 6s193ms 14 2 21s641ms 10s820ms [ User: pubeu - Total duration: 48s706ms - Times executed: 5 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2130340') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-02-25 14:37:19 Duration: 10s862ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2130340') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-02-25 14:37:12 Duration: 10s779ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2130340') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-02-25 07:56:50 Duration: 10s629ms Database: ctdprd51 User: pubeu Bind query: yes
3 5 13m41s 45s877ms 10m36s 2m44s select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, to_char(cdr.mod_tm, ?) from pub2.gene_chem_reference gcr, pub2.chem_disease_reference cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = ? and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Feb 25 18 1 10m36s 10m36s 19 4 3m5s 46s298ms [ User: load - Total duration: 10m36s - Times executed: 1 ]
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 18:42:26 Duration: 10m36s Database: ctdprd51 User: load Bind query: yes
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 19:02:52 Duration: 46s951ms Bind query: yes
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 19:13:38 Duration: 46s419ms Bind query: yes
4 4 7m24s 1m50s 1m52s 1m51s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Feb 25 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m52s 1m52s 18 1 1m51s 1m51s [ User: postgres - Total duration: 7m24s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m24s - Times executed: 4 ]
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-02-25 14:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-02-25 18:06:52 Duration: 1m51s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-02-25 10:06:51 Duration: 1m50s Database: ctdprd51 User: postgres Application: pg_dump
5 4 1m35s 23s679ms 24s199ms 23s930ms copy pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 25 06 1 23s728ms 23s728ms 10 1 23s679ms 23s679ms 14 1 24s199ms 24s199ms 18 1 24s115ms 24s115ms -
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-02-25 14:07:18 Duration: 24s199ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-02-25 18:07:17 Duration: 24s115ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-02-25 06:07:16 Duration: 23s728ms
6 4 1m9s 14s596ms 19s126ms 17s347ms copy edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Feb 25 06 1 17s814ms 17s814ms 10 1 17s851ms 17s851ms 14 1 14s596ms 14s596ms 18 1 19s126ms 19s126ms [ User: postgres - Total duration: 54s792ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 54s792ms - Times executed: 3 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 18:00:20 Duration: 19s126ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 10:00:19 Duration: 17s851ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 06:00:19 Duration: 17s814ms Database: ctdprd51 User: postgres Application: pg_dump
7 4 1m1s 15s329ms 15s533ms 15s441ms copy pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Feb 25 06 1 15s373ms 15s373ms 10 1 15s329ms 15s329ms 14 1 15s527ms 15s527ms 18 1 15s533ms 15s533ms -
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-02-25 18:07:32 Duration: 15s533ms
-
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-02-25 14:07:34 Duration: 15s527ms
-
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-02-25 06:07:31 Duration: 15s373ms
8 4 58s298ms 14s475ms 14s720ms 14s574ms copy edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Feb 25 06 1 14s557ms 14s557ms 10 1 14s544ms 14s544ms 14 1 14s475ms 14s475ms 18 1 14s720ms 14s720ms -
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 18:00:51 Duration: 14s720ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 06:00:50 Duration: 14s557ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 10:00:50 Duration: 14s544ms
9 4 57s587ms 14s343ms 14s431ms 14s396ms copy edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Feb 25 06 1 14s382ms 14s382ms 10 1 14s429ms 14s429ms 14 1 14s343ms 14s343ms 18 1 14s431ms 14s431ms -
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 18:01:06 Duration: 14s431ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 10:01:04 Duration: 14s429ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 06:01:04 Duration: 14s382ms
10 4 29s182ms 7s276ms 7s330ms 7s295ms copy edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Feb 25 06 1 7s291ms 7s291ms 10 1 7s276ms 7s276ms 14 1 7s283ms 7s283ms 18 1 7s330ms 7s330ms -
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 18:00:30 Duration: 7s330ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 06:00:29 Duration: 7s291ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 14:00:29 Duration: 7s283ms
11 4 25s400ms 6s335ms 6s371ms 6s350ms copy edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 25 06 1 6s344ms 6s344ms 10 1 6s349ms 6s349ms 14 1 6s335ms 6s335ms 18 1 6s371ms 6s371ms -
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 18:01:14 Duration: 6s371ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 10:01:12 Duration: 6s349ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 06:01:12 Duration: 6s344ms
12 4 24s131ms 6s10ms 6s66ms 6s32ms copy edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Feb 25 06 1 6s43ms 6s43ms 10 1 6s12ms 6s12ms 14 1 6s10ms 6s10ms 18 1 6s66ms 6s66ms -
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 18:00:36 Duration: 6s66ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 06:00:35 Duration: 6s43ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-02-25 10:00:35 Duration: 6s12ms
13 3 21s403ms 7s18ms 7s286ms 7s134ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and ptr.term_object_type_id = ? and ptr.phenotype_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?))) and taxonterm.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort asc, pt.indirect_term_qty desc limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Feb 25 05 2 14s116ms 7s58ms 12 1 7s286ms 7s286ms [ User: pubeu - Total duration: 7s286ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'CALCIUM ANTIMONY OXIDE HYDROXIDE')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'CARDIOVASCULAR SYSTEM'))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9606' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases', 'decreases', 'affects')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-02-25 12:01:23 Duration: 7s286ms Database: ctdprd51 User: pubeu Bind query: yes
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ACETYLCYSTEINE')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006979' AND l.type_cd = 'A' AND l.object_type_id = 5))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'CARDIOVASCULAR SYSTEM'))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9605' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-02-25 05:49:07 Duration: 7s98ms Bind query: yes
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ACETYLCYSTEINE')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006979' AND l.type_cd = 'A' AND l.object_type_id = 5))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'CARDIOVASCULAR SYSTEM'))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9605' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-02-25 05:44:01 Duration: 7s18ms Bind query: yes
14 2 1m8s 33s442ms 34s606ms 34s24ms select t.id, t.object_type_id, t.acc_txt, t.acc_db_id, t.nm, t.nm_sort, t.secondary_nm, t.description, t.note, l.acc_txt from load.term t, edit.db_link l where t.object_type_id = ? and t.object_type_id = l.object_type_id and t.id = l.object_id;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Feb 25 14 2 1m8s 34s24ms [ User: load - Total duration: 1m8s - Times executed: 2 ]
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_ID, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.ACC_TXT from load.TERM t, edit.DB_LINK l where t.object_type_id = 4 and t.object_type_id = l.object_type_id and t.id = l.object_id;
Date: 2026-02-25 14:43:40 Duration: 34s606ms Database: ctdprd51 User: load Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_ID, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.ACC_TXT from load.TERM t, edit.DB_LINK l where t.object_type_id = 4 and t.object_type_id = l.object_type_id and t.id = l.object_id;
Date: 2026-02-25 14:56:57 Duration: 33s442ms Database: ctdprd51 User: load Bind query: yes
15 2 28s539ms 13s639ms 14s900ms 14s269ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by gd.network_score nulls last, g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Feb 25 22 2 28s539ms 14s269ms [ User: pubeu - Total duration: 28s539ms - Times executed: 2 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2125877') ORDER BY gd.network_score NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-02-25 22:16:45 Duration: 14s900ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2125877') ORDER BY gd.network_score NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-02-25 22:16:47 Duration: 13s639ms Database: ctdprd51 User: pubeu Bind query: yes
16 2 16s175ms 8s84ms 8s90ms 8s87ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort asc, pt.indirect_term_qty desc limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 25 16 2 16s175ms 8s87ms [ User: pubeu - Total duration: 16s175ms - Times executed: 2 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'AMINO ACIDS, PEPTIDES, AND PROTEINS')) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases', 'decreases', 'affects')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-02-25 16:36:22 Duration: 8s90ms Database: ctdprd51 User: pubeu Bind query: yes
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'AMINO ACIDS, PEPTIDES, AND PROTEINS')) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases', 'decreases', 'affects')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-02-25 16:44:08 Duration: 8s84ms Database: ctdprd51 User: pubeu Bind query: yes
17 2 14s74ms 7s17ms 7s57ms 7s37ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and ptr.term_object_type_id = ? and ptr.phenotype_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and taxonterm.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort asc, pt.indirect_term_qty desc limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 25 05 2 14s74ms 7s37ms [ User: qaeu - Total duration: 7s57ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s17ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9606' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-02-25 05:43:54 Duration: 7s57ms Database: ctdprd51 User: qaeu Bind query: yes
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9606' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-02-25 05:49:00 Duration: 7s17ms Database: ctdprd51 User: pubeu Bind query: yes
18 2 11s64ms 5s14ms 6s50ms 5s532ms select d.abbr dagabbr, d.nm dagnm, gt.level_min_no daglevelmin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pvalcorrected, te.raw_p_val pvalraw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, count(*) over () fullrowcount from term_enrichment te inner join dag_node gt on te.enriched_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where te.term_id = ? and te.enriched_object_type_id = ? order by te.corrected_p_val, d.abbr, gt.nm_sort limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 25 04 1 6s50ms 6s50ms 10 1 5s14ms 5s14ms [ User: pubeu - Total duration: 11s64ms - Times executed: 2 ]
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1402245' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-02-25 04:33:34 Duration: 6s50ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1303265' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-02-25 10:02:34 Duration: 5s14ms Database: ctdprd51 User: pubeu Bind query: yes
19 1 51m37s 51m37s 51m37s 51m37s select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.object_type where cd = ?), ( select current_date) from pub2.gene_chem_reference gcr, pub2.gene_go_annot gga, pub2.phenotype_term_reference ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 25 21 1 51m37s 51m37s -
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.GENE_GO_ANNOT gga, pub2.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub2.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 21:04:16 Duration: 51m37s Bind query: yes
20 1 45m29s 45m29s 45m29s 45m29s select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.object_type where cd = ?), ptr.term_id, ( select id from pub2.object_type where cd = ?), ( select current_date) from pub2.gene_chem_reference gcr, pub2.phenotype_term_reference ptr, pub2.phenotype_term_reference ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Feb 25 20 1 45m29s 45m29s -
select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in ( select gene_chem_reference_id from pub2.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 20:12:33 Duration: 45m29s Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 51m37s 51m37s 51m37s 1 51m37s select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.object_type where cd = ?), ( select current_date) from pub2.gene_chem_reference gcr, pub2.gene_go_annot gga, pub2.phenotype_term_reference ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 25 21 1 51m37s 51m37s -
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.GENE_GO_ANNOT gga, pub2.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub2.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 21:04:16 Duration: 51m37s Bind query: yes
2 45m29s 45m29s 45m29s 1 45m29s select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.object_type where cd = ?), ptr.term_id, ( select id from pub2.object_type where cd = ?), ( select current_date) from pub2.gene_chem_reference gcr, pub2.phenotype_term_reference ptr, pub2.phenotype_term_reference ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Feb 25 20 1 45m29s 45m29s -
select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in ( select gene_chem_reference_id from pub2.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 20:12:33 Duration: 45m29s Bind query: yes
3 34m25s 34m25s 34m25s 1 34m25s select i.id, edit.get_ixn_xml (i.id), edit.get_ixn_prose (i.id), edit.get_ixn_delimited_actions (i.id), i.ixn_type_id, r.reference_acc_txt, r.taxon_acc_txt, r.create_by, common.break_html_words (edit.get_ixn_prose_html (i.id), false) from edit.ixn i, edit.reference_ixn r where i.id = i.root_id and i.id = r.ixn_id and r.create_by not in (...) order by i.id asc;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Feb 25 18 1 34m25s 34m25s [ User: load - Total duration: 34m25s - Times executed: 1 ]
-
SELECT i.id, edit.get_ixn_xml (i.id), edit.get_ixn_prose (i.id), edit.get_ixn_delimited_actions (i.id), i.ixn_type_id, r.reference_acc_txt, r.taxon_acc_txt, r.create_by, common.break_html_words (edit.get_ixn_prose_html (i.id), false) FROM edit.IXN i, edit.REFERENCE_IXN r where i.id = i.root_id and i.id = r.ixn_id and r.create_by not in ('bogusName') order by i.id asc;
Date: 2026-02-25 18:28:54 Duration: 34m25s Database: ctdprd51 User: load Bind query: yes
4 27m 27m 27m 1 27m insert into pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) select gene_id, go_term_id, taxon_id, evidence_cd, is_not from load.gene_go_annot;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Feb 25 17 1 27m 27m -
insert into pub2.GENE_GO_ANNOT (gene_id, go_term_id, taxon_id, evidence_cd, is_not) select gene_id, go_term_id, taxon_id, evidence_cd, is_not from load.GENE_GO_ANNOT;
Date: 2026-02-25 17:45:32 Duration: 27m Bind query: yes
5 15m37s 15m37s 15m37s 1 15m37s insert into pub2.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary) select object_id, object_type_id, acc_txt, db_id, type_cd, is_primary from edit.db_link;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 25 17 1 15m37s 15m37s [ User: pub2 - Total duration: 15m37s - Times executed: 1 ]
-
insert into pub2.DB_LINK (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary) select object_id, object_type_id, acc_txt, db_id, type_cd, is_primary from edit.DB_LINK;
Date: 2026-02-25 17:12:49 Duration: 15m37s Database: ctdprd51 User: pub2 Bind query: yes
6 12m58s 12m58s 12m58s 1 12m58s alter table pub2.term_enrichment_agent add constraint term_enr_agent_term_enr_fk foreign key (term_id, enriched_term_id) references term_enrichment (term_id, enriched_term_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Feb 25 23 1 12m58s 12m58s -
ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enr_agent_term_enr_fk FOREIGN KEY (term_id, enriched_term_id) REFERENCES term_enrichment (term_id, enriched_term_id);
Date: 2026-02-25 23:53:28 Duration: 12m58s Bind query: yes
7 9m7s 9m7s 9m7s 1 9m7s select maint_query_logs_archive ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Feb 25 00 1 9m7s 9m7s [ User: pubc - Total duration: 9m7s - Times executed: 1 ]
[ Application: psql - Total duration: 9m7s - Times executed: 1 ]
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-02-25 00:09:09 Duration: 9m7s Database: ctdprd51 User: pubc Application: psql
8 4m42s 4m42s 4m42s 1 4m42s insert into pub2.gene_taxon (gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd) select gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd from load.gene_taxon;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Feb 25 17 1 4m42s 4m42s -
insert into pub2.GENE_TAXON (gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd) select gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd from load.GENE_TAXON;
Date: 2026-02-25 17:50:14 Duration: 4m42s Bind query: yes
9 4m3s 4m3s 4m3s 1 4m3s create unique index gene_disease_reference_ak1 on pub2.gene_disease_reference using btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Feb 25 21 1 4m3s 4m3s -
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub2.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-02-25 21:24:48 Duration: 4m3s Bind query: yes
-
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub2.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-02-25 21:24:47 Duration: 0ms
10 3m35s 3m35s 3m35s 1 3m35s insert into pub2.term_label (id, object_type_id, term_id, term_label_type_id, nm) select l.id, t.object_type_id, l.term_id, l.term_label_type_id, l.nm from load.term t, load.term_label l where t.id = l.term_id and t.id in ( select id from pub2.term);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Feb 25 17 1 3m35s 3m35s -
INSERT INTO pub2.TERM_LABEL (id, object_type_id, term_id, term_label_type_id, nm) select l.id, t.object_type_id, l.term_id, l.term_label_type_id, l.nm from load.TERM t, load.TERM_LABEL l where t.id = l.term_id and t.id in ( select id from pub2.TERM);
Date: 2026-02-25 17:18:30 Duration: 3m35s Bind query: yes
11 3m30s 3m30s 3m30s 1 3m30s alter table pub2.term_enrichment_agent add constraint term_enrichment_agent_pk primary key (term_id, enriched_term_id, agent_term_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 25 23 1 3m30s 3m30s -
ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-02-25 23:56:58 Duration: 3m30s Bind query: yes
-
ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-02-25 23:56:57 Duration: 0ms
12 2m51s 2m51s 2m51s 1 2m51s create index ix_gene_disease_ref_net_sc on pub2.gene_disease_reference using btree (network_score);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Feb 25 21 1 2m51s 2m51s -
CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score);
Date: 2026-02-25 21:41:15 Duration: 2m51s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score);
Date: 2026-02-25 21:41:14 Duration: 0ms
13 45s877ms 10m36s 2m44s 5 13m41s select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, to_char(cdr.mod_tm, ?) from pub2.gene_chem_reference gcr, pub2.chem_disease_reference cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = ? and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Feb 25 18 1 10m36s 10m36s 19 4 3m5s 46s298ms [ User: load - Total duration: 10m36s - Times executed: 1 ]
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 18:42:26 Duration: 10m36s Database: ctdprd51 User: load Bind query: yes
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 19:02:52 Duration: 46s951ms Bind query: yes
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-02-25 19:13:38 Duration: 46s419ms Bind query: yes
14 2m31s 2m31s 2m31s 1 2m31s alter table pub2.gene_disease_reference add constraint gene_disease_reference_pk primary key (id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Feb 25 21 1 2m31s 2m31s -
ALTER TABLE pub2.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-02-25 21:20:44 Duration: 2m31s Bind query: yes
-
ALTER TABLE pub2.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-02-25 21:20:44 Duration: 0ms Database: ctdprd51 User: pub2
15 2m18s 2m18s 2m18s 1 2m18s create index ix_gene_disease_ref_dis_gene on pub2.gene_disease_reference using btree (disease_id, gene_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Feb 25 21 1 2m18s 2m18s -
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub2.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-02-25 21:34:53 Duration: 2m18s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub2.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-02-25 21:34:53 Duration: 0ms
16 2m12s 2m12s 2m12s 1 2m12s vacuum full analyze db_link;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 25 15 1 2m12s 2m12s -
vacuum FULL analyze db_link;
Date: 2026-02-25 15:19:28 Duration: 2m12s
-
vacuum FULL analyze db_link;
Date: 2026-02-25 15:17:40 Duration: 0ms
17 2m10s 2m10s 2m10s 1 2m10s select distinct ptr.phenotype_id, cdr.disease_id, ( select id from pub2.object_type where cd = ?), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub2.object_type where cd = ?), cdr.mod_tm from pub2.chem_disease_reference cdr, pub2.phenotype_term_reference ptr where cdr.chem_id = ptr.term_id and ptr.source_cd = ? and cdr.source_cd = ? and ptr.ixn_id not in ( select ixn_id from pub2.ixn_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 25 21 1 2m10s 2m10s -
SELECT DISTINCT ptr.phenotype_id, cdr.disease_id, ( select id from pub2.OBJECT_TYPE where cd = 'disease'), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), cdr.mod_tm FROM pub2.CHEM_DISEASE_REFERENCE cdr, pub2.PHENOTYPE_TERM_REFERENCE ptr WHERE cdr.chem_id = ptr.term_id AND ptr.source_cd = 'C' AND cdr.source_cd = 'C' AND ptr.ixn_id NOT IN ( SELECT ixn_id FROM pub2.IXN_AXN WHERE action_degree_type_nm = 'does not affect');
Date: 2026-02-25 21:06:33 Duration: 2m10s Bind query: yes
18 2m7s 2m7s 2m7s 1 2m7s create index ix_term_enrich_agent_enr_term on pub2.term_enrichment_agent using btree (enriched_term_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 25 23 1 2m7s 2m7s -
CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);
Date: 2026-02-25 23:59:05 Duration: 2m7s Bind query: yes
-
CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);
Date: 2026-02-25 23:59:05 Duration: 0ms
19 1m50s 1m52s 1m51s 4 7m24s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 25 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m52s 1m52s 18 1 1m51s 1m51s [ User: postgres - Total duration: 7m24s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m24s - Times executed: 4 ]
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-02-25 14:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-02-25 18:06:52 Duration: 1m51s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-02-25 10:06:51 Duration: 1m50s Database: ctdprd51 User: postgres Application: pg_dump
20 5s74ms 7m22s 55s915ms 62 57m46s select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Feb 25 13 23 11m29s 29s993ms 14 18 22m10s 1m13s 18 3 1m7s 22s412ms 21 6 15m1s 2m30s 22 1 32s330ms 32s330ms 23 11 7m25s 40s513ms [ User: load - Total duration: 14m31s - Times executed: 15 ]
[ Application: pg_bulkload - Total duration: 14m31s - Times executed: 15 ]
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.GENE_DISEASE_REFERENCE,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.log,parse-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.DUPE}');
Date: 2026-02-25 21:16:50 Duration: 7m22s Database: ctdprd51 User: load Application: pg_bulkload Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.DAG_PATH,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.log,parse-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.DUPE}');
Date: 2026-02-25 21:52:56 Duration: 4m59s Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}');
Date: 2026-02-25 13:53:40 Duration: 4m52s 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
- 13,254 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 4 FATAL entries
- 5 ERROR entries
- 0 WARNING entries
- 6 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4 Max number of times the same event was reported
- 15 Total events found
Rank Times reported Error 1 4 ERROR: canceling statement due to user request
Times Reported Most Frequent Error / Event #1
Day Hour Count Feb 25 21 2 23 2 - ERROR: canceling statement due to user request
Statement: SELECT pg_database_size(datname::text) FROM pg_catalog.pg_database WHERE datistemplate = false AND datname = $1;
Date: 2026-02-25 21:19:06
2 4 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #2
Day Hour Count Feb 25 21 2 23 2 3 4 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #3
Day Hour Count Feb 25 21 2 23 2 4 1 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Feb 25 13 1 - ERROR: unterminated quoted identifier at or near "" " at character 524
Statement: select reference_acc_txt ,taxon_acc_txt ,pubTerm.nm ,get_ixn_prose( ixn_id ) ,create_by ,create_tm from edit.reference_ixn ri ,pub1.term pubTerm -- set to CURRENT PRODUCTION PUB!!!!! where taxon_acc_txt not in ( select acc_txt from load.term where object_type_id = ( select id from edit.object_type where cd = 'taxon' ) ) and pubTerm.acc_txt = ri.taxon_acc_txt and object_type_id = ( select id from edit.object_type where cd = 'taxon' ) and taxon_acc_txt is not null and taxon_acc_txt <> ''"
Date: 2026-02-25 13:22:51
5 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Feb 25 14 1 - LOG: process 391000 still waiting for AccessExclusiveLock on relation 2633821 of database 484829 after 1000.057 ms
Detail: Process holding the lock: 390753. Wait queue: 391000.
Statement: SELECT * FROM pgbulkload.pg_bulkload($1)Date: 2026-02-25 14:00:24 Database: ctdprd51 Application: pg_bulkload User: load Remote:
6 1 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count Feb 25 14 1 - LOG: process 390753 still waiting for AccessShareLock on relation 2633821 of database 484829 after 1000.078 ms
Detail: Process holding the lock: 390096. Wait queue: 390753.
Statement: LOCK TABLE edit.db_link IN ACCESS SHARE MODEDate: 2026-02-25 14:00:03 Database: ctdprd51 Application: pg_dump User: postgres Remote: