pgBadger-
Global information
- Generated on Tue Jan 6 04:15:03 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260105
- Parsed 27,943 log entries in 2s
- Log start from 2026-01-05 00:00:01 to 2026-01-05 23:59:00
-
Overview
Global Stats
- 167 Number of unique normalized queries
- 262 Number of queries
- 6h53m22s Total query duration
- 2026-01-05 00:09:14 First query
- 2026-01-05 23:46:26 Last query
- 1 queries/s at 2026-01-05 11:22:11 Query peak
- 6h53m22s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h53m22s Execute total duration
- 10 Number of events
- 9 Number of unique normalized events
- 2 Max number of times the same event was reported
- 0 Number of cancellation
- 60 Total number of automatic vacuums
- 104 Total number of automatic analyzes
- 2,126 Number temporary file
- 28.89 GiB Max size of temporary file
- 201.15 MiB Average size of temporary file
- 2,253 Total number of sessions
- 170 sessions at 2026-01-05 23:39:58 Session peak
- 78d19h5m13s Total duration of sessions
- 50m21s Average duration of sessions
- 0 Average queries per session
- 11s8ms Average queries duration per session
- 50m10s Average idle time per session
- 2,260 Total number of connections
- 9 connections/s at 2026-01-05 05:40:09 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-05 11:22:11 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-05 11:22:11 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-05 18:15:06 Date
Queries duration
Key values
- 6h53m22s 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) Jan 05 00 6 0ms 9m12s 1m40s 0ms 15s411ms 9m19s 01 18 0ms 17s920ms 10s823ms 11s499ms 22s101ms 35s815ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 3 0ms 14s13ms 11s20ms 0ms 5s61ms 14s13ms 05 6 0ms 7s513ms 6s616ms 0ms 7s295ms 14s775ms 06 10 0ms 1m50s 22s958ms 13s834ms 39s162ms 1m50s 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 4 0ms 9m5s 2m21s 0ms 5s69ms 9m5s 10 9 0ms 1m50s 24s106ms 20s818ms 45s696ms 1m50s 11 27 0ms 4m51s 31s996ms 1m33s 1m44s 4m51s 12 18 0ms 2m40s 57s972ms 1m32s 1m47s 3m12s 13 6 0ms 2m1s 29s691ms 0ms 12s967ms 2m1s 14 9 0ms 1m51s 24s181ms 0ms 39s555ms 1m51s 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 4 0ms 14m48s 5m3s 0ms 1m55s 14m58s 17 11 0ms 34m23s 6m25s 1m46s 27m 34m23s 18 49 0ms 26m17s 1m24s 1m51s 7m48s 26m17s 19 10 0ms 47m40s 5m15s 38s768ms 1m15s 47m40s 20 11 0ms 54m30s 6m45s 2m8s 7m42s 54m30s 21 26 0ms 5m5s 49s984ms 1m31s 1m57s 5m5s 22 11 0ms 1m1s 22s593ms 13s117ms 49s589ms 1m26s 23 24 0ms 13m40s 1m18s 2m10s 3m7s 13m40s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 05 00 5 0 1m58s 0ms 0ms 9m12s 01 18 0 10s823ms 11s22ms 11s499ms 35s815ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 3 0 11s20ms 0ms 0ms 14s13ms 05 6 0 6s616ms 0ms 0ms 14s775ms 06 1 9 22s958ms 0ms 13s834ms 1m50s 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 4 0 2m21s 0ms 0ms 9m5s 10 0 9 24s106ms 0ms 20s818ms 1m50s 11 26 0 32s884ms 26s270ms 1m33s 4m51s 12 18 0 57s972ms 1m20s 1m32s 3m12s 13 2 0 6s483ms 0ms 0ms 12s967ms 14 0 9 24s181ms 0ms 0ms 1m51s 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 5 0 7m7s 0ms 8s307ms 34m23s 18 8 41 1m24s 1m4s 1m51s 26m17s 19 1 9 5m15s 0ms 38s768ms 47m40s 20 6 0 11m3s 0ms 1m8s 54m30s 21 6 0 1m28s 0ms 12s438ms 5m5s 22 11 0 22s593ms 0ms 13s117ms 1m26s 23 6 0 54s744ms 0ms 14s879ms 3m15s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 05 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 1 0 0 0 8s916ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 4 0 0 0 5m3s 0ms 0ms 3m17s 17 6 0 0 0 5m49s 0ms 0ms 4m31s 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 4 5 0 0 40s75ms 0ms 0ms 1m27s Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jan 05 00 0 4 4.00 0.00% 01 0 18 18.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 3 3.00 0.00% 05 0 6 6.00 0.00% 06 0 1 1.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 4 4.00 0.00% 10 0 0 0.00 0.00% 11 0 26 26.00 0.00% 12 0 18 18.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 4 4.00 0.00% 17 0 11 11.00 0.00% 18 0 8 8.00 0.00% 19 0 1 1.00 0.00% 20 0 11 11.00 0.00% 21 0 26 26.00 0.00% 22 0 11 11.00 0.00% 23 0 24 24.00 0.00% Day Hour Count Average / Second Jan 05 00 94 0.03/s 01 85 0.02/s 02 96 0.03/s 03 91 0.03/s 04 106 0.03/s 05 134 0.04/s 06 90 0.03/s 07 81 0.02/s 08 79 0.02/s 09 82 0.02/s 10 97 0.03/s 11 151 0.04/s 12 111 0.03/s 13 81 0.02/s 14 78 0.02/s 15 77 0.02/s 16 80 0.02/s 17 92 0.03/s 18 97 0.03/s 19 76 0.02/s 20 82 0.02/s 21 91 0.03/s 22 113 0.03/s 23 96 0.03/s Day Hour Count Average Duration Average idle time Jan 05 00 94 26m29s 26m23s 01 85 28m40s 28m38s 02 96 25m16s 25m16s 03 91 24m40s 24m40s 04 106 23m21s 23m21s 05 134 17m24s 17m24s 06 90 26m2s 25m59s 07 81 30m4s 30m4s 08 79 30m57s 30m57s 09 82 29m26s 29m19s 10 91 24m41s 24m38s 11 150 17m4s 16m58s 12 112 22m21s 22m11s 13 81 30m13s 30m11s 14 78 31m 30m57s 15 77 31m48s 31m48s 16 79 31m14s 30m59s 17 92 27m2s 26m15s 18 96 25m28s 24m45s 19 77 31m4s 30m23s 20 82 11h43m27s 11h42m32s 21 91 25m39s 25m25s 22 113 22m6s 22m4s 23 96 25m49s 25m29s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-01-05 05:40:09 Date
Connections per database
Key values
- ctdprd51 Main Database
- 2,260 connections Total
Connections per user
Key values
- pubeu Main User
- 2,260 connections Total
-
Sessions
Simultaneous sessions
Key values
- 170 sessions Session Peak
- 2026-01-05 23:39:58 Date
Histogram of session times
Key values
- 1,802 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 2,253 sessions Total
Sessions per user
Key values
- pubeu Main User
- 2,253 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 2,253 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 5,374,580 buffers Checkpoint Peak
- 2026-01-05 23:45:26 Date
- 1619.885 seconds Highest write time
- 0.776 seconds Sync time
Checkpoints Wal files
Key values
- 567 files Wal files usage Peak
- 2026-01-05 22:58:26 Date
Checkpoints distance
Key values
- 19,003.08 Mo Distance Peak
- 2026-01-05 23:22:10 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 05 00 291 29.244s 0.002s 29.3s 01 53,281 1,634.044s 0.004s 1,634.547s 02 90 9.217s 0.002s 9.246s 03 5,328 533.561s 0.003s 533.661s 04 175 17.714s 0.002s 17.746s 05 160 16.23s 0.002s 16.262s 06 278 28.038s 0.002s 28.068s 07 647 64.989s 0.003s 65.02s 08 316 31.833s 0.002s 31.863s 09 57,020 1,628.666s 0.003s 1,629.2s 10 2,115 211.89s 0.135s 212.21s 11 285,294 2,151.067s 0.583s 2,160.812s 12 2,613 260.422s 0.319s 287.942s 13 86,627 3,182.642s 0.012s 3,195.744s 14 573 57.468s 0.002s 60.915s 15 478 48.055s 0.002s 48.085s 16 2,413,241 1,230.892s 0.768s 1,259.551s 17 1,614,492 3,180.22s 0.207s 3,193.775s 18 211,364 3,254.646s 0.017s 3,255.62s 19 409,408 1,619.59s 0.002s 1,619.606s 20 4,151,515 88.552s 0.784s 112.389s 21 412,384 1,625.161s 1.226s 1,647.9s 22 487,423 3,820.289s 0.01s 3,830.997s 23 10,081,815 2,079.176s 0.237s 2,111.372s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 05 00 0 0 0 51 0.001s 0.001s 01 0 0 35 63 0.001s 0.003s 02 0 0 0 25 0.001s 0.002s 03 0 0 3 45 0.001s 0.002s 04 0 0 0 36 0.001s 0.002s 05 0 0 0 24 0.001s 0.002s 06 0 0 0 78 0.001s 0.002s 07 0 0 0 133 0.001s 0.002s 08 0 0 0 120 0.001s 0.002s 09 0 0 38 39 0.001s 0.002s 10 0 0 1 667 0.002s 0.002s 11 0 217 620 370 0.409s 0.008s 12 0 0 2,018 160 0.189s 0.013s 13 0 0 1,076 185 0.001s 0.002s 14 0 0 275 155 0.001s 0.002s 15 0 0 0 106 0.001s 0.002s 16 0 0 2,152 270 0.111s 0.014s 17 0 0 1,076 189 0.054s 0.006s 18 0 0 62 351 0.001s 0.003s 19 0 0 0 34 0.001s 0.001s 20 0 33 1,609 115 0.775s 0.053s 21 0 0 1,637 125 0.771s 0.055s 22 0 1 870 130 0.001s 0.003s 23 0 403 2,161 538 0.074s 0.006s Day Hour Count Avg time (sec) Jan 05 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 Jan 05 00 2,252.00 kB 333,431.00 kB 01 192,828.33 kB 521,956.00 kB 02 215.00 kB 400,218.50 kB 03 20,677.50 kB 326,278.50 kB 04 462.50 kB 266,193.50 kB 05 408.50 kB 215,685.50 kB 06 901.50 kB 174,850.50 kB 07 2,111.00 kB 141,973.50 kB 08 887.00 kB 115,253.50 kB 09 312,877.00 kB 594,012.50 kB 10 7,448.50 kB 481,924.00 kB 11 4,397,937.67 kB 4,445,854.67 kB 12 8,262,395.75 kB 8,770,500.25 kB 13 8,821,256.00 kB 8,824,324.00 kB 14 2,509,714.50 kB 8,021,291.50 kB 15 1,767.50 kB 6,497,561.50 kB 16 8,683,142.50 kB 8,683,142.50 kB 17 8,811,332.50 kB 8,816,247.00 kB 18 517,048.67 kB 7,307,546.00 kB 19 67.00 kB 5,897,408.00 kB 20 5,347,967.00 kB 7,415,465.00 kB 21 8,815,661.67 kB 9,025,212.67 kB 22 4,756,645.67 kB 8,416,213.33 kB 23 8,402,327.20 kB 9,291,325.00 kB -
Temporary Files
Size of temporary files
Key values
- 17.00 GiB Temp Files size Peak
- 2026-01-05 20:36:40 Date
Number of temporary files
Key values
- 17 per second Temp Files Peak
- 2026-01-05 20:36:40 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jan 05 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 776 25.82 GiB 34.07 MiB 12 452 38.87 GiB 88.05 MiB 13 115 6.32 GiB 56.30 MiB 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 29 28.89 GiB 1020.03 MiB 19 58 57.89 GiB 1022.05 MiB 20 160 137.98 GiB 883.08 MiB 21 195 70.44 GiB 369.89 MiB 22 175 17.27 GiB 101.05 MiB 23 166 34.14 GiB 210.60 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 1,413 89.94 GiB 8.00 KiB 1.00 GiB 65.18 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-01-05 20:49:18 Duration: 7m27s 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-01-05 21:20:39 Duration: 5m5s
-
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-01-05 11:51:49 Duration: 4m51s
2 88 87.86 GiB 880.44 MiB 1.00 GiB 1022.37 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-01-05 20:36:37 Duration: 0ms
3 58 57.89 GiB 911.11 MiB 1.00 GiB 1022.05 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-01-05 19:41:59 Duration: 0ms
4 35 1.21 GiB 23.85 MiB 50.53 MiB 35.47 MiB vacuum full analyze ixn_actor;-
vacuum FULL analyze ixn_actor;
Date: 2026-01-05 13:28:21 Duration: 25s525ms
-
vacuum FULL analyze ixn_actor;
Date: 2026-01-05 13:28:02 Duration: 0ms
5 35 4.51 GiB 77.89 MiB 173.55 MiB 131.81 MiB vacuum full analyze db_link;-
vacuum FULL analyze db_link;
Date: 2026-01-05 13:30:54 Duration: 2m1s
-
vacuum FULL analyze db_link;
Date: 2026-01-05 13:29:15 Duration: 0ms
6 25 17.48 GiB 8.00 KiB 1.00 GiB 715.79 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-01-05 23:22:15 Duration: 3m7s
-
ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-01-05 23:22:14 Duration: 0ms
7 25 399.78 MiB 11.27 MiB 20.17 MiB 15.99 MiB vacuum full analyze ixn;-
vacuum FULL analyze ixn;
Date: 2026-01-05 13:28:44 Duration: 7s780ms
-
vacuum FULL analyze ixn;
Date: 2026-01-05 13:28:39 Duration: 0ms
8 20 219.67 MiB 7.58 MiB 16.27 MiB 10.98 MiB vacuum full analyze term;-
vacuum FULL analyze TERM;
Date: 2026-01-05 13:28:15 Duration: 10s202ms
-
vacuum FULL analyze TERM;
Date: 2026-01-05 13:28:06 Duration: 0ms
9 20 13.65 GiB 8.00 KiB 1.00 GiB 698.63 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-01-05 20:55:15 Duration: 3m18s
-
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-01-05 20:55:14 Duration: 0ms
10 15 12.48 GiB 430.42 MiB 1.00 GiB 852.12 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-01-05 23:24:08 Duration: 1m52s
-
CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);
Date: 2026-01-05 23:24:07 Duration: 0ms
11 15 7.58 GiB 8.00 KiB 1.00 GiB 517.50 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-01-05 20:51:56 Duration: 1m14s
-
ALTER TABLE pub2.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-01-05 20:51:56 Duration: 0ms Database: ctdprd51 User: pub2
12 10 7.58 GiB 453.10 MiB 1.00 GiB 776.25 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-01-05 20:58:40 Duration: 1m33s
-
CREATE INDEX ix_gene_disease_ref_chem ON pub2.gene_disease_reference USING btree (via_chem_id);
Date: 2026-01-05 20:58:39 Duration: 0ms
13 10 7.58 GiB 315.48 MiB 1.00 GiB 776.25 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-01-05 20:57:06 Duration: 1m1s
-
CREATE INDEX ix_gene_disease_ref_source_cd ON pub2.gene_disease_reference USING btree (source_cd);
Date: 2026-01-05 20:57:06 Duration: 0ms
14 10 165.10 MiB 8.00 KiB 33.80 MiB 16.51 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-01-05 23:05:13 Duration: 0ms Database: ctdprd51 User: pub2
15 10 67.20 MiB 8.00 KiB 13.79 MiB 6.72 MiB alter table pub2.phenotype_term add constraint phenotype_term_pk primary key (phenotype_id, term_id);-
ALTER TABLE pub2.phenotype_term ADD CONSTRAINT phenotype_term_pk PRIMARY KEY (phenotype_id, term_id);
Date: 2026-01-05 23:39:52 Duration: 0ms
16 10 1.15 GiB 8.00 KiB 240.95 MiB 117.65 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-01-05 21:09:16 Duration: 14s160ms
-
ALTER TABLE pub2.phenotype_term_reference ADD CONSTRAINT phenotype_term_reference_pk PRIMARY KEY (id);
Date: 2026-01-05 21:09:15 Duration: 0ms
17 10 7.58 GiB 473.36 MiB 1.00 GiB 776.25 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-01-05 21:09:01 Duration: 2m31s
-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score);
Date: 2026-01-05 21:09:01 Duration: 0ms
18 10 7.58 GiB 464.27 MiB 1.00 GiB 776.25 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-01-05 21:03:33 Duration: 1m57s
-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub2.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-01-05 21:03:33 Duration: 0ms
19 10 7.58 GiB 479.88 MiB 1.00 GiB 776.25 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-01-05 21:06:30 Duration: 1m31s
-
CREATE INDEX ix_gene_disease_ref_mod_tm ON pub2.gene_disease_reference USING btree (mod_tm);
Date: 2026-01-05 21:06:29 Duration: 0ms
20 10 257.30 MiB 8.00 KiB 54.56 MiB 25.73 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-01-05 21:11:18 Duration: 0ms
21 10 7.58 GiB 427.54 MiB 1.00 GiB 776.25 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-01-05 21:01:36 Duration: 1m27s
-
CREATE INDEX ix_gene_disease_ref_reference ON pub2.gene_disease_reference USING btree (reference_id);
Date: 2026-01-05 21:01:35 Duration: 0ms
22 10 468.79 MiB 8.00 KiB 96.22 MiB 46.88 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-01-05 21:11:25 Duration: 6s222ms
-
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-01-05 21:11:25 Duration: 0ms
23 10 665.83 MiB 8.00 KiB 134.70 MiB 66.58 MiB alter table pub2.gene_disease add constraint gene_disease_pk primary key (gene_id, disease_id);-
ALTER TABLE pub2.gene_disease ADD CONSTRAINT gene_disease_pk PRIMARY KEY (gene_id, disease_id);
Date: 2026-01-05 23:39:19 Duration: 7s471ms
-
ALTER TABLE pub2.gene_disease ADD CONSTRAINT gene_disease_pk PRIMARY KEY (gene_id, disease_id);
Date: 2026-01-05 23:39:19 Duration: 0ms Database: ctdprd51 User: pub2
24 10 7.58 GiB 497.05 MiB 1.00 GiB 776.25 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-01-05 20:56:05 Duration: 49s560ms
-
CREATE INDEX ix_gene_disease_ref_src_db ON pub2.gene_disease_reference USING btree (source_acc_db_id);
Date: 2026-01-05 20:56:04 Duration: 0ms
25 10 7.58 GiB 439.07 MiB 1.00 GiB 776.25 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-01-05 21:04:59 Duration: 1m25s
-
CREATE INDEX ix_gene_disease_reference_ixn ON pub2.gene_disease_reference USING btree (ixn_id);
Date: 2026-01-05 21:04:58 Duration: 0ms
26 10 7.58 GiB 455.48 MiB 1.00 GiB 776.25 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-01-05 21:00:09 Duration: 1m28s
-
CREATE INDEX ix_gene_disease_ref_disease ON pub2.gene_disease_reference USING btree (disease_id);
Date: 2026-01-05 21:00:08 Duration: 0ms
27 8 66.98 MiB 8.00 KiB 17.77 MiB 8.37 MiB alter table pub2.chem_disease add constraint chem_disease_pk primary key (chem_id, disease_id);-
ALTER TABLE pub2.chem_disease ADD CONSTRAINT chem_disease_pk PRIMARY KEY (chem_id, disease_id);
Date: 2026-01-05 23:39:55 Duration: 0ms
28 7 6.15 GiB 157.56 MiB 1.00 GiB 900.22 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-01-05 20:40:51 Duration: 0ms
29 5 257.25 MiB 50.25 MiB 52.29 MiB 51.45 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-01-05 21:11:34 Duration: 0ms
30 5 688.00 KiB 128.00 KiB 144.00 KiB 137.60 KiB create index ix_gene_disease_cur_ref_qty on pub2.gene_disease using btree (curated_reference_qty) where (curated_reference_qty > ?);-
CREATE INDEX ix_gene_disease_cur_ref_qty ON pub2.gene_disease USING btree (curated_reference_qty) WHERE (curated_reference_qty > 0);
Date: 2026-01-05 23:39:43 Duration: 0ms
31 5 257.25 MiB 48.89 MiB 53.66 MiB 51.45 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-01-05 21:11:40 Duration: 0ms
32 5 1.15 GiB 232.47 MiB 237.02 MiB 235.29 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-01-05 21:09:48 Duration: 9s388ms
-
CREATE INDEX ix_phenotype_term_ref_object_type_id ON pub2.phenotype_term_reference USING btree (term_object_type_id);
Date: 2026-01-05 21:09:48 Duration: 0ms
33 5 665.65 MiB 130.84 MiB 135.05 MiB 133.13 MiB create index ix_gene_disease_ind_chem_qty on pub2.gene_disease using btree (indirect_chem_qty) where (indirect_chem_qty > ?);-
CREATE INDEX ix_gene_disease_ind_chem_qty ON pub2.gene_disease USING btree (indirect_chem_qty) WHERE (indirect_chem_qty > 0);
Date: 2026-01-05 23:39:50 Duration: 7s223ms
-
CREATE INDEX ix_gene_disease_ind_chem_qty ON pub2.gene_disease USING btree (indirect_chem_qty) WHERE (indirect_chem_qty > 0);
Date: 2026-01-05 23:39:50 Duration: 0ms
34 5 257.26 MiB 50.13 MiB 52.70 MiB 51.45 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-01-05 21:11:30 Duration: 0ms
35 5 257.27 MiB 50.87 MiB 52.30 MiB 51.45 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-01-05 21:11:32 Duration: 0ms
36 5 665.78 MiB 127.80 MiB 136.70 MiB 133.16 MiB create index ix_gene_disease_disease on pub2.gene_disease using btree (disease_id);-
CREATE INDEX ix_gene_disease_disease ON pub2.gene_disease USING btree (disease_id);
Date: 2026-01-05 23:39:26 Duration: 7s91ms
-
CREATE INDEX ix_gene_disease_disease ON pub2.gene_disease USING btree (disease_id);
Date: 2026-01-05 23:39:26 Duration: 0ms
37 5 40.00 KiB 8.00 KiB 8.00 KiB 8.00 KiB create index ix_gene_disease_exp_ref_qty on pub2.gene_disease using btree (exposure_reference_qty) where (exposure_reference_qty > ?);-
CREATE INDEX ix_gene_disease_exp_ref_qty ON pub2.gene_disease USING btree (exposure_reference_qty) WHERE (exposure_reference_qty > 0);
Date: 2026-01-05 23:39:51 Duration: 0ms
38 5 165.07 MiB 24.23 MiB 37.50 MiB 33.01 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-01-05 23:05:14 Duration: 0ms
39 5 230.44 MiB 42.77 MiB 49.49 MiB 46.09 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-01-05 23:05:22 Duration: 0ms
40 5 1.61 GiB 318.16 MiB 347.70 MiB 330.20 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-01-05 21:11:16 Duration: 15s458ms
-
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-01-05 21:11:16 Duration: 0ms
41 5 165.06 MiB 31.88 MiB 34.91 MiB 33.01 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-01-05 23:05:17 Duration: 0ms
42 5 1.15 GiB 230.83 MiB 240.65 MiB 235.29 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-01-05 21:10:08 Duration: 8s39ms
-
CREATE INDEX ix_phenotype_term_ref_taxon_id ON pub2.phenotype_term_reference USING btree (taxon_id);
Date: 2026-01-05 21:10:08 Duration: 0ms
43 5 257.27 MiB 50.65 MiB 52.34 MiB 51.45 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-01-05 21:11:27 Duration: 0ms
44 5 1.15 GiB 226.80 MiB 242.06 MiB 235.30 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-01-05 21:11:01 Duration: 12s567ms
-
CREATE INDEX ix_phenotype_term_ref_via_term_id ON pub2.phenotype_term_reference USING btree (via_term_id);
Date: 2026-01-05 21:11:01 Duration: 0ms
45 5 1.15 GiB 228.97 MiB 242.79 MiB 235.30 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-01-05 21:10:48 Duration: 11s756ms
-
CREATE INDEX ix_phenotype_term_reference_ixn_id ON pub2.phenotype_term_reference USING btree (ixn_id);
Date: 2026-01-05 21:10:48 Duration: 0ms
46 5 1.15 GiB 228.03 MiB 242.59 MiB 235.30 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-01-05 21:09:38 Duration: 10s861ms
-
CREATE INDEX ix_phenotype_term_ref_term_id ON pub2.phenotype_term_reference USING btree (term_id);
Date: 2026-01-05 21:09:38 Duration: 0ms
47 5 1.15 GiB 227.77 MiB 246.30 MiB 235.29 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-01-05 21:09:27 Duration: 11s854ms
-
CREATE INDEX ix_phenotype_term_ref_phenotype_id ON pub2.phenotype_term_reference USING btree (phenotype_id);
Date: 2026-01-05 21:09:27 Duration: 0ms
48 5 257.25 MiB 50.05 MiB 52.95 MiB 51.45 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-01-05 21:11:37 Duration: 0ms
49 5 257.25 MiB 50.74 MiB 51.93 MiB 51.45 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-01-05 21:11:44 Duration: 0ms
50 5 67.17 MiB 12.70 MiB 13.86 MiB 13.43 MiB create index ix_phenotype_term_term_id on pub2.phenotype_term using btree (term_id);-
CREATE INDEX ix_phenotype_term_term_id ON pub2.phenotype_term USING btree (term_id);
Date: 2026-01-05 23:39:53 Duration: 0ms
51 5 67.16 MiB 11.71 MiB 14.95 MiB 13.43 MiB create index ix_phenotype_term_phenotype_id on pub2.phenotype_term using btree (phenotype_id);-
CREATE INDEX ix_phenotype_term_phenotype_id ON pub2.phenotype_term USING btree (phenotype_id);
Date: 2026-01-05 23:39:52 Duration: 0ms
52 5 1.15 GiB 228.46 MiB 239.47 MiB 235.30 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-01-05 21:10:00 Duration: 12s119ms
-
CREATE INDEX ix_phenotype_term_ref_reference_id ON pub2.phenotype_term_reference USING btree (reference_id);
Date: 2026-01-05 21:10:00 Duration: 0ms
53 5 1.15 GiB 227.80 MiB 241.60 MiB 235.29 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-01-05 21:10:16 Duration: 8s39ms
-
CREATE INDEX ix_phenotype_term_ref_evidence_cd ON pub2.phenotype_term_reference USING btree (evidence_cd);
Date: 2026-01-05 21:10:16 Duration: 0ms
54 5 257.25 MiB 49.50 MiB 52.96 MiB 51.45 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-01-05 21:11:49 Duration: 5s116ms
-
CREATE INDEX ix_chem_disease_ref_net_sc ON pub2.chem_disease_reference USING btree (network_score);
Date: 2026-01-05 21:11:49 Duration: 0ms
55 5 230.42 MiB 45.75 MiB 46.51 MiB 46.08 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-01-05 23:05:27 Duration: 0ms
56 5 1.15 GiB 224.28 MiB 247.78 MiB 235.30 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-01-05 21:10:36 Duration: 11s899ms
-
CREATE INDEX ix_phenotype_term_reference_term_reference_id ON pub2.phenotype_term_reference USING btree (term_reference_id);
Date: 2026-01-05 21:10:36 Duration: 0ms
57 5 665.78 MiB 131.37 MiB 134.85 MiB 133.16 MiB create index ix_gene_disease_network_score on pub2.gene_disease using btree (network_score);-
CREATE INDEX ix_gene_disease_network_score ON pub2.gene_disease USING btree (network_score);
Date: 2026-01-05 23:39:42 Duration: 15s696ms
-
CREATE INDEX ix_gene_disease_network_score ON pub2.gene_disease USING btree (network_score);
Date: 2026-01-05 23:39:42 Duration: 0ms
58 5 165.06 MiB 32.34 MiB 33.86 MiB 33.01 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-01-05 23:05:16 Duration: 0ms
59 5 1.15 GiB 229.92 MiB 239.70 MiB 235.29 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-01-05 21:10:24 Duration: 8s495ms
-
CREATE INDEX ix_phenotype_term_reference_source_acc_db_id ON pub2.phenotype_term_reference USING btree (source_acc_db_id);
Date: 2026-01-05 21:10:24 Duration: 0ms
60 4 66.06 MiB 15.98 MiB 16.80 MiB 16.52 MiB create index ix_chem_disease_ind_gene_qty on pub2.chem_disease using btree (indirect_gene_qty) where (indirect_gene_qty > ?);-
CREATE INDEX ix_chem_disease_ind_gene_qty ON pub2.chem_disease USING btree (indirect_gene_qty) WHERE (indirect_gene_qty > 0);
Date: 2026-01-05 23:39:58 Duration: 0ms
61 4 14.80 MiB 8.00 KiB 7.55 MiB 3.70 MiB alter table pub2.phenotype_term_axn add constraint phenotype_term_axn_pk primary key (phenotype_id, term_id, action_type_nm, action_degree_type_nm);-
ALTER TABLE pub2.phenotype_term_axn ADD CONSTRAINT phenotype_term_axn_pk PRIMARY KEY (phenotype_id, term_id, action_type_nm, action_degree_type_nm);
Date: 2026-01-05 23:39:54 Duration: 0ms
62 4 66.95 MiB 16.27 MiB 17.20 MiB 16.74 MiB create index ix_chem_disease_disease on pub2.chem_disease using btree (disease_id);-
CREATE INDEX ix_chem_disease_disease ON pub2.chem_disease USING btree (disease_id);
Date: 2026-01-05 23:39:57 Duration: 0ms
63 4 66.95 MiB 14.91 MiB 18.32 MiB 16.74 MiB create index ix_chem_disease_network_score on pub2.chem_disease using btree (network_score);-
CREATE INDEX ix_chem_disease_network_score ON pub2.chem_disease USING btree (network_score);
Date: 2026-01-05 23:39:56 Duration: 0ms
64 4 2.02 MiB 480.00 KiB 560.00 KiB 518.00 KiB create index ix_chem_disease_cur_ref_qty on pub2.chem_disease using btree (curated_reference_qty) where (curated_reference_qty > ?);-
CREATE INDEX ix_chem_disease_cur_ref_qty ON pub2.chem_disease USING btree (curated_reference_qty) WHERE (curated_reference_qty > 0);
Date: 2026-01-05 23:39:57 Duration: 0ms
65 4 32.00 KiB 8.00 KiB 8.00 KiB 8.00 KiB create index ix_chem_disease_exp_ref_qty on pub2.chem_disease using btree (exposure_reference_qty) where (exposure_reference_qty > ?);-
CREATE INDEX ix_chem_disease_exp_ref_qty ON pub2.chem_disease USING btree (exposure_reference_qty) WHERE (exposure_reference_qty > 0);
Date: 2026-01-05 23:39:58 Duration: 0ms
66 2 6.71 MiB 2.88 MiB 3.84 MiB 3.36 MiB create index ix_phenotype_term_axn_phenotype_id on pub2.phenotype_term_axn using btree (phenotype_id);-
CREATE INDEX ix_phenotype_term_axn_phenotype_id ON pub2.phenotype_term_axn USING btree (phenotype_id);
Date: 2026-01-05 23:39:54 Duration: 0ms
67 2 6.71 MiB 2.91 MiB 3.80 MiB 3.36 MiB create index ix_phenotype_term_axn_term_id on pub2.phenotype_term_axn using btree (term_id);-
CREATE INDEX ix_phenotype_term_axn_term_id ON pub2.phenotype_term_axn USING btree (term_id);
Date: 2026-01-05 23:39:54 Duration: 0ms
68 1 28.89 GiB 28.89 GiB 28.89 GiB 28.89 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-01-05 18:50:08 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 28.89 GiB select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');[ Date: 2026-01-05 18:50:08 ]
2 1.00 GiB SELECT * FROM pgbulkload.pg_bulkload ($1);[ Date: 2026-01-05 12:34:49 - 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-01-05 19:41:59 ]
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-01-05 19:41:59 ]
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-01-05 19:41:59 ]
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-01-05 19:41:59 ]
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-01-05 19:41:59 ]
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-01-05 19:41:59 ]
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-01-05 19:41:59 ]
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-01-05 19:41:59 ]
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-01-05 19:42:00 ]
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-01-05 19:42:00 ]
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-01-05 19:42:00 ]
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-01-05 19:42:00 ]
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-01-05 19:42:00 ]
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-01-05 19:42:00 ]
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-01-05 19:42:00 ]
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-01-05 19:42:00 ]
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-01-05 19:42:00 ]
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-01-05 19:42:00 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 72.37 sec Highest CPU-cost vacuum
Table pub2.gene_go_annot
Database ctdprd51 - 2026-01-05 17:13:45 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 72.37 sec Highest CPU-cost vacuum
Table pub2.gene_go_annot
Database ctdprd51 - 2026-01-05 17:13:45 Date
Analyzes per table
Key values
- pubc.log_query (22) Main table analyzed (database ctdprd51)
- 104 analyzes Total
Table Number of analyzes ctdprd51.pubc.log_query 22 ctdprd51.pg_catalog.pg_class 5 ctdprd51.pub2.term 3 ctdprd51.pg_catalog.pg_index 3 ctdprd51.pg_catalog.pg_attribute 3 ctdprd51.pg_catalog.pg_trigger 2 ctdprd51.pub2.reference 2 ctdprd51.pg_catalog.pg_type 2 ctdprd51.pg_catalog.pg_description 2 ctdprd51.pub2.db 2 ctdprd51.pub2.dag_node 2 ctdprd51.edit.db_link 2 ctdprd51.pg_catalog.pg_attrdef 2 ctdprd51.pg_catalog.pg_constraint 2 ctdprd51.pg_catalog.pg_depend 2 ctdprd51.pg_catalog.pg_shdepend 2 postgres.pg_catalog.pg_shdepend 1 ctdprd51.edit.db_report_site 1 ctdprd51.edit.action_type_path 1 ctdprd51.pub2.db_report 1 ctdprd51.edit.list_db_report 1 ctdprd51.pub2.medium 1 ctdprd51.pub2.exposure 1 ctdprd51.pub2.exp_stressor 1 ctdprd51.edit.action_degree 1 ctdprd51.pub2.chem_disease 1 ctdprd51.pub2.gene_go_annot 1 ctdprd51.edit.country 1 ctdprd51.pub2.exp_receptor 1 ctdprd51.pub2.action_type 1 ctdprd51.edit.actor_form_type 1 ctdprd51.pub2.list_db_report 1 ctdprd51.edit.reference_db_link 1 ctdprd51.pub2.exp_event_project 1 ctdprd51.load.data_load 1 ctdprd51.pub2.reference_exp 1 ctdprd51.pub2.exp_outcome 1 ctdprd51.edit.db 1 ctdprd51.pub2.img 1 ctdprd51.pub2.db_report_site 1 ctdprd51.pub2.db_link 1 ctdprd51.pub2.term_label 1 ctdprd51.pub2.exp_study_factor 1 ctdprd51.pub2.exp_event_assay_method 1 ctdprd51.pub2.exp_receptor_tobacco_use 1 ctdprd51.pub2.exp_receptor_race 1 ctdprd51.pub2.exp_event_location 1 ctdprd51.pub2.exp_anatomy 1 ctdprd51.pub2.exp_event 1 ctdprd51.pub2.dag_edge 1 ctdprd51.pub2.exp_receptor_gender 1 ctdprd51.edit.evidence 1 ctdprd51.edit.object_note 1 ctdprd51.edit.action_type 1 ctdprd51.pub2.reference_party_role 1 ctdprd51.edit.db_report 1 ctdprd51.pub2.country 1 ctdprd51.pub2.exp_stressor_stressor_src 1 ctdprd51.pub2.term_pathway 1 ctdprd51.pub2.reference_party 1 ctdprd51.pub2.geographic_region 1 ctdprd51.pub2.gene_taxon 1 Total 104 Vacuums per table
Key values
- pub2.term (3) Main table vacuumed on database ctdprd51
- 60 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes ctdprd51.pub2.term 3 1 561,773 0 2,816 0 0 395,917 6,847 124,648,615 ctdprd51.pubc.log_query 2 2 619 0 135 0 0 200 76 513,000 ctdprd51.pub2.reference 2 1 310,990 0 2,221 0 0 202,833 7 15,414,692 ctdprd51.pub2.dag_node 2 1 409,086 0 42,510 0 0 320,577 568 96,616,166 ctdprd51.pg_catalog.pg_statistic 2 2 1,368 0 256 0 256 970 209 724,176 ctdprd51.pg_catalog.pg_class 2 2 771 0 147 0 0 352 130 475,829 ctdprd51.pg_catalog.pg_trigger 1 1 317 0 40 0 0 121 40 180,827 ctdprd51.pub1.term_set_enrichment 1 0 5,513 0 4,133 0 0 4,169 2 257,870 ctdprd51.edit.list_db_report 1 0 53 0 2 0 0 7 2 16,633 ctdprd51.edit.action_type_path 1 0 48 0 0 0 0 4 1 9,059 ctdprd51.pub2.exp_stressor 1 0 6,739 0 3 0 0 3,340 1 205,479 ctdprd51.pg_catalog.pg_type 1 1 114 0 27 0 0 56 24 121,200 ctdprd51.pub2.exposure 1 0 4,009 0 1,954 0 0 1,951 1 123,528 ctdprd51.pg_toast.pg_toast_2619 1 1 4,300 0 1,515 0 10,146 4,251 813 610,297 ctdprd51.pg_catalog.pg_description 1 1 218 0 39 0 42 120 27 111,573 ctdprd51.edit.action_degree 1 0 45 0 0 0 0 12 1 9,451 ctdprd51.edit.term_label_type 1 0 59 0 5 0 0 3 2 12,017 ctdprd51.pg_catalog.pg_attribute 1 1 611 0 65 0 68 279 58 261,786 ctdprd51.pg_catalog.pg_index 1 1 176 0 31 0 0 111 25 89,610 ctdprd51.edit.country 1 0 63 0 0 0 0 8 1 9,627 ctdprd51.pub2.db 1 1 116 0 12 0 0 20 9 30,851 ctdprd51.pub2.chem_disease 1 1 276,890 0 43,323 0 0 169,214 43,257 176,341,067 ctdprd51.pub2.gene_go_annot 1 0 637,226 0 307,677 0 0 318,494 11 18,877,298 ctdprd51.pub2.exp_receptor 1 0 7,820 0 3 0 0 3,881 1 237,398 ctdprd51.edit.db_link 1 0 7,659 0 3 0 0 3,700 1 226,695 ctdprd51.pub2.exp_event_project 1 0 2,310 0 3 0 0 1,133 1 75,266 ctdprd51.edit.reference_db_link 1 0 5,774 0 1,655 0 0 3,700 1 226,626 ctdprd51.pub2.img 1 0 1,108 0 5 0 0 524 2 43,295 ctdprd51.pub2.exp_outcome 1 0 877 0 4 0 0 380 2 34,371 ctdprd51.pub2.reference_exp 1 0 339 0 3 0 0 132 1 16,207 ctdprd51.pg_catalog.pg_attrdef 1 1 91 0 13 0 0 28 7 34,470 ctdprd51.pub2.exp_study_factor 1 0 113 0 15 0 0 11 2 13,880 ctdprd51.pub2.db_link 1 0 299,440 0 127,712 0 0 149,569 6 8,869,310 ctdprd51.pub2.term_label 1 0 190,842 0 6 0 0 95,353 4 5,654,404 ctdprd51.pub2.exp_event_location 1 0 3,738 0 4 0 0 1,818 2 118,849 ctdprd51.pub2.exp_receptor_race 1 0 1,429 0 669 0 0 665 2 50,822 ctdprd51.pub2.exp_event_assay_method 1 0 5,339 0 3 0 0 2,641 1 164,238 ctdprd51.pub2.exp_receptor_tobacco_use 1 0 1,268 0 602 0 0 599 1 43,760 ctdprd51.pub2.dag_edge 1 0 1,053 0 486 0 0 482 2 40,389 ctdprd51.pub2.exp_event 1 0 13,519 0 3 0 0 6,681 1 402,598 ctdprd51.pub2.exp_anatomy 1 0 129 0 3 0 0 36 1 10,543 ctdprd51.pub2.exp_receptor_gender 1 0 2,883 0 3 0 0 1,426 1 92,553 ctdprd51.pg_catalog.pg_constraint 1 1 233 0 42 0 0 111 41 150,600 ctdprd51.pub2.reference_party_role 1 0 13,743 0 4 0 0 6,818 1 410,681 ctdprd51.edit.action_type 1 0 174 0 1 0 0 7 1 9,121 ctdprd51.edit.object_note 1 1 175 0 5 0 0 16 3 13,752 ctdprd51.pg_toast.pg_toast_10104129 1 0 89,798 0 4 0 0 44,891 2 2,665,092 ctdprd51.pub2.reference_party 1 0 5,180 0 4 0 0 2,539 2 162,160 ctdprd51.pg_catalog.pg_shdepend 1 1 154 0 51 0 0 102 38 122,339 ctdprd51.pg_catalog.pg_depend 1 1 599 0 98 0 65 297 99 373,851 ctdprd51.pub2.exp_stressor_stressor_src 1 0 2,915 0 4 0 0 1,429 1 92,730 ctdprd51.pub2.term_pathway 1 0 3,333 0 4 0 0 1,614 2 107,409 ctdprd51.pub2.gene_taxon 1 0 167,512 0 5 0 0 83,697 3 4,962,936 Total 60 22 3,050,651 20,600 538,328 0 10,577 1,837,289 52,344 461,086,996 Tuples removed per table
Key values
- pub2.chem_disease (3502463) Main table with removed tuples on database ctdprd51
- 7468242 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain ctdprd51.pub2.chem_disease 1 1 3,502,463 3,502,463 0 0 51,458 ctdprd51.pub2.term 3 1 2,140,207 4,313,467 0 0 171,033 ctdprd51.pub2.dag_node 2 1 1,753,063 3,491,004 0 0 125,897 ctdprd51.pub2.reference 2 1 57,056 403,052 0 0 117,548 ctdprd51.pg_toast.pg_toast_2619 1 1 5,339 21,241 0 0 12,592 ctdprd51.pg_catalog.pg_depend 1 1 2,519 11,828 0 0 139 ctdprd51.pg_catalog.pg_attribute 1 1 1,572 7,706 0 0 230 ctdprd51.pg_catalog.pg_statistic 2 2 1,449 5,962 0 0 820 ctdprd51.pg_catalog.pg_description 1 1 946 4,636 0 0 90 ctdprd51.pg_catalog.pg_shdepend 1 1 707 1,535 0 0 24 ctdprd51.pg_catalog.pg_trigger 1 1 640 1,120 0 0 49 ctdprd51.pg_catalog.pg_class 2 2 626 3,116 0 0 188 ctdprd51.pg_catalog.pg_index 1 1 420 812 0 0 38 ctdprd51.pg_catalog.pg_constraint 1 1 252 615 0 0 35 ctdprd51.edit.country 1 0 163 249 0 0 4 ctdprd51.pub2.db 1 1 134 134 0 0 7 ctdprd51.pg_catalog.pg_attrdef 1 1 117 180 0 1 11 ctdprd51.edit.action_type_path 1 0 106 106 0 0 2 ctdprd51.edit.action_degree 1 0 96 219 0 0 6 ctdprd51.edit.list_db_report 1 0 92 183 0 0 3 ctdprd51.edit.term_label_type 1 0 69 39 0 0 1 ctdprd51.edit.action_type 1 0 64 60 0 0 3 ctdprd51.edit.object_note 1 1 61 33 0 1 2 ctdprd51.pg_catalog.pg_type 1 1 60 1,153 0 0 34 ctdprd51.pubc.log_query 2 2 21 3,831 0 0 128 ctdprd51.pub1.term_set_enrichment 1 0 0 1,327,088 0 0 21,961 ctdprd51.pub2.exp_stressor 1 0 0 229,540 0 0 3,339 ctdprd51.pub2.exposure 1 0 0 236,554 0 0 1,950 ctdprd51.pub2.gene_go_annot 1 0 0 50,004,414 0 0 318,493 ctdprd51.pub2.exp_receptor 1 0 0 208,516 0 0 3,880 ctdprd51.edit.db_link 1 0 0 331,874 0 0 3,699 ctdprd51.pub2.exp_event_project 1 0 0 108,233 0 0 1,132 ctdprd51.edit.reference_db_link 1 0 0 331,874 0 0 3,699 ctdprd51.pub2.img 1 0 0 50,671 0 0 523 ctdprd51.pub2.exp_outcome 1 0 0 39,182 0 0 379 ctdprd51.pub2.reference_exp 1 0 0 3,619 0 0 131 ctdprd51.pub2.exp_study_factor 1 0 0 1,711 0 0 10 ctdprd51.pub2.db_link 1 0 0 20,647,671 0 0 149,568 ctdprd51.pub2.term_label 1 0 0 6,565,012 0 0 95,352 ctdprd51.pub2.exp_event_location 1 0 0 272,747 0 0 1,817 ctdprd51.pub2.exp_receptor_race 1 0 0 102,409 0 0 664 ctdprd51.pub2.exp_event_assay_method 1 0 0 262,846 0 0 2,640 ctdprd51.pub2.exp_receptor_tobacco_use 1 0 0 84,705 0 0 598 ctdprd51.pub2.dag_edge 1 0 0 88,931 0 0 481 ctdprd51.pub2.exp_event 1 0 0 226,697 0 0 6,680 ctdprd51.pub2.exp_anatomy 1 0 0 4,078 0 0 35 ctdprd51.pub2.exp_receptor_gender 1 0 0 204,834 0 0 1,425 ctdprd51.pub2.reference_party_role 1 0 0 1,260,972 0 0 6,817 ctdprd51.pg_toast.pg_toast_10104129 1 0 0 242,661 0 0 44,890 ctdprd51.pub2.reference_party 1 0 0 454,324 0 0 2,538 ctdprd51.pub2.exp_stressor_stressor_src 1 0 0 322,705 0 0 1,428 ctdprd51.pub2.term_pathway 1 0 0 135,792 0 0 1,613 ctdprd51.pub2.gene_taxon 1 0 0 13,140,279 0 0 83,696 Total 60 22 7,468,242 108,664,683 0 2 1,239,780 Pages removed per table
Key values
- pg_catalog.pg_attrdef (1) Main table with removed pages on database ctdprd51
- 2 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed ctdprd51.pg_catalog.pg_attrdef 1 1 117 1 ctdprd51.edit.object_note 1 1 61 1 ctdprd51.pg_catalog.pg_trigger 1 1 640 0 ctdprd51.pub1.term_set_enrichment 1 0 0 0 ctdprd51.edit.list_db_report 1 0 92 0 ctdprd51.pubc.log_query 2 2 21 0 ctdprd51.edit.action_type_path 1 0 106 0 ctdprd51.pub2.exp_stressor 1 0 0 0 ctdprd51.pg_catalog.pg_type 1 1 60 0 ctdprd51.pub2.reference 2 1 57056 0 ctdprd51.pub2.exposure 1 0 0 0 ctdprd51.pg_toast.pg_toast_2619 1 1 5339 0 ctdprd51.pg_catalog.pg_description 1 1 946 0 ctdprd51.edit.action_degree 1 0 96 0 ctdprd51.edit.term_label_type 1 0 69 0 ctdprd51.pg_catalog.pg_attribute 1 1 1572 0 ctdprd51.pg_catalog.pg_index 1 1 420 0 ctdprd51.edit.country 1 0 163 0 ctdprd51.pub2.term 3 1 2140207 0 ctdprd51.pub2.db 1 1 134 0 ctdprd51.pub2.chem_disease 1 1 3502463 0 ctdprd51.pub2.gene_go_annot 1 0 0 0 ctdprd51.pub2.exp_receptor 1 0 0 0 ctdprd51.edit.db_link 1 0 0 0 ctdprd51.pub2.dag_node 2 1 1753063 0 ctdprd51.pub2.exp_event_project 1 0 0 0 ctdprd51.edit.reference_db_link 1 0 0 0 ctdprd51.pub2.img 1 0 0 0 ctdprd51.pub2.exp_outcome 1 0 0 0 ctdprd51.pub2.reference_exp 1 0 0 0 ctdprd51.pub2.exp_study_factor 1 0 0 0 ctdprd51.pub2.db_link 1 0 0 0 ctdprd51.pub2.term_label 1 0 0 0 ctdprd51.pub2.exp_event_location 1 0 0 0 ctdprd51.pub2.exp_receptor_race 1 0 0 0 ctdprd51.pub2.exp_event_assay_method 1 0 0 0 ctdprd51.pub2.exp_receptor_tobacco_use 1 0 0 0 ctdprd51.pub2.dag_edge 1 0 0 0 ctdprd51.pub2.exp_event 1 0 0 0 ctdprd51.pub2.exp_anatomy 1 0 0 0 ctdprd51.pub2.exp_receptor_gender 1 0 0 0 ctdprd51.pg_catalog.pg_constraint 1 1 252 0 ctdprd51.pub2.reference_party_role 1 0 0 0 ctdprd51.edit.action_type 1 0 64 0 ctdprd51.pg_toast.pg_toast_10104129 1 0 0 0 ctdprd51.pub2.reference_party 1 0 0 0 ctdprd51.pg_catalog.pg_shdepend 1 1 707 0 ctdprd51.pg_catalog.pg_statistic 2 2 1449 0 ctdprd51.pg_catalog.pg_depend 1 1 2519 0 ctdprd51.pub2.exp_stressor_stressor_src 1 0 0 0 ctdprd51.pub2.term_pathway 1 0 0 0 ctdprd51.pg_catalog.pg_class 2 2 626 0 ctdprd51.pub2.gene_taxon 1 0 0 0 Total 60 22 7,468,242 2 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jan 05 00 1 1 01 0 2 02 0 1 03 0 1 04 0 3 05 0 3 06 0 0 07 1 1 08 0 0 09 0 1 10 11 21 11 8 14 12 1 0 13 1 3 14 0 0 15 0 0 16 6 12 17 10 12 18 0 3 19 0 0 20 0 0 21 1 1 22 0 1 23 20 24 - 72.37 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 126 Total read queries
- 129 Total write queries
Queries by database
Key values
- unknown Main database
- 197 Requests
- 5h2m22s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 253 Requests
User Request type Count Duration load Total 23 1h2m48s select 23 1h2m48s postgres Total 10 9m10s copy to 10 9m10s pub2 Total 3 15m3s insert 2 14m57s select 1 5s672ms pubc Total 1 9m12s select 1 9m12s pubeu Total 51 22m37s select 51 22m37s qaeu Total 4 33s150ms select 4 33s150ms unknown Total 253 6h38m31s copy to 120 2h33m41s ddl 32 40m4s insert 13 40m52s others 7 3m18s select 76 2h35m4s update 5 5m29s Duration by user
Key values
- 6h38m31s (unknown) Main time consuming user
User Request type Count Duration load Total 23 1h2m48s select 23 1h2m48s postgres Total 10 9m10s copy to 10 9m10s pub2 Total 3 15m3s insert 2 14m57s select 1 5s672ms pubc Total 1 9m12s select 1 9m12s pubeu Total 51 22m37s select 51 22m37s qaeu Total 4 33s150ms select 4 33s150ms unknown Total 253 6h38m31s copy to 120 2h33m41s ddl 32 40m4s insert 13 40m52s others 7 3m18s select 76 2h35m4s update 5 5m29s Queries by host
Key values
- unknown Main host
- 345 Requests
- 8h37m57s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 236 Requests
- 6h20m1s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-01-05 10:38:58 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 180 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 54m30s 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-01-05 20:36:34 - Bind query: yes ]
2 47m40s 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-01-05 19:41:57 - Bind query: yes ]
3 34m23s 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-01-05 17:54:56 - 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-01-05 17:11:48 - Bind query: yes ]
5 26m17s COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-05 18:43:43 ]
6 14m48s 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-01-05 16:39:22 - Database: ctdprd51 - User: pub2 - Bind query: yes ]
7 13m40s 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-01-05 23:19:07 - Bind query: yes ]
8 11m55s 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-01-05 18:09:41 - Database: ctdprd51 - User: load - Bind query: yes ]
9 9m12s /* * 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-01-05 00:09:14 - Database: ctdprd51 - User: pubc - Application: psql ]
10 9m5s SELECT /* GoDiseasesDAO */ phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT(*) OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1289647') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc LIMIT 50;[ Date: 2026-01-05 09:56:53 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
11 7m27s 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-01-05 20:49:18 - Database: ctdprd51 - User: load - Application: pg_bulkload - Bind query: yes ]
12 7m25s COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-01-05 18:56:34 ]
13 5m5s 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-01-05 21:20:39 - Bind query: yes ]
14 4m51s 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-01-05 11:51:49 - Bind query: yes ]
15 4m31s 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-01-05 17:16:19 - Bind query: yes ]
16 3m18s 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-01-05 20:55:15 - Bind query: yes ]
17 3m17s 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-01-05 16:44:47 - Bind query: yes ]
18 3m15s 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-01-05 23:02:43 - Database: ctdprd51 - User: load - Application: pg_bulkload - Bind query: yes ]
19 3m7s ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);[ Date: 2026-01-05 23:22:15 - Bind query: yes ]
20 2m40s 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-01-05 12:46:23 - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 55m24s 62 5s99ms 7m27s 53s626ms select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 05 11 26 14m14s 32s884ms 12 14 16m31s 1m10s 17 3 1m7s 22s567ms 20 3 8m51s 2m57s 21 4 6m53s 1m43s 22 9 3m56s 26s279ms 23 3 3m49s 1m16s [ User: load - Total duration: 15m15s - Times executed: 16 ]
[ Application: pg_bulkload - Total duration: 15m15s - Times executed: 16 ]
-
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-01-05 20:49:18 Duration: 7m27s 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-01-05 21:20:39 Duration: 5m5s 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-01-05 11:51:49 Duration: 4m51s Bind query: yes
2 54m30s 1 54m30s 54m30s 54m30s 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 Jan 05 20 1 54m30s 54m30s -
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-01-05 20:36:34 Duration: 54m30s Bind query: yes
3 47m40s 1 47m40s 47m40s 47m40s 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 Jan 05 19 1 47m40s 47m40s -
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-01-05 19:41:57 Duration: 47m40s Bind query: yes
4 34m23s 1 34m23s 34m23s 34m23s 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 Jan 05 17 1 34m23s 34m23s [ User: load - Total duration: 34m23s - 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-01-05 17:54:56 Duration: 34m23s 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 Jan 05 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-01-05 17:11:48 Duration: 27m Bind query: yes
6 26m17s 1 26m17s 26m17s 26m17s copy pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 05 18 1 26m17s 26m17s -
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-05 18:43:43 Duration: 26m17s
7 15m49s 5 53s352ms 11m55s 3m9s 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 Jan 05 18 5 15m49s 3m9s [ User: load - Total duration: 11m55s - 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-01-05 18:09:41 Duration: 11m55s 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-01-05 18:28:05 Duration: 1m4s 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-01-05 18:34:20 Duration: 1m1s Bind query: yes
8 14m48s 1 14m48s 14m48s 14m48s 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 #8
Day Hour Count Duration Avg duration Jan 05 16 1 14m48s 14m48s [ User: pub2 - Total duration: 14m48s - 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-01-05 16:39:22 Duration: 14m48s Database: ctdprd51 User: pub2 Bind query: yes
9 13m40s 1 13m40s 13m40s 13m40s 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 #9
Day Hour Count Duration Avg duration Jan 05 23 1 13m40s 13m40s -
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-01-05 23:19:07 Duration: 13m40s Bind query: yes
10 9m13s 5 1m49s 1m51s 1m50s 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 Jan 05 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m51s 1m51s 18 1 1m50s 1m50s 19 1 1m49s 1m49s [ User: postgres - Total duration: 7m23s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m23s - 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-01-05 14:06:53 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-01-05 10:06:53 Duration: 1m50s 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-01-05 18:06:52 Duration: 1m50s Database: ctdprd51 User: postgres Application: pg_dump
11 9m12s 1 9m12s 9m12s 9m12s select maint_query_logs_archive ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 05 00 1 9m12s 9m12s [ User: pubc - Total duration: 9m12s - Times executed: 1 ]
[ Application: psql - Total duration: 9m12s - 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-01-05 00:09:14 Duration: 9m12s Database: ctdprd51 User: pubc Application: psql
12 9m5s 1 9m5s 9m5s 9m5s select phenotypeterm.nm gonm, phenotypeterm.nm_html gonmhtml, phenotypeterm.acc_txt goacc, phenotypeterm.id goid, diseaseterm.nm diseasenm, diseaseterm.acc_txt diseaseacc, diseaseterm.acc_db_cd diseaseaccdbcd, diseaseterm.id diseaseid, via_gene_qty genenetworkcount, via_chem_qty chemnetworkcount, indirect_reference_qty referencecount, count(*) over () fullrowcount from phenotype_term pt inner join term phenotypeterm on pt.phenotype_id = phenotypeterm.id inner join term diseaseterm on pt.term_id = diseaseterm.id where phenotypeterm.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id = ?) and diseaseterm.object_type_id = ? order by chemnetworkcount desc, genenetworkcount desc limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 05 09 1 9m5s 9m5s [ User: pubeu - Total duration: 9m5s - Times executed: 1 ]
-
SELECT /* GoDiseasesDAO */ phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT(*) OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1289647') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc LIMIT 50;
Date: 2026-01-05 09:56:53 Duration: 9m5s Database: ctdprd51 User: pubeu Bind query: yes
13 7m25s 1 7m25s 7m25s 7m25s copy pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 05 18 1 7m25s 7m25s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-05 18:56:34 Duration: 7m25s
14 4m31s 1 4m31s 4m31s 4m31s 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 #14
Day Hour Count Duration Avg duration Jan 05 17 1 4m31s 4m31s -
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-01-05 17:16:19 Duration: 4m31s Bind query: yes
15 3m18s 1 3m18s 3m18s 3m18s 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 #15
Day Hour Count Duration Avg duration Jan 05 20 1 3m18s 3m18s -
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-01-05 20:55:15 Duration: 3m18s 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-01-05 20:55:14 Duration: 0ms
16 3m17s 1 3m17s 3m17s 3m17s 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 #16
Day Hour Count Duration Avg duration Jan 05 16 1 3m17s 3m17s -
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-01-05 16:44:47 Duration: 3m17s Bind query: yes
17 3m7s 1 3m7s 3m7s 3m7s 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 #17
Day Hour Count Duration Avg duration Jan 05 23 1 3m7s 3m7s -
ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-01-05 23:22:15 Duration: 3m7s 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-01-05 23:22:14 Duration: 0ms
18 2m31s 1 2m31s 2m31s 2m31s create index ix_gene_disease_ref_net_sc on pub2.gene_disease_reference using btree (network_score);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 05 21 1 2m31s 2m31s -
CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score);
Date: 2026-01-05 21:09:01 Duration: 2m31s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score);
Date: 2026-01-05 21:09:01 Duration: 0ms
19 2m12s 1 2m12s 2m12s 2m12s update pub2.term set has_exposures = false;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 05 23 1 2m12s 2m12s -
update pub2.TERM set has_exposures = false;
Date: 2026-01-05 23:43:07 Duration: 2m12s Bind query: yes
20 2m8s 1 2m8s 2m8s 2m8s 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 #20
Day Hour Count Duration Avg duration Jan 05 20 1 2m8s 2m8s -
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-01-05 20:38:51 Duration: 2m8s Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 62 55m24s 5s99ms 7m27s 53s626ms select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 05 11 26 14m14s 32s884ms 12 14 16m31s 1m10s 17 3 1m7s 22s567ms 20 3 8m51s 2m57s 21 4 6m53s 1m43s 22 9 3m56s 26s279ms 23 3 3m49s 1m16s [ User: load - Total duration: 15m15s - Times executed: 16 ]
[ Application: pg_bulkload - Total duration: 15m15s - Times executed: 16 ]
-
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-01-05 20:49:18 Duration: 7m27s 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-01-05 21:20:39 Duration: 5m5s 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-01-05 11:51:49 Duration: 4m51s Bind query: yes
2 9 1m32s 7s537ms 11s213ms 10s253ms 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 Jan 05 00 3 26s84ms 8s694ms 01 6 1m6s 11s33ms [ User: pubeu - Total duration: 1m10s - Times executed: 7 ]
-
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 = '2122064') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-01-05 01:17:20 Duration: 11s213ms 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 = '2122064') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-01-05 01:40:41 Duration: 11s44ms 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 = '2122064') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-01-05 01:19:26 Duration: 11s40ms Bind query: yes
3 5 15m49s 53s352ms 11m55s 3m9s 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 Jan 05 18 5 15m49s 3m9s [ User: load - Total duration: 11m55s - 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-01-05 18:09:41 Duration: 11m55s 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-01-05 18:28:05 Duration: 1m4s 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-01-05 18:34:20 Duration: 1m1s Bind query: yes
4 5 9m13s 1m49s 1m51s 1m50s 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 Jan 05 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m51s 1m51s 18 1 1m50s 1m50s 19 1 1m49s 1m49s [ User: postgres - Total duration: 7m23s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m23s - 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-01-05 14:06:53 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-01-05 10:06:53 Duration: 1m50s 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-01-05 18:06:52 Duration: 1m50s Database: ctdprd51 User: postgres Application: pg_dump
5 5 1m58s 23s508ms 23s959ms 23s795ms 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 Jan 05 06 1 23s728ms 23s728ms 10 1 23s884ms 23s884ms 14 1 23s959ms 23s959ms 18 1 23s896ms 23s896ms 19 1 23s508ms 23s508ms -
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-01-05 14:07:17 Duration: 23s959ms
-
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-01-05 18:07:15 Duration: 23s896ms
-
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-01-05 10:07:17 Duration: 23s884ms
6 5 1m29s 17s765ms 18s8ms 17s884ms 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 Jan 05 06 1 17s765ms 17s765ms 10 1 17s868ms 17s868ms 14 1 17s935ms 17s935ms 18 2 35s851ms 17s925ms [ User: postgres - Total duration: 1m29s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m29s - Times executed: 5 ]
-
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-01-05 18:00:19 Duration: 18s8ms 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-01-05 14:00:20 Duration: 17s935ms 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-01-05 10:00:19 Duration: 17s868ms Database: ctdprd51 User: postgres Application: pg_dump
7 5 1m17s 15s260ms 15s648ms 15s490ms 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 Jan 05 06 1 15s434ms 15s434ms 10 1 15s648ms 15s648ms 14 1 15s596ms 15s596ms 18 1 15s514ms 15s514ms 19 1 15s260ms 15s260ms -
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-01-05 10:07:32 Duration: 15s648ms
-
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-01-05 14:07:32 Duration: 15s596ms
-
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-01-05 18:07:31 Duration: 15s514ms
8 5 1m12s 14s395ms 14s573ms 14s492ms 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 Jan 05 06 1 14s459ms 14s459ms 10 1 14s573ms 14s573ms 14 1 14s557ms 14s557ms 18 2 28s872ms 14s436ms -
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-01-05 10:00:49 Duration: 14s573ms
-
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-01-05 14: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-01-05 18:00:50 Duration: 14s476ms
9 5 1m12s 14s316ms 14s610ms 14s477ms 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 Jan 05 06 1 14s316ms 14s316ms 10 1 14s402ms 14s402ms 14 1 14s610ms 14s610ms 18 2 29s55ms 14s527ms -
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-01-05 14:01:05 Duration: 14s610ms
-
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-01-05 18:01:04 Duration: 14s589ms
-
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-01-05 18:11:05 Duration: 14s466ms
10 5 1m11s 13s834ms 15s318ms 14s316ms 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;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 05 04 2 28s1ms 14s 06 1 13s834ms 13s834ms 18 2 29s747ms 14s873ms [ User: pubeu - Total duration: 1m11s - 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 = '2123914') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-01-05 18:24:26 Duration: 15s318ms 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 = '2123914') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-01-05 18:33:15 Duration: 14s429ms 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 = '2123914') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-01-05 04:55:52 Duration: 14s13ms Database: ctdprd51 User: pubeu Bind query: yes
11 5 36s669ms 7s211ms 7s756ms 7s333ms 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 #11
Day Hour Count Duration Avg duration Jan 05 06 1 7s211ms 7s211ms 10 1 7s243ms 7s243ms 14 1 7s236ms 7s236ms 18 2 14s976ms 7s488ms -
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-01-05 18:10:29 Duration: 7s756ms
-
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-01-05 10:00:29 Duration: 7s243ms
-
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-01-05 14:00:29 Duration: 7s236ms
12 5 31s838ms 6s298ms 6s415ms 6s367ms 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 #12
Day Hour Count Duration Avg duration Jan 05 06 1 6s348ms 6s348ms 10 1 6s415ms 6s415ms 14 1 6s392ms 6s392ms 18 2 12s681ms 6s340ms -
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-01-05 10:01:12 Duration: 6s415ms
-
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-01-05 14:01:13 Duration: 6s392ms
-
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-01-05 18:01:12 Duration: 6s382ms
13 5 30s23ms 5s989ms 6s39ms 6s4ms 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 #13
Day Hour Count Duration Avg duration Jan 05 06 1 5s991ms 5s991ms 10 1 6s10ms 6s10ms 14 1 5s992ms 5s992ms 18 2 12s29ms 6s14ms -
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-01-05 18:00:35 Duration: 6s39ms
-
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-01-05 10:00:35 Duration: 6s10ms
-
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-01-05 14:00:35 Duration: 5s992ms
14 4 22s929ms 5s713ms 5s784ms 5s732ms select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ?) union select ?, r.id from reference r where r.title_abstract_fts @@ to_tsquery(?, ?) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 05 01 4 22s929ms 5s732ms [ User: pubeu - Total duration: 5s714ms - Times executed: 1 ]
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'DAUCOSTEROL_QT') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'DAUCOSTEROL_QT') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAUCOSTEROL_QT')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'DAUCOSTEROL_QT')) ii GROUP BY ii.cd;
Date: 2026-01-05 01:47:26 Duration: 5s784ms Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'DAUCOSTERIN_QT') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'DAUCOSTERIN_QT') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAUCOSTERIN_QT')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'DAUCOSTERIN_QT')) ii GROUP BY ii.cd;
Date: 2026-01-05 01:46:31 Duration: 5s716ms Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'DAUCOSTEROL_QT') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'DAUCOSTEROL_QT') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAUCOSTEROL_QT')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'DAUCOSTEROL_QT')) ii GROUP BY ii.cd;
Date: 2026-01-05 01:47:00 Duration: 5s714ms Database: ctdprd51 User: pubeu Bind query: yes
15 3 1m46s 15s411ms 1m14s 35s486ms select ? "Input", d.nm "DiseaseName", d.acc_db_cd || ? || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( select string_agg(stm.slim_term_nm, ? order by stm.slim_term_nm) from slim_term_mapping stm where stm.mapped_term_id = d.id) "DiseaseCategories", case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", string_agg(gdr.source_acc_txt, ? order by gdr.source_acc_txt) "OmimIDs", string_agg(distinct r.acc_txt, ?) "PubMedIDs" from gene_disease_reference gdr inner join term g on gdr.gene_id = g.id inner join term d on gdr.disease_id = d.id left outer join reference r on gdr.reference_id = r.id left outer join term c on gdr.via_chem_id = c.id where d.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id = ?) group by g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end, c.nm, gdr.network_score order by d.nm_sort, g.nm, "DirectEvidence", c.nm;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 05 00 1 15s411ms 15s411ms 01 1 16s905ms 16s905ms 23 1 1m14s 1m14s [ User: pubeu - Total duration: 1m46s - Times executed: 3 ]
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'lung neoplasm' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2121534) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-01-05 23:03:00 Duration: 1m14s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'edema' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2117273) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-01-05 01:00:25 Duration: 16s905ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'anemia' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2113662) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-01-05 00:59:54 Duration: 15s411ms Database: ctdprd51 User: pubeu Bind query: yes
16 2 35s815ms 17s895ms 17s920ms 17s907ms select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ? reference ? pg_catalog.english ? name) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 05 01 2 35s815ms 17s907ms [ User: pubeu - Total duration: 17s895ms - Times executed: 1 ]
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'NAME) UNION SELECT 'reference' ,r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english',' NAME) OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'NAME,' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ID,' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AUTHOR...STIGMASTEROL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(3-O-BETA-D-GLUCOPYRANOSIDE_QT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3OBETADGLUCOPYRANOSIDE_QT)')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'NAME,' OR upper(l.acc_txt) LIKE 'ID,' OR upper(l.acc_txt) LIKE 'AUTHOR...STIGMASTEROL' OR upper(l.acc_txt) LIKE '3-O-BETA-D-GLUCOPYRANOSIDE_QT')) ii GROUP BY ii.cd;
Date: 2026-01-05 01:44:20 Duration: 17s920ms Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'NAME) UNION SELECT 'reference' ,r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english',' NAME) OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'NAME,' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ID,' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AUTHOR...STIGMASTEROL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(3-O-BETA-D-GLUCOPYRANOSIDE_QT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3OBETADGLUCOPYRANOSIDE_QT)')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'NAME,' OR upper(l.acc_txt) LIKE 'ID,' OR upper(l.acc_txt) LIKE 'AUTHOR...STIGMASTEROL' OR upper(l.acc_txt) LIKE '3-O-BETA-D-GLUCOPYRANOSIDE_QT')) ii GROUP BY ii.cd;
Date: 2026-01-05 01:44:42 Duration: 17s895ms Database: ctdprd51 User: pubeu Bind query: yes
17 2 24s137ms 12s23ms 12s113ms 12s68ms select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ?) union select ?, r.id from reference r where r.title_abstract_fts @@ to_tsquery(?, ?) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ? or upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 05 01 2 24s137ms 12s68ms [ User: pubeu - Total duration: 12s23ms - Times executed: 1 ]
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', '(BETA-SITOSTEROL | BETASITOSTEROL) & (3-O-GLUCOSIDE_QT | 3OGLUCOSIDE_QT)') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', '(BETA-SITOSTEROL | BETASITOSTEROL) & (3-O-GLUCOSIDE_QT | 3OGLUCOSIDE_QT)') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(BETA-SITOSTEROL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BETASITOSTEROL)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(3-O-GLUCOSIDE_QT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3OGLUCOSIDE_QT)')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'BETA-SITOSTEROL' OR upper(l.acc_txt) LIKE '3-O-GLUCOSIDE_QT')) ii GROUP BY ii.cd;
Date: 2026-01-05 01:45:34 Duration: 12s113ms Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', '(BETA-SITOSTEROL | BETASITOSTEROL) & (3-O-GLUCOSIDE_QT | 3OGLUCOSIDE_QT)') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', '(BETA-SITOSTEROL | BETASITOSTEROL) & (3-O-GLUCOSIDE_QT | 3OGLUCOSIDE_QT)') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(BETA-SITOSTEROL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BETASITOSTEROL)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(3-O-GLUCOSIDE_QT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3OGLUCOSIDE_QT)')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'BETA-SITOSTEROL' OR upper(l.acc_txt) LIKE '3-O-GLUCOSIDE_QT')) ii GROUP BY ii.cd;
Date: 2026-01-05 01:45:25 Duration: 12s23ms Database: ctdprd51 User: pubeu Bind query: yes
18 2 22s162ms 11s22ms 11s140ms 11s81ms 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 ? offset ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 05 01 2 22s162ms 11s81ms [ User: pubeu - Total duration: 22s162ms - 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 = '2122064') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 50;
Date: 2026-01-05 01:25:25 Duration: 11s140ms 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 = '2122064') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 50;
Date: 2026-01-05 01:18:25 Duration: 11s22ms Database: ctdprd51 User: pubeu Bind query: yes
19 2 16s858ms 8s366ms 8s492ms 8s429ms 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 #19
Day Hour Count Duration Avg duration Jan 05 09 1 8s366ms 8s366ms 12 1 8s492ms 8s492ms [ User: pubeu - Total duration: 16s858ms - 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 'BETA-HEXACHLOROCYCLOHEXANE')) 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 500;
Date: 2026-01-05 12:25:46 Duration: 8s492ms 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 'DIETHYLHEXYL PHTHALATE')) 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-01-05 09:01:20 Duration: 8s366ms Database: ctdprd51 User: pubeu Bind query: yes
20 2 14s809ms 7s295ms 7s513ms 7s404ms 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 #20
Day Hour Count Duration Avg duration Jan 05 05 2 14s809ms 7s404ms -
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-01-05 05:49:31 Duration: 7s513ms 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-01-05 05:44:06 Duration: 7s295ms Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 54m30s 54m30s 54m30s 1 54m30s 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 Jan 05 20 1 54m30s 54m30s -
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-01-05 20:36:34 Duration: 54m30s Bind query: yes
2 47m40s 47m40s 47m40s 1 47m40s 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 Jan 05 19 1 47m40s 47m40s -
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-01-05 19:41:57 Duration: 47m40s Bind query: yes
3 34m23s 34m23s 34m23s 1 34m23s 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 Jan 05 17 1 34m23s 34m23s [ User: load - Total duration: 34m23s - 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-01-05 17:54:56 Duration: 34m23s 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 Jan 05 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-01-05 17:11:48 Duration: 27m Bind query: yes
5 26m17s 26m17s 26m17s 1 26m17s copy pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 05 18 1 26m17s 26m17s -
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-05 18:43:43 Duration: 26m17s
6 14m48s 14m48s 14m48s 1 14m48s 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 Jan 05 16 1 14m48s 14m48s [ User: pub2 - Total duration: 14m48s - 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-01-05 16:39:22 Duration: 14m48s Database: ctdprd51 User: pub2 Bind query: yes
7 13m40s 13m40s 13m40s 1 13m40s 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 #7
Day Hour Count Duration Avg duration Jan 05 23 1 13m40s 13m40s -
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-01-05 23:19:07 Duration: 13m40s Bind query: yes
8 9m12s 9m12s 9m12s 1 9m12s select maint_query_logs_archive ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 05 00 1 9m12s 9m12s [ User: pubc - Total duration: 9m12s - Times executed: 1 ]
[ Application: psql - Total duration: 9m12s - 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-01-05 00:09:14 Duration: 9m12s Database: ctdprd51 User: pubc Application: psql
9 9m5s 9m5s 9m5s 1 9m5s select phenotypeterm.nm gonm, phenotypeterm.nm_html gonmhtml, phenotypeterm.acc_txt goacc, phenotypeterm.id goid, diseaseterm.nm diseasenm, diseaseterm.acc_txt diseaseacc, diseaseterm.acc_db_cd diseaseaccdbcd, diseaseterm.id diseaseid, via_gene_qty genenetworkcount, via_chem_qty chemnetworkcount, indirect_reference_qty referencecount, count(*) over () fullrowcount from phenotype_term pt inner join term phenotypeterm on pt.phenotype_id = phenotypeterm.id inner join term diseaseterm on pt.term_id = diseaseterm.id where phenotypeterm.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id = ?) and diseaseterm.object_type_id = ? order by chemnetworkcount desc, genenetworkcount desc limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 05 09 1 9m5s 9m5s [ User: pubeu - Total duration: 9m5s - Times executed: 1 ]
-
SELECT /* GoDiseasesDAO */ phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT(*) OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1289647') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc LIMIT 50;
Date: 2026-01-05 09:56:53 Duration: 9m5s Database: ctdprd51 User: pubeu Bind query: yes
10 7m25s 7m25s 7m25s 1 7m25s copy pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 05 18 1 7m25s 7m25s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-05 18:56:34 Duration: 7m25s
11 4m31s 4m31s 4m31s 1 4m31s 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 Jan 05 17 1 4m31s 4m31s -
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-01-05 17:16:19 Duration: 4m31s Bind query: yes
12 3m18s 3m18s 3m18s 1 3m18s 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 Jan 05 20 1 3m18s 3m18s -
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-01-05 20:55:15 Duration: 3m18s 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-01-05 20:55:14 Duration: 0ms
13 3m17s 3m17s 3m17s 1 3m17s 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 Jan 05 16 1 3m17s 3m17s -
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-01-05 16:44:47 Duration: 3m17s Bind query: yes
14 53s352ms 11m55s 3m9s 5 15m49s 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 #14
Day Hour Count Duration Avg duration Jan 05 18 5 15m49s 3m9s [ User: load - Total duration: 11m55s - 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-01-05 18:09:41 Duration: 11m55s 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-01-05 18:28:05 Duration: 1m4s 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-01-05 18:34:20 Duration: 1m1s Bind query: yes
15 3m7s 3m7s 3m7s 1 3m7s 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 #15
Day Hour Count Duration Avg duration Jan 05 23 1 3m7s 3m7s -
ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-01-05 23:22:15 Duration: 3m7s 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-01-05 23:22:14 Duration: 0ms
16 2m31s 2m31s 2m31s 1 2m31s create index ix_gene_disease_ref_net_sc on pub2.gene_disease_reference using btree (network_score);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 05 21 1 2m31s 2m31s -
CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score);
Date: 2026-01-05 21:09:01 Duration: 2m31s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score);
Date: 2026-01-05 21:09:01 Duration: 0ms
17 2m12s 2m12s 2m12s 1 2m12s update pub2.term set has_exposures = false;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 05 23 1 2m12s 2m12s -
update pub2.TERM set has_exposures = false;
Date: 2026-01-05 23:43:07 Duration: 2m12s Bind query: yes
18 2m8s 2m8s 2m8s 1 2m8s 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 #18
Day Hour Count Duration Avg duration Jan 05 20 1 2m8s 2m8s -
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-01-05 20:38:51 Duration: 2m8s Bind query: yes
19 1m49s 1m51s 1m50s 5 9m13s 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 Jan 05 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m51s 1m51s 18 1 1m50s 1m50s 19 1 1m49s 1m49s [ User: postgres - Total duration: 7m23s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m23s - 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-01-05 14:06:53 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-01-05 10:06:53 Duration: 1m50s 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-01-05 18:06:52 Duration: 1m50s Database: ctdprd51 User: postgres Application: pg_dump
20 5s99ms 7m27s 53s626ms 62 55m24s select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 05 11 26 14m14s 32s884ms 12 14 16m31s 1m10s 17 3 1m7s 22s567ms 20 3 8m51s 2m57s 21 4 6m53s 1m43s 22 9 3m56s 26s279ms 23 3 3m49s 1m16s [ User: load - Total duration: 15m15s - Times executed: 16 ]
[ Application: pg_bulkload - Total duration: 15m15s - Times executed: 16 ]
-
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-01-05 20:49:18 Duration: 7m27s 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-01-05 21:20:39 Duration: 5m5s 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-01-05 11:51:49 Duration: 4m51s 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,892 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 1 FATAL entries
- 8 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2 Max number of times the same event was reported
- 10 Total events found
Rank Times reported Error 1 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Jan 05 13 2 - ERROR: syntax error at or near ".." at character 21
- ERROR: syntax error at or near "select" at character 210
Statement: select * from pub1..term where object_type_id = 3 -- and nm like 'AL%' and acc_db_id = 29 and nm not in ( select nm from load.term where object_type_id = 3 and acc_db_id = 29 ) limit 100
Date: 2026-01-05 13:22:27
Statement: select * from pub1.term where object_type_id = 3 -- and nm like 'AL%' and acc_db_cd = 'OMIM' and nm not in ( select nm from load.term where object_type_id = 3 and acc_db_id = 29 ) limit 100 select * from pub1.term where object_type_id = 3 and nm like 'AL%'
Date: 2026-01-05 13:23:28
2 1 ERROR: invalid byte sequence for encoding
Times Reported Most Frequent Error / Event #2
Day Hour Count Jan 05 16 1 - ERROR: invalid byte sequence for encoding "UTF8": 0x00
Context: unnamed portal parameter $1
Statement: SELECT /* ObjectIdDAOImpl.LabelsAndAccs */ t.id ,t.nm ,t.nm_sort nmSort ,t.acc_txt acc ,t.acc_db_cd accDbCd FROM term t ,(SELECT li.term_id FROM term_label li WHERE UPPER(li.nm) = $1 AND li.object_type_id = 2 UNION SELECT l.object_id FROM db_link l WHERE upper( l.acc_txt ) = $2 AND l.object_type_id = 2 AND l.type_cd = 'A') ids WHERE t.id = ids.term_id ORDER BY CASE WHEN UPPER(t.nm) = $3 THEN 1 ELSE 2 END ,t.nm_sortDate: 2026-01-05 16:43:14 Database: ctdprd51 Application: User: pubeu Remote:
3 1 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #3
Day Hour Count Jan 05 20 1 4 1 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jan 05 06 1 - ERROR: duplicate key value violates unique constraint "ixn_action_pk"
Detail: Key (ixn_id, action_type_id, action_degree_type_id)=(9305649, 1, 1) already exists.
Context: SQL statement "INSERT INTO edit.ixn_action (ixn_id ,action_type_id ,action_degree_type_id ,position_seq ,create_by ,mod_by ,create_tm ,mod_tm ) VALUES (p_ixn_id ,p_action_type_id ,p_action_degree_type_id ,p_position_seq ,p_create_by ,p_mod_by ,p_create_tm ,p_mod_tm )" PL/pgSQL function ins_ixn_action(integer,integer,integer,smallint,character varying,character varying,timestamp without time zone,timestamp without time zone) line 9 at SQL statement
Statement: select * from edit.ins_ixn_action($1, $2, $3, $4, $5, $6, $7, $8) as resultDate: 2026-01-05 06:32:52 Database: ctdprd51 Application: User: editeu Remote:
5 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jan 05 13 1 - ERROR: relation "object_note" does not exist at character 15
Statement: select * from object_note
Date: 2026-01-05 13:04:32 Database: ctdprd51 Application: pgAdmin 4 - CONN:5987907 User: load Remote:
6 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #6
Day Hour Count Jan 05 20 1 7 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jan 05 13 1 - ERROR: column "acc_db_id" does not exist at character 81
Hint: Perhaps you meant to reference the column "term.acc_db_cd".
Statement: select * from pub1.term where object_type_id = 3 -- and nm like 'AL%' and acc_db_id = 29 and nm not in ( select nm from load.term where object_type_id = 3 and acc_db_id = 29 ) limit 100Date: 2026-01-05 13:22:32
8 1 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Jan 05 10 1 - ERROR: unterminated quoted identifier at or near "" -- This provides discrepancies introduced this month - it is NOT aggregate select nm as Underlying_Term_Name ,acc_txt as Underlying_Term_Accession ,synonym ,reference_acc_txt ,notes ,create_by ,create_tm from edit.term_label where ( acc_txt, object_type_id ) not in ( -- Current Month's PUB select acc_txt, object_type_id from pub1.term ) order by acc_txt " at character 1
Statement: " -- This provides discrepancies introduced this month - it is NOT aggregate select nm as Underlying_Term_Name ,acc_txt as Underlying_Term_Accession ,synonym ,reference_acc_txt ,notes ,create_by ,create_tm from edit.term_label where ( acc_txt, object_type_id ) not in ( -- Current Month's PUB select acc_txt, object_type_id from pub1.term ) order by acc_txt
Date: 2026-01-05 10:18:08 Database: ctdprd51 Application: pgAdmin 4 - CONN:5312266 User: edit Remote:
9 1 ERROR: canceling statement due to user request
Times Reported Most Frequent Error / Event #9
Day Hour Count Jan 05 20 1 - 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-01-05 20:54:07