pgBadger-
Global information
- Generated on Sat Jul 4 04:15:04 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260703
- Parsed 15,399 log entries in 3s
- Log start from 2026-07-03 00:00:01 to 2026-07-03 23:59:40
-
Overview
Global Stats
- 16 Number of unique normalized queries
- 47 Number of queries
- 28m50s Total query duration
- 2026-07-03 00:09:23 First query
- 2026-07-03 23:42:21 Last query
- 1 queries/s at 2026-07-03 14:07:34 Query peak
- 28m50s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 28m50s Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 3 Total number of automatic vacuums
- 20 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,874 Total number of sessions
- 52 sessions at 2026-07-03 03:41:41 Session peak
- 39d23h33m9s Total duration of sessions
- 30m43s Average duration of sessions
- 0 Average queries per session
- 923ms Average queries duration per session
- 30m42s Average idle time per session
- 1,874 Total number of connections
- 9 connections/s at 2026-07-03 05:40:08 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-03 14:07:34 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-03 22:30:42 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-03 14:07:34 Date
Queries duration
Key values
- 28m50s 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) Jul 03 00 2 0ms 9m21s 4m44s 0ms 0ms 9m28s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 1 0ms 6s335ms 6s335ms 0ms 0ms 6s335ms 04 1 0ms 6s373ms 6s373ms 0ms 0ms 6s373ms 05 2 0ms 5s390ms 5s352ms 0ms 0ms 5s390ms 06 10 0ms 1m52s 23s243ms 10s711ms 39s773ms 1m52s 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 9 0ms 1m52s 24s608ms 21s20ms 48s715ms 1m52s 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 1 0ms 5s107ms 5s107ms 0ms 0ms 5s107ms 14 9 0ms 1m52s 24s637ms 21s156ms 48s511ms 1m52s 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 9 0ms 1m51s 24s546ms 21s26ms 48s267ms 1m51s 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 1 0ms 3m34s 3m34s 0ms 0ms 3m34s 23 2 0ms 11s445ms 11s417ms 0ms 0ms 22s834ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 03 00 1 0 9m21s 0ms 0ms 9m21s 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 6s335ms 0ms 0ms 6s335ms 04 1 0 6s373ms 0ms 0ms 6s373ms 05 2 0 5s352ms 0ms 0ms 5s390ms 06 1 9 23s243ms 0ms 10s711ms 1m52s 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 9 24s608ms 0ms 21s20ms 1m52s 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 1 0 5s107ms 0ms 0ms 5s107ms 14 0 9 24s637ms 0ms 21s156ms 1m52s 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 9 24s546ms 0ms 21s26ms 1m51s 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 1 0 3m34s 0ms 0ms 3m34s 23 2 0 11s417ms 0ms 0ms 22s834ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 03 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 03 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 1 1.00 0.00% 05 0 2 2.00 0.00% 06 0 1 1.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 1 1.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 1 1.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Jul 03 00 75 0.02/s 01 78 0.02/s 02 75 0.02/s 03 73 0.02/s 04 81 0.02/s 05 96 0.03/s 06 78 0.02/s 07 70 0.02/s 08 81 0.02/s 09 72 0.02/s 10 81 0.02/s 11 81 0.02/s 12 75 0.02/s 13 77 0.02/s 14 75 0.02/s 15 78 0.02/s 16 75 0.02/s 17 89 0.02/s 18 78 0.02/s 19 79 0.02/s 20 76 0.02/s 21 78 0.02/s 22 78 0.02/s 23 75 0.02/s Day Hour Count Average Duration Average idle time Jul 03 00 75 31m2s 30m54s 01 78 31m19s 31m19s 02 75 31m11s 31m11s 03 73 31m14s 31m14s 04 81 29m25s 29m25s 05 96 25m59s 25m59s 06 78 30m4s 30m1s 07 70 32m53s 32m53s 08 81 29m35s 29m35s 09 72 32m20s 32m20s 10 81 30m47s 30m44s 11 81 30m15s 30m15s 12 75 32m13s 32m13s 13 77 31m54s 31m54s 14 75 30m16s 30m13s 15 78 31m36s 31m36s 16 75 31m37s 31m37s 17 89 28m15s 28m15s 18 78 30m52s 30m49s 19 79 30m53s 30m53s 20 76 31m34s 31m34s 21 78 31m13s 31m13s 22 78 31m24s 31m21s 23 75 31m23s 31m23s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-07-03 05:40:08 Date
Connections per database
Key values
- ctdprd51 Main Database
- 1,874 connections Total
Connections per user
Key values
- pubeu Main User
- 1,874 connections Total
-
Sessions
Simultaneous sessions
Key values
- 52 sessions Session Peak
- 2026-07-03 03:41:41 Date
Histogram of session times
Key values
- 1,751 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 1,874 sessions Total
Sessions per user
Key values
- pubeu Main User
- 1,874 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 1,874 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 6,762 buffers Checkpoint Peak
- 2026-07-03 09:54:30 Date
- 676.846 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-03 23:13:22 Date
Checkpoints distance
Key values
- 144.03 Mo Distance Peak
- 2026-07-03 09:54:30 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 03 00 1,738 174.159s 0.003s 174.212s 01 232 23.42s 0.002s 23.428s 02 273 27.507s 0.002s 27.516s 03 230 23.215s 0.002s 23.223s 04 263 26.507s 0.002s 26.515s 05 366 36.826s 0.002s 36.835s 06 763 76.614s 0.002s 76.623s 07 688 69.085s 0.002s 69.094s 08 551 55.254s 0.002s 55.263s 09 6,989 699.666s 0.002s 699.724s 10 518 52.101s 0.002s 52.11s 11 43 4.503s 0.002s 4.512s 12 51 5.306s 0.002s 5.316s 13 496 49.846s 0.002s 49.856s 14 55 5.686s 0.002s 5.715s 15 24 2.599s 0.002s 2.608s 16 22 2.374s 0.002s 2.383s 17 29 3.09s 0.002s 3.101s 18 25 2.603s 0.001s 2.608s 19 0 0s 0s 0s 20 99 10.075s 0.002s 10.083s 21 241 24.296s 0.002s 24.305s 22 285 28.625s 0.002s 28.635s 23 119 12.105s 0.002s 12.114s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 03 00 0 1 0 76 0.001s 0.002s 01 0 0 0 27 0.001s 0.002s 02 0 0 0 33 0.001s 0.002s 03 0 0 0 26 0.001s 0.002s 04 0 0 0 28 0.001s 0.002s 05 0 0 0 30 0.001s 0.002s 06 0 0 0 125 0.001s 0.002s 07 0 0 0 107 0.001s 0.002s 08 0 0 0 76 0.001s 0.002s 09 0 5 0 125 0.001s 0.002s 10 0 0 0 124 0.001s 0.002s 11 0 0 0 18 0.001s 0.002s 12 0 0 0 19 0.001s 0.002s 13 0 0 0 37 0.001s 0.002s 14 0 0 0 24 0.001s 0.002s 15 0 0 0 16 0.001s 0.002s 16 0 0 0 15 0.001s 0.002s 17 0 0 0 21 0.001s 0.002s 18 0 0 0 9 0.001s 0.001s 19 0 0 0 0 0s 0s 20 0 0 0 18 0.001s 0.002s 21 0 0 0 28 0.001s 0.002s 22 0 0 0 29 0.001s 0.002s 23 0 0 0 22 0.001s 0.002s Day Hour Count Avg time (sec) Jul 03 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 Jul 03 00 7,342.50 kB 88,946.00 kB 01 173.50 kB 72,598.50 kB 02 353.50 kB 58,869.50 kB 03 180.00 kB 47,732.50 kB 04 202.50 kB 38,688.00 kB 05 259.50 kB 31,396.50 kB 06 857.00 kB 25,573.00 kB 07 760.50 kB 20,851.00 kB 08 1,063.00 kB 17,053.50 kB 09 37,248.50 kB 44,218.50 kB 10 1,311.50 kB 63,259.00 kB 11 68.50 kB 51,292.00 kB 12 81.00 kB 41,561.00 kB 13 1,609.00 kB 33,971.50 kB 14 71.50 kB 27,530.00 kB 15 34.00 kB 22,307.50 kB 16 32.00 kB 18,075.00 kB 17 29.50 kB 14,646.50 kB 18 23.00 kB 12,492.00 kB 19 0.00 kB 0.00 kB 20 34.00 kB 10,684.50 kB 21 388.00 kB 8,699.00 kB 22 520.50 kB 7,169.00 kB 23 101.50 kB 5,828.50 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.02 sec Highest CPU-cost vacuum
Table pub2.term_set_enrichment
Database ctdprd51 - 2026-07-03 09:43:17 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 0.02 sec Highest CPU-cost vacuum
Table pub2.term_set_enrichment
Database ctdprd51 - 2026-07-03 09:43:17 Date
Analyzes per table
Key values
- pubc.log_query (18) Main table analyzed (database ctdprd51)
- 20 analyzes Total
Vacuums per table
Key values
- pubc.log_query (2) Main table vacuumed on database ctdprd51
- 3 vacuums Total
Tuples removed per table
Key values
- pubc.log_query (14) Main table with removed tuples on database ctdprd51
- 14 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 03 00 0 1 01 0 2 02 0 2 03 0 0 04 0 1 05 1 3 06 0 0 07 0 0 08 0 6 09 1 1 10 0 0 11 0 0 12 0 0 13 0 1 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 1 1 22 0 2 23 0 0 - 0.02 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
- 10 Total read queries
- 36 Total write queries
Queries by database
Key values
- unknown Main database
- 29 Requests
- 22m47s (ctdprd51)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 70 Requests
User Request type Count Duration load Total 2 11m1s ddl 1 8m10s select 1 2m50s postgres Total 16 17m38s copy to 16 17m38s pubc Total 1 9m21s select 1 9m21s pubeu Total 45 10m54s select 45 10m54s unknown Total 70 15m11s copy to 56 11m52s others 1 6s686ms select 13 3m11s Duration by user
Key values
- 17m38s (postgres) Main time consuming user
User Request type Count Duration load Total 2 11m1s ddl 1 8m10s select 1 2m50s postgres Total 16 17m38s copy to 16 17m38s pubc Total 1 9m21s select 1 9m21s pubeu Total 45 10m54s select 45 10m54s unknown Total 70 15m11s copy to 56 11m52s others 1 6s686ms select 13 3m11s Queries by host
Key values
- unknown Main host
- 134 Requests
- 1h4m7s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 38 Requests
- 10m39s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-03 05:02:01 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 29 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 9m21s /* * 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-07-03 00:09:23 - Database: ctdprd51 - User: pubc - Application: psql ]
2 3m34s 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', '二、你现在先下载 & 4 & 个数据库 & 1. & CTD & 搜索： & TRICLOSAN & 下载 & (CHEMICAL-GENE | CHEMICALGENE) & INTERACTIONS，物种选 & HOMO & SAPIENS。保存为： & CTD_TRICLOSAN_CHEMICAL_GENE.CSV & CTD & 是最重要的，必须有。 & 2. & CHEMBL & 搜索 & COMPOUND： & TRICLOSAN & 找到 & COMPOUND & 后看 & TARGET & / & BIOACTIVITY & 信息，导出 & TARGET & 相关表。保存为： & CHEMBL_TRICLOSAN_TARGETS.CSV & 如果你暂时不会导出，可以先跳过，后面补。 & 3. & STITCH & 搜索： & TRICLOSAN & 物种选择： & HOMO & SAPIENS & 下载 & PROTEIN & INTERACTION & / & TARGET & TABLE。保存为： & STITCH_TRICLOSAN.TSV & 4. & SWISSTARGETPREDICTION & 输入 & TRICLOSAN & 的 & SMILES。TRICLOSAN & 的 & SMILES & 可以用： & OC1CC & CL & CCC1OC2CCC & CL & CC2CL & 物种选择：') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', '二、你现在先下载 & 4 & 个数据库 & 1. & CTD & 搜索： & TRICLOSAN & 下载 & (CHEMICAL-GENE | CHEMICALGENE) & INTERACTIONS，物种选 & HOMO & SAPIENS。保存为： & CTD_TRICLOSAN_CHEMICAL_GENE.CSV & CTD & 是最重要的，必须有。 & 2. & CHEMBL & 搜索 & COMPOUND： & TRICLOSAN & 找到 & COMPOUND & 后看 & TARGET & / & BIOACTIVITY & 信息，导出 & TARGET & 相关表。保存为： & CHEMBL_TRICLOSAN_TARGETS.CSV & 如果你暂时不会导出，可以先跳过，后面补。 & 3. & STITCH & 搜索： & TRICLOSAN & 物种选择： & HOMO & SAPIENS & 下载 & PROTEIN & INTERACTION & / & TARGET & TABLE。保存为： & STITCH_TRICLOSAN.TSV & 4. & SWISSTARGETPREDICTION & 输入 & TRICLOSAN & 的 & SMILES。TRICLOSAN & 的 & SMILES & 可以用： & OC1CC & CL & CCC1OC2CCC & CL & CC2CL & 物种选择：') 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 '二、你现在先下载' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '个数据库' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '搜索：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '下载' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(CHEMICAL-GENE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEMICALGENE)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INTERACTIONS，物种选' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HOMO' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SAPIENS。保存为：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD_TRICLOSAN_CHEMICAL_GENE.CSV' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '是最重要的，必须有。' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '2.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEMBL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '搜索' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COMPOUND：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '找到' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COMPOUND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '后看' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TARGET' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '/' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BIOACTIVITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '信息，导出' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TARGET' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '相关表。保存为：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEMBL_TRICLOSAN_TARGETS.CSV' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '如果你暂时不会导出，可以先跳过，后面补。' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STITCH' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '搜索：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '物种选择：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HOMO' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SAPIENS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '下载' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PROTEIN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INTERACTION' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '/' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TARGET' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TABLE。保存为：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STITCH_TRICLOSAN.TSV' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '4.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SWISSTARGETPREDICTION' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '输入' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '的' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SMILES。TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '的' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SMILES' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '可以用：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OC1CC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CCC1OC2CCC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CC2CL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) 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 = 'A' AND (upper(l.acc_txt) LIKE '二、你现在先下载' OR upper(l.acc_txt) LIKE '4' OR upper(l.acc_txt) LIKE '个数据库' OR upper(l.acc_txt) LIKE '1.' OR upper(l.acc_txt) LIKE 'CTD' OR upper(l.acc_txt) LIKE '搜索：' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '下载' OR upper(l.acc_txt) LIKE 'CHEMICAL-GENE' OR upper(l.acc_txt) LIKE 'INTERACTIONS，物种选' OR upper(l.acc_txt) LIKE 'HOMO' OR upper(l.acc_txt) LIKE 'SAPIENS。保存为：' OR upper(l.acc_txt) LIKE 'CTD_TRICLOSAN_CHEMICAL_GENE.CSV' OR upper(l.acc_txt) LIKE 'CTD' OR upper(l.acc_txt) LIKE '是最重要的，必须有。' OR upper(l.acc_txt) LIKE '2.' OR upper(l.acc_txt) LIKE 'CHEMBL' OR upper(l.acc_txt) LIKE '搜索' OR upper(l.acc_txt) LIKE 'COMPOUND：' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '找到' OR upper(l.acc_txt) LIKE 'COMPOUND' OR upper(l.acc_txt) LIKE '后看' OR upper(l.acc_txt) LIKE 'TARGET' OR upper(l.acc_txt) LIKE '/' OR upper(l.acc_txt) LIKE 'BIOACTIVITY' OR upper(l.acc_txt) LIKE '信息，导出' OR upper(l.acc_txt) LIKE 'TARGET' OR upper(l.acc_txt) LIKE '相关表。保存为：' OR upper(l.acc_txt) LIKE 'CHEMBL_TRICLOSAN_TARGETS.CSV' OR upper(l.acc_txt) LIKE '如果你暂时不会导出，可以先跳过，后面补。' OR upper(l.acc_txt) LIKE '3.' OR upper(l.acc_txt) LIKE 'STITCH' OR upper(l.acc_txt) LIKE '搜索：' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '物种选择：' OR upper(l.acc_txt) LIKE 'HOMO' OR upper(l.acc_txt) LIKE 'SAPIENS' OR upper(l.acc_txt) LIKE '下载' OR upper(l.acc_txt) LIKE 'PROTEIN' OR upper(l.acc_txt) LIKE 'INTERACTION' OR upper(l.acc_txt) LIKE '/' OR upper(l.acc_txt) LIKE 'TARGET' OR upper(l.acc_txt) LIKE 'TABLE。保存为：' OR upper(l.acc_txt) LIKE 'STITCH_TRICLOSAN.TSV' OR upper(l.acc_txt) LIKE '4.' OR upper(l.acc_txt) LIKE 'SWISSTARGETPREDICTION' OR upper(l.acc_txt) LIKE '输入' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '的' OR upper(l.acc_txt) LIKE 'SMILES。TRICLOSAN' OR upper(l.acc_txt) LIKE '的' OR upper(l.acc_txt) LIKE 'SMILES' OR upper(l.acc_txt) LIKE '可以用：' OR upper(l.acc_txt) LIKE 'OC1CC' OR upper(l.acc_txt) LIKE 'CL' OR upper(l.acc_txt) LIKE 'CCC1OC2CCC' OR upper(l.acc_txt) LIKE 'CL' OR upper(l.acc_txt) LIKE 'CC2CL' OR upper(l.acc_txt) LIKE '物种选择：')) ii GROUP BY ii.cd;[ Date: 2026-07-03 22:30:42 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
3 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;[ Date: 2026-07-03 14:06:54 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
4 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;[ Date: 2026-07-03 06:06:54 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
5 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;[ Date: 2026-07-03 10:06:54 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
6 1m51s COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;[ Date: 2026-07-03 18:06:53 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
7 24s293ms 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-07-03 06:07:18 ]
8 24s109ms 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-07-03 14:07:18 ]
9 24s79ms 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-07-03 18:07:17 ]
10 24s40ms 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-07-03 10:07:18 ]
11 20s158ms 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-07-03 10:00:22 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
12 20s69ms 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-07-03 14:00:21 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
13 20s23ms 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-07-03 06:00:21 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
14 19s881ms 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-07-03 18:00:21 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
15 15s555ms 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-07-03 18:07:33 ]
16 15s479ms 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-07-03 06:07:34 ]
17 15s469ms 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-07-03 14:07:34 ]
18 15s405ms 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-07-03 10:07:34 ]
19 14s923ms 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-07-03 10:00:53 ]
20 14s848ms 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-07-03 06:00:52 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 9m21s 1 9m21s 9m21s 9m21s select maint_query_logs_archive ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 03 00 1 9m21s 9m21s [ User: pubc - Total duration: 9m21s - Times executed: 1 ]
[ Application: psql - Total duration: 9m21s - 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-07-03 00:09:23 Duration: 9m21s Database: ctdprd51 User: pubc Application: psql
2 7m29s 4 1m51s 1m52s 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 #2
Day Hour Count Duration Avg duration Jul 03 06 1 1m52s 1m52s 10 1 1m52s 1m52s 14 1 1m52s 1m52s 18 1 1m51s 1m51s [ User: postgres - Total duration: 7m29s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m29s - 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-07-03 14:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-03 06: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-07-03 10:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
3 3m34s 1 3m34s 3m34s 3m34s select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ?) union select ?, r.id from reference r where r.title_abstract_fts @@ to_tsquery(?, ?) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 03 22 1 3m34s 3m34s [ User: pubeu - Total duration: 3m34s - Times executed: 1 ]
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', '二、你现在先下载 & 4 & 个数据库 & 1. & CTD & 搜索： & TRICLOSAN & 下载 & (CHEMICAL-GENE | CHEMICALGENE) & INTERACTIONS，物种选 & HOMO & SAPIENS。保存为： & CTD_TRICLOSAN_CHEMICAL_GENE.CSV & CTD & 是最重要的，必须有。 & 2. & CHEMBL & 搜索 & COMPOUND： & TRICLOSAN & 找到 & COMPOUND & 后看 & TARGET & / & BIOACTIVITY & 信息，导出 & TARGET & 相关表。保存为： & CHEMBL_TRICLOSAN_TARGETS.CSV & 如果你暂时不会导出，可以先跳过，后面补。 & 3. & STITCH & 搜索： & TRICLOSAN & 物种选择： & HOMO & SAPIENS & 下载 & PROTEIN & INTERACTION & / & TARGET & TABLE。保存为： & STITCH_TRICLOSAN.TSV & 4. & SWISSTARGETPREDICTION & 输入 & TRICLOSAN & 的 & SMILES。TRICLOSAN & 的 & SMILES & 可以用： & OC1CC & CL & CCC1OC2CCC & CL & CC2CL & 物种选择：') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', '二、你现在先下载 & 4 & 个数据库 & 1. & CTD & 搜索： & TRICLOSAN & 下载 & (CHEMICAL-GENE | CHEMICALGENE) & INTERACTIONS，物种选 & HOMO & SAPIENS。保存为： & CTD_TRICLOSAN_CHEMICAL_GENE.CSV & CTD & 是最重要的，必须有。 & 2. & CHEMBL & 搜索 & COMPOUND： & TRICLOSAN & 找到 & COMPOUND & 后看 & TARGET & / & BIOACTIVITY & 信息，导出 & TARGET & 相关表。保存为： & CHEMBL_TRICLOSAN_TARGETS.CSV & 如果你暂时不会导出，可以先跳过，后面补。 & 3. & STITCH & 搜索： & TRICLOSAN & 物种选择： & HOMO & SAPIENS & 下载 & PROTEIN & INTERACTION & / & TARGET & TABLE。保存为： & STITCH_TRICLOSAN.TSV & 4. & SWISSTARGETPREDICTION & 输入 & TRICLOSAN & 的 & SMILES。TRICLOSAN & 的 & SMILES & 可以用： & OC1CC & CL & CCC1OC2CCC & CL & CC2CL & 物种选择：') 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 '二、你现在先下载' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '个数据库' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '搜索：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '下载' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(CHEMICAL-GENE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEMICALGENE)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INTERACTIONS，物种选' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HOMO' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SAPIENS。保存为：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD_TRICLOSAN_CHEMICAL_GENE.CSV' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '是最重要的，必须有。' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '2.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEMBL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '搜索' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COMPOUND：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '找到' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COMPOUND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '后看' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TARGET' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '/' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BIOACTIVITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '信息，导出' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TARGET' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '相关表。保存为：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEMBL_TRICLOSAN_TARGETS.CSV' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '如果你暂时不会导出，可以先跳过，后面补。' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STITCH' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '搜索：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '物种选择：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HOMO' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SAPIENS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '下载' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PROTEIN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INTERACTION' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '/' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TARGET' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TABLE。保存为：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STITCH_TRICLOSAN.TSV' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '4.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SWISSTARGETPREDICTION' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '输入' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '的' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SMILES。TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '的' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SMILES' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '可以用：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OC1CC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CCC1OC2CCC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CC2CL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) 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 = 'A' AND (upper(l.acc_txt) LIKE '二、你现在先下载' OR upper(l.acc_txt) LIKE '4' OR upper(l.acc_txt) LIKE '个数据库' OR upper(l.acc_txt) LIKE '1.' OR upper(l.acc_txt) LIKE 'CTD' OR upper(l.acc_txt) LIKE '搜索：' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '下载' OR upper(l.acc_txt) LIKE 'CHEMICAL-GENE' OR upper(l.acc_txt) LIKE 'INTERACTIONS，物种选' OR upper(l.acc_txt) LIKE 'HOMO' OR upper(l.acc_txt) LIKE 'SAPIENS。保存为：' OR upper(l.acc_txt) LIKE 'CTD_TRICLOSAN_CHEMICAL_GENE.CSV' OR upper(l.acc_txt) LIKE 'CTD' OR upper(l.acc_txt) LIKE '是最重要的，必须有。' OR upper(l.acc_txt) LIKE '2.' OR upper(l.acc_txt) LIKE 'CHEMBL' OR upper(l.acc_txt) LIKE '搜索' OR upper(l.acc_txt) LIKE 'COMPOUND：' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '找到' OR upper(l.acc_txt) LIKE 'COMPOUND' OR upper(l.acc_txt) LIKE '后看' OR upper(l.acc_txt) LIKE 'TARGET' OR upper(l.acc_txt) LIKE '/' OR upper(l.acc_txt) LIKE 'BIOACTIVITY' OR upper(l.acc_txt) LIKE '信息，导出' OR upper(l.acc_txt) LIKE 'TARGET' OR upper(l.acc_txt) LIKE '相关表。保存为：' OR upper(l.acc_txt) LIKE 'CHEMBL_TRICLOSAN_TARGETS.CSV' OR upper(l.acc_txt) LIKE '如果你暂时不会导出，可以先跳过，后面补。' OR upper(l.acc_txt) LIKE '3.' OR upper(l.acc_txt) LIKE 'STITCH' OR upper(l.acc_txt) LIKE '搜索：' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '物种选择：' OR upper(l.acc_txt) LIKE 'HOMO' OR upper(l.acc_txt) LIKE 'SAPIENS' OR upper(l.acc_txt) LIKE '下载' OR upper(l.acc_txt) LIKE 'PROTEIN' OR upper(l.acc_txt) LIKE 'INTERACTION' OR upper(l.acc_txt) LIKE '/' OR upper(l.acc_txt) LIKE 'TARGET' OR upper(l.acc_txt) LIKE 'TABLE。保存为：' OR upper(l.acc_txt) LIKE 'STITCH_TRICLOSAN.TSV' OR upper(l.acc_txt) LIKE '4.' OR upper(l.acc_txt) LIKE 'SWISSTARGETPREDICTION' OR upper(l.acc_txt) LIKE '输入' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '的' OR upper(l.acc_txt) LIKE 'SMILES。TRICLOSAN' OR upper(l.acc_txt) LIKE '的' OR upper(l.acc_txt) LIKE 'SMILES' OR upper(l.acc_txt) LIKE '可以用：' OR upper(l.acc_txt) LIKE 'OC1CC' OR upper(l.acc_txt) LIKE 'CL' OR upper(l.acc_txt) LIKE 'CCC1OC2CCC' OR upper(l.acc_txt) LIKE 'CL' OR upper(l.acc_txt) LIKE 'CC2CL' OR upper(l.acc_txt) LIKE '物种选择：')) ii GROUP BY ii.cd;
Date: 2026-07-03 22:30:42 Duration: 3m34s Database: ctdprd51 User: pubeu Bind query: yes
4 1m36s 4 24s40ms 24s293ms 24s130ms 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 #4
Day Hour Count Duration Avg duration Jul 03 06 1 24s293ms 24s293ms 10 1 24s40ms 24s40ms 14 1 24s109ms 24s109ms 18 1 24s79ms 24s79ms -
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-07-03 06:07:18 Duration: 24s293ms
-
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-07-03 14:07:18 Duration: 24s109ms
-
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-07-03 18:07:17 Duration: 24s79ms
5 1m20s 4 19s881ms 20s158ms 20s33ms 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 #5
Day Hour Count Duration Avg duration Jul 03 06 1 20s23ms 20s23ms 10 1 20s158ms 20s158ms 14 1 20s69ms 20s69ms 18 1 19s881ms 19s881ms [ User: postgres - Total duration: 1m20s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m20s - Times executed: 4 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-03 10:00:22 Duration: 20s158ms 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-07-03 14:00:21 Duration: 20s69ms 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-07-03 06:00:21 Duration: 20s23ms Database: ctdprd51 User: postgres Application: pg_dump
6 1m1s 4 15s405ms 15s555ms 15s477ms 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 #6
Day Hour Count Duration Avg duration Jul 03 06 1 15s479ms 15s479ms 10 1 15s405ms 15s405ms 14 1 15s469ms 15s469ms 18 1 15s555ms 15s555ms -
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-07-03 18:07:33 Duration: 15s555ms
-
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-07-03 06:07:34 Duration: 15s479ms
-
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-07-03 14:07:34 Duration: 15s469ms
7 59s393ms 4 14s786ms 14s923ms 14s848ms 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 #7
Day Hour Count Duration Avg duration Jul 03 06 1 14s848ms 14s848ms 10 1 14s923ms 14s923ms 14 1 14s834ms 14s834ms 18 1 14s786ms 14s786ms -
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-07-03 10:00:53 Duration: 14s923ms
-
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-07-03 06:00:52 Duration: 14s848ms
-
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-07-03 14:00:52 Duration: 14s834ms
8 58s208ms 4 14s519ms 14s612ms 14s552ms 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 #8
Day Hour Count Duration Avg duration Jul 03 06 1 14s519ms 14s519ms 10 1 14s546ms 14s546ms 14 1 14s612ms 14s612ms 18 1 14s529ms 14s529ms -
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-07-03 14:01:07 Duration: 14s612ms
-
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-07-03 10:01:07 Duration: 14s546ms
-
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-07-03 18:01:07 Duration: 14s529ms
9 33s546ms 3 10s711ms 11s445ms 11s182ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 03 06 1 10s711ms 10s711ms 23 2 22s834ms 11s417ms [ User: pubeu - Total duration: 33s546ms - Times executed: 3 ]
-
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 = '2201750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-03 23:42:14 Duration: 11s445ms 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 = '2201750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-03 23:42:21 Duration: 11s388ms 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 = '2201750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-03 06:23:32 Duration: 10s711ms Database: ctdprd51 User: pubeu Bind query: yes
10 29s842ms 4 7s449ms 7s471ms 7s460ms copy edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 03 06 1 7s471ms 7s471ms 10 1 7s470ms 7s470ms 14 1 7s449ms 7s449ms 18 1 7s451ms 7s451ms -
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-07-03 06:00:31 Duration: 7s471ms
-
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-07-03 10:00:31 Duration: 7s470ms
-
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-07-03 18:00:31 Duration: 7s451ms
11 25s989ms 4 6s473ms 6s544ms 6s497ms copy edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 03 06 1 6s475ms 6s475ms 10 1 6s473ms 6s473ms 14 1 6s544ms 6s544ms 18 1 6s496ms 6s496ms -
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-07-03 14:01:15 Duration: 6s544ms
-
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-07-03 18:01:15 Duration: 6s496ms
-
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-07-03 06:01:15 Duration: 6s475ms
12 24s633ms 4 6s148ms 6s163ms 6s158ms copy edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 03 06 1 6s163ms 6s163ms 10 1 6s163ms 6s163ms 14 1 6s157ms 6s157ms 18 1 6s148ms 6s148ms -
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-07-03 10:00:38 Duration: 6s163ms
-
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-07-03 06:00:37 Duration: 6s163ms
-
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-07-03 14:00:37 Duration: 6s157ms
13 12s709ms 2 6s335ms 6s373ms 6s354ms 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 #13
Day Hour Count Duration Avg duration Jul 03 03 1 6s335ms 6s335ms 04 1 6s373ms 6s373ms [ User: pubeu - Total duration: 12s709ms - Times executed: 2 ]
-
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', 'DIBUTYL_PHOSPHATE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'DIBUTYL_PHOSPHATE') 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 'DIBUTYL_PHOSPHATE')) 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 'DIBUTYL_PHOSPHATE')) ii GROUP BY ii.cd;
Date: 2026-07-03 04:34:22 Duration: 6s373ms 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', 'CTD_GENE_DISEASE_ASSOCIATIONS.TSV.GZ') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_GENE_DISEASE_ASSOCIATIONS.TSV.GZ') 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 'CTD_GENE_DISEASE_ASSOCIATIONS.TSV.GZ')) 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 'CTD_GENE_DISEASE_ASSOCIATIONS.TSV.GZ')) ii GROUP BY ii.cd;
Date: 2026-07-03 03:14:40 Duration: 6s335ms Database: ctdprd51 User: pubeu Bind query: yes
14 10s421ms 2 5s107ms 5s313ms 5s210ms 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 #14
Day Hour Count Duration Avg duration Jul 03 05 1 5s313ms 5s313ms 13 1 5s107ms 5s107ms [ User: pubeu - Total duration: 10s421ms - Times executed: 2 ]
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1366331' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-03 05:03:28 Duration: 5s313ms 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 = '1402023' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-03 13:58:52 Duration: 5s107ms Database: ctdprd51 User: pubeu Bind query: yes
15 6s686ms 1 6s686ms 6s686ms 6s686ms vacuum analyze log_query_archive;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 03 00 1 6s686ms 6s686ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-07-03 00:09:30 Duration: 6s686ms
16 5s390ms 1 5s390ms 5s390ms 5s390ms 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 #16
Day Hour Count Duration Avg duration Jul 03 05 1 5s390ms 5s390ms [ User: pubeu - Total duration: 5s390ms - 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 = 1400764)) 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-07-03 05:48:44 Duration: 5s390ms Database: ctdprd51 User: pubeu Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 4 7m29s 1m51s 1m52s 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 #1
Day Hour Count Duration Avg duration Jul 03 06 1 1m52s 1m52s 10 1 1m52s 1m52s 14 1 1m52s 1m52s 18 1 1m51s 1m51s [ User: postgres - Total duration: 7m29s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m29s - 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-07-03 14:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-03 06: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-07-03 10:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
2 4 1m36s 24s40ms 24s293ms 24s130ms 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 #2
Day Hour Count Duration Avg duration Jul 03 06 1 24s293ms 24s293ms 10 1 24s40ms 24s40ms 14 1 24s109ms 24s109ms 18 1 24s79ms 24s79ms -
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-07-03 06:07:18 Duration: 24s293ms
-
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-07-03 14:07:18 Duration: 24s109ms
-
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-07-03 18:07:17 Duration: 24s79ms
3 4 1m20s 19s881ms 20s158ms 20s33ms 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 #3
Day Hour Count Duration Avg duration Jul 03 06 1 20s23ms 20s23ms 10 1 20s158ms 20s158ms 14 1 20s69ms 20s69ms 18 1 19s881ms 19s881ms [ User: postgres - Total duration: 1m20s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m20s - Times executed: 4 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-03 10:00:22 Duration: 20s158ms 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-07-03 14:00:21 Duration: 20s69ms 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-07-03 06:00:21 Duration: 20s23ms Database: ctdprd51 User: postgres Application: pg_dump
4 4 1m1s 15s405ms 15s555ms 15s477ms 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 #4
Day Hour Count Duration Avg duration Jul 03 06 1 15s479ms 15s479ms 10 1 15s405ms 15s405ms 14 1 15s469ms 15s469ms 18 1 15s555ms 15s555ms -
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-07-03 18:07:33 Duration: 15s555ms
-
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-07-03 06:07:34 Duration: 15s479ms
-
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-07-03 14:07:34 Duration: 15s469ms
5 4 59s393ms 14s786ms 14s923ms 14s848ms 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 #5
Day Hour Count Duration Avg duration Jul 03 06 1 14s848ms 14s848ms 10 1 14s923ms 14s923ms 14 1 14s834ms 14s834ms 18 1 14s786ms 14s786ms -
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-07-03 10:00:53 Duration: 14s923ms
-
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-07-03 06:00:52 Duration: 14s848ms
-
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-07-03 14:00:52 Duration: 14s834ms
6 4 58s208ms 14s519ms 14s612ms 14s552ms 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 #6
Day Hour Count Duration Avg duration Jul 03 06 1 14s519ms 14s519ms 10 1 14s546ms 14s546ms 14 1 14s612ms 14s612ms 18 1 14s529ms 14s529ms -
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-07-03 14:01:07 Duration: 14s612ms
-
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-07-03 10:01:07 Duration: 14s546ms
-
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-07-03 18:01:07 Duration: 14s529ms
7 4 29s842ms 7s449ms 7s471ms 7s460ms 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 #7
Day Hour Count Duration Avg duration Jul 03 06 1 7s471ms 7s471ms 10 1 7s470ms 7s470ms 14 1 7s449ms 7s449ms 18 1 7s451ms 7s451ms -
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-07-03 06:00:31 Duration: 7s471ms
-
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-07-03 10:00:31 Duration: 7s470ms
-
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-07-03 18:00:31 Duration: 7s451ms
8 4 25s989ms 6s473ms 6s544ms 6s497ms 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 #8
Day Hour Count Duration Avg duration Jul 03 06 1 6s475ms 6s475ms 10 1 6s473ms 6s473ms 14 1 6s544ms 6s544ms 18 1 6s496ms 6s496ms -
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-07-03 14:01:15 Duration: 6s544ms
-
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-07-03 18:01:15 Duration: 6s496ms
-
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-07-03 06:01:15 Duration: 6s475ms
9 4 24s633ms 6s148ms 6s163ms 6s158ms 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 #9
Day Hour Count Duration Avg duration Jul 03 06 1 6s163ms 6s163ms 10 1 6s163ms 6s163ms 14 1 6s157ms 6s157ms 18 1 6s148ms 6s148ms -
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-07-03 10:00:38 Duration: 6s163ms
-
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-07-03 06:00:37 Duration: 6s163ms
-
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-07-03 14:00:37 Duration: 6s157ms
10 3 33s546ms 10s711ms 11s445ms 11s182ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 03 06 1 10s711ms 10s711ms 23 2 22s834ms 11s417ms [ User: pubeu - Total duration: 33s546ms - Times executed: 3 ]
-
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 = '2201750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-03 23:42:14 Duration: 11s445ms 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 = '2201750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-03 23:42:21 Duration: 11s388ms 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 = '2201750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-03 06:23:32 Duration: 10s711ms Database: ctdprd51 User: pubeu Bind query: yes
11 2 12s709ms 6s335ms 6s373ms 6s354ms 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 #11
Day Hour Count Duration Avg duration Jul 03 03 1 6s335ms 6s335ms 04 1 6s373ms 6s373ms [ User: pubeu - Total duration: 12s709ms - Times executed: 2 ]
-
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', 'DIBUTYL_PHOSPHATE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'DIBUTYL_PHOSPHATE') 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 'DIBUTYL_PHOSPHATE')) 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 'DIBUTYL_PHOSPHATE')) ii GROUP BY ii.cd;
Date: 2026-07-03 04:34:22 Duration: 6s373ms 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', 'CTD_GENE_DISEASE_ASSOCIATIONS.TSV.GZ') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_GENE_DISEASE_ASSOCIATIONS.TSV.GZ') 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 'CTD_GENE_DISEASE_ASSOCIATIONS.TSV.GZ')) 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 'CTD_GENE_DISEASE_ASSOCIATIONS.TSV.GZ')) ii GROUP BY ii.cd;
Date: 2026-07-03 03:14:40 Duration: 6s335ms Database: ctdprd51 User: pubeu Bind query: yes
12 2 10s421ms 5s107ms 5s313ms 5s210ms 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 #12
Day Hour Count Duration Avg duration Jul 03 05 1 5s313ms 5s313ms 13 1 5s107ms 5s107ms [ User: pubeu - Total duration: 10s421ms - Times executed: 2 ]
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1366331' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-03 05:03:28 Duration: 5s313ms 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 = '1402023' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-03 13:58:52 Duration: 5s107ms Database: ctdprd51 User: pubeu Bind query: yes
13 1 9m21s 9m21s 9m21s 9m21s select maint_query_logs_archive ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 03 00 1 9m21s 9m21s [ User: pubc - Total duration: 9m21s - Times executed: 1 ]
[ Application: psql - Total duration: 9m21s - 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-07-03 00:09:23 Duration: 9m21s Database: ctdprd51 User: pubc Application: psql
14 1 3m34s 3m34s 3m34s 3m34s select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ?) union select ?, r.id from reference r where r.title_abstract_fts @@ to_tsquery(?, ?) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 03 22 1 3m34s 3m34s [ User: pubeu - Total duration: 3m34s - Times executed: 1 ]
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', '二、你现在先下载 & 4 & 个数据库 & 1. & CTD & 搜索： & TRICLOSAN & 下载 & (CHEMICAL-GENE | CHEMICALGENE) & INTERACTIONS，物种选 & HOMO & SAPIENS。保存为： & CTD_TRICLOSAN_CHEMICAL_GENE.CSV & CTD & 是最重要的，必须有。 & 2. & CHEMBL & 搜索 & COMPOUND： & TRICLOSAN & 找到 & COMPOUND & 后看 & TARGET & / & BIOACTIVITY & 信息，导出 & TARGET & 相关表。保存为： & CHEMBL_TRICLOSAN_TARGETS.CSV & 如果你暂时不会导出，可以先跳过，后面补。 & 3. & STITCH & 搜索： & TRICLOSAN & 物种选择： & HOMO & SAPIENS & 下载 & PROTEIN & INTERACTION & / & TARGET & TABLE。保存为： & STITCH_TRICLOSAN.TSV & 4. & SWISSTARGETPREDICTION & 输入 & TRICLOSAN & 的 & SMILES。TRICLOSAN & 的 & SMILES & 可以用： & OC1CC & CL & CCC1OC2CCC & CL & CC2CL & 物种选择：') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', '二、你现在先下载 & 4 & 个数据库 & 1. & CTD & 搜索： & TRICLOSAN & 下载 & (CHEMICAL-GENE | CHEMICALGENE) & INTERACTIONS，物种选 & HOMO & SAPIENS。保存为： & CTD_TRICLOSAN_CHEMICAL_GENE.CSV & CTD & 是最重要的，必须有。 & 2. & CHEMBL & 搜索 & COMPOUND： & TRICLOSAN & 找到 & COMPOUND & 后看 & TARGET & / & BIOACTIVITY & 信息，导出 & TARGET & 相关表。保存为： & CHEMBL_TRICLOSAN_TARGETS.CSV & 如果你暂时不会导出，可以先跳过，后面补。 & 3. & STITCH & 搜索： & TRICLOSAN & 物种选择： & HOMO & SAPIENS & 下载 & PROTEIN & INTERACTION & / & TARGET & TABLE。保存为： & STITCH_TRICLOSAN.TSV & 4. & SWISSTARGETPREDICTION & 输入 & TRICLOSAN & 的 & SMILES。TRICLOSAN & 的 & SMILES & 可以用： & OC1CC & CL & CCC1OC2CCC & CL & CC2CL & 物种选择：') 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 '二、你现在先下载' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '个数据库' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '搜索：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '下载' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(CHEMICAL-GENE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEMICALGENE)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INTERACTIONS，物种选' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HOMO' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SAPIENS。保存为：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD_TRICLOSAN_CHEMICAL_GENE.CSV' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '是最重要的，必须有。' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '2.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEMBL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '搜索' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COMPOUND：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '找到' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COMPOUND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '后看' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TARGET' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '/' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BIOACTIVITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '信息，导出' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TARGET' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '相关表。保存为：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEMBL_TRICLOSAN_TARGETS.CSV' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '如果你暂时不会导出，可以先跳过，后面补。' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STITCH' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '搜索：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '物种选择：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HOMO' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SAPIENS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '下载' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PROTEIN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INTERACTION' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '/' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TARGET' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TABLE。保存为：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STITCH_TRICLOSAN.TSV' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '4.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SWISSTARGETPREDICTION' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '输入' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '的' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SMILES。TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '的' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SMILES' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '可以用：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OC1CC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CCC1OC2CCC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CC2CL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) 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 = 'A' AND (upper(l.acc_txt) LIKE '二、你现在先下载' OR upper(l.acc_txt) LIKE '4' OR upper(l.acc_txt) LIKE '个数据库' OR upper(l.acc_txt) LIKE '1.' OR upper(l.acc_txt) LIKE 'CTD' OR upper(l.acc_txt) LIKE '搜索：' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '下载' OR upper(l.acc_txt) LIKE 'CHEMICAL-GENE' OR upper(l.acc_txt) LIKE 'INTERACTIONS，物种选' OR upper(l.acc_txt) LIKE 'HOMO' OR upper(l.acc_txt) LIKE 'SAPIENS。保存为：' OR upper(l.acc_txt) LIKE 'CTD_TRICLOSAN_CHEMICAL_GENE.CSV' OR upper(l.acc_txt) LIKE 'CTD' OR upper(l.acc_txt) LIKE '是最重要的，必须有。' OR upper(l.acc_txt) LIKE '2.' OR upper(l.acc_txt) LIKE 'CHEMBL' OR upper(l.acc_txt) LIKE '搜索' OR upper(l.acc_txt) LIKE 'COMPOUND：' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '找到' OR upper(l.acc_txt) LIKE 'COMPOUND' OR upper(l.acc_txt) LIKE '后看' OR upper(l.acc_txt) LIKE 'TARGET' OR upper(l.acc_txt) LIKE '/' OR upper(l.acc_txt) LIKE 'BIOACTIVITY' OR upper(l.acc_txt) LIKE '信息，导出' OR upper(l.acc_txt) LIKE 'TARGET' OR upper(l.acc_txt) LIKE '相关表。保存为：' OR upper(l.acc_txt) LIKE 'CHEMBL_TRICLOSAN_TARGETS.CSV' OR upper(l.acc_txt) LIKE '如果你暂时不会导出，可以先跳过，后面补。' OR upper(l.acc_txt) LIKE '3.' OR upper(l.acc_txt) LIKE 'STITCH' OR upper(l.acc_txt) LIKE '搜索：' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '物种选择：' OR upper(l.acc_txt) LIKE 'HOMO' OR upper(l.acc_txt) LIKE 'SAPIENS' OR upper(l.acc_txt) LIKE '下载' OR upper(l.acc_txt) LIKE 'PROTEIN' OR upper(l.acc_txt) LIKE 'INTERACTION' OR upper(l.acc_txt) LIKE '/' OR upper(l.acc_txt) LIKE 'TARGET' OR upper(l.acc_txt) LIKE 'TABLE。保存为：' OR upper(l.acc_txt) LIKE 'STITCH_TRICLOSAN.TSV' OR upper(l.acc_txt) LIKE '4.' OR upper(l.acc_txt) LIKE 'SWISSTARGETPREDICTION' OR upper(l.acc_txt) LIKE '输入' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '的' OR upper(l.acc_txt) LIKE 'SMILES。TRICLOSAN' OR upper(l.acc_txt) LIKE '的' OR upper(l.acc_txt) LIKE 'SMILES' OR upper(l.acc_txt) LIKE '可以用：' OR upper(l.acc_txt) LIKE 'OC1CC' OR upper(l.acc_txt) LIKE 'CL' OR upper(l.acc_txt) LIKE 'CCC1OC2CCC' OR upper(l.acc_txt) LIKE 'CL' OR upper(l.acc_txt) LIKE 'CC2CL' OR upper(l.acc_txt) LIKE '物种选择：')) ii GROUP BY ii.cd;
Date: 2026-07-03 22:30:42 Duration: 3m34s Database: ctdprd51 User: pubeu Bind query: yes
15 1 6s686ms 6s686ms 6s686ms 6s686ms vacuum analyze log_query_archive;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 03 00 1 6s686ms 6s686ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-07-03 00:09:30 Duration: 6s686ms
16 1 5s390ms 5s390ms 5s390ms 5s390ms 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 #16
Day Hour Count Duration Avg duration Jul 03 05 1 5s390ms 5s390ms [ User: pubeu - Total duration: 5s390ms - 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 = 1400764)) 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-07-03 05:48:44 Duration: 5s390ms Database: ctdprd51 User: pubeu Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 9m21s 9m21s 9m21s 1 9m21s select maint_query_logs_archive ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 03 00 1 9m21s 9m21s [ User: pubc - Total duration: 9m21s - Times executed: 1 ]
[ Application: psql - Total duration: 9m21s - 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-07-03 00:09:23 Duration: 9m21s Database: ctdprd51 User: pubc Application: psql
2 3m34s 3m34s 3m34s 1 3m34s select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ?) union select ?, r.id from reference r where r.title_abstract_fts @@ to_tsquery(?, ?) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 03 22 1 3m34s 3m34s [ User: pubeu - Total duration: 3m34s - Times executed: 1 ]
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', '二、你现在先下载 & 4 & 个数据库 & 1. & CTD & 搜索： & TRICLOSAN & 下载 & (CHEMICAL-GENE | CHEMICALGENE) & INTERACTIONS，物种选 & HOMO & SAPIENS。保存为： & CTD_TRICLOSAN_CHEMICAL_GENE.CSV & CTD & 是最重要的，必须有。 & 2. & CHEMBL & 搜索 & COMPOUND： & TRICLOSAN & 找到 & COMPOUND & 后看 & TARGET & / & BIOACTIVITY & 信息，导出 & TARGET & 相关表。保存为： & CHEMBL_TRICLOSAN_TARGETS.CSV & 如果你暂时不会导出，可以先跳过，后面补。 & 3. & STITCH & 搜索： & TRICLOSAN & 物种选择： & HOMO & SAPIENS & 下载 & PROTEIN & INTERACTION & / & TARGET & TABLE。保存为： & STITCH_TRICLOSAN.TSV & 4. & SWISSTARGETPREDICTION & 输入 & TRICLOSAN & 的 & SMILES。TRICLOSAN & 的 & SMILES & 可以用： & OC1CC & CL & CCC1OC2CCC & CL & CC2CL & 物种选择：') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', '二、你现在先下载 & 4 & 个数据库 & 1. & CTD & 搜索： & TRICLOSAN & 下载 & (CHEMICAL-GENE | CHEMICALGENE) & INTERACTIONS，物种选 & HOMO & SAPIENS。保存为： & CTD_TRICLOSAN_CHEMICAL_GENE.CSV & CTD & 是最重要的，必须有。 & 2. & CHEMBL & 搜索 & COMPOUND： & TRICLOSAN & 找到 & COMPOUND & 后看 & TARGET & / & BIOACTIVITY & 信息，导出 & TARGET & 相关表。保存为： & CHEMBL_TRICLOSAN_TARGETS.CSV & 如果你暂时不会导出，可以先跳过，后面补。 & 3. & STITCH & 搜索： & TRICLOSAN & 物种选择： & HOMO & SAPIENS & 下载 & PROTEIN & INTERACTION & / & TARGET & TABLE。保存为： & STITCH_TRICLOSAN.TSV & 4. & SWISSTARGETPREDICTION & 输入 & TRICLOSAN & 的 & SMILES。TRICLOSAN & 的 & SMILES & 可以用： & OC1CC & CL & CCC1OC2CCC & CL & CC2CL & 物种选择：') 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 '二、你现在先下载' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '个数据库' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '搜索：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '下载' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(CHEMICAL-GENE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEMICALGENE)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INTERACTIONS，物种选' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HOMO' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SAPIENS。保存为：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD_TRICLOSAN_CHEMICAL_GENE.CSV' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '是最重要的，必须有。' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '2.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEMBL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '搜索' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COMPOUND：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '找到' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COMPOUND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '后看' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TARGET' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '/' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BIOACTIVITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '信息，导出' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TARGET' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '相关表。保存为：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEMBL_TRICLOSAN_TARGETS.CSV' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '如果你暂时不会导出，可以先跳过，后面补。' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STITCH' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '搜索：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '物种选择：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HOMO' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SAPIENS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '下载' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PROTEIN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INTERACTION' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '/' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TARGET' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TABLE。保存为：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STITCH_TRICLOSAN.TSV' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '4.' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SWISSTARGETPREDICTION' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '输入' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '的' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SMILES。TRICLOSAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '的' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SMILES' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '可以用：' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OC1CC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CCC1OC2CCC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CC2CL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) 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 = 'A' AND (upper(l.acc_txt) LIKE '二、你现在先下载' OR upper(l.acc_txt) LIKE '4' OR upper(l.acc_txt) LIKE '个数据库' OR upper(l.acc_txt) LIKE '1.' OR upper(l.acc_txt) LIKE 'CTD' OR upper(l.acc_txt) LIKE '搜索：' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '下载' OR upper(l.acc_txt) LIKE 'CHEMICAL-GENE' OR upper(l.acc_txt) LIKE 'INTERACTIONS，物种选' OR upper(l.acc_txt) LIKE 'HOMO' OR upper(l.acc_txt) LIKE 'SAPIENS。保存为：' OR upper(l.acc_txt) LIKE 'CTD_TRICLOSAN_CHEMICAL_GENE.CSV' OR upper(l.acc_txt) LIKE 'CTD' OR upper(l.acc_txt) LIKE '是最重要的，必须有。' OR upper(l.acc_txt) LIKE '2.' OR upper(l.acc_txt) LIKE 'CHEMBL' OR upper(l.acc_txt) LIKE '搜索' OR upper(l.acc_txt) LIKE 'COMPOUND：' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '找到' OR upper(l.acc_txt) LIKE 'COMPOUND' OR upper(l.acc_txt) LIKE '后看' OR upper(l.acc_txt) LIKE 'TARGET' OR upper(l.acc_txt) LIKE '/' OR upper(l.acc_txt) LIKE 'BIOACTIVITY' OR upper(l.acc_txt) LIKE '信息，导出' OR upper(l.acc_txt) LIKE 'TARGET' OR upper(l.acc_txt) LIKE '相关表。保存为：' OR upper(l.acc_txt) LIKE 'CHEMBL_TRICLOSAN_TARGETS.CSV' OR upper(l.acc_txt) LIKE '如果你暂时不会导出，可以先跳过，后面补。' OR upper(l.acc_txt) LIKE '3.' OR upper(l.acc_txt) LIKE 'STITCH' OR upper(l.acc_txt) LIKE '搜索：' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '物种选择：' OR upper(l.acc_txt) LIKE 'HOMO' OR upper(l.acc_txt) LIKE 'SAPIENS' OR upper(l.acc_txt) LIKE '下载' OR upper(l.acc_txt) LIKE 'PROTEIN' OR upper(l.acc_txt) LIKE 'INTERACTION' OR upper(l.acc_txt) LIKE '/' OR upper(l.acc_txt) LIKE 'TARGET' OR upper(l.acc_txt) LIKE 'TABLE。保存为：' OR upper(l.acc_txt) LIKE 'STITCH_TRICLOSAN.TSV' OR upper(l.acc_txt) LIKE '4.' OR upper(l.acc_txt) LIKE 'SWISSTARGETPREDICTION' OR upper(l.acc_txt) LIKE '输入' OR upper(l.acc_txt) LIKE 'TRICLOSAN' OR upper(l.acc_txt) LIKE '的' OR upper(l.acc_txt) LIKE 'SMILES。TRICLOSAN' OR upper(l.acc_txt) LIKE '的' OR upper(l.acc_txt) LIKE 'SMILES' OR upper(l.acc_txt) LIKE '可以用：' OR upper(l.acc_txt) LIKE 'OC1CC' OR upper(l.acc_txt) LIKE 'CL' OR upper(l.acc_txt) LIKE 'CCC1OC2CCC' OR upper(l.acc_txt) LIKE 'CL' OR upper(l.acc_txt) LIKE 'CC2CL' OR upper(l.acc_txt) LIKE '物种选择：')) ii GROUP BY ii.cd;
Date: 2026-07-03 22:30:42 Duration: 3m34s Database: ctdprd51 User: pubeu Bind query: yes
3 1m51s 1m52s 1m52s 4 7m29s 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 #3
Day Hour Count Duration Avg duration Jul 03 06 1 1m52s 1m52s 10 1 1m52s 1m52s 14 1 1m52s 1m52s 18 1 1m51s 1m51s [ User: postgres - Total duration: 7m29s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m29s - 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-07-03 14:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-03 06: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-07-03 10:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
4 24s40ms 24s293ms 24s130ms 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 #4
Day Hour Count Duration Avg duration Jul 03 06 1 24s293ms 24s293ms 10 1 24s40ms 24s40ms 14 1 24s109ms 24s109ms 18 1 24s79ms 24s79ms -
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-07-03 06:07:18 Duration: 24s293ms
-
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-07-03 14:07:18 Duration: 24s109ms
-
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-07-03 18:07:17 Duration: 24s79ms
5 19s881ms 20s158ms 20s33ms 4 1m20s 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 #5
Day Hour Count Duration Avg duration Jul 03 06 1 20s23ms 20s23ms 10 1 20s158ms 20s158ms 14 1 20s69ms 20s69ms 18 1 19s881ms 19s881ms [ User: postgres - Total duration: 1m20s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m20s - Times executed: 4 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-03 10:00:22 Duration: 20s158ms 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-07-03 14:00:21 Duration: 20s69ms 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-07-03 06:00:21 Duration: 20s23ms Database: ctdprd51 User: postgres Application: pg_dump
6 15s405ms 15s555ms 15s477ms 4 1m1s 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 #6
Day Hour Count Duration Avg duration Jul 03 06 1 15s479ms 15s479ms 10 1 15s405ms 15s405ms 14 1 15s469ms 15s469ms 18 1 15s555ms 15s555ms -
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-07-03 18:07:33 Duration: 15s555ms
-
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-07-03 06:07:34 Duration: 15s479ms
-
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-07-03 14:07:34 Duration: 15s469ms
7 14s786ms 14s923ms 14s848ms 4 59s393ms 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 #7
Day Hour Count Duration Avg duration Jul 03 06 1 14s848ms 14s848ms 10 1 14s923ms 14s923ms 14 1 14s834ms 14s834ms 18 1 14s786ms 14s786ms -
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-07-03 10:00:53 Duration: 14s923ms
-
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-07-03 06:00:52 Duration: 14s848ms
-
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-07-03 14:00:52 Duration: 14s834ms
8 14s519ms 14s612ms 14s552ms 4 58s208ms 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 #8
Day Hour Count Duration Avg duration Jul 03 06 1 14s519ms 14s519ms 10 1 14s546ms 14s546ms 14 1 14s612ms 14s612ms 18 1 14s529ms 14s529ms -
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-07-03 14:01:07 Duration: 14s612ms
-
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-07-03 10:01:07 Duration: 14s546ms
-
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-07-03 18:01:07 Duration: 14s529ms
9 10s711ms 11s445ms 11s182ms 3 33s546ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 03 06 1 10s711ms 10s711ms 23 2 22s834ms 11s417ms [ User: pubeu - Total duration: 33s546ms - Times executed: 3 ]
-
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 = '2201750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-03 23:42:14 Duration: 11s445ms 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 = '2201750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-03 23:42:21 Duration: 11s388ms 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 = '2201750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-03 06:23:32 Duration: 10s711ms Database: ctdprd51 User: pubeu Bind query: yes
10 7s449ms 7s471ms 7s460ms 4 29s842ms copy edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 03 06 1 7s471ms 7s471ms 10 1 7s470ms 7s470ms 14 1 7s449ms 7s449ms 18 1 7s451ms 7s451ms -
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-07-03 06:00:31 Duration: 7s471ms
-
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-07-03 10:00:31 Duration: 7s470ms
-
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-07-03 18:00:31 Duration: 7s451ms
11 6s686ms 6s686ms 6s686ms 1 6s686ms vacuum analyze log_query_archive;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 03 00 1 6s686ms 6s686ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-07-03 00:09:30 Duration: 6s686ms
12 6s473ms 6s544ms 6s497ms 4 25s989ms copy edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 03 06 1 6s475ms 6s475ms 10 1 6s473ms 6s473ms 14 1 6s544ms 6s544ms 18 1 6s496ms 6s496ms -
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-07-03 14:01:15 Duration: 6s544ms
-
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-07-03 18:01:15 Duration: 6s496ms
-
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-07-03 06:01:15 Duration: 6s475ms
13 6s335ms 6s373ms 6s354ms 2 12s709ms 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 #13
Day Hour Count Duration Avg duration Jul 03 03 1 6s335ms 6s335ms 04 1 6s373ms 6s373ms [ User: pubeu - Total duration: 12s709ms - Times executed: 2 ]
-
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', 'DIBUTYL_PHOSPHATE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'DIBUTYL_PHOSPHATE') 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 'DIBUTYL_PHOSPHATE')) 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 'DIBUTYL_PHOSPHATE')) ii GROUP BY ii.cd;
Date: 2026-07-03 04:34:22 Duration: 6s373ms 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', 'CTD_GENE_DISEASE_ASSOCIATIONS.TSV.GZ') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_GENE_DISEASE_ASSOCIATIONS.TSV.GZ') 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 'CTD_GENE_DISEASE_ASSOCIATIONS.TSV.GZ')) 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 'CTD_GENE_DISEASE_ASSOCIATIONS.TSV.GZ')) ii GROUP BY ii.cd;
Date: 2026-07-03 03:14:40 Duration: 6s335ms Database: ctdprd51 User: pubeu Bind query: yes
14 6s148ms 6s163ms 6s158ms 4 24s633ms 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 #14
Day Hour Count Duration Avg duration Jul 03 06 1 6s163ms 6s163ms 10 1 6s163ms 6s163ms 14 1 6s157ms 6s157ms 18 1 6s148ms 6s148ms -
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-07-03 10:00:38 Duration: 6s163ms
-
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-07-03 06:00:37 Duration: 6s163ms
-
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-07-03 14:00:37 Duration: 6s157ms
15 5s390ms 5s390ms 5s390ms 1 5s390ms select ? "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casrn "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" from ( with sq as ( select distinct c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casrn, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort from term c inner join gene_chem_reference gcr on c.id = gcr.chem_id inner join term g on gcr.gene_id = g.id where (c.id = ?)) select distinct sq.chem_nm, sq.chem_acc_txt, sq.casrn, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm from sq inner join gene_go_annot gga on sq.gene_id = gga.gene_id inner join dag_node gt on gga.go_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where gga.is_not = false and (d.id = ? or d.id = ?) order by sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 03 05 1 5s390ms 5s390ms [ User: pubeu - Total duration: 5s390ms - 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 = 1400764)) 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-07-03 05:48:44 Duration: 5s390ms Database: ctdprd51 User: pubeu Bind query: yes
16 5s107ms 5s313ms 5s210ms 2 10s421ms 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 #16
Day Hour Count Duration Avg duration Jul 03 05 1 5s313ms 5s313ms 13 1 5s107ms 5s107ms [ User: pubeu - Total duration: 10s421ms - Times executed: 2 ]
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1366331' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-03 05:03:28 Duration: 5s313ms 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 = '1402023' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-03 13:58:52 Duration: 5s107ms Database: ctdprd51 User: pubeu Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 1 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 03 22 1 0ms 0ms [ User: pubeu - Total duration: 3m34s - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: ctdprd51 Remote: pubeu
-
Events
Log levels
Key values
- 7,673 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Events per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET