pgBadger-
Global information
- Generated on Thu May 28 04:15:03 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260527
- Parsed 29,348 log entries in 2s
- Log start from 2026-05-27 00:00:01 to 2026-05-27 23:58:59
-
Overview
Global Stats
- 100 Number of unique normalized queries
- 260 Number of queries
- 6h21m4s Total query duration
- 2026-05-27 00:09:19 First query
- 2026-05-27 23:58:19 Last query
- 4 queries/s at 2026-05-27 06:40:00 Query peak
- 6h21m4s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h21m4s Execute total duration
- 11 Number of events
- 9 Number of unique normalized events
- 3 Max number of times the same event was reported
- 0 Number of cancellation
- 57 Total number of automatic vacuums
- 99 Total number of automatic analyzes
- 2,383 Number temporary file
- 1.00 GiB Max size of temporary file
- 259.20 MiB Average size of temporary file
- 2,351 Total number of sessions
- 188 sessions at 2026-05-27 23:58:26 Session peak
- 69d22h59m53s Total duration of sessions
- 42m50s Average duration of sessions
- 0 Average queries per session
- 9s725ms Average queries duration per session
- 42m41s Average idle time per session
- 2,358 Total number of connections
- 24 connections/s at 2026-05-27 06:26:09 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-27 06:40:00 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-27 06:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-05-27 06:00:21 Date
Queries duration
Key values
- 6h21m4s 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) May 27 00 2 0ms 9m17s 4m42s 0ms 0ms 9m24s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 1 0ms 8s373ms 8s373ms 0ms 0ms 8s373ms 03 23 0ms 39s706ms 13s345ms 20s534ms 53s105ms 57s552ms 04 4 0ms 5s776ms 5s488ms 0ms 5s776ms 10s470ms 05 2 0ms 5s651ms 5s574ms 0ms 5s497ms 5s651ms 06 45 0ms 1m51s 14s343ms 57s982ms 1m12s 1m51s 07 2 0ms 7s694ms 6s570ms 0ms 5s447ms 7s694ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 1 0ms 5s35ms 5s35ms 0ms 0ms 5s35ms 10 12 0ms 1m52s 19s858ms 6s103ms 39s580ms 1m52s 11 4 0ms 6s179ms 6s173ms 0ms 6s171ms 18s521ms 12 1 0ms 5s989ms 5s989ms 0ms 0ms 5s989ms 13 20 0ms 15s356ms 8s613ms 20s933ms 24s740ms 36s324ms 14 36 0ms 5m21s 45s326ms 1m47s 1m48s 5m45s 15 9 0ms 3m9s 1m15s 1m31s 2m5s 3m9s 16 8 0ms 16m48s 3m17s 48s31ms 2m23s 16m58s 17 11 0ms 35m11s 6m45s 1m48s 29m16s 35m11s 18 15 0ms 12m14s 1m22s 59s254ms 1m52s 12m14s 19 1 0ms 50m24s 50m24s 0ms 0ms 50m24s 20 9 0ms 1h6m17s 8m21s 1m7s 3m44s 1h6m49s 21 39 0ms 7m30s 1m22s 3m49s 5m21s 7m45s 22 1 0ms 33s660ms 33s660ms 0ms 0ms 33s660ms 23 14 0ms 2m55s 33s495ms 54s512ms 1m34s 2m55s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 27 00 1 0 9m17s 0ms 0ms 9m17s 01 0 0 0ms 0ms 0ms 0ms 02 1 0 8s373ms 0ms 0ms 8s373ms 03 13 0 16s749ms 0ms 8s97ms 57s552ms 04 4 0 5s488ms 0ms 0ms 10s470ms 05 2 0 5s574ms 0ms 0ms 5s651ms 06 36 9 14s343ms 24s646ms 57s982ms 1m51s 07 2 0 6s570ms 0ms 0ms 7s694ms 08 0 0 0ms 0ms 0ms 0ms 09 1 0 5s35ms 0ms 0ms 5s35ms 10 2 9 21s147ms 0ms 6s103ms 1m52s 11 4 0 6s173ms 0ms 0ms 18s521ms 12 1 0 5s989ms 0ms 0ms 5s989ms 13 18 0 8s552ms 0ms 20s933ms 36s324ms 14 28 8 45s326ms 1m30s 1m47s 5m45s 15 9 0 1m15s 0ms 1m31s 3m9s 16 0 0 0ms 0ms 0ms 0ms 17 5 0 7m17s 0ms 7s825ms 35m11s 18 6 9 1m22s 42s994ms 59s254ms 12m14s 19 1 0 50m24s 0ms 0ms 50m24s 20 9 0 8m21s 18s721ms 1m7s 1h6m49s 21 14 0 1m57s 5s412ms 1m45s 7m45s 22 1 0 33s660ms 0ms 0ms 33s660ms 23 14 0 33s495ms 12s937ms 54s512ms 2m55s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 27 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 2 0 0 0 9s161ms 0ms 0ms 9s151ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 4 0 0 0 5m47s 0ms 0ms 4m4s 17 6 0 0 0 6m19s 0ms 0ms 5m3s 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 27 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 1 1.00 0.00% 03 0 23 23.00 0.00% 04 0 4 4.00 0.00% 05 0 2 2.00 0.00% 06 0 36 36.00 0.00% 07 0 2 2.00 0.00% 08 0 0 0.00 0.00% 09 0 1 1.00 0.00% 10 0 2 2.00 0.00% 11 0 4 4.00 0.00% 12 0 1 1.00 0.00% 13 0 18 18.00 0.00% 14 0 28 28.00 0.00% 15 0 8 8.00 0.00% 16 0 4 4.00 0.00% 17 0 11 11.00 0.00% 18 0 6 6.00 0.00% 19 0 1 1.00 0.00% 20 0 9 9.00 0.00% 21 0 39 39.00 0.00% 22 0 1 1.00 0.00% 23 0 14 14.00 0.00% Day Hour Count Average / Second May 27 00 83 0.02/s 01 78 0.02/s 02 86 0.02/s 03 132 0.04/s 04 87 0.02/s 05 90 0.03/s 06 220 0.06/s 07 77 0.02/s 08 81 0.02/s 09 82 0.02/s 10 104 0.03/s 11 81 0.02/s 12 80 0.02/s 13 193 0.05/s 14 116 0.03/s 15 101 0.03/s 16 75 0.02/s 17 89 0.02/s 18 77 0.02/s 19 72 0.02/s 20 73 0.02/s 21 85 0.02/s 22 86 0.02/s 23 110 0.03/s Day Hour Count Average Duration Average idle time May 27 00 83 29m31s 29m24s 01 78 31m22s 31m22s 02 86 28m39s 28m39s 03 132 19m3s 19m 04 87 27m23s 27m22s 05 90 27m10s 27m10s 06 220 11m24s 11m21s 07 77 29m25s 29m24s 08 81 30m13s 30m13s 09 82 30m39s 30m39s 10 98 24m38s 24m36s 11 81 28m28s 28m28s 12 80 31m51s 31m51s 13 192 12m47s 12m46s 14 117 21m2s 20m48s 15 101 24m5s 23m58s 16 74 33m55s 33m33s 17 89 27m29s 26m39s 18 77 30m40s 30m24s 19 72 31m37s 30m55s 20 73 31m30s 30m29s 21 86 8h40m35s 8h39m57s 22 85 28m10s 28m9s 23 110 23m43s 23m39s -
Connections
Established Connections
Key values
- 24 connections Connection Peak
- 2026-05-27 06:26:09 Date
Connections per database
Key values
- ctdprd51 Main Database
- 2,358 connections Total
Connections per user
Key values
- pubeu Main User
- 2,358 connections Total
-
Sessions
Simultaneous sessions
Key values
- 188 sessions Session Peak
- 2026-05-27 23:58:26 Date
Histogram of session times
Key values
- 1,748 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 2,351 sessions Total
Sessions per user
Key values
- pubeu Main User
- 2,351 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 2,351 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 966,305 buffers Checkpoint Peak
- 2026-05-27 17:36:49 Date
- 1619.866 seconds Highest write time
- 1.124 seconds Sync time
Checkpoints Wal files
Key values
- 598 files Wal files usage Peak
- 2026-05-27 21:25:03 Date
Checkpoints distance
Key values
- 17,274.08 Mo Distance Peak
- 2026-05-27 21:21:20 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 27 00 571 57.405s 0.002s 57.416s 01 143 14.504s 0.002s 14.513s 02 144 14.603s 0.003s 14.613s 03 97 9.821s 0.001s 9.825s 04 60,880 1,639.627s 0.003s 1,639.741s 05 190 19.124s 0.002s 19.133s 06 481 48.413s 0.002s 48.422s 07 370 37.276s 0.002s 37.285s 08 2,642 264.796s 0.002s 264.842s 09 1,098 110.194s 0.002s 110.207s 10 1,787 179.202s 0.003s 179.245s 11 3,166 317.127s 0.098s 317.34s 12 41 4.19s 0.001s 4.194s 13 82,031 3,239.492s 0.112s 3,240.012s 14 315,850 605.926s 0.232s 612.294s 15 528 53.123s 0.004s 53.772s 16 2,741,894 3,558.333s 1.082s 3,567.212s 17 1,712,096 3,127.248s 0.037s 3,129.392s 18 279,395 1,619.706s 0.008s 1,620.046s 19 75 7.686s 0.002s 7.696s 20 41 4.302s 0.002s 4.318s 21 3,975 398.728s 0.59s 406.607s 22 792,856 1,632.595s 0.008s 1,633.519s 23 346,937 2,505.736s 1.127s 2,508.131s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 27 00 0 0 0 71 0.001s 0.002s 01 0 0 0 29 0.001s 0.002s 02 0 0 0 25 0.001s 0.002s 03 0 0 0 18 0.001s 0.001s 04 0 0 32 73 0.001s 0.003s 05 0 0 0 31 0.001s 0.002s 06 0 0 0 138 0.001s 0.002s 07 0 0 0 119 0.001s 0.002s 08 0 0 1 129 0.001s 0.002s 09 0 0 1 131 0.001s 0.002s 10 0 0 1 139 0.001s 0.002s 11 0 0 1 786 0.001s 0.002s 12 0 0 0 12 0.001s 0.001s 13 0 2 182 855 0.001s 0.002s 14 0 1 2,934 420 0.106s 0.01s 15 0 0 225 52 0.001s 0.001s 16 0 33 3,765 611 0.209s 0.023s 17 0 0 1,076 167 0.010s 0.003s 18 0 0 158 235 0.001s 0.001s 19 0 0 0 20 0.001s 0.002s 20 0 0 0 16 0.001s 0.002s 21 0 0 3,235 175 0.514s 0.036s 22 0 0 447 127 0.001s 0.002s 23 0 38 539 64 1.083s 0.033s Day Hour Count Avg time (sec) May 27 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 May 27 00 2,297.00 kB 24,784.00 kB 01 166.50 kB 20,095.50 kB 02 181.00 kB 16,310.50 kB 03 348.00 kB 13,957.00 kB 04 173,491.67 kB 469,463.33 kB 05 392.50 kB 359,997.50 kB 06 1,356.50 kB 291,811.50 kB 07 996.00 kB 236,575.00 kB 08 8,408.00 kB 192,548.00 kB 09 3,455.00 kB 157,096.50 kB 10 5,813.50 kB 128,554.50 kB 11 8,559.00 kB 105,766.50 kB 12 108.00 kB 90,236.00 kB 13 1,247,181.50 kB 1,247,181.50 kB 14 8,103,440.17 kB 8,756,188.33 kB 15 3,674,509.00 kB 7,924,512.00 kB 16 8,814,955.14 kB 8,822,451.29 kB 17 8,813,827.50 kB 8,820,622.50 kB 18 3,114,579.00 kB 8,249,575.00 kB 19 87.00 kB 7,053,400.00 kB 20 52.00 kB 5,713,264.50 kB 21 7,560,491.57 kB 8,271,700.00 kB 22 3,702,267.00 kB 8,255,117.00 kB 23 4,460,216.50 kB 7,933,253.50 kB -
Temporary Files
Size of temporary files
Key values
- 40.00 GiB Temp Files size Peak
- 2026-05-27 21:02:08 Date
Number of temporary files
Key values
- 40 per second Temp Files Peak
- 2026-05-27 21:02:08 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 27 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 420 3.89 GiB 9.49 MiB 14 826 48.11 GiB 59.64 MiB 15 162 20.44 GiB 129.20 MiB 16 115 6.77 GiB 60.24 MiB 17 0 0 0 18 31 30.31 GiB 1001.26 MiB 19 63 62.33 GiB 1013.08 MiB 20 0 0 0 21 556 412.92 GiB 760.48 MiB 22 0 0 0 23 210 18.43 GiB 89.87 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 1,593 98.50 GiB 8.00 KiB 1.00 GiB 63.32 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-05-27 21:15:04 Duration: 7m30s 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-05-27 21:52:16 Duration: 5m21s
-
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-05-27 14:11:01 Duration: 5m21s
2 289 288.19 GiB 318.25 MiB 1.00 GiB 1021.13 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-05-27 21:01:55 Duration: 0ms
3 63 62.33 GiB 336.05 MiB 1.00 GiB 1013.08 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-05-27 19:40:03 Duration: 0ms
4 35 4.91 GiB 81.73 MiB 215.51 MiB 143.77 MiB vacuum full analyze db_link;-
vacuum FULL analyze db_link;
Date: 2026-05-27 16:07:22 Duration: 2m23s
-
vacuum FULL analyze db_link;
Date: 2026-05-27 16:05:26 Duration: 0ms
5 35 1.23 GiB 26.10 MiB 53.73 MiB 36.06 MiB vacuum full analyze ixn_actor;-
vacuum FULL analyze ixn_actor;
Date: 2026-05-27 16:04:24 Duration: 27s690ms
-
vacuum FULL analyze ixn_actor;
Date: 2026-05-27 16:04:04 Duration: 0ms
6 31 30.31 GiB 319.14 MiB 1.00 GiB 1001.26 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-05-27 18:45:19 Duration: 0ms
7 25 407.13 MiB 11.52 MiB 20.29 MiB 16.29 MiB vacuum full analyze ixn;-
vacuum FULL analyze ixn;
Date: 2026-05-27 16:04:50 Duration: 9s75ms
-
vacuum FULL analyze ixn;
Date: 2026-05-27 16:04:44 Duration: 0ms
8 20 226.26 MiB 5.51 MiB 16.64 MiB 11.31 MiB vacuum full analyze term;-
vacuum FULL analyze TERM;
Date: 2026-05-27 16:04:17 Duration: 11s265ms
-
vacuum FULL analyze TERM;
Date: 2026-05-27 16:04:08 Duration: 0ms
9 20 14.05 GiB 8.00 KiB 1.00 GiB 719.56 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-05-27 21:23:07 Duration: 4m3s
-
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-05-27 21:23:06 Duration: 0ms
10 15 7.81 GiB 8.00 KiB 1.00 GiB 533.01 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-05-27 21:19:03 Duration: 2m33s
-
ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-05-27 21:19:03 Duration: 0ms Database: ctdprd51 User: pub1
11 10 475.70 MiB 8.00 KiB 102.77 MiB 47.57 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-05-27 21:42:47 Duration: 7s791ms
-
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-05-27 21:42:47 Duration: 0ms
12 10 261.09 MiB 8.00 KiB 54.00 MiB 26.11 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-05-27 21:42:39 Duration: 0ms
13 10 7.81 GiB 563.93 MiB 1.00 GiB 799.51 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-05-27 21:31:09 Duration: 1m45s
-
CREATE INDEX ix_gene_disease_ref_reference ON pub1.gene_disease_reference USING btree (reference_id);
Date: 2026-05-27 21:31:08 Duration: 0ms
14 10 7.81 GiB 563.93 MiB 1.00 GiB 799.51 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-05-27 21:27:33 Duration: 1m52s
-
CREATE INDEX ix_gene_disease_ref_chem ON pub1.gene_disease_reference USING btree (via_chem_id);
Date: 2026-05-27 21:27:32 Duration: 0ms
15 10 7.81 GiB 563.93 MiB 1.00 GiB 799.51 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-05-27 21:25:40 Duration: 1m22s
-
CREATE INDEX ix_gene_disease_ref_source_cd ON pub1.gene_disease_reference USING btree (source_cd);
Date: 2026-05-27 21:25:40 Duration: 0ms
16 10 7.81 GiB 563.93 MiB 1.00 GiB 799.51 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-05-27 21:33:31 Duration: 2m22s
-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-05-27 21:33:30 Duration: 0ms
17 10 7.81 GiB 563.93 MiB 1.00 GiB 799.51 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-05-27 21:35:17 Duration: 1m45s
-
CREATE INDEX ix_gene_disease_reference_ixn ON pub1.gene_disease_reference USING btree (ixn_id);
Date: 2026-05-27 21:35:16 Duration: 0ms
18 10 7.81 GiB 563.93 MiB 1.00 GiB 799.51 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-05-27 21:40:04 Duration: 2m58s
-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);
Date: 2026-05-27 21:40:03 Duration: 0ms
19 10 7.81 GiB 510.17 MiB 1.00 GiB 799.51 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-05-27 21:24:18 Duration: 1m10s
-
CREATE INDEX ix_gene_disease_ref_src_db ON pub1.gene_disease_reference USING btree (source_acc_db_id);
Date: 2026-05-27 21:24:17 Duration: 0ms
20 10 1.19 GiB 8.00 KiB 249.91 MiB 121.69 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-05-27 21:40:21 Duration: 16s417ms
-
ALTER TABLE pub1.phenotype_term_reference ADD CONSTRAINT phenotype_term_reference_pk PRIMARY KEY (id);
Date: 2026-05-27 21:40:21 Duration: 0ms
21 10 7.81 GiB 563.93 MiB 1.00 GiB 799.51 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-05-27 21:29:23 Duration: 1m50s
-
CREATE INDEX ix_gene_disease_ref_disease ON pub1.gene_disease_reference USING btree (disease_id);
Date: 2026-05-27 21:29:23 Duration: 0ms
22 10 154.73 MiB 8.00 KiB 31.16 MiB 15.47 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-05-27 23:58:23 Duration: 0ms Database: ctdprd51 User: pub1
23 10 7.81 GiB 564.09 MiB 1.00 GiB 799.51 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-05-27 21:37:06 Duration: 1m48s
-
CREATE INDEX ix_gene_disease_ref_mod_tm ON pub1.gene_disease_reference USING btree (mod_tm);
Date: 2026-05-27 21:37:05 Duration: 0ms
24 7 6.44 GiB 453.16 MiB 1.00 GiB 942.45 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-05-27 21:06:36 Duration: 0ms
25 5 261.05 MiB 50.16 MiB 54.41 MiB 52.21 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-05-27 21:43:08 Duration: 0ms
26 5 1.19 GiB 233.35 MiB 249.66 MiB 243.38 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-05-27 21:42:05 Duration: 12s834ms
-
CREATE INDEX ix_phenotype_term_reference_ixn_id ON pub1.phenotype_term_reference USING btree (ixn_id);
Date: 2026-05-27 21:42:05 Duration: 0ms
27 5 1.19 GiB 235.14 MiB 249.55 MiB 243.38 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-05-27 21:41:39 Duration: 10s254ms
-
CREATE INDEX ix_phenotype_term_reference_source_acc_db_id ON pub1.phenotype_term_reference USING btree (source_acc_db_id);
Date: 2026-05-27 21:41:39 Duration: 0ms
28 5 1.19 GiB 232.73 MiB 253.22 MiB 243.38 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-05-27 21:41:53 Duration: 13s306ms
-
CREATE INDEX ix_phenotype_term_reference_term_reference_id ON pub1.phenotype_term_reference USING btree (term_reference_id);
Date: 2026-05-27 21:41:53 Duration: 0ms
29 5 1.19 GiB 238.24 MiB 246.90 MiB 243.38 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-05-27 21:40:46 Duration: 12s477ms
-
CREATE INDEX ix_phenotype_term_ref_term_id ON pub1.phenotype_term_reference USING btree (term_id);
Date: 2026-05-27 21:40:46 Duration: 0ms
30 5 261.06 MiB 49.57 MiB 56.52 MiB 52.21 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-05-27 21:42:58 Duration: 0ms
31 5 215.95 MiB 42.03 MiB 44.30 MiB 43.19 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-05-27 23:58:36 Duration: 0ms
32 5 261.06 MiB 50.00 MiB 54.73 MiB 52.21 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-05-27 21:43:13 Duration: 5s610ms
-
CREATE INDEX ix_chem_disease_ref_net_sc ON pub1.chem_disease_reference USING btree (network_score);
Date: 2026-05-27 21:43:13 Duration: 0ms
33 5 1.19 GiB 226.25 MiB 256.41 MiB 243.38 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-05-27 21:40:57 Duration: 10s973ms
-
CREATE INDEX ix_phenotype_term_ref_object_type_id ON pub1.phenotype_term_reference USING btree (term_object_type_id);
Date: 2026-05-27 21:40:57 Duration: 0ms
34 5 154.70 MiB 28.57 MiB 31.93 MiB 30.94 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-05-27 23:58:26 Duration: 0ms
35 5 261.05 MiB 51.00 MiB 52.70 MiB 52.21 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-05-27 21:43:04 Duration: 0ms
36 5 1.19 GiB 231.65 MiB 255.45 MiB 243.38 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-05-27 21:41:10 Duration: 13s224ms
-
CREATE INDEX ix_phenotype_term_ref_reference_id ON pub1.phenotype_term_reference USING btree (reference_id);
Date: 2026-05-27 21:41:10 Duration: 0ms
37 5 261.06 MiB 49.11 MiB 54.77 MiB 52.21 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-05-27 21:43:01 Duration: 0ms
38 5 261.05 MiB 51.65 MiB 52.58 MiB 52.21 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-05-27 21:42:50 Duration: 0ms
39 5 215.96 MiB 42.65 MiB 43.62 MiB 43.19 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-05-27 23:58:32 Duration: 0ms
40 5 1.19 GiB 241.51 MiB 245.37 MiB 243.38 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-05-27 21:41:29 Duration: 9s666ms
-
CREATE INDEX ix_phenotype_term_ref_evidence_cd ON pub1.phenotype_term_reference USING btree (evidence_cd);
Date: 2026-05-27 21:41:29 Duration: 0ms
41 5 154.70 MiB 27.53 MiB 33.39 MiB 30.94 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-05-27 23:58:24 Duration: 0ms
42 5 261.06 MiB 50.85 MiB 54.14 MiB 52.21 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-05-27 21:42:56 Duration: 0ms
43 5 1.19 GiB 240.05 MiB 250.10 MiB 243.38 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-05-27 21:42:19 Duration: 13s794ms
-
CREATE INDEX ix_phenotype_term_ref_via_term_id ON pub1.phenotype_term_reference USING btree (via_term_id);
Date: 2026-05-27 21:42:19 Duration: 0ms
44 5 1.19 GiB 241.95 MiB 245.19 MiB 243.38 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-05-27 21:41:19 Duration: 9s519ms
-
CREATE INDEX ix_phenotype_term_ref_taxon_id ON pub1.phenotype_term_reference USING btree (taxon_id);
Date: 2026-05-27 21:41:19 Duration: 0ms
45 5 154.70 MiB 29.80 MiB 31.78 MiB 30.94 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-05-27 23:58:27 Duration: 0ms
46 5 1.19 GiB 228.27 MiB 256.84 MiB 243.38 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-05-27 21:40:33 Duration: 12s8ms
-
CREATE INDEX ix_phenotype_term_ref_phenotype_id ON pub1.phenotype_term_reference USING btree (phenotype_id);
Date: 2026-05-27 21:40:33 Duration: 0ms
47 5 261.06 MiB 51.33 MiB 53.42 MiB 52.21 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-05-27 21:42:53 Duration: 0ms
48 5 1.67 GiB 330.68 MiB 355.23 MiB 341.54 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-05-27 21:42:36 Duration: 16s482ms
-
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-05-27 21:42:36 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 1.00 GiB SELECT * FROM pgbulkload.pg_bulkload ($1);[ Date: 2026-05-27 15:23:13 - 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-05-27 18:45: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-05-27 18:45: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-05-27 18:45:20 ]
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-05-27 18:45:20 ]
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-05-27 18:45:20 ]
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-05-27 18:45:20 ]
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-05-27 18:45: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-05-27 18:45: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-05-27 18:45: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-05-27 18:45: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-05-27 18:45: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-05-27 18:45: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-05-27 18:45: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-05-27 18:45: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-05-27 18:45: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-05-27 18:45: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-05-27 18:45:21 ]
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-05-27 18:45:21 ]
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-05-27 18:45:21 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 74.46 sec Highest CPU-cost vacuum
Table pub1.gene_go_annot
Database ctdprd51 - 2026-05-27 17:06:23 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 74.46 sec Highest CPU-cost vacuum
Table pub1.gene_go_annot
Database ctdprd51 - 2026-05-27 17:06:23 Date
Analyzes per table
Key values
- pubc.log_query (16) Main table analyzed (database ctdprd51)
- 99 analyzes Total
Table Number of analyzes ctdprd51.pubc.log_query 16 ctdprd51.pg_catalog.pg_class 5 ctdprd51.pg_catalog.pg_constraint 3 ctdprd51.pg_catalog.pg_index 3 ctdprd51.pg_catalog.pg_trigger 3 ctdprd51.pg_catalog.pg_depend 3 ctdprd51.pg_catalog.pg_attribute 3 ctdprd51.edit.list_db_report 2 ctdprd51.edit.db_report 2 ctdprd51.edit.chem_conc_uom 2 ctdprd51.pub1.db 2 ctdprd51.pg_catalog.pg_shdepend 2 ctdprd51.pg_catalog.pg_attrdef 2 ctdprd51.edit.db 2 ctdprd51.edit.db_link 2 ctdprd51.edit.action_type 2 ctdprd51.edit.country 2 ctdprd51.edit.action_type_path 2 ctdprd51.edit.action_degree 2 ctdprd51.pg_catalog.pg_type 2 ctdprd51.edit.db_report_site 2 ctdprd51.pub1.term 2 ctdprd51.pg_catalog.pg_description 2 ctdprd51.edit.term_label_type 1 ctdprd51.pub1.term_label 1 ctdprd51.pub1.reference 1 ctdprd51.pub1.reference_party_role 1 ctdprd51.edit.chem_conc_exp_route 1 postgres.pg_catalog.pg_shdepend 1 ctdprd51.edit.reference_db_link 1 ctdprd51.edit.slim_term 1 ctdprd51.edit.receptor 1 ctdprd51.pg_catalog.pg_proc 1 ctdprd51.edit.race 1 ctdprd51.pub1.gene_taxon 1 ctdprd51.pub1.db_report_site 1 ctdprd51.edit.geographic_region 1 ctdprd51.pub1.dag_edge 1 ctdprd51.pub1.chem_conc_anatomy 1 ctdprd51.pub1.dag_node 1 ctdprd51.pub2.term_set_enrichment_agent 1 ctdprd51.pub1.db_report 1 ctdprd51.pub1.action_type 1 ctdprd51.pub1.list_db_report 1 ctdprd51.edit.action_degree_type 1 ctdprd51.pub1.img 1 ctdprd51.pub1.db_link 1 ctdprd51.pub1.gene_go_annot 1 ctdprd51.edit.object_note 1 ctdprd51.load.data_load 1 ctdprd51.pub1.chem_conc 1 ctdprd51.pub1.reference_party 1 ctdprd51.pub2.term_set_enrichment 1 ctdprd51.pub1.term_pathway 1 Total 99 Vacuums per table
Key values
- pg_catalog.pg_class (4) Main table vacuumed on database ctdprd51
- 57 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes ctdprd51.pg_catalog.pg_class 4 4 1,483 0 145 0 13 629 136 514,496 ctdprd51.pg_catalog.pg_attribute 3 3 1,978 0 135 0 133 912 129 661,320 ctdprd51.pg_catalog.pg_trigger 2 2 711 0 58 0 0 281 62 271,943 ctdprd51.pg_catalog.pg_constraint 2 2 575 0 62 0 0 232 58 204,769 ctdprd51.pg_catalog.pg_index 2 2 356 0 35 0 0 181 31 175,622 ctdprd51.pubc.log_query 2 1 418 0 42 0 0 112 28 217,073 ctdprd51.pub1.term 2 0 136,407 0 5 0 0 48,000 3 2,852,006 ctdprd51.edit.action_degree 2 0 93 0 0 0 0 24 2 18,902 ctdprd51.edit.action_type_path 2 0 99 0 0 0 0 8 2 18,118 ctdprd51.edit.country 2 0 129 0 0 0 0 16 2 19,254 ctdprd51.edit.db_link 2 0 15,426 0 6 0 0 7,454 2 456,576 ctdprd51.pub1.db 1 1 149 0 13 0 0 20 10 34,623 ctdprd51.pub1.gene_taxon 1 0 182,602 0 6 0 0 91,241 4 5,411,164 ctdprd51.pg_catalog.pg_shdepend 1 1 218 0 14 0 0 94 12 53,121 ctdprd51.edit.race 1 0 57 0 1 0 0 3 1 8,837 ctdprd51.pg_catalog.pg_attrdef 1 1 87 0 5 0 0 19 3 14,711 ctdprd51.pg_toast.pg_toast_2619 1 1 5,742 0 946 0 10,013 4,570 887 608,868 ctdprd51.edit.receptor 1 0 43 0 1 0 0 2 1 8,502 ctdprd51.pg_toast.pg_toast_11410220 1 0 90,580 0 4 0 0 45,282 2 2,688,161 ctdprd51.pg_catalog.pg_statistic 1 1 846 0 66 0 117 635 64 189,527 ctdprd51.pg_catalog.pg_depend 1 1 833 0 90 0 65 381 96 343,833 postgres.pg_catalog.pg_shdepend 1 1 227 0 21 0 0 104 18 58,458 ctdprd51.edit.study_factor 1 0 57 0 5 0 0 3 2 16,683 ctdprd51.edit.reference_db_link 1 0 5,801 0 1,682 0 0 3,727 1 228,219 ctdprd51.edit.term_label_type 1 0 59 0 2 0 0 3 2 11,573 ctdprd51.edit.list_db_report 1 0 54 0 1 0 0 7 1 9,345 ctdprd51.pub1.reference_party_role 1 0 13,758 0 4 0 0 6,852 1 412,687 ctdprd51.pub1.reference 1 0 78,904 0 5 0 0 39,342 3 2,342,170 ctdprd51.pub1.term_label 1 0 234,357 0 7 0 0 117,124 5 6,947,078 ctdprd51.pub1.chem_conc 1 0 617 0 3 0 0 294 1 25,765 ctdprd51.pub1.reference_party 1 0 5,161 0 4 0 0 2,547 2 162,624 ctdprd51.pub1.term_pathway 1 0 3,331 0 4 0 0 1,614 2 107,397 ctdprd51.pg_catalog.pg_description 1 1 242 0 27 0 42 119 21 100,611 ctdprd51.pub1.db_link 1 0 326,634 0 152,061 0 0 163,190 6 9,675,665 ctdprd51.pub1.gene_go_annot 1 0 684,658 0 313,617 0 0 342,207 12 20,283,734 ctdprd51.pg_catalog.pg_type 1 1 160 0 8 0 0 74 8 23,437 ctdprd51.pub1.img 1 0 1,108 0 4 0 0 524 2 42,467 ctdprd51.edit.evidence 1 0 32 0 2 0 0 3 2 15,475 ctdprd51.pub1.chem_conc_anatomy 1 0 431 0 3 0 0 186 1 19,393 ctdprd51.edit.db 1 0 93 0 2 0 0 17 2 12,112 ctdprd51.pub1.dag_edge 1 0 1,024 0 5 0 0 482 2 41,037 ctdprd51.pub1.dag_node 1 0 86,882 0 4,201 0 0 43,298 3 2,574,410 ctdprd51.edit.action_type 1 0 174 0 2 0 0 7 2 14,521 Total 57 23 1,882,596 2,792 473,304 0 10,383 921,820 1,634 57,896,287 Tuples removed per table
Key values
- pg_toast.pg_toast_2619 (5761) Main table with removed tuples on database ctdprd51
- 20917 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain ctdprd51.pg_toast.pg_toast_2619 1 1 5,761 20,100 0 0 12,592 ctdprd51.pg_catalog.pg_attribute 3 3 3,617 27,600 0 0 708 ctdprd51.pg_catalog.pg_depend 1 1 3,496 13,731 0 0 153 ctdprd51.pg_catalog.pg_trigger 2 2 1,380 3,060 0 0 116 ctdprd51.pg_catalog.pg_statistic 1 1 919 2,781 0 0 410 ctdprd51.pg_catalog.pg_class 4 4 842 7,535 0 0 376 ctdprd51.pg_catalog.pg_description 1 1 836 5,354 0 0 90 ctdprd51.pg_catalog.pg_shdepend 1 1 731 2,119 0 0 22 postgres.pg_catalog.pg_shdepend 1 1 696 2,119 0 0 22 ctdprd51.pg_catalog.pg_constraint 2 2 482 1,623 0 4 79 ctdprd51.pg_catalog.pg_index 2 2 449 2,374 0 0 78 ctdprd51.edit.country 2 0 326 498 0 0 8 ctdprd51.pg_catalog.pg_type 1 1 222 1,169 0 0 35 ctdprd51.edit.action_type_path 2 0 212 212 0 0 4 ctdprd51.edit.action_degree 2 0 192 438 0 0 12 ctdprd51.pub1.db 1 1 134 134 0 0 7 ctdprd51.edit.list_db_report 1 0 92 183 0 0 3 ctdprd51.edit.db 1 0 91 134 0 0 8 ctdprd51.edit.race 1 0 81 27 0 0 1 ctdprd51.edit.receptor 1 0 64 16 0 0 1 ctdprd51.edit.action_type 1 0 64 60 0 0 3 ctdprd51.edit.study_factor 1 0 60 11 0 0 1 ctdprd51.edit.term_label_type 1 0 59 39 0 0 1 ctdprd51.edit.evidence 1 0 54 18 0 0 1 ctdprd51.pg_catalog.pg_attrdef 1 1 44 238 0 0 11 ctdprd51.pubc.log_query 2 1 13 1,449 0 0 51 ctdprd51.pub1.gene_taxon 1 0 0 14,324,653 0 0 91,240 ctdprd51.pg_toast.pg_toast_11410220 1 0 0 244,753 0 0 45,281 ctdprd51.edit.reference_db_link 1 0 0 334,267 0 0 3,726 ctdprd51.pub1.reference_party_role 1 0 0 1,267,402 0 0 6,851 ctdprd51.pub1.reference 1 0 0 202,534 0 0 39,341 ctdprd51.pub1.term_label 1 0 0 8,039,651 0 0 117,123 ctdprd51.pub1.term 2 0 0 2,253,274 0 0 72,498 ctdprd51.pub1.chem_conc 1 0 0 9,118 0 0 293 ctdprd51.pub1.reference_party 1 0 0 455,842 0 0 2,546 ctdprd51.pub1.term_pathway 1 0 0 135,792 0 0 1,613 ctdprd51.pub1.db_link 1 0 0 22,507,987 0 0 163,189 ctdprd51.pub1.gene_go_annot 1 0 0 53,727,540 0 0 342,206 ctdprd51.pub1.img 1 0 0 50,650 0 0 523 ctdprd51.pub1.chem_conc_anatomy 1 0 0 19,683 0 0 185 ctdprd51.pub1.dag_edge 1 0 0 88,931 0 0 481 ctdprd51.edit.db_link 2 0 0 668,534 0 0 7,452 ctdprd51.pub1.dag_node 1 0 0 1,812,211 0 0 43,297 Total 57 23 20,917 106,235,844 0 4 952,638 Pages removed per table
Key values
- pg_catalog.pg_constraint (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_constraint 2 2 482 4 ctdprd51.pub1.db 1 1 134 0 ctdprd51.pub1.gene_taxon 1 0 0 0 ctdprd51.pg_catalog.pg_shdepend 1 1 731 0 ctdprd51.edit.race 1 0 81 0 ctdprd51.pg_catalog.pg_attrdef 1 1 44 0 ctdprd51.pg_toast.pg_toast_2619 1 1 5761 0 ctdprd51.pg_catalog.pg_trigger 2 2 1380 0 ctdprd51.edit.receptor 1 0 64 0 ctdprd51.pg_toast.pg_toast_11410220 1 0 0 0 ctdprd51.pg_catalog.pg_statistic 1 1 919 0 ctdprd51.pg_catalog.pg_depend 1 1 3496 0 postgres.pg_catalog.pg_shdepend 1 1 696 0 ctdprd51.edit.study_factor 1 0 60 0 ctdprd51.pg_catalog.pg_index 2 2 449 0 ctdprd51.edit.reference_db_link 1 0 0 0 ctdprd51.edit.term_label_type 1 0 59 0 ctdprd51.edit.list_db_report 1 0 92 0 ctdprd51.pub1.reference_party_role 1 0 0 0 ctdprd51.pubc.log_query 2 1 13 0 ctdprd51.pg_catalog.pg_class 4 4 842 0 ctdprd51.pub1.reference 1 0 0 0 ctdprd51.pub1.term_label 1 0 0 0 ctdprd51.pub1.term 2 0 0 0 ctdprd51.pub1.chem_conc 1 0 0 0 ctdprd51.pub1.reference_party 1 0 0 0 ctdprd51.pub1.term_pathway 1 0 0 0 ctdprd51.pg_catalog.pg_description 1 1 836 0 ctdprd51.edit.action_degree 2 0 192 0 ctdprd51.pub1.db_link 1 0 0 0 ctdprd51.pub1.gene_go_annot 1 0 0 0 ctdprd51.pg_catalog.pg_type 1 1 222 0 ctdprd51.pub1.img 1 0 0 0 ctdprd51.edit.evidence 1 0 54 0 ctdprd51.edit.action_type_path 2 0 212 0 ctdprd51.pg_catalog.pg_attribute 3 3 3617 0 ctdprd51.edit.country 2 0 326 0 ctdprd51.pub1.chem_conc_anatomy 1 0 0 0 ctdprd51.edit.db 1 0 91 0 ctdprd51.pub1.dag_edge 1 0 0 0 ctdprd51.edit.db_link 2 0 0 0 ctdprd51.pub1.dag_node 1 0 0 0 ctdprd51.edit.action_type 1 0 64 0 Total 57 23 20,917 4 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 27 00 1 0 01 0 1 02 0 1 03 0 3 04 0 2 05 0 2 06 1 3 07 0 1 08 0 0 09 0 0 10 10 15 11 3 1 12 0 1 13 24 41 14 0 0 15 0 2 16 6 12 17 12 11 18 0 0 19 0 0 20 0 0 21 0 2 22 0 1 23 0 0 - 74.46 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 172 Total read queries
- 83 Total write queries
Queries by database
Key values
- unknown Main database
- 153 Requests
- 4h31m8s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 183 Requests
User Request type Count Duration edit Total 1 9s151ms insert 1 9s151ms editeu Total 1 10s368ms select 1 10s368ms load Total 25 1h3m50s insert 1 9s170ms select 24 1h3m41s postgres Total 16 17m22s copy to 16 17m22s pub1 Total 3 17m3s ddl 1 5s682ms insert 1 16m48s select 1 8s925ms pubc Total 1 9m17s select 1 9m17s pubeu Total 76 11m47s cte 8 1m8s select 68 10m39s qaeu Total 2 11s83ms select 2 11s83ms unknown Total 183 17h39m31s copy to 55 11m43s cte 2 20s468ms ddl 25 26m17s insert 9 44m16s others 5 3m17s select 87 16h13m34s Duration by user
Key values
- 17h39m31s (unknown) Main time consuming user
User Request type Count Duration edit Total 1 9s151ms insert 1 9s151ms editeu Total 1 10s368ms select 1 10s368ms load Total 25 1h3m50s insert 1 9s170ms select 24 1h3m41s postgres Total 16 17m22s copy to 16 17m22s pub1 Total 3 17m3s ddl 1 5s682ms insert 1 16m48s select 1 8s925ms pubc Total 1 9m17s select 1 9m17s pubeu Total 76 11m47s cte 8 1m8s select 68 10m39s qaeu Total 2 11s83ms select 2 11s83ms unknown Total 183 17h39m31s copy to 55 11m43s cte 2 20s468ms ddl 25 26m17s insert 9 44m16s others 5 3m17s select 87 16h13m34s Queries by host
Key values
- unknown Main host
- 308 Requests
- 19h39m23s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 230 Requests
- 5h47m35s (unknown)
- Main time consuming application
Application Request type Count Duration pgAdmin 4 - CONN:3363897 Total 1 9s151ms insert 1 9s151ms pgAdmin 4 - CONN:6899138 Total 1 9s170ms insert 1 9s170ms pg_bulkload Total 18 15m12s select 18 15m12s pg_dump Total 8 8m35s copy to 8 8m35s psql Total 2 9m22s ddl 1 5s682ms select 1 9m17s unknown Total 230 5h47m35s copy to 27 5m47s cte 10 1m29s ddl 25 26m17s insert 10 1h1m4s others 5 3m17s select 153 4h9m38s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-27 19:14:05 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 162 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 1h6m17s 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-05-27 20:46:25 - Bind query: yes ]
2 50m24s 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-05-27 19:40:01 - Bind query: yes ]
3 35m11s 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-05-27 17:48:54 - Database: ctdprd51 - User: load - Bind query: yes ]
4 29m16s 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-05-27 17:04:13 - Bind query: yes ]
5 16m48s 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-05-27 16:28:34 - Database: ctdprd51 - User: pub1 - Bind query: yes ]
6 12m14s 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-05-27 18:03:59 - Database: ctdprd51 - User: load - Bind query: yes ]
7 9m17s /* * 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-05-27 00:09:19 - Database: ctdprd51 - User: pubc - Application: psql ]
8 7m30s 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-05-27 21:15:04 - Database: ctdprd51 - User: load - Application: pg_bulkload - Bind query: yes ]
9 5m39s 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-05-27 21:01:02 - Bind query: yes ]
10 5m21s 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-05-27 21:52:16 - Bind query: yes ]
11 5m21s 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-05-27 14:11:01 - Bind query: yes ]
12 5m3s 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-05-27 17:09:16 - Bind query: yes ]
13 4m4s 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-05-27 16:34:56 - Bind query: yes ]
14 4m3s 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-05-27 21:23:07 - Bind query: yes ]
15 3m44s 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-05-27 20:55:22 - Bind query: yes ]
16 3m9s 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-05-27 15:35:35 - Bind query: yes ]
17 2m58s CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);[ Date: 2026-05-27 21:40:04 - Bind query: yes ]
18 2m55s 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-05-27 23:55:44 - Database: ctdprd51 - User: load - Application: pg_bulkload - Bind query: yes ]
19 2m33s ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);[ Date: 2026-05-27 21:19:03 - Bind query: yes ]
20 2m23s 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-05-27 21:04:33 - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h21m44s 12 13s383ms 1h6m17s 6m48s 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 May 27 20 9 1h15m13s 8m21s 21 3 6m30s 2m10s -
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-05-27 20:46:25 Duration: 1h6m17s Bind query: yes
-
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-05-27 21:01:02 Duration: 5m39s Bind query: yes
-
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-05-27 20:55:22 Duration: 3m44s Bind query: yes
2 1h1m7s 70 5s256ms 7m30s 52s392ms select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 27 13 18 2m33s 8s552ms 14 26 23m21s 53s908ms 15 5 10m25s 2m5s 17 3 1m8s 22s935ms 21 6 15m36s 2m36s 22 1 33s660ms 33s660ms 23 11 7m27s 40s705ms [ User: load - Total duration: 15m12s - Times executed: 18 ]
[ Application: pg_bulkload - Total duration: 15m12s - Times executed: 18 ]
-
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-05-27 21:15:04 Duration: 7m30s 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-05-27 21:52:16 Duration: 5m21s 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-05-27 14:11:01 Duration: 5m21s Bind query: yes
3 50m24s 1 50m24s 50m24s 50m24s 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 May 27 19 1 50m24s 50m24s -
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-05-27 19:40:01 Duration: 50m24s Bind query: yes
4 35m11s 1 35m11s 35m11s 35m11s 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 May 27 17 1 35m11s 35m11s [ User: load - Total duration: 35m11s - 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-05-27 17:48:54 Duration: 35m11s Database: ctdprd51 User: load Bind query: yes
5 29m16s 1 29m16s 29m16s 29m16s 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 May 27 17 1 29m16s 29m16s -
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-05-27 17:04:13 Duration: 29m16s Bind query: yes
6 16m48s 1 16m48s 16m48s 16m48s 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 May 27 16 1 16m48s 16m48s [ User: pub1 - Total duration: 16m48s - 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-05-27 16:28:34 Duration: 16m48s Database: ctdprd51 User: pub1 Bind query: yes
7 16m9s 5 55s884ms 12m14s 3m13s 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 #7
Day Hour Count Duration Avg duration May 27 18 5 16m9s 3m13s [ User: load - Total duration: 12m14s - 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-05-27 18:03:59 Duration: 12m14s 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-05-27 18:23:20 Duration: 1m2s 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-05-27 18:29:41 Duration: 59s254ms Bind query: yes
8 9m17s 1 9m17s 9m17s 9m17s select maint_query_logs_archive ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 27 00 1 9m17s 9m17s [ User: pubc - Total duration: 9m17s - Times executed: 1 ]
[ Application: psql - Total duration: 9m17s - 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-05-27 00:09:19 Duration: 9m17s Database: ctdprd51 User: pubc Application: psql
9 7m30s 4 1m51s 1m53s 1m52s 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 #9
Day Hour Count Duration Avg duration May 27 06 1 1m51s 1m51s 10 1 1m52s 1m52s 14 1 1m53s 1m53s 18 1 1m52s 1m52s [ User: postgres - Total duration: 7m30s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m30s - 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-05-27 14:06:55 Duration: 1m53s 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-05-27 10:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-05-27 18:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
10 6m55s 34 7s607ms 1m12s 12s219ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 27 03 1 8s97ms 8s97ms 06 32 6m39s 12s490ms 07 1 7s694ms 7s694ms [ User: pubeu - Total duration: 5m11s - Times executed: 29 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2134012') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-05-27 06:42:51 Duration: 1m12s Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2134012') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-05-27 06:27:28 Duration: 27s975ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2134012') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-05-27 06:27:16 Duration: 15s459ms Database: ctdprd51 User: pubeu Bind query: yes
11 5m3s 1 5m3s 5m3s 5m3s 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 May 27 17 1 5m3s 5m3s -
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-05-27 17:09:16 Duration: 5m3s Bind query: yes
12 4m4s 1 4m4s 4m4s 4m4s 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 May 27 16 1 4m4s 4m4s -
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-05-27 16:34:56 Duration: 4m4s Bind query: yes
13 4m3s 1 4m3s 4m3s 4m3s 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 May 27 21 1 4m3s 4m3s -
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-05-27 21:23:07 Duration: 4m3s 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-05-27 21:23:06 Duration: 0ms
14 3m29s 12 7s149ms 39s706ms 17s470ms 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 in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_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 order by sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 27 03 12 3m29s 17s470ms [ User: pubeu - Total duration: 2m6s - Times executed: 9 ]
-
SELECT /* BatchChemGODAO */ 'titanium' "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 in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 1446734)) 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 ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-05-27 03:44:03 Duration: 39s706ms Bind query: yes
-
SELECT /* BatchChemGODAO */ 'nickel' "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 in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 1439685)) 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 ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-05-27 03:43:02 Duration: 32s976ms Bind query: yes
-
SELECT /* BatchChemGODAO */ 'cadmium' "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 in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 1354795)) 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 ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-05-27 03:41:16 Duration: 29s12ms Database: ctdprd51 User: pubeu Bind query: yes
15 2m58s 1 2m58s 2m58s 2m58s 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 May 27 21 1 2m58s 2m58s -
CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);
Date: 2026-05-27 21:40:04 Duration: 2m58s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);
Date: 2026-05-27 21:40:03 Duration: 0ms
16 2m33s 1 2m33s 2m33s 2m33s alter table pub1.gene_disease_reference add constraint gene_disease_reference_pk primary key (id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 27 21 1 2m33s 2m33s -
ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-05-27 21:19:03 Duration: 2m33s Bind query: yes
-
ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-05-27 21:19:03 Duration: 0ms Database: ctdprd51 User: pub1
17 2m23s 1 2m23s 2m23s 2m23s 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 #17
Day Hour Count Duration Avg duration May 27 21 1 2m23s 2m23s -
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-05-27 21:04:33 Duration: 2m23s Bind query: yes
18 2m23s 1 2m23s 2m23s 2m23s vacuum full analyze db_link;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 27 16 1 2m23s 2m23s -
vacuum FULL analyze db_link;
Date: 2026-05-27 16:07:22 Duration: 2m23s
-
vacuum FULL analyze db_link;
Date: 2026-05-27 16:05:26 Duration: 0ms
19 2m22s 1 2m22s 2m22s 2m22s create index ix_gene_disease_ref_dis_gene on pub1.gene_disease_reference using btree (disease_id, gene_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 27 21 1 2m22s 2m22s -
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-05-27 21:33:31 Duration: 2m22s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-05-27 21:33:30 Duration: 0ms
20 2m6s 1 2m6s 2m6s 2m6s 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 #20
Day Hour Count Duration Avg duration May 27 16 1 2m6s 2m6s -
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-05-27 16:30:51 Duration: 2m6s Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 70 1h1m7s 5s256ms 7m30s 52s392ms select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 27 13 18 2m33s 8s552ms 14 26 23m21s 53s908ms 15 5 10m25s 2m5s 17 3 1m8s 22s935ms 21 6 15m36s 2m36s 22 1 33s660ms 33s660ms 23 11 7m27s 40s705ms [ User: load - Total duration: 15m12s - Times executed: 18 ]
[ Application: pg_bulkload - Total duration: 15m12s - Times executed: 18 ]
-
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-05-27 21:15:04 Duration: 7m30s 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-05-27 21:52:16 Duration: 5m21s 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-05-27 14:11:01 Duration: 5m21s Bind query: yes
2 34 6m55s 7s607ms 1m12s 12s219ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 27 03 1 8s97ms 8s97ms 06 32 6m39s 12s490ms 07 1 7s694ms 7s694ms [ User: pubeu - Total duration: 5m11s - Times executed: 29 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2134012') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-05-27 06:42:51 Duration: 1m12s Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2134012') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-05-27 06:27:28 Duration: 27s975ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2134012') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-05-27 06:27:16 Duration: 15s459ms Database: ctdprd51 User: pubeu Bind query: yes
3 12 1h21m44s 13s383ms 1h6m17s 6m48s 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 #3
Day Hour Count Duration Avg duration May 27 20 9 1h15m13s 8m21s 21 3 6m30s 2m10s -
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-05-27 20:46:25 Duration: 1h6m17s Bind query: yes
-
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-05-27 21:01:02 Duration: 5m39s Bind query: yes
-
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-05-27 20:55:22 Duration: 3m44s Bind query: yes
4 12 3m29s 7s149ms 39s706ms 17s470ms 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 in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_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 order by sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 27 03 12 3m29s 17s470ms [ User: pubeu - Total duration: 2m6s - Times executed: 9 ]
-
SELECT /* BatchChemGODAO */ 'titanium' "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 in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 1446734)) 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 ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-05-27 03:44:03 Duration: 39s706ms Bind query: yes
-
SELECT /* BatchChemGODAO */ 'nickel' "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 in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 1439685)) 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 ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-05-27 03:43:02 Duration: 32s976ms Bind query: yes
-
SELECT /* BatchChemGODAO */ 'cadmium' "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 in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 1354795)) 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 ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-05-27 03:41:16 Duration: 29s12ms Database: ctdprd51 User: pubeu Bind query: yes
5 10 1m29s 5s906ms 14s523ms 8s919ms with sq as ( select distinct gcr.gene_id, gcr.chem_id from gene_chem_reference gcr where gcr.chem_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id = ?)) select ? "Input", c.nm "ChemicalName", c.acc_txt "ChemicalID", c.secondary_nm "CasRN", tp.pathway_nm "PathwayName", tp.pathway_acc_db_cd || ? || tp.pathway_acc_txt "PathwayID", g.nm "InferenceGeneSymbol" from term c inner join sq on c.id = sq.chem_id inner join term g on sq.gene_id = g.id inner join term_pathway tp on g.id = tp.term_id order by c.nm_sort, g.nm_sort, upper(tp.pathway_nm);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 27 03 10 1m29s 8s919ms [ User: pubeu - Total duration: 1m8s - Times executed: 8 ]
-
WITH sq AS ( SELECT DISTINCT gcr.gene_id, gcr.chem_id FROM gene_chem_reference gcr WHERE gcr.chem_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 1366644)) SELECT /* BatchChemPathwaysDAO */ 'd001555' "Input", c.nm "ChemicalName", c.acc_txt "ChemicalID", c.secondary_nm "CasRN", tp.pathway_nm "PathwayName", tp.pathway_acc_db_cd || ':' || tp.pathway_acc_txt "PathwayID", g.nm "InferenceGeneSymbol" FROM term c INNER JOIN sq ON c.id = sq.chem_id INNER JOIN term g ON sq.gene_id = g.id INNER JOIN term_pathway tp ON g.id = tp.term_id ORDER BY c.nm_sort, g.nm_sort, UPPER(tp.pathway_nm);
Date: 2026-05-27 03:36:14 Duration: 14s523ms Bind query: yes
-
WITH sq AS ( SELECT DISTINCT gcr.gene_id, gcr.chem_id FROM gene_chem_reference gcr WHERE gcr.chem_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 1366644)) SELECT /* BatchChemPathwaysDAO */ 'd001555' "Input", c.nm "ChemicalName", c.acc_txt "ChemicalID", c.secondary_nm "CasRN", tp.pathway_nm "PathwayName", tp.pathway_acc_db_cd || ':' || tp.pathway_acc_txt "PathwayID", g.nm "InferenceGeneSymbol" FROM term c INNER JOIN sq ON c.id = sq.chem_id INNER JOIN term g ON sq.gene_id = g.id INNER JOIN term_pathway tp ON g.id = tp.term_id ORDER BY c.nm_sort, g.nm_sort, UPPER(tp.pathway_nm);
Date: 2026-05-27 03:26:28 Duration: 14s363ms Database: ctdprd51 User: pubeu Bind query: yes
-
WITH sq AS ( SELECT DISTINCT gcr.gene_id, gcr.chem_id FROM gene_chem_reference gcr WHERE gcr.chem_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 1354311)) SELECT /* BatchChemPathwaysDAO */ 'd002264' "Input", c.nm "ChemicalName", c.acc_txt "ChemicalID", c.secondary_nm "CasRN", tp.pathway_nm "PathwayName", tp.pathway_acc_db_cd || ':' || tp.pathway_acc_txt "PathwayID", g.nm "InferenceGeneSymbol" FROM term c INNER JOIN sq ON c.id = sq.chem_id INNER JOIN term g ON sq.gene_id = g.id INNER JOIN term_pathway tp ON g.id = tp.term_id ORDER BY c.nm_sort, g.nm_sort, UPPER(tp.pathway_nm);
Date: 2026-05-27 03:38:46 Duration: 11s889ms Database: ctdprd51 User: pubeu Bind query: yes
6 5 16m9s 55s884ms 12m14s 3m13s 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 #6
Day Hour Count Duration Avg duration May 27 18 5 16m9s 3m13s [ User: load - Total duration: 12m14s - 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-05-27 18:03:59 Duration: 12m14s 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-05-27 18:23:20 Duration: 1m2s 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-05-27 18:29:41 Duration: 59s254ms Bind query: yes
7 4 7m30s 1m51s 1m53s 1m52s 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 #7
Day Hour Count Duration Avg duration May 27 06 1 1m51s 1m51s 10 1 1m52s 1m52s 14 1 1m53s 1m53s 18 1 1m52s 1m52s [ User: postgres - Total duration: 7m30s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m30s - 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-05-27 14:06:55 Duration: 1m53s 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-05-27 10:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-05-27 18:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
8 4 1m36s 23s966ms 24s183ms 24s82ms 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 #8
Day Hour Count Duration Avg duration May 27 06 1 24s57ms 24s57ms 10 1 24s123ms 24s123ms 14 1 24s183ms 24s183ms 18 1 23s966ms 23s966ms -
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-05-27 14:07:19 Duration: 24s183ms
-
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-05-27 10:07:18 Duration: 24s123ms
-
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-05-27 06:07:18 Duration: 24s57ms
9 4 1m2s 15s456ms 15s559ms 15s503ms 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 #9
Day Hour Count Duration Avg duration May 27 06 1 15s526ms 15s526ms 10 1 15s456ms 15s456ms 14 1 15s559ms 15s559ms 18 1 15s473ms 15s473ms -
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-05-27 14:07:35 Duration: 15s559ms
-
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-05-27 06:07:33 Duration: 15s526ms
-
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-05-27 18:07:33 Duration: 15s473ms
10 4 58s694ms 14s649ms 14s701ms 14s673ms 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 #10
Day Hour Count Duration Avg duration May 27 06 1 14s652ms 14s652ms 10 1 14s649ms 14s649ms 14 1 14s690ms 14s690ms 18 1 14s701ms 14s701ms -
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-05-27 18:00:52 Duration: 14s701ms
-
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-05-27 14:00:34 Duration: 14s690ms
-
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-05-27 06:00:51 Duration: 14s652ms
11 4 57s940ms 14s444ms 14s600ms 14s485ms 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 #11
Day Hour Count Duration Avg duration May 27 06 1 14s450ms 14s450ms 10 1 14s444ms 14s444ms 14 1 14s445ms 14s445ms 18 1 14s600ms 14s600ms -
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-05-27 18:01:06 Duration: 14s600ms
-
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-05-27 06:01:06 Duration: 14s450ms
-
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-05-27 14:00:49 Duration: 14s445ms
12 4 38s173ms 5s249ms 18s546ms 9s543ms select coalesce(st.alt_nm, t.nm) slimtermnm, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.curated_reference_qty > ?) curatedcount, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.indirect_gene_qty > ?) inferredcount from slim_term st inner join term t on st.slim_term_id = t.id where st.slim_id = ? order by ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 27 14 2 27s510ms 13s755ms 21 1 5s412ms 5s412ms 23 1 5s249ms 5s249ms [ User: pubeu - Total duration: 38s173ms - Times executed: 4 ]
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1437042') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1437042') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-05-27 14:39:19 Duration: 18s546ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1475221') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1475221') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-05-27 14:38:28 Duration: 8s963ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1470340') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1470340') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-05-27 21:37:50 Duration: 5s412ms Database: ctdprd51 User: pubeu Bind query: yes
13 4 29s438ms 7s335ms 7s381ms 7s359ms 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 #13
Day Hour Count Duration Avg duration May 27 06 1 7s335ms 7s335ms 10 1 7s381ms 7s381ms 14 1 7s366ms 7s366ms 18 1 7s355ms 7s355ms [ User: postgres - Total duration: 7s366ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7s366ms - Times executed: 1 ]
-
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-05-27 10:00:31 Duration: 7s381ms
-
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-05-27 14:00:13 Duration: 7s366ms Database: ctdprd51 User: postgres Application: pg_dump
-
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-05-27 18:00:31 Duration: 7s355ms
14 4 25s806ms 6s398ms 6s525ms 6s451ms 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 #14
Day Hour Count Duration Avg duration May 27 06 1 6s456ms 6s456ms 10 1 6s525ms 6s525ms 14 1 6s425ms 6s425ms 18 1 6s398ms 6s398ms -
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-05-27 10:01:15 Duration: 6s525ms
-
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-05-27 06:01:14 Duration: 6s456ms
-
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-05-27 14:00:57 Duration: 6s425ms
15 4 24s693ms 6s166ms 6s179ms 6s173ms select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ?) union select ?, r.id from reference r where r.title_abstract_fts @@ to_tsquery(?, ?) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 27 11 4 24s693ms 6s173ms [ User: pubeu - Total duration: 24s693ms - Times executed: 4 ]
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'CID_167753199') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CID_167753199') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CID_167753199')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'CID_167753199')) ii GROUP BY ii.cd;
Date: 2026-05-27 11:06:32 Duration: 6s179ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'CID_167753199') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CID_167753199') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CID_167753199')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'CID_167753199')) ii GROUP BY ii.cd;
Date: 2026-05-27 11:06:29 Duration: 6s175ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'CID_167752679') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CID_167752679') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CID_167752679')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'CID_167752679')) ii GROUP BY ii.cd;
Date: 2026-05-27 11:15:45 Duration: 6s171ms Database: ctdprd51 User: pubeu Bind query: yes
16 4 24s368ms 6s79ms 6s99ms 6s92ms 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 #16
Day Hour Count Duration Avg duration May 27 06 1 6s96ms 6s96ms 10 1 6s79ms 6s79ms 14 1 6s92ms 6s92ms 18 1 6s99ms 6s99ms -
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-05-27 18:00:37 Duration: 6s99ms
-
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-05-27 06:00:37 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-05-27 14:00:19 Duration: 6s92ms
17 4 22s983ms 5s497ms 6s214ms 5s745ms 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 #17
Day Hour Count Duration Avg duration May 27 05 2 11s148ms 5s574ms 06 2 11s834ms 5s917ms [ User: pubeu - Total duration: 17s486ms - Times executed: 3 ]
[ User: qaeu - Total duration: 5s497ms - 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 = 1339298)) 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-05-27 06:51:10 Duration: 6s214ms Database: ctdprd51 User: pubeu 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 = 1339298)) 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-05-27 05:48:47 Duration: 5s651ms Database: ctdprd51 User: pubeu 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 = 1339298)) 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-05-27 06:37:01 Duration: 5s619ms Database: ctdprd51 User: pubeu Bind query: yes
18 4 21s736ms 5s24ms 6s229ms 5s434ms select d.abbr dagabbr, d.nm dagnm, gt.level_min_no daglevelmin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pvalcorrected, te.raw_p_val pvalraw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, count(*) over () fullrowcount from term_enrichment te inner join dag_node gt on te.enriched_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where te.term_id = ? and te.enriched_object_type_id = ? order by te.corrected_p_val, d.abbr, gt.nm_sort limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 27 04 2 10s470ms 5s235ms 06 1 6s229ms 6s229ms 09 1 5s35ms 5s35ms [ User: pubeu - Total duration: 21s736ms - Times executed: 4 ]
-
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 = '1405237' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-05-27 06:45:09 Duration: 6s229ms 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 = '1423264' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-05-27 04:03:30 Duration: 5s446ms 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 = '1399440' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-05-27 09:34:47 Duration: 5s35ms Database: ctdprd51 User: pubeu Bind query: yes
19 3 58s190ms 19s244ms 19s534ms 19s396ms 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 #19
Day Hour Count Duration Avg duration May 27 06 1 19s244ms 19s244ms 10 1 19s534ms 19s534ms 18 1 19s411ms 19s411ms [ User: postgres - Total duration: 58s190ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 58s190ms - Times executed: 3 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-05-27 10:00:21 Duration: 19s534ms 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-05-27 18:00:21 Duration: 19s411ms 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-05-27 06:00:21 Duration: 19s244ms Database: ctdprd51 User: postgres Application: pg_dump
20 2 18s322ms 9s151ms 9s170ms 9s161ms insert into edit.db_link select * from edit.reference_db_link;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 27 13 2 18s322ms 9s161ms [ User: load - Total duration: 9s170ms - Times executed: 1 ]
[ User: edit - Total duration: 9s151ms - Times executed: 1 ]
[ Application: pgAdmin 4 - CONN:6899138 - Total duration: 9s170ms - Times executed: 1 ]
[ Application: pgAdmin 4 - CONN:3363897 - Total duration: 9s151ms - Times executed: 1 ]
-
insert into edit.db_link select * from edit.reference_db_link;
Date: 2026-05-27 13:27:37 Duration: 9s170ms Database: ctdprd51 User: load Application: pgAdmin 4 - CONN:6899138
-
insert into edit.db_link select * from edit.reference_db_link;
Date: 2026-05-27 13:01:54 Duration: 9s151ms Database: ctdprd51 User: edit Application: pgAdmin 4 - CONN:3363897
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 50m24s 50m24s 50m24s 1 50m24s 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 #1
Day Hour Count Duration Avg duration May 27 19 1 50m24s 50m24s -
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-05-27 19:40:01 Duration: 50m24s Bind query: yes
2 35m11s 35m11s 35m11s 1 35m11s 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 #2
Day Hour Count Duration Avg duration May 27 17 1 35m11s 35m11s [ User: load - Total duration: 35m11s - 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-05-27 17:48:54 Duration: 35m11s Database: ctdprd51 User: load Bind query: yes
3 29m16s 29m16s 29m16s 1 29m16s 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 #3
Day Hour Count Duration Avg duration May 27 17 1 29m16s 29m16s -
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-05-27 17:04:13 Duration: 29m16s Bind query: yes
4 16m48s 16m48s 16m48s 1 16m48s 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 #4
Day Hour Count Duration Avg duration May 27 16 1 16m48s 16m48s [ User: pub1 - Total duration: 16m48s - 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-05-27 16:28:34 Duration: 16m48s Database: ctdprd51 User: pub1 Bind query: yes
5 9m17s 9m17s 9m17s 1 9m17s select maint_query_logs_archive ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 27 00 1 9m17s 9m17s [ User: pubc - Total duration: 9m17s - Times executed: 1 ]
[ Application: psql - Total duration: 9m17s - 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-05-27 00:09:19 Duration: 9m17s Database: ctdprd51 User: pubc Application: psql
6 13s383ms 1h6m17s 6m48s 12 1h21m44s 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 #6
Day Hour Count Duration Avg duration May 27 20 9 1h15m13s 8m21s 21 3 6m30s 2m10s -
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-05-27 20:46:25 Duration: 1h6m17s Bind query: yes
-
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-05-27 21:01:02 Duration: 5m39s Bind query: yes
-
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-05-27 20:55:22 Duration: 3m44s Bind query: yes
7 5m3s 5m3s 5m3s 1 5m3s 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 #7
Day Hour Count Duration Avg duration May 27 17 1 5m3s 5m3s -
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-05-27 17:09:16 Duration: 5m3s Bind query: yes
8 4m4s 4m4s 4m4s 1 4m4s 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 #8
Day Hour Count Duration Avg duration May 27 16 1 4m4s 4m4s -
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-05-27 16:34:56 Duration: 4m4s Bind query: yes
9 4m3s 4m3s 4m3s 1 4m3s 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 #9
Day Hour Count Duration Avg duration May 27 21 1 4m3s 4m3s -
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-05-27 21:23:07 Duration: 4m3s 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-05-27 21:23:06 Duration: 0ms
10 55s884ms 12m14s 3m13s 5 16m9s 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 #10
Day Hour Count Duration Avg duration May 27 18 5 16m9s 3m13s [ User: load - Total duration: 12m14s - 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-05-27 18:03:59 Duration: 12m14s 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-05-27 18:23:20 Duration: 1m2s 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-05-27 18:29:41 Duration: 59s254ms Bind query: yes
11 2m58s 2m58s 2m58s 1 2m58s create index ix_gene_disease_ref_net_sc on pub1.gene_disease_reference using btree (network_score);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 27 21 1 2m58s 2m58s -
CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);
Date: 2026-05-27 21:40:04 Duration: 2m58s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);
Date: 2026-05-27 21:40:03 Duration: 0ms
12 2m33s 2m33s 2m33s 1 2m33s alter table pub1.gene_disease_reference add constraint gene_disease_reference_pk primary key (id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 27 21 1 2m33s 2m33s -
ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-05-27 21:19:03 Duration: 2m33s Bind query: yes
-
ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-05-27 21:19:03 Duration: 0ms Database: ctdprd51 User: pub1
13 2m23s 2m23s 2m23s 1 2m23s 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 #13
Day Hour Count Duration Avg duration May 27 21 1 2m23s 2m23s -
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-05-27 21:04:33 Duration: 2m23s Bind query: yes
14 2m23s 2m23s 2m23s 1 2m23s vacuum full analyze db_link;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 27 16 1 2m23s 2m23s -
vacuum FULL analyze db_link;
Date: 2026-05-27 16:07:22 Duration: 2m23s
-
vacuum FULL analyze db_link;
Date: 2026-05-27 16:05:26 Duration: 0ms
15 2m22s 2m22s 2m22s 1 2m22s 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 May 27 21 1 2m22s 2m22s -
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-05-27 21:33:31 Duration: 2m22s Bind query: yes
-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-05-27 21:33:30 Duration: 0ms
16 2m6s 2m6s 2m6s 1 2m6s 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 #16
Day Hour Count Duration Avg duration May 27 16 1 2m6s 2m6s -
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-05-27 16:30:51 Duration: 2m6s Bind query: yes
17 1m51s 1m53s 1m52s 4 7m30s 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 #17
Day Hour Count Duration Avg duration May 27 06 1 1m51s 1m51s 10 1 1m52s 1m52s 14 1 1m53s 1m53s 18 1 1m52s 1m52s [ User: postgres - Total duration: 7m30s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m30s - 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-05-27 14:06:55 Duration: 1m53s 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-05-27 10:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-05-27 18:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
18 5s256ms 7m30s 52s392ms 70 1h1m7s select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 27 13 18 2m33s 8s552ms 14 26 23m21s 53s908ms 15 5 10m25s 2m5s 17 3 1m8s 22s935ms 21 6 15m36s 2m36s 22 1 33s660ms 33s660ms 23 11 7m27s 40s705ms [ User: load - Total duration: 15m12s - Times executed: 18 ]
[ Application: pg_bulkload - Total duration: 15m12s - Times executed: 18 ]
-
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-05-27 21:15:04 Duration: 7m30s 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-05-27 21:52:16 Duration: 5m21s 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-05-27 14:11:01 Duration: 5m21s Bind query: yes
19 23s966ms 24s183ms 24s82ms 4 1m36s 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 #19
Day Hour Count Duration Avg duration May 27 06 1 24s57ms 24s57ms 10 1 24s123ms 24s123ms 14 1 24s183ms 24s183ms 18 1 23s966ms 23s966ms -
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-05-27 14:07:19 Duration: 24s183ms
-
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-05-27 10:07:18 Duration: 24s123ms
-
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-05-27 06:07:18 Duration: 24s57ms
20 19s244ms 19s534ms 19s396ms 3 58s190ms 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 #20
Day Hour Count Duration Avg duration May 27 06 1 19s244ms 19s244ms 10 1 19s534ms 19s534ms 18 1 19s411ms 19s411ms [ User: postgres - Total duration: 58s190ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 58s190ms - Times executed: 3 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-05-27 10:00:21 Duration: 19s534ms 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-05-27 18:00:21 Duration: 19s411ms 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-05-27 06:00:21 Duration: 19s244ms Database: ctdprd51 User: postgres Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 14,638 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 2 FATAL entries
- 3 ERROR entries
- 2 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3 Max number of times the same event was reported
- 11 Total events found
Rank Times reported Error 1 3 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #1
Day Hour Count May 27 06 3 2 1 ERROR: function get_ixn_prose(...) does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count May 27 13 1 - ERROR: function get_ixn_prose(integer) does not exist at character 66
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select reference_acc_txt ,taxon_acc_txt ,pubTerm.nm ,get_ixn_prose( ixn_id ) ,create_by ,create_tm from edit.reference_ixn ri ,pub2.term pubTerm -- set to CURRENT PRODUCTION PUB!!!!! where taxon_acc_txt not in ( select acc_txt from load.term where object_type_id = ( select id from edit.object_type where cd = 'taxon' ) ) and pubTerm.acc_txt = ri.taxon_acc_txt and object_type_id = ( select id from edit.object_type where cd = 'taxon' ) and taxon_acc_txt is not null and taxon_acc_txt <> ''Date: 2026-05-27 13:41:09
3 1 WARNING: Maximum parse error count exceeded - 1 error(...) found in input file
Times Reported Most Frequent Error / Event #3
Day Hour Count May 27 13 1 4 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #4
Day Hour Count May 27 21 1 5 1 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #5
Day Hour Count May 27 21 1 6 1 ERROR: value too long for type character varying(...)
Times Reported Most Frequent Error / Event #6
Day Hour Count May 27 02 1 - ERROR: value too long for type character varying(256)
Statement: INSERT /* AdvancedQueryDAO.logQuery */ INTO pubc.log_query (type_cd ,query_tm ,submission_qty ,session_id ,server_nm ,node_nm ,remote_addr ,http_user_agent ,results_qty ,execution_ms ,gene_txt ,taxon_txt ,chem_txt ,acc_txt ,party_nm_txt ,gene_query_type ,taxon_query_type ,chem_query_type ,party_query_type ,action_type_txt ,pathway_txt ,pathway_query_type ,gene_form_type_txt ,action_degree_type_txt,go_txt ,go_query_type ,disease_txt ,disease_query_type ,gd_assn_type ,from_yr ,through_yr ,title_abstract_txt ,review_status ) VALUES ($1 ,CURRENT_TIMESTAMP ,1 ,$2 ,$3 ,NULLIF($4,'') ,SUBSTR($5,1,128) ,NULLIF(SUBSTR($6,1,256),'') ,$7 ,NULLIF($8,-1) ,NULLIF($9,'') ,NULLIF($10,'') ,NULLIF($11,'') ,NULLIF(SUBSTR($12,1,4000),'') ,NULLIF($13,'') ,NULLIF($14,'') ,NULLIF($15,'') ,NULLIF($16,'') ,NULLIF($17,'') ,NULLIF(SUBSTR($18,1,4000),'') ,NULLIF(SUBSTR($19,1,4000),'') ,NULLIF(SUBSTR($20,1,4000),'') ,NULLIF(SUBSTR($21,1,4000),'') ,NULLIF(SUBSTR($22,1,4000),'') ,NULLIF($23,'') ,NULLIF($24,'') ,NULLIF(SUBSTR($25,1,4000),'') ,NULLIF($26,'') ,NULLIF($27,'') ,NULLIF($28,0) ,NULLIF($29,0) ,NULLIF($30,'') ,NULLIF($31,'') ) RETURNING id
Date: 2026-05-27 02:51:41 Database: ctdprd51 Application: User: pubeu Remote:
7 1 FATAL: canceling authentication due to timeout
Times Reported Most Frequent Error / Event #7
Day Hour Count May 27 06 1 8 1 ERROR: canceling statement due to user request
Times Reported Most Frequent Error / Event #8
Day Hour Count May 27 21 1 - ERROR: canceling statement due to user request
Statement: SELECT row_to_json(T) FROM ( WITH values AS ( SELECT 4096/(ceil(pg_settings.setting::numeric/1024/1024))::int AS segment_parts_count, setting::bigint AS segment_size, ('x' || substring(pg_stat_archiver.last_archived_wal from 9 for 8))::bit(32)::int AS last_wal_div, ('x' || substring(pg_stat_archiver.last_archived_wal from 17 for 8))::bit(32)::int AS last_wal_mod, CASE WHEN pg_is_in_recovery() THEN NULL ELSE ('x' || substring(pg_walfile_name(pg_current_wal_lsn()) from 9 for 8))::bit(32)::int END AS current_wal_div, CASE WHEN pg_is_in_recovery() THEN NULL ELSE ('x' || substring(pg_walfile_name(pg_current_wal_lsn()) from 17 for 8))::bit(32)::int END AS current_wal_mod FROM pg_settings, pg_stat_archiver WHERE pg_settings.name = 'wal_segment_size') SELECT greatest(coalesce((segment_parts_count - last_wal_mod) + ((current_wal_div - last_wal_div - 1) * segment_parts_count) + current_wal_mod - 1, 0), 0) AS count_files, greatest(coalesce(((segment_parts_count - last_wal_mod) + ((current_wal_div - last_wal_div - 1) * segment_parts_count) + current_wal_mod - 1) * segment_size, 0), 0) AS size_files FROM values ) T;
Date: 2026-05-27 21:17:09
9 1 WARNING: Parse error Record 1: Input Record 216393: Rejected - column 4. missing data for column "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count May 27 13 1