pgBadger-
Global information
- Generated on Thu Jan 29 04:15:04 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260128
- Parsed 26,941 log entries in 3s
- Log start from 2026-01-28 00:00:18 to 2026-01-28 23:59:53
-
Overview
Global Stats
- 128 Number of unique normalized queries
- 196 Number of queries
- 5h38m19s Total query duration
- 2026-01-28 00:09:31 First query
- 2026-01-28 23:59:22 Last query
- 2 queries/s at 2026-01-28 15:24:21 Query peak
- 5h38m19s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 5h38m19s Execute total duration
- 12 Number of events
- 4 Number of unique normalized events
- 5 Max number of times the same event was reported
- 0 Number of cancellation
- 54 Total number of automatic vacuums
- 92 Total number of automatic analyzes
- 2,163 Number temporary file
- 1.00 GiB Max size of temporary file
- 198.90 MiB Average size of temporary file
- 2,128 Total number of sessions
- 168 sessions at 2026-01-28 23:56:53 Session peak
- 40d9h34m23s Total duration of sessions
- 27m20s Average duration of sessions
- 0 Average queries per session
- 9s539ms Average queries duration per session
- 27m10s Average idle time per session
- 2,140 Total number of connections
- 9 connections/s at 2026-01-28 05:45:08 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2026-01-28 15:24:21 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-28 13:18:45 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-28 21:21:44 Date
Queries duration
Key values
- 5h38m19s 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 28 00 3 0ms 9m12s 3m9s 0ms 7s794ms 9m19s 01 1 0ms 11s320ms 11s320ms 0ms 0ms 11s320ms 02 1 0ms 7s357ms 7s357ms 0ms 0ms 7s357ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 2 0ms 5s221ms 5s171ms 0ms 5s120ms 5s221ms 06 10 0ms 1m50s 22s420ms 0ms 39s419ms 1m58s 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 9 0ms 1m51s 24s142ms 0ms 39s556ms 1m51s 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 10 0ms 13s626ms 8s323ms 0ms 22s465ms 28s985ms 13 25 0ms 4m41s 42s547ms 1m32s 1m43s 5m18s 14 21 0ms 2m38s 46s248ms 1m31s 1m46s 3m10s 15 9 0ms 1m59s 26s9ms 0ms 34s68ms 1m59s 16 3 0ms 15m 5m42s 0ms 1m57s 15m10s 17 9 0ms 27m5s 4m18s 1m42s 3m22s 27m5s 18 19 0ms 34m29s 2m45s 42s945ms 1m51s 34m29s 19 2 0ms 44m46s 22m44s 0ms 42s242ms 44m46s 20 5 0ms 53m1s 12m48s 50s8ms 7m59s 53m1s 21 34 0ms 5m 56s620ms 1m57s 3m16s 5m 22 11 0ms 1m1s 22s298ms 36s926ms 50s871ms 1m1s 23 22 0ms 14m14s 1m15s 1m54s 3m1s 14m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 28 00 2 0 4m40s 0ms 0ms 9m12s 01 1 0 11s320ms 0ms 0ms 11s320ms 02 1 0 7s357ms 0ms 0ms 7s357ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 2 0 5s171ms 0ms 0ms 5s221ms 06 1 9 22s420ms 0ms 8s266ms 1m50s 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 9 24s142ms 0ms 0ms 1m51s 11 0 0 0ms 0ms 0ms 0ms 12 9 0 8s281ms 0ms 0ms 28s985ms 13 25 0 42s547ms 28s822ms 1m32s 5m18s 14 12 9 46s248ms 41s751ms 1m31s 3m10s 15 3 0 9s367ms 0ms 0ms 11s864ms 16 0 0 0ms 0ms 0ms 0ms 17 2 0 5s784ms 0ms 0ms 11s569ms 18 10 9 2m45s 39s717ms 42s945ms 34m29s 19 2 0 22m44s 0ms 0ms 44m46s 20 5 0 12m48s 0ms 50s8ms 53m1s 21 9 0 1m8s 0ms 32s114ms 5m 22 11 0 22s298ms 0ms 36s926ms 1m1s 23 7 0 38s984ms 0ms 8s795ms 3m16s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 28 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 1 0 0 0 8s693ms 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 3 0 0 0 5m42s 0ms 0ms 1m57s 17 7 0 0 0 5m30s 0ms 0ms 4m33s 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 2 0 0 24s505ms 0ms 0ms 16s614ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jan 28 00 0 1 1.00 0.00% 01 0 1 1.00 0.00% 02 0 1 1.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 2 2.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 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 9 9.00 0.00% 13 0 24 24.00 0.00% 14 0 12 12.00 0.00% 15 0 4 4.00 0.00% 16 0 3 3.00 0.00% 17 0 9 9.00 0.00% 18 0 10 10.00 0.00% 19 0 2 2.00 0.00% 20 0 5 5.00 0.00% 21 0 34 34.00 0.00% 22 0 11 11.00 0.00% 23 0 22 22.00 0.00% Day Hour Count Average / Second Jan 28 00 84 0.02/s 01 77 0.02/s 02 92 0.03/s 03 78 0.02/s 04 88 0.02/s 05 96 0.03/s 06 82 0.02/s 07 72 0.02/s 08 79 0.02/s 09 79 0.02/s 10 107 0.03/s 11 78 0.02/s 12 131 0.04/s 13 113 0.03/s 14 107 0.03/s 15 83 0.02/s 16 76 0.02/s 17 82 0.02/s 18 93 0.03/s 19 80 0.02/s 20 78 0.02/s 21 90 0.03/s 22 99 0.03/s 23 96 0.03/s Day Hour Count Average Duration Average idle time Jan 28 00 84 29m38s 29m32s 01 77 30m58s 30m58s 02 92 26m45s 26m45s 03 78 30m19s 30m19s 04 88 27m39s 27m39s 05 96 25m17s 25m17s 06 82 28m44s 28m42s 07 72 30m38s 30m38s 08 79 30m32s 30m32s 09 79 31m4s 31m4s 10 99 24m12s 24m10s 11 78 31m36s 31m36s 12 127 18m51s 18m50s 13 114 21m50s 21m40s 14 107 22m37s 22m28s 15 83 29m50s 29m48s 16 75 30m58s 30m44s 17 82 30m52s 30m24s 18 93 26m52s 26m18s 19 80 28m16s 27m42s 20 78 32m18s 31m28s 21 90 26m15s 25m54s 22 99 24m52s 24m49s 23 96 26m47s 26m30s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-01-28 05:45:08 Date
Connections per database
Key values
- ctdprd51 Main Database
- 2,140 connections Total
Connections per user
Key values
- pubeu Main User
- 2,140 connections Total
-
Sessions
Simultaneous sessions
Key values
- 168 sessions Session Peak
- 2026-01-28 23:56:53 Date
Histogram of session times
Key values
- 1,808 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 2,128 sessions Total
Sessions per user
Key values
- pubeu Main User
- 2,128 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 2,128 sessions Total
Host Count Total Duration Average Duration 10.12.5.45 380 7d23h40m 30m15s 10.12.5.46 376 8d11m21s 30m40s 10.12.5.52 15 20s448ms 1s363ms 10.12.5.53 414 8d1h29m49s 28m2s 10.12.5.54 374 8d8m23s 30m49s 10.12.5.55 376 7d23h26m40s 30m32s 10.12.5.56 182 8h22m31s 2m45s 192.168.201.10 1 394ms 394ms 192.168.201.6 2 1s542ms 771ms ::1 8 15m14s 1m54s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 966,182 buffers Checkpoint Peak
- 2026-01-28 23:37:21 Date
- 1620.040 seconds Highest write time
- 0.766 seconds Sync time
Checkpoints Wal files
Key values
- 643 files Wal files usage Peak
- 2026-01-28 21:07:49 Date
Checkpoints distance
Key values
- 35,795.56 Mo Distance Peak
- 2026-01-28 23:37:21 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 28 00 569 57.179s 0.002s 57.318s 01 421 42.33s 0.002s 42.361s 02 91 9.268s 0.002s 9.297s 03 145 14.686s 0.002s 14.716s 04 1,155 115.834s 0.002s 115.864s 05 407 40.931s 0.002s 41.008s 06 1,916 191.982s 0.003s 192.012s 07 5,593 560.209s 0.002s 560.288s 08 211 21.285s 0.002s 21.315s 09 125 12.575s 0.002s 12.604s 10 57 5.885s 0.002s 5.916s 11 5,419 542.65s 0.145s 543.033s 12 255 25.69s 0.002s 25.72s 13 290,331 1,846.254s 1.68s 1,869.86s 14 1,501 150.884s 0.305s 164.618s 15 82,568 2,629.812s 0.116s 2,648.275s 16 1,148,147 759.121s 0.262s 773.217s 17 2,035,772 2,042.287s 0.556s 2,063.136s 18 970,423 3,238.855s 0.028s 3,246.217s 19 34,968 1,622.497s 0.002s 1,622.546s 20 117 11.986s 0.002s 12.024s 21 633,981 1,684.131s 1.382s 1,729.345s 22 146,931 2,103.94s 0.004s 2,107.922s 23 1,591,327 2,946.183s 0.016s 2,964.485s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 28 00 0 0 1 70 0.001s 0.002s 01 0 0 0 37 0.001s 0.002s 02 0 0 0 24 0.001s 0.002s 03 0 0 0 30 0.001s 0.002s 04 0 0 0 46 0.001s 0.002s 05 0 0 1 46 0.001s 0.002s 06 0 0 0 46 0.001s 0.002s 07 0 0 4 46 0.001s 0.002s 08 0 0 0 26 0.001s 0.002s 09 0 0 0 31 0.001s 0.002s 10 0 0 0 20 0.001s 0.002s 11 0 0 3 759 0.001s 0.002s 12 0 0 0 61 0.001s 0.002s 13 0 181 1,609 327 0.593s 0.036s 14 0 0 1,076 194 0.296s 0.004s 15 0 0 1,445 391 0.097s 0.004s 16 0 31 1,077 143 0.067s 0.006s 17 0 0 1,614 175 0.135s 0.014s 18 0 0 591 311 0.001s 0.002s 19 0 0 0 44 0.001s 0.002s 20 0 0 0 27 0.001s 0.002s 21 0 33 3,240 232 0.765s 0.062s 22 0 0 320 85 0.001s 0.002s 23 0 0 1,314 169 0.005s 0.003s Day Hour Count Avg time (sec) Jan 28 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 28 00 1,593.00 kB 8,648.50 kB 01 1,146.50 kB 7,276.00 kB 02 173.00 kB 5,927.50 kB 03 364.50 kB 4,855.50 kB 04 4,275.00 kB 6,193.00 kB 05 1,213.00 kB 7,226.00 kB 06 7,018.50 kB 9,652.50 kB 07 29,400.00 kB 55,730.50 kB 08 312.50 kB 45,185.00 kB 09 321.00 kB 36,661.00 kB 10 94.50 kB 29,731.50 kB 11 24,127.00 kB 30,167.50 kB 12 389.00 kB 28,718.50 kB 13 7,201,477.75 kB 7,204,888.00 kB 14 8,815,377.00 kB 8,822,774.50 kB 15 6,047,249.75 kB 8,545,053.00 kB 16 5,876,767.67 kB 8,294,857.33 kB 17 8,814,964.00 kB 8,817,492.00 kB 18 5,104,714.00 kB 8,445,839.00 kB 19 498.50 kB 6,904,128.50 kB 20 243.50 kB 5,592,377.00 kB 21 8,849,542.83 kB 8,955,628.00 kB 22 2,884,115.00 kB 8,196,487.50 kB 23 8,183,890.00 kB 8,912,772.50 kB -
Temporary Files
Size of temporary files
Key values
- 21.00 GiB Temp Files size Peak
- 2026-01-28 20:46:23 Date
Number of temporary files
Key values
- 21 per second Temp Files Peak
- 2026-01-28 20:46:23 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jan 28 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 240 2.21 GiB 9.42 MiB 13 696 35.39 GiB 52.07 MiB 14 292 27.41 GiB 96.13 MiB 15 150 7.55 GiB 51.54 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 88 86.72 GiB 1009.06 MiB 20 96 94.48 GiB 1007.78 MiB 21 260 114.85 GiB 452.33 MiB 22 175 17.29 GiB 101.19 MiB 23 166 34.23 GiB 211.18 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 1,413 90.29 GiB 8.00 KiB 1.00 GiB 65.43 MiB select * from pgbulkload.pg_bulkload (?);-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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-28 20:59:21 Duration: 7m44s Database: ctdprd51 User: load Application: pg_bulkload
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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-28 21:31:46 Duration: 5m
-
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-28 13:24:01 Duration: 4m41s
2 89 88.29 GiB 298.09 MiB 1.00 GiB 1015.84 MiB select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.gene_go_annot gga, pub1.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 pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.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-28 20:46:22 Duration: 0ms
3 70 2.43 GiB 21.73 MiB 53.40 MiB 35.55 MiB vacuum full analyze ixn_actor;-
vacuum FULL analyze ixn_actor;
Date: 2026-01-28 15:24:23 Duration: 24s680ms
-
vacuum FULL analyze ixn_actor;
Date: 2026-01-28 15:27:27 Duration: 24s580ms
-
vacuum FULL analyze ixn_actor;
Date: 2026-01-28 15:24:05 Duration: 0ms
4 59 58.36 GiB 365.95 MiB 1.00 GiB 1012.85 MiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.object_type where cd = ?), ptr.term_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.phenotype_term_reference ptr, pub1.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 pub1.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.PHENOTYPE_TERM_REFERENCE ptr, pub1.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-28 19:53:15 Duration: 0ms
5 35 4.51 GiB 75.16 MiB 175.20 MiB 132.08 MiB vacuum full analyze db_link;-
vacuum FULL analyze db_link;
Date: 2026-01-28 15:26:51 Duration: 1m59s
-
vacuum FULL analyze db_link;
Date: 2026-01-28 15:25:13 Duration: 0ms
6 29 28.36 GiB 367.00 MiB 1.00 GiB 1001.34 MiB 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 pub1.gene_chem_reference gcr, pub1.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 pub1.gene_chem_reference_axn;-
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;
Date: 2026-01-28 19:04:19 Duration: 0ms
7 25 17.52 GiB 8.00 KiB 1.00 GiB 717.77 MiB alter table pub1.term_enrichment_agent add constraint term_enrichment_agent_pk primary key (term_id, enriched_term_id, agent_term_id);-
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-01-28 23:37:33 Duration: 3m1s
-
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-01-28 23:37:32 Duration: 0ms
8 25 400.66 MiB 11.42 MiB 25.96 MiB 16.03 MiB vacuum full analyze ixn;-
vacuum FULL analyze ixn;
Date: 2026-01-28 15:24:42 Duration: 7s982ms
-
vacuum FULL analyze ixn;
Date: 2026-01-28 15:24:37 Duration: 0ms
9 20 219.82 MiB 4.76 MiB 19.35 MiB 10.99 MiB vacuum full analyze term;-
vacuum FULL analyze TERM;
Date: 2026-01-28 15:24:18 Duration: 10s664ms
-
vacuum FULL analyze TERM;
Date: 2026-01-28 15:24:09 Duration: 0ms
10 20 13.70 GiB 8.00 KiB 1.00 GiB 701.50 MiB create unique index gene_disease_reference_ak1 on pub1.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 pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-01-28 21:05:55 Duration: 3m18s
-
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-01-28 21:05:55 Duration: 0ms
11 15 12.52 GiB 499.98 MiB 1.00 GiB 854.47 MiB create index ix_term_enrich_agent_enr_term on pub1.term_enrichment_agent using btree (enriched_term_id);-
CREATE INDEX ix_term_enrich_agent_enr_term ON pub1.term_enrichment_agent USING btree (enriched_term_id);
Date: 2026-01-28 23:39:22 Duration: 1m49s
-
CREATE INDEX ix_term_enrich_agent_enr_term ON pub1.term_enrichment_agent USING btree (enriched_term_id);
Date: 2026-01-28 23:39:22 Duration: 0ms
12 15 7.61 GiB 8.00 KiB 1.00 GiB 519.63 MiB alter table pub1.gene_disease_reference add constraint gene_disease_reference_pk primary key (id);-
ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-01-28 21:02:37 Duration: 1m50s
-
ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-01-28 21:02:36 Duration: 0ms Database: ctdprd51 User: pub1
13 10 67.36 MiB 8.00 KiB 14.70 MiB 6.74 MiB alter table pub1.phenotype_term add constraint phenotype_term_pk primary key (phenotype_id, term_id);-
ALTER TABLE pub1.phenotype_term ADD CONSTRAINT phenotype_term_pk PRIMARY KEY (phenotype_id, term_id);
Date: 2026-01-28 23:56:22 Duration: 0ms
14 10 1.15 GiB 8.00 KiB 243.83 MiB 118.22 MiB alter table pub1.phenotype_term_reference add constraint phenotype_term_reference_pk primary key (id);-
ALTER TABLE pub1.phenotype_term_reference ADD CONSTRAINT phenotype_term_reference_pk PRIMARY KEY (id);
Date: 2026-01-28 21:20:18 Duration: 11s535ms
-
ALTER TABLE pub1.phenotype_term_reference ADD CONSTRAINT phenotype_term_reference_pk PRIMARY KEY (id);
Date: 2026-01-28 21:20:18 Duration: 0ms
15 10 7.61 GiB 426.46 MiB 1.00 GiB 779.44 MiB create index ix_gene_disease_ref_dis_gene on pub1.gene_disease_reference using btree (disease_id, gene_id);-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-01-28 21:14:31 Duration: 1m59s
-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-01-28 21:14:30 Duration: 0ms
16 10 469.45 MiB 8.00 KiB 97.63 MiB 46.94 MiB create unique index chem_disease_reference_ak1 on pub1.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 pub1.chem_disease_reference USING btree (chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id);
Date: 2026-01-28 21:22:32 Duration: 6s146ms
-
CREATE UNIQUE INDEX chem_disease_reference_ak1 ON pub1.chem_disease_reference USING btree (chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id);
Date: 2026-01-28 21:22:32 Duration: 0ms
17 10 7.61 GiB 502.02 MiB 1.00 GiB 779.44 MiB create index ix_gene_disease_ref_src_db on pub1.gene_disease_reference using btree (source_acc_db_id);-
CREATE INDEX ix_gene_disease_ref_src_db ON pub1.gene_disease_reference USING btree (source_acc_db_id);
Date: 2026-01-28 21:06:48 Duration: 52s310ms
-
CREATE INDEX ix_gene_disease_ref_src_db ON pub1.gene_disease_reference USING btree (source_acc_db_id);
Date: 2026-01-28 21:06:47 Duration: 0ms
18 10 7.61 GiB 496.62 MiB 1.00 GiB 779.44 MiB create index ix_gene_disease_ref_mod_tm on pub1.gene_disease_reference using btree (mod_tm);-
CREATE INDEX ix_gene_disease_ref_mod_tm ON pub1.gene_disease_reference USING btree (mod_tm);
Date: 2026-01-28 21:17:32 Duration: 1m32s
-
CREATE INDEX ix_gene_disease_ref_mod_tm ON pub1.gene_disease_reference USING btree (mod_tm);
Date: 2026-01-28 21:17:32 Duration: 0ms
19 10 7.61 GiB 479.20 MiB 1.00 GiB 779.44 MiB create index ix_gene_disease_reference_ixn on pub1.gene_disease_reference using btree (ixn_id);-
CREATE INDEX ix_gene_disease_reference_ixn ON pub1.gene_disease_reference USING btree (ixn_id);
Date: 2026-01-28 21:16:00 Duration: 1m28s
-
CREATE INDEX ix_gene_disease_reference_ixn ON pub1.gene_disease_reference USING btree (ixn_id);
Date: 2026-01-28 21:15:59 Duration: 0ms
20 10 7.61 GiB 481.10 MiB 1.00 GiB 779.44 MiB create index ix_gene_disease_ref_disease on pub1.gene_disease_reference using btree (disease_id);-
CREATE INDEX ix_gene_disease_ref_disease ON pub1.gene_disease_reference USING btree (disease_id);
Date: 2026-01-28 21:11:04 Duration: 1m31s
-
CREATE INDEX ix_gene_disease_ref_disease ON pub1.gene_disease_reference USING btree (disease_id);
Date: 2026-01-28 21:11:04 Duration: 0ms
21 10 7.61 GiB 488.53 MiB 1.00 GiB 779.44 MiB create index ix_gene_disease_ref_source_cd on pub1.gene_disease_reference using btree (source_cd);-
CREATE INDEX ix_gene_disease_ref_source_cd ON pub1.gene_disease_reference USING btree (source_cd);
Date: 2026-01-28 21:07:56 Duration: 1m8s
-
CREATE INDEX ix_gene_disease_ref_source_cd ON pub1.gene_disease_reference USING btree (source_cd);
Date: 2026-01-28 21:07:56 Duration: 0ms
22 10 257.66 MiB 8.00 KiB 54.12 MiB 25.77 MiB alter table pub1.chem_disease_reference add constraint chem_disease_reference_pk primary key (id);-
ALTER TABLE pub1.chem_disease_reference ADD CONSTRAINT chem_disease_reference_pk PRIMARY KEY (id);
Date: 2026-01-28 21:22:26 Duration: 0ms
23 10 165.70 MiB 8.00 KiB 36.16 MiB 16.57 MiB alter table pub1.term_enrichment add constraint term_enrichment_pk primary key (term_id, enriched_term_id);-
ALTER TABLE pub1.term_enrichment ADD CONSTRAINT term_enrichment_pk PRIMARY KEY (term_id, enriched_term_id);
Date: 2026-01-28 23:20:04 Duration: 0ms Database: ctdprd51 User: pub1
24 10 667.42 MiB 8.00 KiB 136.05 MiB 66.74 MiB alter table pub1.gene_disease add constraint gene_disease_pk primary key (gene_id, disease_id);-
ALTER TABLE pub1.gene_disease ADD CONSTRAINT gene_disease_pk PRIMARY KEY (gene_id, disease_id);
Date: 2026-01-28 23:55:50 Duration: 8s421ms
-
ALTER TABLE pub1.gene_disease ADD CONSTRAINT gene_disease_pk PRIMARY KEY (gene_id, disease_id);
Date: 2026-01-28 23:55:50 Duration: 0ms Database: ctdprd51 User: pub1
25 10 7.61 GiB 483.38 MiB 1.00 GiB 779.44 MiB create index ix_gene_disease_ref_reference on pub1.gene_disease_reference using btree (reference_id);-
CREATE INDEX ix_gene_disease_ref_reference ON pub1.gene_disease_reference USING btree (reference_id);
Date: 2026-01-28 21:12:31 Duration: 1m26s
-
CREATE INDEX ix_gene_disease_ref_reference ON pub1.gene_disease_reference USING btree (reference_id);
Date: 2026-01-28 21:12:30 Duration: 0ms
26 10 7.61 GiB 448.59 MiB 1.00 GiB 779.44 MiB create index ix_gene_disease_ref_chem on pub1.gene_disease_reference using btree (via_chem_id);-
CREATE INDEX ix_gene_disease_ref_chem ON pub1.gene_disease_reference USING btree (via_chem_id);
Date: 2026-01-28 21:09:33 Duration: 1m36s
-
CREATE INDEX ix_gene_disease_ref_chem ON pub1.gene_disease_reference USING btree (via_chem_id);
Date: 2026-01-28 21:09:33 Duration: 0ms
27 10 7.61 GiB 483.83 MiB 1.00 GiB 779.44 MiB create index ix_gene_disease_ref_net_sc on pub1.gene_disease_reference using btree (network_score);-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);
Date: 2026-01-28 21:20:07 Duration: 2m34s
-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);
Date: 2026-01-28 21:20:06 Duration: 0ms
28 8 67.03 MiB 8.00 KiB 16.83 MiB 8.38 MiB alter table pub1.chem_disease add constraint chem_disease_pk primary key (chem_id, disease_id);-
ALTER TABLE pub1.chem_disease ADD CONSTRAINT chem_disease_pk PRIMARY KEY (chem_id, disease_id);
Date: 2026-01-28 23:56:25 Duration: 0ms
29 7 6.19 GiB 193.20 MiB 1.00 GiB 905.31 MiB select distinct ptr.phenotype_id, cdr.disease_id, ( select id from pub1.object_type where cd = ?), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub1.object_type where cd = ?), cdr.mod_tm from pub1.chem_disease_reference cdr, pub1.phenotype_term_reference ptr where cdr.chem_id = ptr.term_id;-
SELECT DISTINCT ptr.phenotype_id, cdr.disease_id, ( select id from pub1.OBJECT_TYPE where cd = 'disease'), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), cdr.mod_tm FROM pub1.CHEM_DISEASE_REFERENCE cdr, pub1.PHENOTYPE_TERM_REFERENCE ptr WHERE cdr.chem_id = ptr.term_id;
Date: 2026-01-28 20:50:38 Duration: 0ms
30 5 257.62 MiB 48.16 MiB 54.20 MiB 51.52 MiB create index ix_chem_disease_ref_src_db on pub1.chem_disease_reference using btree (source_acc_db_id);-
CREATE INDEX ix_chem_disease_ref_src_db ON pub1.chem_disease_reference USING btree (source_acc_db_id);
Date: 2026-01-28 21:22:43 Duration: 0ms
31 5 257.62 MiB 49.23 MiB 54.07 MiB 51.52 MiB create index ix_chem_disease_reference_dis on pub1.chem_disease_reference using btree (disease_id);-
CREATE INDEX ix_chem_disease_reference_dis ON pub1.chem_disease_reference USING btree (disease_id);
Date: 2026-01-28 21:22:36 Duration: 0ms
32 5 257.62 MiB 47.73 MiB 54.33 MiB 51.52 MiB create index ix_chem_disease_reference_ref on pub1.chem_disease_reference using btree (reference_id);-
CREATE INDEX ix_chem_disease_reference_ref ON pub1.chem_disease_reference USING btree (reference_id);
Date: 2026-01-28 21:22:39 Duration: 0ms
33 5 165.68 MiB 32.75 MiB 33.96 MiB 33.14 MiB create index ix_term_enrich_tgt_match on pub1.term_enrichment using btree (target_match_qty);-
CREATE INDEX ix_term_enrich_tgt_match ON pub1.term_enrichment USING btree (target_match_qty);
Date: 2026-01-28 23:20:07 Duration: 0ms
34 5 1.15 GiB 227.16 MiB 242.34 MiB 236.43 MiB create index ix_phenotype_term_reference_ixn_id on pub1.phenotype_term_reference using btree (ixn_id);-
CREATE INDEX ix_phenotype_term_reference_ixn_id ON pub1.phenotype_term_reference USING btree (ixn_id);
Date: 2026-01-28 21:21:56 Duration: 11s356ms
-
CREATE INDEX ix_phenotype_term_reference_ixn_id ON pub1.phenotype_term_reference USING btree (ixn_id);
Date: 2026-01-28 21:21:56 Duration: 0ms
35 5 231.26 MiB 44.10 MiB 47.80 MiB 46.25 MiB create index ix_term_enrich_raw_p_val on pub1.term_enrichment using btree (raw_p_val);-
CREATE INDEX ix_term_enrich_raw_p_val ON pub1.term_enrichment USING btree (raw_p_val);
Date: 2026-01-28 23:20:18 Duration: 0ms
36 5 40.00 KiB 8.00 KiB 8.00 KiB 8.00 KiB create index ix_gene_disease_exp_ref_qty on pub1.gene_disease using btree (exposure_reference_qty) where (exposure_reference_qty > ?);-
CREATE INDEX ix_gene_disease_exp_ref_qty ON pub1.gene_disease USING btree (exposure_reference_qty) WHERE (exposure_reference_qty > 0);
Date: 2026-01-28 23:56:21 Duration: 0ms
37 5 257.62 MiB 50.13 MiB 52.11 MiB 51.52 MiB create index ix_chem_disease_reference_ixn on pub1.chem_disease_reference using btree (ixn_id);-
CREATE INDEX ix_chem_disease_reference_ixn ON pub1.chem_disease_reference USING btree (ixn_id);
Date: 2026-01-28 21:22:49 Duration: 0ms
38 5 257.62 MiB 50.05 MiB 52.95 MiB 51.52 MiB create index ix_chem_disease_ref_net_sc on pub1.chem_disease_reference using btree (network_score);-
CREATE INDEX ix_chem_disease_ref_net_sc ON pub1.chem_disease_reference USING btree (network_score);
Date: 2026-01-28 21:22:56 Duration: 5s99ms
-
CREATE INDEX ix_chem_disease_ref_net_sc ON pub1.chem_disease_reference USING btree (network_score);
Date: 2026-01-28 21:22:56 Duration: 0ms
39 5 231.27 MiB 45.58 MiB 47.98 MiB 46.25 MiB create index ix_term_enrich_corr_p_val on pub1.term_enrichment using btree (corrected_p_val);-
CREATE INDEX ix_term_enrich_corr_p_val ON pub1.term_enrichment USING btree (corrected_p_val);
Date: 2026-01-28 23:20:13 Duration: 0ms
40 5 67.31 MiB 12.56 MiB 13.85 MiB 13.46 MiB create index ix_phenotype_term_term_id on pub1.phenotype_term using btree (term_id);-
CREATE INDEX ix_phenotype_term_term_id ON pub1.phenotype_term USING btree (term_id);
Date: 2026-01-28 23:56:23 Duration: 0ms
41 5 667.39 MiB 125.63 MiB 138.88 MiB 133.48 MiB create index ix_gene_disease_disease on pub1.gene_disease using btree (disease_id);-
CREATE INDEX ix_gene_disease_disease ON pub1.gene_disease USING btree (disease_id);
Date: 2026-01-28 23:55:57 Duration: 6s787ms
-
CREATE INDEX ix_gene_disease_disease ON pub1.gene_disease USING btree (disease_id);
Date: 2026-01-28 23:55:57 Duration: 0ms
42 5 165.66 MiB 31.72 MiB 34.13 MiB 33.13 MiB create index ix_term_enrich_obj_type on pub1.term_enrichment using btree (object_type_id);-
CREATE INDEX ix_term_enrich_obj_type ON pub1.term_enrichment USING btree (object_type_id);
Date: 2026-01-28 23:20:05 Duration: 0ms
43 5 1.15 GiB 226.33 MiB 246.45 MiB 236.43 MiB create index ix_phenotype_term_reference_term_reference_id on pub1.phenotype_term_reference using btree (term_reference_id);-
CREATE INDEX ix_phenotype_term_reference_term_reference_id ON pub1.phenotype_term_reference USING btree (term_reference_id);
Date: 2026-01-28 21:21:44 Duration: 13s215ms
-
CREATE INDEX ix_phenotype_term_reference_term_reference_id ON pub1.phenotype_term_reference USING btree (term_reference_id);
Date: 2026-01-28 21:21:44 Duration: 0ms
44 5 667.25 MiB 129.38 MiB 137.09 MiB 133.45 MiB create index ix_gene_disease_ind_chem_qty on pub1.gene_disease using btree (indirect_chem_qty) where (indirect_chem_qty > ?);-
CREATE INDEX ix_gene_disease_ind_chem_qty ON pub1.gene_disease USING btree (indirect_chem_qty) WHERE (indirect_chem_qty > 0);
Date: 2026-01-28 23:56:20 Duration: 7s314ms
-
CREATE INDEX ix_gene_disease_ind_chem_qty ON pub1.gene_disease USING btree (indirect_chem_qty) WHERE (indirect_chem_qty > 0);
Date: 2026-01-28 23:56:20 Duration: 0ms
45 5 67.31 MiB 9.38 MiB 14.95 MiB 13.46 MiB create index ix_phenotype_term_phenotype_id on pub1.phenotype_term using btree (phenotype_id);-
CREATE INDEX ix_phenotype_term_phenotype_id ON pub1.phenotype_term USING btree (phenotype_id);
Date: 2026-01-28 23:56:22 Duration: 0ms
46 5 680.00 KiB 128.00 KiB 144.00 KiB 136.00 KiB create index ix_gene_disease_cur_ref_qty on pub1.gene_disease using btree (curated_reference_qty) where (curated_reference_qty > ?);-
CREATE INDEX ix_gene_disease_cur_ref_qty ON pub1.gene_disease USING btree (curated_reference_qty) WHERE (curated_reference_qty > 0);
Date: 2026-01-28 23:56:13 Duration: 0ms
47 5 1.15 GiB 226.54 MiB 245.64 MiB 236.43 MiB create index ix_phenotype_term_ref_taxon_id on pub1.phenotype_term_reference using btree (taxon_id);-
CREATE INDEX ix_phenotype_term_ref_taxon_id ON pub1.phenotype_term_reference USING btree (taxon_id);
Date: 2026-01-28 21:21:11 Duration: 9s704ms
-
CREATE INDEX ix_phenotype_term_ref_taxon_id ON pub1.phenotype_term_reference USING btree (taxon_id);
Date: 2026-01-28 21:21:11 Duration: 0ms
48 5 1.15 GiB 231.29 MiB 240.42 MiB 236.43 MiB create index ix_phenotype_term_ref_term_id on pub1.phenotype_term_reference using btree (term_id);-
CREATE INDEX ix_phenotype_term_ref_term_id ON pub1.phenotype_term_reference USING btree (term_id);
Date: 2026-01-28 21:20:39 Duration: 10s748ms
-
CREATE INDEX ix_phenotype_term_ref_term_id ON pub1.phenotype_term_reference USING btree (term_id);
Date: 2026-01-28 21:20:39 Duration: 0ms
49 5 1.15 GiB 230.26 MiB 242.79 MiB 236.43 MiB create index ix_phenotype_term_ref_object_type_id on pub1.phenotype_term_reference using btree (term_object_type_id);-
CREATE INDEX ix_phenotype_term_ref_object_type_id ON pub1.phenotype_term_reference USING btree (term_object_type_id);
Date: 2026-01-28 21:20:49 Duration: 9s349ms
-
CREATE INDEX ix_phenotype_term_ref_object_type_id ON pub1.phenotype_term_reference USING btree (term_object_type_id);
Date: 2026-01-28 21:20:49 Duration: 0ms
50 5 1.62 GiB 318.12 MiB 348.18 MiB 331.79 MiB create index ix_phenotype_term_ref_ids on pub1.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 pub1.phenotype_term_reference USING btree (phenotype_id, term_id, via_term_object_type_id, term_object_type_id);
Date: 2026-01-28 21:22:23 Duration: 15s48ms
-
CREATE INDEX ix_phenotype_term_ref_ids ON pub1.phenotype_term_reference USING btree (phenotype_id, term_id, via_term_object_type_id, term_object_type_id);
Date: 2026-01-28 21:22:23 Duration: 0ms
51 5 1.15 GiB 229.68 MiB 242.51 MiB 236.43 MiB create index ix_phenotype_term_reference_source_acc_db_id on pub1.phenotype_term_reference using btree (source_acc_db_id);-
CREATE INDEX ix_phenotype_term_reference_source_acc_db_id ON pub1.phenotype_term_reference USING btree (source_acc_db_id);
Date: 2026-01-28 21:21:31 Duration: 10s17ms
-
CREATE INDEX ix_phenotype_term_reference_source_acc_db_id ON pub1.phenotype_term_reference USING btree (source_acc_db_id);
Date: 2026-01-28 21:21:31 Duration: 0ms
52 5 667.39 MiB 131.81 MiB 135.63 MiB 133.48 MiB create index ix_gene_disease_network_score on pub1.gene_disease using btree (network_score);-
CREATE INDEX ix_gene_disease_network_score ON pub1.gene_disease USING btree (network_score);
Date: 2026-01-28 23:56:12 Duration: 15s408ms
-
CREATE INDEX ix_gene_disease_network_score ON pub1.gene_disease USING btree (network_score);
Date: 2026-01-28 23:56:12 Duration: 0ms
53 5 1.15 GiB 228.73 MiB 244.37 MiB 236.43 MiB create index ix_phenotype_term_ref_via_term_id on pub1.phenotype_term_reference using btree (via_term_id);-
CREATE INDEX ix_phenotype_term_ref_via_term_id ON pub1.phenotype_term_reference USING btree (via_term_id);
Date: 2026-01-28 21:22:08 Duration: 12s3ms
-
CREATE INDEX ix_phenotype_term_ref_via_term_id ON pub1.phenotype_term_reference USING btree (via_term_id);
Date: 2026-01-28 21:22:08 Duration: 0ms
54 5 257.62 MiB 49.48 MiB 53.63 MiB 51.52 MiB create index ix_chem_disease_ref_mod_tm on pub1.chem_disease_reference using btree (mod_tm);-
CREATE INDEX ix_chem_disease_ref_mod_tm ON pub1.chem_disease_reference USING btree (mod_tm);
Date: 2026-01-28 21:22:51 Duration: 0ms
55 5 1.15 GiB 229.63 MiB 245.67 MiB 236.43 MiB create index ix_phenotype_term_ref_reference_id on pub1.phenotype_term_reference using btree (reference_id);-
CREATE INDEX ix_phenotype_term_ref_reference_id ON pub1.phenotype_term_reference USING btree (reference_id);
Date: 2026-01-28 21:21:02 Duration: 13s69ms
-
CREATE INDEX ix_phenotype_term_ref_reference_id ON pub1.phenotype_term_reference USING btree (reference_id);
Date: 2026-01-28 21:21:02 Duration: 0ms
56 5 1.15 GiB 231.02 MiB 239.60 MiB 236.43 MiB create index ix_phenotype_term_ref_evidence_cd on pub1.phenotype_term_reference using btree (evidence_cd);-
CREATE INDEX ix_phenotype_term_ref_evidence_cd ON pub1.phenotype_term_reference USING btree (evidence_cd);
Date: 2026-01-28 21:21:21 Duration: 9s582ms
-
CREATE INDEX ix_phenotype_term_ref_evidence_cd ON pub1.phenotype_term_reference USING btree (evidence_cd);
Date: 2026-01-28 21:21:21 Duration: 0ms
57 5 257.62 MiB 48.52 MiB 52.62 MiB 51.52 MiB create index ix_chem_disease_reference_gene on pub1.chem_disease_reference using btree (via_gene_id);-
CREATE INDEX ix_chem_disease_reference_gene ON pub1.chem_disease_reference USING btree (via_gene_id);
Date: 2026-01-28 21:22:46 Duration: 0ms
58 5 1.15 GiB 222.27 MiB 245.96 MiB 236.43 MiB create index ix_phenotype_term_ref_phenotype_id on pub1.phenotype_term_reference using btree (phenotype_id);-
CREATE INDEX ix_phenotype_term_ref_phenotype_id ON pub1.phenotype_term_reference USING btree (phenotype_id);
Date: 2026-01-28 21:20:29 Duration: 10s418ms
-
CREATE INDEX ix_phenotype_term_ref_phenotype_id ON pub1.phenotype_term_reference USING btree (phenotype_id);
Date: 2026-01-28 21:20:29 Duration: 0ms
59 5 257.62 MiB 50.44 MiB 52.41 MiB 51.52 MiB create index ix_chem_disease_ref_source_cd on pub1.chem_disease_reference using btree (source_cd);-
CREATE INDEX ix_chem_disease_ref_source_cd ON pub1.chem_disease_reference USING btree (source_cd);
Date: 2026-01-28 21:22:41 Duration: 0ms
60 5 165.67 MiB 30.44 MiB 35.23 MiB 33.13 MiB create index ix_term_enrich_enr_obj_type on pub1.term_enrichment using btree (enriched_object_type_id);-
CREATE INDEX ix_term_enrich_enr_obj_type ON pub1.term_enrichment USING btree (enriched_object_type_id);
Date: 2026-01-28 23:20:08 Duration: 0ms
61 4 66.11 MiB 15.91 MiB 16.84 MiB 16.53 MiB create index ix_chem_disease_ind_gene_qty on pub1.chem_disease using btree (indirect_gene_qty) where (indirect_gene_qty > ?);-
CREATE INDEX ix_chem_disease_ind_gene_qty ON pub1.chem_disease USING btree (indirect_gene_qty) WHERE (indirect_gene_qty > 0);
Date: 2026-01-28 23:56:29 Duration: 0ms
62 4 67.00 MiB 16.04 MiB 17.24 MiB 16.75 MiB create index ix_chem_disease_disease on pub1.chem_disease using btree (disease_id);-
CREATE INDEX ix_chem_disease_disease ON pub1.chem_disease USING btree (disease_id);
Date: 2026-01-28 23:56:28 Duration: 0ms
63 4 66.99 MiB 16.29 MiB 17.03 MiB 16.75 MiB create index ix_chem_disease_network_score on pub1.chem_disease using btree (network_score);-
CREATE INDEX ix_chem_disease_network_score ON pub1.chem_disease USING btree (network_score);
Date: 2026-01-28 23:56:27 Duration: 0ms
64 4 14.85 MiB 8.00 KiB 7.50 MiB 3.71 MiB alter table pub1.phenotype_term_axn add constraint phenotype_term_axn_pk primary key (phenotype_id, term_id, action_type_nm, action_degree_type_nm);-
ALTER TABLE pub1.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-28 23:56:24 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 pub1.chem_disease using btree (exposure_reference_qty) where (exposure_reference_qty > ?);-
CREATE INDEX ix_chem_disease_exp_ref_qty ON pub1.chem_disease USING btree (exposure_reference_qty) WHERE (exposure_reference_qty > 0);
Date: 2026-01-28 23:56:29 Duration: 0ms
66 4 2.02 MiB 408.00 KiB 616.00 KiB 516.00 KiB create index ix_chem_disease_cur_ref_qty on pub1.chem_disease using btree (curated_reference_qty) where (curated_reference_qty > ?);-
CREATE INDEX ix_chem_disease_cur_ref_qty ON pub1.chem_disease USING btree (curated_reference_qty) WHERE (curated_reference_qty > 0);
Date: 2026-01-28 23:56:28 Duration: 0ms
67 2 6.73 MiB 3.02 MiB 3.72 MiB 3.37 MiB create index ix_phenotype_term_axn_phenotype_id on pub1.phenotype_term_axn using btree (phenotype_id);-
CREATE INDEX ix_phenotype_term_axn_phenotype_id ON pub1.phenotype_term_axn USING btree (phenotype_id);
Date: 2026-01-28 23:56:24 Duration: 0ms
68 2 6.73 MiB 3.01 MiB 3.73 MiB 3.37 MiB create index ix_phenotype_term_axn_term_id on pub1.phenotype_term_axn using btree (term_id);-
CREATE INDEX ix_phenotype_term_axn_term_id ON pub1.phenotype_term_axn USING btree (term_id);
Date: 2026-01-28 23:56:24 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 1.00 GiB SELECT * FROM pgbulkload.pg_bulkload ($1);[ Date: 2026-01-28 14:30:59 - Database: ctdprd51 - User: load - Application: pg_bulkload ]
2 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:19 ]
3 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:19 ]
4 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:19 ]
5 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:19 ]
6 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:19 ]
7 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:19 ]
8 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:20 ]
9 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:20 ]
10 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:20 ]
11 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:20 ]
12 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:20 ]
13 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:20 ]
14 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:20 ]
15 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:20 ]
16 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:20 ]
17 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:20 ]
18 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:20 ]
19 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:20 ]
20 1.00 GiB 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn;[ Date: 2026-01-28 19:04:20 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 73.54 sec Highest CPU-cost vacuum
Table pub1.gene_go_annot
Database ctdprd51 - 2026-01-28 17:30:27 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 73.54 sec Highest CPU-cost vacuum
Table pub1.gene_go_annot
Database ctdprd51 - 2026-01-28 17:30:27 Date
Analyzes per table
Key values
- pubc.log_query (17) Main table analyzed (database ctdprd51)
- 92 analyzes Total
Table Number of analyzes ctdprd51.pubc.log_query 17 ctdprd51.pg_catalog.pg_class 3 ctdprd51.pg_catalog.pg_index 2 ctdprd51.pub1.term 2 ctdprd51.pub1.db 2 ctdprd51.pg_catalog.pg_attribute 2 ctdprd51.pub1.gene_go_annot 1 ctdprd51.pub1.exp_stressor_stressor_src 1 ctdprd51.pub1.geographic_region 1 ctdprd51.pub1.exp_event_location 1 ctdprd51.pub1.reference_party_role 1 ctdprd51.pub1.db_link 1 ctdprd51.pub1.gene_taxon 1 ctdprd51.pg_catalog.pg_trigger 1 ctdprd51.pub1.exp_event_assay_method 1 ctdprd51.edit.action_type 1 ctdprd51.pub1.dag_node 1 ctdprd51.pub1.reference_party 1 ctdprd51.edit.slim_term 1 ctdprd51.pub1.dag_edge 1 ctdprd51.pub1.db_report_site 1 ctdprd51.pub1.exp_receptor 1 ctdprd51.pg_catalog.pg_shdepend 1 ctdprd51.edit.db_link 1 ctdprd51.pub1.exp_event_project 1 postgres.pg_catalog.pg_shdepend 1 ctdprd51.pub1.exp_outcome 1 ctdprd51.edit.receptor 1 ctdprd51.edit.chem_conc_exp_route 1 ctdprd51.edit.country 1 ctdprd51.pub1.exp_study_factor 1 ctdprd51.pub1.medium 1 ctdprd51.pub1.exp_receptor_tobacco_use 1 ctdprd51.pub1.exp_receptor_gender 1 ctdprd51.pub1.list_db_report 1 ctdprd51.pub1.exp_receptor_race 1 ctdprd51.pg_catalog.pg_type 1 ctdprd51.edit.action_degree 1 ctdprd51.pub1.img 1 ctdprd51.pg_catalog.pg_attrdef 1 ctdprd51.pub2.term_comp_agent 1 ctdprd51.edit.reference_db_link 1 ctdprd51.pub1.reference 1 ctdprd51.pub1.exp_event 1 ctdprd51.pub2.term_comp 1 ctdprd51.pg_catalog.pg_depend 1 ctdprd51.pub1.term_label 1 ctdprd51.edit.action_degree_type 1 ctdprd51.pub1.reference_exp 1 ctdprd51.edit.object_note 1 ctdprd51.pg_catalog.pg_constraint 1 ctdprd51.edit.race 1 ctdprd51.edit.term_label_type 1 ctdprd51.pub1.action_type 1 ctdprd51.pub1.exp_stressor 1 ctdprd51.edit.list_db_report 1 ctdprd51.edit.geographic_region 1 ctdprd51.pub1.exp_anatomy 1 ctdprd51.pg_catalog.pg_description 1 ctdprd51.pg_catalog.pg_proc 1 ctdprd51.edit.db 1 ctdprd51.edit.db_report 1 ctdprd51.edit.db_report_site 1 ctdprd51.load.data_load 1 ctdprd51.pub1.term_pathway 1 ctdprd51.pub1.country 1 ctdprd51.edit.chem_conc_uom 1 ctdprd51.edit.action_type_path 1 ctdprd51.pub1.db_report 1 ctdprd51.pub1.exposure 1 Total 92 Vacuums per table
Key values
- pub1.term (2) Main table vacuumed on database ctdprd51
- 54 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes ctdprd51.pub1.term 2 0 162,441 0 5 0 0 46,744 3 2,778,354 ctdprd51.pg_catalog.pg_class 2 2 762 0 82 0 32 343 77 347,665 ctdprd51.pub1.reference 1 0 78,593 0 5 0 0 39,205 3 2,333,127 ctdprd51.edit.reference_db_link 1 0 7,442 0 4 0 0 3,708 1 227,098 ctdprd51.pg_catalog.pg_attrdef 1 1 103 0 3 0 0 24 1 10,363 ctdprd51.pub1.reference_party 1 0 5,152 0 4 0 0 2,542 2 162,017 ctdprd51.pub1.db 1 1 148 0 13 0 0 20 10 36,275 ctdprd51.pub1.dag_node 1 0 84,198 0 4 0 0 41,972 2 2,492,964 ctdprd51.pub1.exp_event_assay_method 1 0 5,355 0 4 0 0 2,649 2 170,634 ctdprd51.pub1.img 1 0 1,108 0 5 0 0 524 2 44,715 ctdprd51.pub2.term_comp 1 0 140 0 26 0 0 23 2 16,060 ctdprd51.pg_catalog.pg_index 1 1 200 0 19 0 0 106 19 91,103 ctdprd51.pub1.dag_edge 1 0 1,054 0 5 0 0 482 2 40,025 ctdprd51.pub1.exp_event 1 0 13,549 0 3 0 0 6,696 1 403,483 ctdprd51.pub1.exp_receptor_race 1 0 1,398 0 667 0 0 664 1 47,595 ctdprd51.pub1.reference_party_role 1 0 13,696 0 4 0 0 6,821 1 410,858 ctdprd51.pub1.exp_event_location 1 0 3,746 0 4 0 0 1,822 2 120,973 ctdprd51.pubc.log_query 1 1 246 0 20 0 0 81 14 100,490 ctdprd51.pub1.exp_receptor_gender 1 0 2,885 0 1,430 0 0 1,427 1 92,612 ctdprd51.pub1.gene_go_annot 1 0 638,177 0 312,471 0 0 318,970 11 18,906,802 ctdprd51.pub1.exp_stressor_stressor_src 1 0 2,919 0 1,434 0 0 1,431 1 92,848 ctdprd51.edit.actor_form_type 1 0 82 0 1 0 0 3 1 8,747 ctdprd51.pub1.gene_taxon 1 0 167,905 0 5 0 0 83,893 3 4,974,500 ctdprd51.pg_catalog.pg_trigger 1 1 347 0 34 0 0 153 37 194,403 ctdprd51.pg_toast.pg_toast_486223 1 0 52 0 4 0 0 2 1 8,444 ctdprd51.pub1.db_link 1 0 299,985 0 131,257 0 0 149,869 6 8,890,602 ctdprd51.pg_catalog.pg_type 1 1 159 0 38 0 0 67 38 166,296 ctdprd51.edit.action_degree 1 0 45 0 0 0 0 12 1 9,451 ctdprd51.pub1.exp_study_factor 1 0 113 0 3 0 0 11 1 9,068 ctdprd51.pub1.term_pathway 1 0 3,365 0 4 0 0 1,614 2 110,533 ctdprd51.edit.country 1 0 63 0 0 0 0 8 1 9,627 ctdprd51.edit.db 1 0 93 0 3 0 0 17 2 12,470 ctdprd51.pg_catalog.pg_attribute 1 1 804 0 77 0 37 403 76 407,897 ctdprd51.edit.receptor 1 0 42 0 4 0 0 2 1 8,598 ctdprd51.pub1.exp_anatomy 1 0 163 0 40 0 0 36 2 16,247 ctdprd51.pub1.exposure 1 0 4,017 0 3 0 0 1,955 1 123,764 ctdprd51.edit.action_type_path 1 0 48 0 0 0 0 4 1 9,059 ctdprd51.pub1.exp_receptor_tobacco_use 1 0 1,268 0 602 0 0 599 1 43,760 ctdprd51.pg_catalog.pg_statistic 1 1 808 0 101 0 128 649 97 322,919 ctdprd51.edit.db_link 1 0 7,653 0 3 0 0 3,708 1 227,167 ctdprd51.pub1.reference_exp 1 0 338 0 3 0 0 132 1 16,207 ctdprd51.pub1.exp_event_project 1 0 2,310 0 1,137 0 0 1,133 2 80,322 ctdprd51.pg_catalog.pg_shdepend 1 1 238 0 3 0 0 88 2 19,414 ctdprd51.pg_toast.pg_toast_2619 1 1 3,977 0 1,317 0 10,289 3,476 1,098 447,320 ctdprd51.pub1.term_label 1 0 196,735 0 7 0 0 98,315 5 5,836,183 ctdprd51.pg_catalog.pg_depend 1 1 718 0 92 0 65 312 92 354,231 ctdprd51.pub1.exp_receptor 1 0 7,833 0 3,892 0 0 3,888 2 241,411 ctdprd51.pub1.exp_stressor 1 0 6,751 0 3,349 0 0 3,346 1 205,833 postgres.pg_catalog.pg_shdepend 1 1 198 0 50 0 0 93 42 147,548 ctdprd51.pub1.exp_outcome 1 0 881 0 387 0 0 383 2 34,184 ctdprd51.pg_catalog.pg_constraint 1 1 292 0 22 0 0 120 19 84,986 ctdprd51.pg_toast.pg_toast_10357625 1 0 90,096 0 5 0 0 45,040 3 2,680,952 Total 54 15 1,820,691 1,117 458,655 0 10,551 875,585 1,700 54,628,204 Tuples removed per table
Key values
- pg_toast.pg_toast_2619 (4310) Main table with removed tuples on database ctdprd51
- 10749 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain ctdprd51.pg_toast.pg_toast_2619 1 1 4,310 20,363 0 0 12,592 ctdprd51.pg_catalog.pg_depend 1 1 1,423 14,143 0 0 139 ctdprd51.pg_catalog.pg_attribute 1 1 1,163 8,833 0 0 230 ctdprd51.pg_catalog.pg_statistic 1 1 956 2,875 0 0 410 ctdprd51.pg_catalog.pg_trigger 1 1 585 1,821 0 0 53 ctdprd51.pg_catalog.pg_shdepend 1 1 463 2,098 0 4 20 ctdprd51.pg_catalog.pg_class 2 2 287 4,370 0 0 188 postgres.pg_catalog.pg_shdepend 1 1 272 1,965 0 0 24 ctdprd51.pg_catalog.pg_index 1 1 259 1,173 0 0 38 ctdprd51.pg_catalog.pg_constraint 1 1 168 889 0 0 37 ctdprd51.edit.country 1 0 163 249 0 0 4 ctdprd51.pub1.db 1 1 134 134 0 0 7 ctdprd51.edit.receptor 1 0 112 16 0 0 1 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.db 1 0 84 134 0 0 8 ctdprd51.pg_catalog.pg_attrdef 1 1 54 238 0 0 11 ctdprd51.edit.actor_form_type 1 0 54 18 0 0 1 ctdprd51.pg_catalog.pg_type 1 1 50 1,165 0 0 34 ctdprd51.pubc.log_query 1 1 10 778 0 0 33 ctdprd51.pub1.reference 1 0 0 201,793 0 0 39,204 ctdprd51.edit.reference_db_link 1 0 0 332,648 0 0 3,707 ctdprd51.pub1.reference_party 1 0 0 454,938 0 0 2,541 ctdprd51.pub1.dag_node 1 0 0 1,747,171 0 0 41,971 ctdprd51.pub1.exp_event_assay_method 1 0 0 263,279 0 0 2,648 ctdprd51.pub1.img 1 0 0 50,654 0 0 523 ctdprd51.pub2.term_comp 1 0 0 2,152 0 0 22 ctdprd51.pub1.dag_edge 1 0 0 88,931 0 0 481 ctdprd51.pub1.exp_event 1 0 0 227,056 0 0 6,695 ctdprd51.pub1.exp_receptor_race 1 0 0 102,328 0 0 663 ctdprd51.pub1.reference_party_role 1 0 0 1,261,540 0 0 6,820 ctdprd51.pub1.exp_event_location 1 0 0 273,106 0 0 1,821 ctdprd51.pub1.exp_receptor_gender 1 0 0 205,132 0 0 1,426 ctdprd51.pub1.term 2 0 0 2,178,165 0 0 85,461 ctdprd51.pub1.gene_go_annot 1 0 0 50,079,263 0 0 318,969 ctdprd51.pub1.exp_stressor_stressor_src 1 0 0 323,089 0 0 1,430 ctdprd51.pub1.gene_taxon 1 0 0 13,170,965 0 0 83,892 ctdprd51.pg_toast.pg_toast_486223 1 0 0 2 0 0 1 ctdprd51.pub1.db_link 1 0 0 20,688,696 0 0 149,868 ctdprd51.pub1.exp_study_factor 1 0 0 1,705 0 0 10 ctdprd51.pub1.term_pathway 1 0 0 135,792 0 0 1,613 ctdprd51.pub1.exp_anatomy 1 0 0 4,106 0 0 35 ctdprd51.pub1.exposure 1 0 0 236,947 0 0 1,954 ctdprd51.pub1.exp_receptor_tobacco_use 1 0 0 84,619 0 0 598 ctdprd51.edit.db_link 1 0 0 332,648 0 0 3,707 ctdprd51.pub1.reference_exp 1 0 0 3,613 0 0 131 ctdprd51.pub1.exp_event_project 1 0 0 108,198 0 0 1,132 ctdprd51.pub1.term_label 1 0 0 6,737,776 0 0 98,314 ctdprd51.pub1.exp_receptor 1 0 0 208,909 0 0 3,887 ctdprd51.pub1.exp_stressor 1 0 0 229,899 0 0 3,345 ctdprd51.pub1.exp_outcome 1 0 0 39,599 0 0 382 ctdprd51.pg_toast.pg_toast_10357625 1 0 0 243,469 0 0 45,039 Total 54 15 10,749 100,079,775 0 4 922,128 Pages removed per table
Key values
- pg_catalog.pg_shdepend (4) Main table with removed pages on database ctdprd51
- 4 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed ctdprd51.pg_catalog.pg_shdepend 1 1 463 4 ctdprd51.pub1.reference 1 0 0 0 ctdprd51.edit.reference_db_link 1 0 0 0 ctdprd51.pg_catalog.pg_attrdef 1 1 54 0 ctdprd51.pub1.reference_party 1 0 0 0 ctdprd51.pub1.db 1 1 134 0 ctdprd51.pub1.dag_node 1 0 0 0 ctdprd51.pub1.exp_event_assay_method 1 0 0 0 ctdprd51.pub1.img 1 0 0 0 ctdprd51.pub2.term_comp 1 0 0 0 ctdprd51.pg_catalog.pg_index 1 1 259 0 ctdprd51.pub1.dag_edge 1 0 0 0 ctdprd51.pub1.exp_event 1 0 0 0 ctdprd51.pub1.exp_receptor_race 1 0 0 0 ctdprd51.pub1.reference_party_role 1 0 0 0 ctdprd51.pub1.exp_event_location 1 0 0 0 ctdprd51.pubc.log_query 1 1 10 0 ctdprd51.pub1.exp_receptor_gender 1 0 0 0 ctdprd51.pub1.term 2 0 0 0 ctdprd51.pub1.gene_go_annot 1 0 0 0 ctdprd51.pub1.exp_stressor_stressor_src 1 0 0 0 ctdprd51.edit.actor_form_type 1 0 54 0 ctdprd51.pub1.gene_taxon 1 0 0 0 ctdprd51.pg_catalog.pg_trigger 1 1 585 0 ctdprd51.pg_toast.pg_toast_486223 1 0 0 0 ctdprd51.pub1.db_link 1 0 0 0 ctdprd51.pg_catalog.pg_type 1 1 50 0 ctdprd51.edit.action_degree 1 0 96 0 ctdprd51.pub1.exp_study_factor 1 0 0 0 ctdprd51.pub1.term_pathway 1 0 0 0 ctdprd51.edit.country 1 0 163 0 ctdprd51.edit.db 1 0 84 0 ctdprd51.pg_catalog.pg_attribute 1 1 1163 0 ctdprd51.edit.receptor 1 0 112 0 ctdprd51.pub1.exp_anatomy 1 0 0 0 ctdprd51.pub1.exposure 1 0 0 0 ctdprd51.edit.action_type_path 1 0 106 0 ctdprd51.pub1.exp_receptor_tobacco_use 1 0 0 0 ctdprd51.pg_catalog.pg_statistic 1 1 956 0 ctdprd51.edit.db_link 1 0 0 0 ctdprd51.pub1.reference_exp 1 0 0 0 ctdprd51.pub1.exp_event_project 1 0 0 0 ctdprd51.pg_toast.pg_toast_2619 1 1 4310 0 ctdprd51.pub1.term_label 1 0 0 0 ctdprd51.pg_catalog.pg_class 2 2 287 0 ctdprd51.pg_catalog.pg_depend 1 1 1423 0 ctdprd51.pub1.exp_receptor 1 0 0 0 ctdprd51.pub1.exp_stressor 1 0 0 0 postgres.pg_catalog.pg_shdepend 1 1 272 0 ctdprd51.pub1.exp_outcome 1 0 0 0 ctdprd51.pg_catalog.pg_constraint 1 1 168 0 ctdprd51.pg_toast.pg_toast_10357625 1 0 0 0 Total 54 15 10,749 4 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jan 28 00 1 1 01 0 1 02 0 1 03 0 2 04 1 3 05 1 5 06 0 1 07 0 0 08 0 1 09 0 1 10 9 11 11 1 0 12 8 19 13 0 1 14 0 1 15 2 3 16 4 9 17 11 10 18 1 0 19 0 0 20 0 1 21 0 2 22 0 1 23 15 18 - 73.54 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- RowExclusiveLock Main Lock Type
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 5 1m1s 4s888ms 18s535ms 12s383ms select * from edit.del_ixn_by_root_id (?) as result;-
select * from edit.del_ixn_by_root_id ('9317859') as result;
Date: 2026-01-28 15:24:21 Bind query: yes
-
select * from edit.del_ixn_by_root_id ('9317907') as result;
Date: 2026-01-28 15:27:25 Bind query: yes
-
select * from edit.del_ixn_by_root_id ($1) as result;
Date: 2026-01-28 15:24:21
Queries that waited the most
Rank Wait time Query 1 18s535ms select * from edit.del_ixn_by_root_id ($1) as result;[ Date: 2026-01-28 15:24:21 ]
2 17s161ms select * from edit.del_ixn_by_root_id ($1) as result;[ Date: 2026-01-28 15:24:21 ]
3 11s847ms select * from edit.del_ixn_by_root_id ($1) as result;[ Date: 2026-01-28 15:24:21 ]
4 9s485ms select * from edit.del_ixn_by_root_id ($1) as result;[ Date: 2026-01-28 15:27:25 ]
5 4s888ms select * from edit.del_ixn_by_root_id ($1) as result;[ Date: 2026-01-28 15:24:21 ]
-
Queries
Queries by type
Key values
- 102 Total read queries
- 85 Total write queries
Queries by database
Key values
- unknown Main database
- 145 Requests
- 4h1m49s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 181 Requests
User Request type Count Duration edit Total 1 8s693ms insert 1 8s693ms load Total 24 1h1m46s select 24 1h1m46s postgres Total 16 17m8s copy to 16 17m8s pub1 Total 3 15m14s insert 2 15m9s select 1 5s526ms pubc Total 1 9m12s select 1 9m12s pubeu Total 40 7m38s select 40 7m38s qaeu Total 2 10s296ms select 2 10s296ms unknown Total 181 4h9m48s copy to 56 11m43s ddl 32 41m30s insert 12 41m2s others 9 4m38s select 70 2h28m59s update 2 1m54s Duration by user
Key values
- 4h9m48s (unknown) Main time consuming user
User Request type Count Duration edit Total 1 8s693ms insert 1 8s693ms load Total 24 1h1m46s select 24 1h1m46s postgres Total 16 17m8s copy to 16 17m8s pub1 Total 3 15m14s insert 2 15m9s select 1 5s526ms pubc Total 1 9m12s select 1 9m12s pubeu Total 40 7m38s select 40 7m38s qaeu Total 2 10s296ms select 2 10s296ms unknown Total 181 4h9m48s copy to 56 11m43s ddl 32 41m30s insert 12 41m2s others 9 4m38s select 70 2h28m59s update 2 1m54s Queries by host
Key values
- unknown Main host
- 268 Requests
- 6h1m8s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 170 Requests
- 5h4m50s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-01-28 21:06:47 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 132 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 53m1s select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.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 pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');[ Date: 2026-01-28 20:46:19 - Bind query: yes ]
2 44m46s select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.PHENOTYPE_TERM_REFERENCE ptr, pub1.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 pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');[ Date: 2026-01-28 19:53:13 - Bind query: yes ]
3 34m29s 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-28 18:11:53 - Database: ctdprd51 - User: load - Bind query: yes ]
4 27m5s insert into pub1.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-28 17:28:52 - Bind query: yes ]
5 15m insert into pub1.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-28 16:56:14 - Database: ctdprd51 - User: pub1 - Bind query: yes ]
6 14m14s ALTER TABLE pub1.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-28 23:34:32 - Bind query: yes ]
7 10m18s 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');[ Date: 2026-01-28 18:25:03 - Database: ctdprd51 - User: load - Bind query: yes ]
8 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-28 00:09:31 - Database: ctdprd51 - User: pubc - Application: psql ]
9 7m44s SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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-28 20:59:21 - Database: ctdprd51 - User: load - Application: pg_bulkload - Bind query: yes ]
10 5m SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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-28 21:31:46 - Bind query: yes ]
11 4m41s 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-28 13:24:01 - Bind query: yes ]
12 4m33s insert into pub1.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-28 17:33:25 - Bind query: yes ]
13 3m22s INSERT INTO pub1.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 pub1.TERM);[ Date: 2026-01-28 17:01:46 - Bind query: yes ]
14 3m18s CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);[ Date: 2026-01-28 21:05:55 - Bind query: yes ]
15 3m16s SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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-28 23:17:30 - Database: ctdprd51 - User: load - Application: pg_bulkload - Bind query: yes ]
16 3m1s ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);[ Date: 2026-01-28 23:37:33 - Bind query: yes ]
17 2m38s 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-28 14:42:23 - Bind query: yes ]
18 2m34s CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);[ Date: 2026-01-28 21:20:07 - Bind query: yes ]
19 2m10s SELECT DISTINCT ptr.phenotype_id, cdr.disease_id, ( select id from pub1.OBJECT_TYPE where cd = 'disease'), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), cdr.mod_tm FROM pub1.CHEM_DISEASE_REFERENCE cdr, pub1.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 pub1.IXN_AXN WHERE action_degree_type_nm = 'does not affect');[ Date: 2026-01-28 20:48:37 - Bind query: yes ]
20 1m59s CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);[ Date: 2026-01-28 21:14:31 - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 55m1s 61 5s6ms 7m44s 54s115ms select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 28 12 9 1m14s 8s281ms 13 21 16m58s 48s495ms 14 9 11m54s 1m19s 18 3 1m7s 22s608ms 20 2 7m59s 3m59s 21 5 8m 1m36s 22 8 3m45s 28s198ms 23 4 4m 1m [ User: load - Total duration: 15m36s - Times executed: 16 ]
[ Application: pg_bulkload - Total duration: 15m36s - Times executed: 16 ]
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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-28 20:59:21 Duration: 7m44s Database: ctdprd51 User: load Application: pg_bulkload Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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-28 21:31:46 Duration: 5m 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-28 13:24:01 Duration: 4m41s Bind query: yes
2 53m1s 1 53m1s 53m1s 53m1s select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.gene_go_annot gga, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 28 20 1 53m1s 53m1s -
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.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 pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 20:46:19 Duration: 53m1s Bind query: yes
3 44m46s 1 44m46s 44m46s 44m46s select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.object_type where cd = ?), ptr.term_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.phenotype_term_reference ptr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 28 19 1 44m46s 44m46s -
select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.PHENOTYPE_TERM_REFERENCE ptr, pub1.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 pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 19:53:13 Duration: 44m46s Bind query: yes
4 34m29s 1 34m29s 34m29s 34m29s 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 28 18 1 34m29s 34m29s [ User: load - Total duration: 34m29s - 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-28 18:11:53 Duration: 34m29s Database: ctdprd51 User: load Bind query: yes
5 27m5s 1 27m5s 27m5s 27m5s insert into pub1.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 28 17 1 27m5s 27m5s -
insert into pub1.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-28 17:28:52 Duration: 27m5s Bind query: yes
6 15m 1 15m 15m 15m insert into pub1.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 28 16 1 15m 15m [ User: pub1 - Total duration: 15m - Times executed: 1 ]
-
insert into pub1.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-28 16:56:14 Duration: 15m Database: ctdprd51 User: pub1 Bind query: yes
7 14m14s 1 14m14s 14m14s 14m14s alter table pub1.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 28 23 1 14m14s 14m14s -
ALTER TABLE pub1.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-28 23:34:32 Duration: 14m14s Bind query: yes
8 13m7s 5 41s545ms 10m18s 2m37s 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 pub1.gene_chem_reference gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 28 18 5 13m7s 2m37s [ User: load - Total duration: 10m18s - 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 18:25:03 Duration: 10m18s 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 18:49:31 Duration: 42s945ms 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 18:43:43 Duration: 42s190ms Bind query: yes
9 9m12s 1 9m12s 9m12s 9m12s select maint_query_logs_archive ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 28 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-28 00:09:31 Duration: 9m12s Database: ctdprd51 User: pubc Application: psql
10 7m24s 4 1m50s 1m51s 1m51s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 28 06 1 1m50s 1m50s 10 1 1m51s 1m51s 14 1 1m51s 1m51s 18 1 1m51s 1m51s [ User: postgres - Total duration: 7m24s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m24s - Times executed: 4 ]
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-01-28 18:06:52 Duration: 1m51s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-01-28 10: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-28 14:06:52 Duration: 1m51s Database: ctdprd51 User: postgres Application: pg_dump
11 4m33s 1 4m33s 4m33s 4m33s insert into pub1.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 28 17 1 4m33s 4m33s -
insert into pub1.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-28 17:33:25 Duration: 4m33s Bind query: yes
12 3m22s 1 3m22s 3m22s 3m22s insert into pub1.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 pub1.term);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 28 17 1 3m22s 3m22s -
INSERT INTO pub1.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 pub1.TERM);
Date: 2026-01-28 17:01:46 Duration: 3m22s Bind query: yes
13 3m18s 1 3m18s 3m18s 3m18s create unique index gene_disease_reference_ak1 on pub1.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 #13
Day Hour Count Duration Avg duration Jan 28 21 1 3m18s 3m18s -
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-01-28 21:05:55 Duration: 3m18s Bind query: yes
-
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-01-28 21:05:55 Duration: 0ms
14 3m1s 1 3m1s 3m1s 3m1s alter table pub1.term_enrichment_agent add constraint term_enrichment_agent_pk primary key (term_id, enriched_term_id, agent_term_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 28 23 1 3m1s 3m1s -
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-01-28 23:37:33 Duration: 3m1s Bind query: yes
-
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-01-28 23:37:32 Duration: 0ms
15 2m34s 1 2m34s 2m34s 2m34s create index ix_gene_disease_ref_net_sc on pub1.gene_disease_reference using btree (network_score);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 28 21 1 2m34s 2m34s -
CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);
Date: 2026-01-28 21:20:07 Duration: 2m34s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);
Date: 2026-01-28 21:20:06 Duration: 0ms
16 2m10s 1 2m10s 2m10s 2m10s select distinct ptr.phenotype_id, cdr.disease_id, ( select id from pub1.object_type where cd = ?), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub1.object_type where cd = ?), cdr.mod_tm from pub1.chem_disease_reference cdr, pub1.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 pub1.ixn_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 28 20 1 2m10s 2m10s -
SELECT DISTINCT ptr.phenotype_id, cdr.disease_id, ( select id from pub1.OBJECT_TYPE where cd = 'disease'), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), cdr.mod_tm FROM pub1.CHEM_DISEASE_REFERENCE cdr, pub1.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 pub1.IXN_AXN WHERE action_degree_type_nm = 'does not affect');
Date: 2026-01-28 20:48:37 Duration: 2m10s Bind query: yes
17 1m59s 1 1m59s 1m59s 1m59s create index ix_gene_disease_ref_dis_gene on pub1.gene_disease_reference using btree (disease_id, gene_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 28 21 1 1m59s 1m59s -
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-01-28 21:14:31 Duration: 1m59s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-01-28 21:14:30 Duration: 0ms
18 1m59s 1 1m59s 1m59s 1m59s vacuum full analyze db_link;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 28 15 1 1m59s 1m59s -
vacuum FULL analyze db_link;
Date: 2026-01-28 15:26:51 Duration: 1m59s
-
vacuum FULL analyze db_link;
Date: 2026-01-28 15:25:13 Duration: 0ms
19 1m57s 1 1m57s 1m57s 1m57s insert into pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, secondary_nm, description, note, is_leaf, nm_html, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_marrays, nm_fts) select t.id, t.object_type_id, t.acc_txt, get_db_cd (t.acc_db_id) as db_cd, t.nm, common.search_str (t.nm_sort), t.secondary_nm, t.description, t.note, is_leaf, break_html_words (t.nm), ?, ?, ?, ?, ?, ?, ? from load.term t where object_type_id not in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 28 16 1 1m57s 1m57s -
INSERT INTO pub1.TERM (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, secondary_nm, description, note, is_leaf, nm_html, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_marrays, nm_fts) SELECT t.id, t.object_type_id, t.acc_txt, get_db_cd (t.acc_db_id) AS db_cd, t.nm, common.search_str (t.nm_sort), t.secondary_nm, t.description, t.note, is_leaf, break_html_words (t.nm), 0, 0, 'f', 'f', 'f', 'f', 'dummy' FROM load.TERM t where object_type_id NOT in (2, 3, 6);
Date: 2026-01-28 16:58:23 Duration: 1m57s Bind query: yes
20 1m50s 1 1m50s 1m50s 1m50s alter table pub1.gene_disease_reference add constraint gene_disease_reference_pk primary key (id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 28 21 1 1m50s 1m50s -
ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-01-28 21:02:37 Duration: 1m50s Bind query: yes
-
ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-01-28 21:02:36 Duration: 0ms Database: ctdprd51 User: pub1
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 61 55m1s 5s6ms 7m44s 54s115ms select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 28 12 9 1m14s 8s281ms 13 21 16m58s 48s495ms 14 9 11m54s 1m19s 18 3 1m7s 22s608ms 20 2 7m59s 3m59s 21 5 8m 1m36s 22 8 3m45s 28s198ms 23 4 4m 1m [ User: load - Total duration: 15m36s - Times executed: 16 ]
[ Application: pg_bulkload - Total duration: 15m36s - Times executed: 16 ]
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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-28 20:59:21 Duration: 7m44s Database: ctdprd51 User: load Application: pg_bulkload Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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-28 21:31:46 Duration: 5m 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-28 13:24:01 Duration: 4m41s Bind query: yes
2 7 40s988ms 5s63ms 6s611ms 5s855ms select d.abbr dagabbr, d.nm dagnm, gt.level_min_no daglevelmin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pvalcorrected, te.raw_p_val pvalraw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, count(*) over () fullrowcount from term_enrichment te inner join dag_node gt on te.enriched_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where te.term_id = ? and te.enriched_object_type_id = ? order by te.corrected_p_val, d.abbr, gt.nm_sort limit ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 28 13 3 16s449ms 5s483ms 17 2 11s569ms 5s784ms 21 2 12s969ms 6s484ms [ User: pubeu - Total duration: 40s988ms - Times executed: 7 ]
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1397318' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-01-28 21:51:29 Duration: 6s611ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1314493' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-01-28 21:10:17 Duration: 6s357ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1296979' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-01-28 13:55:08 Duration: 5s935ms Database: ctdprd51 User: pubeu Bind query: yes
3 5 13m7s 41s545ms 10m18s 2m37s 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 pub1.gene_chem_reference gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 28 18 5 13m7s 2m37s [ User: load - Total duration: 10m18s - 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 18:25:03 Duration: 10m18s 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 18:49:31 Duration: 42s945ms 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 18:43:43 Duration: 42s190ms Bind query: yes
4 4 7m24s 1m50s 1m51s 1m51s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 28 06 1 1m50s 1m50s 10 1 1m51s 1m51s 14 1 1m51s 1m51s 18 1 1m51s 1m51s [ User: postgres - Total duration: 7m24s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m24s - Times executed: 4 ]
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-01-28 18:06:52 Duration: 1m51s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-01-28 10: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-28 14:06:52 Duration: 1m51s Database: ctdprd51 User: postgres Application: pg_dump
5 4 1m35s 23s660ms 24s189ms 23s943ms 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 28 06 1 23s888ms 23s888ms 10 1 24s34ms 24s34ms 14 1 23s660ms 23s660ms 18 1 24s189ms 24s189ms -
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-28 18:07:17 Duration: 24s189ms
-
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-28 10:07:17 Duration: 24s34ms
-
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-28 06:07:16 Duration: 23s888ms
6 4 1m7s 13s974ms 17s989ms 16s926ms 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 28 06 1 17s781ms 17s781ms 10 1 17s959ms 17s959ms 14 1 13s974ms 13s974ms 18 1 17s989ms 17s989ms [ User: postgres - Total duration: 1m7s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m7s - Times executed: 4 ]
-
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-28 18:00:19 Duration: 17s989ms 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-28 10:00:19 Duration: 17s959ms 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-28 06:00:20 Duration: 17s781ms Database: ctdprd51 User: postgres Application: pg_dump
7 4 1m1s 15s389ms 15s530ms 15s492ms 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 28 06 1 15s530ms 15s530ms 10 1 15s522ms 15s522ms 14 1 15s389ms 15s389ms 18 1 15s527ms 15s527ms -
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-01-28 06:07:32 Duration: 15s530ms
-
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-28 18:07:32 Duration: 15s527ms
-
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-01-28 10:07:33 Duration: 15s522ms
8 4 57s943ms 14s449ms 14s520ms 14s485ms 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 28 06 1 14s449ms 14s449ms 10 1 14s460ms 14s460ms 14 1 14s520ms 14s520ms 18 1 14s512ms 14s512ms -
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-28 14:00:46 Duration: 14s520ms
-
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-28 18:00:50 Duration: 14s512ms
-
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-28 10:00:49 Duration: 14s460ms
9 4 57s580ms 14s328ms 14s431ms 14s395ms 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 28 06 1 14s328ms 14s328ms 10 1 14s430ms 14s430ms 14 1 14s390ms 14s390ms 18 1 14s431ms 14s431ms -
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-01-28 18:01:04 Duration: 14s431ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-01-28 10:01:04 Duration: 14s430ms
-
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-28 14:01:01 Duration: 14s390ms
10 4 29s21ms 7s215ms 7s335ms 7s255ms copy edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 28 06 1 7s215ms 7s215ms 10 1 7s237ms 7s237ms 14 1 7s233ms 7s233ms 18 1 7s335ms 7s335ms -
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-28 18:00:29 Duration: 7s335ms
-
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-28 10:00:29 Duration: 7s237ms
-
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-28 14:00:25 Duration: 7s233ms
11 4 25s277ms 6s293ms 6s346ms 6s319ms copy edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 28 06 1 6s293ms 6s293ms 10 1 6s333ms 6s333ms 14 1 6s303ms 6s303ms 18 1 6s346ms 6s346ms -
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-28 18:01:12 Duration: 6s346ms
-
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-28 10:01:12 Duration: 6s333ms
-
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-28 14:01:09 Duration: 6s303ms
12 4 24s83ms 5s979ms 6s96ms 6s20ms copy edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 28 06 1 5s979ms 5s979ms 10 1 5s984ms 5s984ms 14 1 6s22ms 6s22ms 18 1 6s96ms 6s96ms -
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-28 18:00:35 Duration: 6s96ms
-
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-28 14:00:32 Duration: 6s22ms
-
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-28 10:00:35 Duration: 5s984ms
13 2 49s260ms 24s580ms 24s680ms 24s630ms vacuum full analyze ixn_actor;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 28 15 2 49s260ms 24s630ms -
vacuum FULL analyze ixn_actor;
Date: 2026-01-28 15:24:23 Duration: 24s680ms
-
vacuum FULL analyze ixn_actor;
Date: 2026-01-28 15:27:27 Duration: 24s580ms
-
vacuum FULL analyze ixn_actor;
Date: 2026-01-28 15:24:05 Duration: 0ms
14 2 21s352ms 9s487ms 11s864ms 10s676ms select * from edit.del_ixn_by_root_id (?) as result;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 28 15 2 21s352ms 10s676ms -
select * from edit.del_ixn_by_root_id ('9317859') as result;
Date: 2026-01-28 15:24:21 Duration: 11s864ms Bind query: yes
-
select * from edit.del_ixn_by_root_id ('9317907') as result;
Date: 2026-01-28 15:27:25 Duration: 9s487ms Bind query: yes
-
select * from edit.del_ixn_by_root_id ($1) as result;
Date: 2026-01-28 15:24:21 Duration: 0ms
15 2 10s342ms 5s120ms 5s221ms 5s171ms select ? "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casrn "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" from ( with sq as ( select distinct c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casrn, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort from term c inner join gene_chem_reference gcr on c.id = gcr.chem_id inner join term g on gcr.gene_id = g.id where (c.id = ?)) select distinct sq.chem_nm, sq.chem_acc_txt, sq.casrn, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm from sq inner join gene_go_annot gga on sq.gene_id = gga.gene_id inner join dag_node gt on gga.go_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where gga.is_not = false and (d.id = ? or d.id = ?) order by sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 28 05 2 10s342ms 5s171ms [ User: qaeu - Total duration: 5s221ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s120ms - Times executed: 1 ]
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1332236)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-01-28 05:43:36 Duration: 5s221ms Database: ctdprd51 User: qaeu Bind query: yes
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1332236)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-01-28 05:48:39 Duration: 5s120ms Database: ctdprd51 User: pubeu Bind query: yes
16 1 53m1s 53m1s 53m1s 53m1s select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.gene_go_annot gga, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 28 20 1 53m1s 53m1s -
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.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 pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 20:46:19 Duration: 53m1s Bind query: yes
17 1 44m46s 44m46s 44m46s 44m46s select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.object_type where cd = ?), ptr.term_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.phenotype_term_reference ptr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 28 19 1 44m46s 44m46s -
select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.PHENOTYPE_TERM_REFERENCE ptr, pub1.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 pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 19:53:13 Duration: 44m46s Bind query: yes
18 1 34m29s 34m29s 34m29s 34m29s 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 #18
Day Hour Count Duration Avg duration Jan 28 18 1 34m29s 34m29s [ User: load - Total duration: 34m29s - 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-28 18:11:53 Duration: 34m29s Database: ctdprd51 User: load Bind query: yes
19 1 27m5s 27m5s 27m5s 27m5s insert into pub1.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 #19
Day Hour Count Duration Avg duration Jan 28 17 1 27m5s 27m5s -
insert into pub1.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-28 17:28:52 Duration: 27m5s Bind query: yes
20 1 15m 15m 15m 15m insert into pub1.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 #20
Day Hour Count Duration Avg duration Jan 28 16 1 15m 15m [ User: pub1 - Total duration: 15m - Times executed: 1 ]
-
insert into pub1.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-28 16:56:14 Duration: 15m Database: ctdprd51 User: pub1 Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 53m1s 53m1s 53m1s 1 53m1s select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.gene_go_annot gga, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 28 20 1 53m1s 53m1s -
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.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 pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 20:46:19 Duration: 53m1s Bind query: yes
2 44m46s 44m46s 44m46s 1 44m46s select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.object_type where cd = ?), ptr.term_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.phenotype_term_reference ptr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 28 19 1 44m46s 44m46s -
select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.PHENOTYPE_TERM_REFERENCE ptr, pub1.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 pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 19:53:13 Duration: 44m46s Bind query: yes
3 34m29s 34m29s 34m29s 1 34m29s 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 28 18 1 34m29s 34m29s [ User: load - Total duration: 34m29s - 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-28 18:11:53 Duration: 34m29s Database: ctdprd51 User: load Bind query: yes
4 27m5s 27m5s 27m5s 1 27m5s insert into pub1.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 28 17 1 27m5s 27m5s -
insert into pub1.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-28 17:28:52 Duration: 27m5s Bind query: yes
5 15m 15m 15m 1 15m insert into pub1.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary) select object_id, object_type_id, acc_txt, db_id, type_cd, is_primary from edit.db_link;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 28 16 1 15m 15m [ User: pub1 - Total duration: 15m - Times executed: 1 ]
-
insert into pub1.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-28 16:56:14 Duration: 15m Database: ctdprd51 User: pub1 Bind query: yes
6 14m14s 14m14s 14m14s 1 14m14s alter table pub1.term_enrichment_agent add constraint term_enr_agent_term_enr_fk foreign key (term_id, enriched_term_id) references term_enrichment (term_id, enriched_term_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 28 23 1 14m14s 14m14s -
ALTER TABLE pub1.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-28 23:34:32 Duration: 14m14s Bind query: yes
7 9m12s 9m12s 9m12s 1 9m12s select maint_query_logs_archive ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 28 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-28 00:09:31 Duration: 9m12s Database: ctdprd51 User: pubc Application: psql
8 4m33s 4m33s 4m33s 1 4m33s insert into pub1.gene_taxon (gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd) select gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd from load.gene_taxon;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 28 17 1 4m33s 4m33s -
insert into pub1.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-28 17:33:25 Duration: 4m33s Bind query: yes
9 3m22s 3m22s 3m22s 1 3m22s insert into pub1.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 pub1.term);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 28 17 1 3m22s 3m22s -
INSERT INTO pub1.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 pub1.TERM);
Date: 2026-01-28 17:01:46 Duration: 3m22s Bind query: yes
10 3m18s 3m18s 3m18s 1 3m18s create unique index gene_disease_reference_ak1 on pub1.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 #10
Day Hour Count Duration Avg duration Jan 28 21 1 3m18s 3m18s -
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-01-28 21:05:55 Duration: 3m18s Bind query: yes
-
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-01-28 21:05:55 Duration: 0ms
11 3m1s 3m1s 3m1s 1 3m1s alter table pub1.term_enrichment_agent add constraint term_enrichment_agent_pk primary key (term_id, enriched_term_id, agent_term_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 28 23 1 3m1s 3m1s -
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-01-28 23:37:33 Duration: 3m1s Bind query: yes
-
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-01-28 23:37:32 Duration: 0ms
12 41s545ms 10m18s 2m37s 5 13m7s 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 pub1.gene_chem_reference gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 28 18 5 13m7s 2m37s [ User: load - Total duration: 10m18s - 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 18:25:03 Duration: 10m18s 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 18:49:31 Duration: 42s945ms 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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-01-28 18:43:43 Duration: 42s190ms Bind query: yes
13 2m34s 2m34s 2m34s 1 2m34s create index ix_gene_disease_ref_net_sc on pub1.gene_disease_reference using btree (network_score);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 28 21 1 2m34s 2m34s -
CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);
Date: 2026-01-28 21:20:07 Duration: 2m34s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);
Date: 2026-01-28 21:20:06 Duration: 0ms
14 2m10s 2m10s 2m10s 1 2m10s select distinct ptr.phenotype_id, cdr.disease_id, ( select id from pub1.object_type where cd = ?), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub1.object_type where cd = ?), cdr.mod_tm from pub1.chem_disease_reference cdr, pub1.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 pub1.ixn_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 28 20 1 2m10s 2m10s -
SELECT DISTINCT ptr.phenotype_id, cdr.disease_id, ( select id from pub1.OBJECT_TYPE where cd = 'disease'), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), cdr.mod_tm FROM pub1.CHEM_DISEASE_REFERENCE cdr, pub1.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 pub1.IXN_AXN WHERE action_degree_type_nm = 'does not affect');
Date: 2026-01-28 20:48:37 Duration: 2m10s Bind query: yes
15 1m59s 1m59s 1m59s 1 1m59s create index ix_gene_disease_ref_dis_gene on pub1.gene_disease_reference using btree (disease_id, gene_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 28 21 1 1m59s 1m59s -
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-01-28 21:14:31 Duration: 1m59s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-01-28 21:14:30 Duration: 0ms
16 1m59s 1m59s 1m59s 1 1m59s vacuum full analyze db_link;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 28 15 1 1m59s 1m59s -
vacuum FULL analyze db_link;
Date: 2026-01-28 15:26:51 Duration: 1m59s
-
vacuum FULL analyze db_link;
Date: 2026-01-28 15:25:13 Duration: 0ms
17 1m57s 1m57s 1m57s 1 1m57s insert into pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, secondary_nm, description, note, is_leaf, nm_html, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_marrays, nm_fts) select t.id, t.object_type_id, t.acc_txt, get_db_cd (t.acc_db_id) as db_cd, t.nm, common.search_str (t.nm_sort), t.secondary_nm, t.description, t.note, is_leaf, break_html_words (t.nm), ?, ?, ?, ?, ?, ?, ? from load.term t where object_type_id not in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 28 16 1 1m57s 1m57s -
INSERT INTO pub1.TERM (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, secondary_nm, description, note, is_leaf, nm_html, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_marrays, nm_fts) SELECT t.id, t.object_type_id, t.acc_txt, get_db_cd (t.acc_db_id) AS db_cd, t.nm, common.search_str (t.nm_sort), t.secondary_nm, t.description, t.note, is_leaf, break_html_words (t.nm), 0, 0, 'f', 'f', 'f', 'f', 'dummy' FROM load.TERM t where object_type_id NOT in (2, 3, 6);
Date: 2026-01-28 16:58:23 Duration: 1m57s Bind query: yes
18 1m50s 1m51s 1m51s 4 7m24s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 28 06 1 1m50s 1m50s 10 1 1m51s 1m51s 14 1 1m51s 1m51s 18 1 1m51s 1m51s [ User: postgres - Total duration: 7m24s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m24s - Times executed: 4 ]
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-01-28 18:06:52 Duration: 1m51s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-01-28 10: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-28 14:06:52 Duration: 1m51s Database: ctdprd51 User: postgres Application: pg_dump
19 1m50s 1m50s 1m50s 1 1m50s alter table pub1.gene_disease_reference add constraint gene_disease_reference_pk primary key (id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 28 21 1 1m50s 1m50s -
ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-01-28 21:02:37 Duration: 1m50s Bind query: yes
-
ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-01-28 21:02:36 Duration: 0ms Database: ctdprd51 User: pub1
20 5s6ms 7m44s 54s115ms 61 55m1s select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 28 12 9 1m14s 8s281ms 13 21 16m58s 48s495ms 14 9 11m54s 1m19s 18 3 1m7s 22s608ms 20 2 7m59s 3m59s 21 5 8m 1m36s 22 8 3m45s 28s198ms 23 4 4m 1m [ User: load - Total duration: 15m36s - Times executed: 16 ]
[ Application: pg_bulkload - Total duration: 15m36s - Times executed: 16 ]
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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-28 20:59:21 Duration: 7m44s Database: ctdprd51 User: load Application: pg_bulkload Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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-28 21:31:46 Duration: 5m 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-28 13:24:01 Duration: 4m41s 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 1 0ms 2 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jan 28 15 2 0ms 0ms -
;
Date: Duration: 0ms Database: postgres parameters: $1 = '9317859'
-
Events
Log levels
Key values
- 13,400 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 6 ERROR entries
- 1 WARNING entries
- 5 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5 Max number of times the same event was reported
- 12 Total events found
Rank Times reported Error 1 5 LOG: process ... still waiting for RowExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #1
Day Hour Count Jan 28 15 5 - LOG: process 337462 still waiting for RowExclusiveLock on relation 2633859 of database 484829 after 1000.041 ms
Detail: Processes holding the lock: 303157, 337914, 337916, 337917, 337915. Wait queue: 337462.
Context: SQL statement "DELETE FROM edit.ixn_actor WHERE ixn_id IN (SELECT id FROM edit.ixn WHERE root_id = p_root_id)" PL/pgSQL function del_ixn_by_root_id(integer) line 9 at SQL statement
Statement: select * from edit.del_ixn_by_root_id($1) as resultDate: 2026-01-28 15:24:03 Database: ctdprd51 Application: User: editeu Remote:
2 4 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jan 28 06 4 - ERROR: syntax error at or near ")" at character 4938
Statement: select distinct e.reference_acc_txt as "Reference", pref.abbr_authors_txt as "Author", referenceExp.author_summary as "AuthorSummary", (Select STRING_AGG( distinct eventproject.project_nm, '|')) as "AssociatedStudyTitles", eevent.collection_start_yr as "EnrollmentStartYear", eevent.collection_end_yr as "EnrollmentEndYear", (Select STRING_AGG( distinct studyFactor.nm, '|')) as "StudyFactors", (Select STRING_AGG(distinct stressorSrcType.nm, '|')) as "StressorSourceCategory", stressor.chem_term_nm as "ExposureStressorName", stressor.src_details as "StressorSourceDetails", stressor.sample_qty as "NumberOfStressorSamples", stressor.note as "StressorNotes", ereceptor.qty as "NumberOfReceptors", ereceptor.description as "Receptors", ereceptor.term_nm as "ReceptorDescription", ereceptor.term_acc_txt as "ReceptorID", ereceptor.note as "ReceptorNotes", (Select STRING_AGG(distinct COALESCE( COALESCE(NULLIF(CAST(receptorTobaccoUse.pct as int),0)) || '% ' || tobaccoUse.nm, COALESCE(COALESCE(NULLIF(CAST(receptorTobaccoUse.pct as int),0)) || '% ' , tobaccoUse.nm)), '|')) as "SmokingStatus", ereceptor.age || ' ' || age_uom.nm as "Age", age_qualifier.nm as "AgeQualifier", (Select STRING_AGG(distinct COALESCE( COALESCE(NULLIF(CAST(pct as int),0)) || '% ' || gender.nm, COALESCE(COALESCE(NULLIF(CAST(pct as int),0)) || '% ' , gender.nm)), '|') from exp_receptor_gender expgender left outer join gender on expgender.gender_id=gender.id where exp_receptor_id = ereceptor.id ) as "Sex", (Select STRING_AGG(distinct COALESCE( COALESCE(NULLIF(CAST(receptorRace.pct as int),0)) || '% ' || race.nm, COALESCE(COALESCE(NULLIF(CAST(receptorRace.pct as int),0)) || '% ' , race.nm)), '|')) as "Race", (Select STRING_AGG( distinct eventAssayMethod.nm, '|')) as "Methods" , eevent.detection_limit as "DetectionLimit", eevent.detection_limit_uom as "DetectionLimitUnitsOfMeasurement", eevent.detection_freq as "DetectionFrequency", emedium.nm as "Medium", eevent.exp_marker_term_nm as "ExposureMarker", eevent.exp_marker_lvl as "MarkerLevel", eevent.assay_uom as "MarkerUnitsOfMeasurement", eevent.assay_measurement_stat as "MarkerMeasurementStatistic", eevent.assay_note as "AssayNotes", (Select STRING_AGG( distinct country.nm, '|')) as "StudyCountries", (Select STRING_AGG( distinct eventLocation.geographic_region_nm, '|')) as "StateOrProvince", (Select STRING_AGG( distinct eventLocation.locality_txt, '|')) as "CityTownRegionOrArea", eevent.note as "ExposureEventNotes", eiot.description as "OutcomeRelationship", outcome.disease_term_nm as "DiseaseName", outcome.phenotype_action_degree_type_nm as "PhenotypeActionDegreeType", outcome.phenotype_term_nm as "PhenotypeName", (Select STRING_AGG( distinct expAnatomy.anatomy_term_nm, '|')) as "Anatomy", outcome.note as "ExposureOutcomeNotes" from exposure e left outer join reference pref on pref.acc_txt = e.reference_acc_txt left outer join reference_exp referenceExp on referenceExp.reference_acc_txt = e.reference_acc_txt left outer join exp_study_factor expStudyFactor on referenceExp.id = expStudyFactor.reference_exp_id left outer join study_factor studyFactor on studyFactor.id = expStudyFactor.study_factor_id left outer join exp_event_project eventproject on eventproject.exp_event_id = e.exp_event_id inner join exp_stressor stressor on e.exp_stressor_id = stressor.id left outer join exp_receptor ereceptor on e.exp_receptor_id = ereceptor.id left outer join age_uom age_uom on ereceptor.age_uom_id = age_uom.id left outer join age_qualifier age_qualifier on ereceptor.age_qualifier_id = age_qualifier.id left outer join exp_event eevent on e.exp_event_id = eevent.id left outer join medium emedium on eevent.medium_id = emedium.id left outer join exp_stressor_stressor_src esss on stressor.id = esss.exp_stressor_id left outer join exp_stressor_src_type stressorSrcType on esss.exp_stressor_src_type_id = stressorSrcType.id left outer join exp_receptor_tobacco_use receptorTobaccoUse on ereceptor.id = receptorTobaccoUse.exp_receptor_id left outer join tobacco_use tobaccoUse on receptorTobaccoUse.tobacco_use_id = tobaccoUse.id left outer join exp_receptor_race receptorRace on ereceptor.id = receptorRace.exp_receptor_id left outer join race race on receptorRace.race_id = race.id left outer join exp_event_location eventLocation on eevent.id = eventLocation.exp_event_id left outer join country on eventLocation.country_id = country.id left outer join exp_outcome outcome on e.exp_outcome_id = outcome.id left outer join exp_outcome_ixn_type eiot on outcome.exp_outcome_ixn_type_id = eiot.id left outer join exp_anatomy expAnatomy on outcome.id = expAnatomy.exp_outcome_id left outer join exp_event_assay_method eventAssayMethod on eevent.id = eventAssayMethod.exp_event_id where ereceptor.term_acc_txt in ( select acc_txt from term where id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( )))or outcome.phenotype_acc_txt in ( select acc_txt from term where id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( ))) group by "Reference", "Author", "AuthorSummary", "EnrollmentStartYear", "EnrollmentEndYear", "ExposureStressorName", "StressorSourceDetails", "NumberOfStressorSamples", "StressorNotes", "NumberOfReceptors", "Receptors", "ReceptorDescription", "ReceptorID", "ReceptorNotes", "Age", "AgeQualifier", "DetectionLimit", "DetectionLimitUnitsOfMeasurement", "DetectionFrequency", "Medium", "ExposureMarker", "MarkerLevel", "MarkerUnitsOfMeasurement", "MarkerMeasurementStatistic", "AssayNotes", "ExposureEventNotes", "OutcomeRelationship", "DiseaseName", "PhenotypeActionDegreeType", "PhenotypeName", "ExposureOutcomeNotes", ereceptor.id, eventLocation.exp_event_id
Date: 2026-01-28 06:15:22 Database: ctdprd51 Application: User: pubeu Remote:
3 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jan 28 10 1 12 1 - ERROR: relation "chem_conc" does not exist at character 15
- ERROR: relation "object_type" does not exist at character 84
Statement: select * from chem_conc
Date: 2026-01-28 10:57:26 Database: ctdprd51 Application: pgAdmin 4 - CONN:4617924 User: load Remote:
Statement: select count(*) from edit.db_link where object_type_id = ( select id from object_type where cd = 'reference' );
Date: 2026-01-28 12:38:48 Database: ctdprd51 Application: pgAdmin 4 - CONN:7453006 User: load Remote:
4 1 WARNING: is not a PostgreSQL server process
Times Reported Most Frequent Error / Event #4
Day Hour Count Jan 28 10 1