pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed Oct 29 04:15:03 2025
Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20251028
Parsed 19,255 log entries in 2s
Log start from 2025-10-28 00:00:01 to 2025-10-28 23:58:26

Global Stats

16 Number of unique normalized queries
498 Number of queries
2h18m30s Total query duration
2025-10-28 00:03:14 First query
2025-10-28 23:22:50 Last query
2 queries/s at 2025-10-28 05:21:41 Query peak

2h18m30s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
2h18m30s Execute total duration

7 Number of events
3 Number of unique normalized events
4 Max number of times the same event was reported
0 Number of cancellation

10 Total number of automatic vacuums
26 Total number of automatic analyzes

0 Number temporary file
0 Max size of temporary file
0.00 B Average size of temporary file

2,210 Total number of sessions
44 sessions at 2025-10-28 10:57:37 Session peak
41d14h58m16s Total duration of sessions
27m7s Average duration of sessions
0 Average queries per session
3s760ms Average queries duration per session
27m3s Average idle time per session

2,210 Total number of connections
9 connections/s at 2025-10-28 05:40:26 Connection peak
2 Total number of databases

SQL Traffic

Key values

2 queries/s Query Peak
2025-10-28 05:21:41 Date

SELECT Traffic

Key values

2 queries/s Query Peak
2025-10-28 05:21:41 Date

INSERT/UPDATE/DELETE Traffic

Key values

0 queries/s Query Peak
Date

Queries duration

Key values

2h18m30s 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

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Oct 28	00	62	0ms	10m57s	23s596ms	38s146ms	39s720ms	11m11s
	01	60	0ms	22s513ms	13s907ms	34s899ms	39s406ms	46s546ms
	02	80	0ms	2m	14s	34s739ms	40s415ms	2m26s
	03	44	0ms	1m58s	15s868ms	34s296ms	39s666ms	2m19s
	04	59	0ms	3m39s	30s132ms	40s90ms	3m47s	7m14s
	05	86	0ms	22s116ms	12s467ms	39s936ms	40s786ms	45s27ms
	06	78	0ms	21s746ms	12s81ms	33s838ms	34s444ms	39s568ms
	07	24	0ms	21s286ms	14s724ms	26s840ms	33s677ms	47s791ms
	08	0	0ms	0ms	0ms	0ms	0ms	0ms
	09	0	0ms	0ms	0ms	0ms	0ms	0ms
	10	0	0ms	0ms	0ms	0ms	0ms	0ms
	11	0	0ms	0ms	0ms	0ms	0ms	0ms
	12	2	0ms	17s954ms	12s135ms	0ms	6s316ms	17s954ms
	13	0	0ms	0ms	0ms	0ms	0ms	0ms
	14	0	0ms	0ms	0ms	0ms	0ms	0ms
	15	0	0ms	0ms	0ms	0ms	0ms	0ms
	16	1	0ms	12s375ms	12s375ms	0ms	0ms	12s375ms
	17	0	0ms	0ms	0ms	0ms	0ms	0ms
	18	0	0ms	0ms	0ms	0ms	0ms	0ms
	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	0	0ms	0ms	0ms	0ms	0ms	0ms
	23	2	0ms	6s424ms	6s407ms	0ms	0ms	12s815ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Oct 28	00	61	23s871ms	33s699ms	38s146ms	42s284ms
	01	60	13s907ms	31s35ms	34s899ms	45s8ms
	02	80	14s	26s208ms	34s739ms	41s620ms
	03	44	15s868ms	27s207ms	34s296ms	40s132ms
	04	59	30s132ms	38s71ms	40s90ms	4m7s
	05	86	12s467ms	34s105ms	39s936ms	41s222ms
	06	78	12s81ms	26s183ms	33s838ms	39s416ms
	07	24	14s724ms	19s741ms	26s840ms	47s791ms
	08	0	0ms	0ms	0ms	0ms
	09	0	0ms	0ms	0ms	0ms
	10	0	0ms	0ms	0ms	0ms
	11	0	0ms	0ms	0ms	0ms
	12	2	12s135ms	0ms	0ms	17s954ms
	13	0	0ms	0ms	0ms	0ms
	14	0	0ms	0ms	0ms	0ms
	15	0	0ms	0ms	0ms	0ms
	16	1	12s375ms	0ms	0ms	12s375ms
	17	0	0ms	0ms	0ms	0ms
	18	0	0ms	0ms	0ms	0ms
	19	0	0ms	0ms	0ms	0ms
	20	0	0ms	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms
	22	0	0ms	0ms	0ms	0ms
	23	2	6s407ms	0ms	0ms	12s815ms

Day	Hour	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Oct 28	00	0ms	0ms	0ms	0ms
	01	0ms	0ms	0ms	0ms
	02	0ms	0ms	0ms	0ms
	03	0ms	0ms	0ms	0ms
	04	0ms	0ms	0ms	0ms
	05	0ms	0ms	0ms	0ms
	06	0ms	0ms	0ms	0ms
	07	0ms	0ms	0ms	0ms
	08	0ms	0ms	0ms	0ms
	09	0ms	0ms	0ms	0ms
	10	0ms	0ms	0ms	0ms
	11	0ms	0ms	0ms	0ms
	12	0ms	0ms	0ms	0ms
	13	0ms	0ms	0ms	0ms
	14	0ms	0ms	0ms	0ms
	15	0ms	0ms	0ms	0ms
	16	0ms	0ms	0ms	0ms
	17	0ms	0ms	0ms	0ms
	18	0ms	0ms	0ms	0ms
	19	0ms	0ms	0ms	0ms
	20	0ms	0ms	0ms	0ms
	21	0ms	0ms	0ms	0ms
	22	0ms	0ms	0ms	0ms
	23	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Oct 28	00	60	60.00	0.00%
	01	60	60.00	0.00%
	02	80	80.00	0.00%
	03	44	44.00	0.00%
	04	59	59.00	0.00%
	05	86	86.00	0.00%
	06	78	78.00	0.00%
	07	24	24.00	0.00%
	08	0	0.00	0.00%
	09	0	0.00	0.00%
	10	0	0.00	0.00%
	11	0	0.00	0.00%
	12	2	2.00	0.00%
	13	0	0.00	0.00%
	14	0	0.00	0.00%
	15	0	0.00	0.00%
	16	1	1.00	0.00%
	17	0	0.00	0.00%
	18	0	0.00	0.00%
	19	0	0.00	0.00%
	20	0	0.00	0.00%
	21	0	0.00	0.00%
	22	0	0.00	0.00%
	23	2	2.00	0.00%

Day	Hour	Count	Average / Second
Oct 28	00	110	0.03/s
	01	113	0.03/s
	02	133	0.04/s
	03	112	0.03/s
	04	116	0.03/s
	05	138	0.04/s
	06	122	0.03/s
	07	100	0.03/s
	08	81	0.02/s
	09	74	0.02/s
	10	82	0.02/s
	11	76	0.02/s
	12	77	0.02/s
	13	77	0.02/s
	14	78	0.02/s
	15	83	0.02/s
	16	77	0.02/s
	17	78	0.02/s
	18	81	0.02/s
	19	79	0.02/s
	20	75	0.02/s
	21	85	0.02/s
	22	80	0.02/s
	23	83	0.02/s

Day	Hour	Count	Average Duration	Average idle time
Oct 28	00	110	21m51s	21m38s
	01	113	20m56s	20m48s
	02	133	18m18s	18m10s
	03	111	21m44s	21m38s
	04	117	20m59s	20m43s
	05	138	17m52s	17m44s
	06	122	19m49s	19m41s
	07	100	24m	23m56s
	08	81	27m45s	27m45s
	09	74	31m9s	31m9s
	10	77	31m18s	31m18s
	11	76	31m6s	31m6s
	12	77	32m18s	32m18s
	13	77	31m35s	31m35s
	14	78	31m24s	31m24s
	15	83	29m49s	29m49s
	16	77	30m59s	30m59s
	17	78	31m13s	31m13s
	18	86	53m45s	53m45s
	19	79	30m39s	30m39s
	20	75	31m11s	31m11s
	21	85	27m21s	27m21s
	22	80	30m35s	30m35s
	23	83	29m12s	29m12s

↑ Back to the top of the General Activity table

Established Connections

Key values

9 connections Connection Peak
2025-10-28 05:40:26 Date

Connections per database

Key values

ctdprd51 Main Database
2,210 connections Total

Chart
Table

Database	User	Count
ctdprd51		2,206
	editeu	370
	load	2
	pub1	2
	pubc	4
	pubeu	1,070
	qaeu	758
postgres		4
	load	2
	pub1	1
	pubc	1

Connections per user

Key values

pubeu Main User
2,210 connections Total

Chart
Table

User	Count
editeu	370
load	4
pub1	3
pubc	5
pubeu	1,070
qaeu	758

Connections per host

Key values

10.12.5.53 Main host with 697 connections
2,210 Total connections

Chart
Table

Host	Count
10.12.5.45	382
10.12.5.46	376
10.12.5.53	697
10.12.5.54	374
10.12.5.55	370
192.168.201.10	11

Simultaneous sessions

Key values

44 sessions Session Peak
2025-10-28 10:57:37 Date

Histogram of session times

Key values

1,794 1800000-3600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	27	1.22%
500ms-1s	2	0.09%
1s-30s	15	0.68%
30s-1m	138	6.24%
1m-10m	200	9.05%
10m-30m	29	1.31%
30m-1h	1,794	81.18%
1h-8h	5	0.23%
> 8h	0	0.00%

Sessions per database

Key values

ctdprd51 Main Database
2,210 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
ctdprd51	2,206	40d23h46m16s	26m45s
postgres	4	15h12m	3h48m

Sessions per user

Key values

pubeu Main User
2,210 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
editeu	370	8d46m56s	31m15s
load	4	7h35m29s	1h53m52s
pub1	3	7h36m14s	2h32m4s
pubc	5	22h55m31s	4h35m6s
pubeu	1,070	15d23h52m18s	21m31s
qaeu	758	16d11m47s	30m24s

Sessions per host

Key values

10.12.5.53 Main Host
2,210 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.12.5.45	382	8d24s	30m9s
10.12.5.46	376	8d11m22s	30m40s
10.12.5.53	697	8d9m54s	16m32s
10.12.5.54	374	7d23h53m28s	30m47s
10.12.5.55	370	8d46m56s	31m15s
192.168.201.10	11	1d13h56m10s	3h26m55s

Sessions per application

Key values

unknown Main Application
2,210 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
pgAdmin 4 - CONN:7720162	3	7h33m49s	2h31m16s
pgAdmin 4 - DB:postgres	1	766ms	766ms
unknown	2,206	41d7h24m26s	26m57s

Checkpoints Buffers

Key values

10,934 buffers Checkpoint Peak
2025-10-28 05:36:08 Date
1094.799 seconds Highest write time
0.002 seconds Sync time

Checkpoints Wal files

Key values

6 files Wal files usage Peak
2025-10-28 05:36:08 Date

Checkpoints distance

Key values

193.74 Mo Distance Peak
2025-10-28 05:36:08 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Oct 28	00	2,521	252.539s	0.002s	252.634s
	01	390	39.044s	0.002s	39.074s
	02	470	47.181s	0.002s	47.211s
	03	524	52.47s	0.002s	52.5s
	04	875	87.526s	0.002s	87.604s
	05	11,166	1,118.054s	0.003s	1,118.156s
	06	355	35.651s	0.002s	35.681s
	07	537	53.876s	0.003s	53.908s
	08	6,044	605.382s	0.003s	605.493s
	09	339	34.147s	0.002s	34.177s
	10	5,937	594.603s	0.002s	594.743s
	11	11,141	1,115.582s	0.003s	1,115.707s
	12	269	27.116s	0.002s	27.145s
	13	135	13.696s	0.002s	13.726s
	14	23	2.47s	0.002s	2.5s
	15	32	3.371s	0.002s	3.401s
	16	47	4.902s	0.002s	4.931s
	17	19	2.001s	0.001s	2.017s
	18	45	4.711s	0.002s	4.744s
	19	17	1.884s	0.002s	1.913s
	20	29	3.09s	0.002s	3.119s
	21	72	7.376s	0.002s	7.406s
	22	69	7.093s	0.002s	7.123s
	23	52	5.374s	0.002s	5.404s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Oct 28	00	2	75	0.001s	0.002s
	01	0	43	0.001s	0.002s
	02	0	42	0.001s	0.002s
	03	0	40	0.001s	0.002s
	04	1	46	0.001s	0.002s
	05	6	55	0.001s	0.002s
	06	0	39	0.001s	0.002s
	07	0	74	0.001s	0.002s
	08	4	122	0.001s	0.002s
	09	0	118	0.001s	0.002s
	10	6	126	0.001s	0.002s
	11	2	131	0.001s	0.002s
	12	0	105	0.001s	0.002s
	13	0	60	0.001s	0.002s
	14	0	14	0.001s	0.002s
	15	0	18	0.001s	0.002s
	16	0	17	0.001s	0.002s
	17	0	7	0.001s	0.001s
	18	0	16	0.001s	0.002s
	19	0	14	0.001s	0.002s
	20	0	14	0.001s	0.002s
	21	0	18	0.001s	0.002s
	22	0	18	0.001s	0.002s
	23	0	17	0.001s	0.002s

Day	Hour	Avg time (sec)
Oct 28	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s
	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s
	23	0s

Day	Hour	Mean distance	Mean estimate
Oct 28	00	14,704.00 kB	26,798.00 kB
	01	1,431.00 kB	21,977.50 kB
	02	1,239.50 kB	18,044.50 kB
	03	1,660.50 kB	14,902.50 kB
	04	2,794.50 kB	12,510.00 kB
	05	50,395.50 kB	94,315.00 kB
	06	1,085.00 kB	76,615.00 kB
	07	1,356.50 kB	62,339.50 kB
	08	31,735.50 kB	59,527.00 kB
	09	925.50 kB	48,392.00 kB
	10	24,434.00 kB	44,844.00 kB
	11	35,029.00 kB	62,909.00 kB
	12	726.00 kB	51,256.00 kB
	13	298.00 kB	41,591.50 kB
	14	38.50 kB	33,698.00 kB
	15	50.50 kB	27,304.50 kB
	16	47.50 kB	22,126.00 kB
	17	58.00 kB	18,873.00 kB
	18	69.50 kB	16,147.00 kB
	19	18.00 kB	13,084.00 kB
	20	42.00 kB	10,605.00 kB
	21	85.00 kB	8,604.00 kB
	22	129.50 kB	6,992.00 kB
	23	114.00 kB	5,686.50 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (47) Main checkpoint cause
47 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	47
Total	47

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

Temp Files

Day	Hour	Count	Total size	Average size
Oct 28	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	0	0	0
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

0.69 sec Highest CPU-cost vacuum
Table pub1.term_set_enrichment
Database ctdprd51
2025-10-28 11:04:22 Date
0 sec Highest CPU-cost analyze
Table
Database ctdprd51
Date

Average Autovacuum Duration

Key values

0.69 sec Highest CPU-cost vacuum
Table pub1.term_set_enrichment
Database ctdprd51
2025-10-28 11:04:22 Date

Analyzes per table

Key values

pubc.log_query (25) Main table analyzed (database ctdprd51)
26 analyzes Total

Chart
Table

Table	Number of analyzes
ctdprd51.pubc.log_query	25
ctdprd51.pg_catalog.pg_class	1
Total	26

Vacuums per table

Key values

pubc.log_query (9) Main table vacuumed on database ctdprd51
10 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
ctdprd51.pubc.log_query	9	5	12,786	0	1,809	0	3,561	4,340	134	1,368,076
ctdprd51.pub1.term_set_enrichment	1	0	6,400	0	2,983	0	0	3,146	2	199,961
Total	10	5	19,186	352	4,792	0	3,561	7,486	136	1,568,037

Tuples removed per table

Key values

pubc.log_query (34042) Main table with removed tuples on database ctdprd51
34042 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
ctdprd51.pubc.log_query	9	5	34,042	134,883	33,974	0	7,046
ctdprd51.pub1.term_set_enrichment	1	0	0	994,416	0	0	16,473
Total	10	5	34,042	1,129,299	33,974	0	23,519

Pages removed per table

Key values

unknown (0) Main table with removed pages on database unknown
0 pages Total removed

Chart
Table

Pages removed per tables

NO DATASET

Table	Number of vacuums	Index scans	Tuples removed
ctdprd51.pubc.log_query	9	5	34042
ctdprd51.pub1.term_set_enrichment	1	0	0
Total	10	5	34,042

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Oct 28	00	3	9
	01	2	6
	02	0	2
	03	2	3
	04	0	3
	05	1	1
	06	1	1
	07	0	1
	08	0	0
	09	0	0
	10	0	0
	11	1	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

NO DATASET

Type	Object	Count	Total Duration	Average Duration (s)
NO DATASET

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 by type

Key values

497 Total read queries
0 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	497	99.80%
INSERT	0	0.00%
UPDATE	0	0.00%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%
OTHERS	1	0.20%

Queries by database

Key values

ctdprd51 Main database
296 Requests
1h31m33s (ctdprd51)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
ctdprd51	Total	296	1h31m33s
	select	296	1h31m33s
unknown	Total	202	46m56s
	others	1	6s790ms
	select	201	46m50s

Queries by user

Key values

pubeu Main user
602 Requests

Queries Chart
Table

User	Request type	Count	Duration
pubc	Total	1	10m57s
	select	1	10m57s
pubeu	Total	602	2h34m32s
	select	602	2h34m32s
qaeu	Total	3	17s437ms
	select	3	17s437ms
unknown	Total	414	1h32m5s
	others	1	6s790ms
	select	413	1h31m59s

Duration by user

Key values

2h34m32s (pubeu) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pubc	Total	1	10m57s
	select	1	10m57s
pubeu	Total	602	2h34m32s
	select	602	2h34m32s
qaeu	Total	3	17s437ms
	select	3	17s437ms
unknown	Total	414	1h32m5s
	others	1	6s790ms
	select	413	1h31m59s

Queries by host

Key values

unknown Main host
1,020 Requests
4h17m53s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	1,020	4h17m53s
	others	1	6s790ms
	select	1,019	4h17m46s

Queries by application

Key values

unknown Main application
497 Requests
2h7m32s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
psql	Total	1	10m57s
	select	1	10m57s
unknown	Total	497	2h7m32s
	others	1	6s790ms
	select	496	2h7m26s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-10-28 01:51:18 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

333 > 10000ms duration

Chart
Table

Range	Count	Percentage
0-1ms	0	0.00%
1-5ms	0	0.00%
5-10ms	0	0.00%
10-25ms	0	0.00%
25-50ms	0	0.00%
50-100ms	0	0.00%
100-500ms	0	0.00%
500-1000ms	0	0.00%
1000-10000ms	165	33.13%
> 10000ms	333	66.87%

Slowest individual queries


[ Date: 2025-10-28 00:10:59 - Database: ctdprd51 - User: pubc - Application: psql ]
[ Date: 2025-10-28 04:05:31 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2025-10-28 04:07:04 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2025-10-28 04:07:55 - Bind query: yes ]
[ Date: 2025-10-28 04:10:34 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2025-10-28 04:02:33 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2025-10-28 02:54:39 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2025-10-28 03:37:20 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2025-10-28 01:43:24 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2025-10-28 01:55:41 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2025-10-28 02:26:37 - Bind query: yes ]
[ Date: 2025-10-28 02:19:12 - Bind query: yes ]
[ Date: 2025-10-28 02:20:52 - Bind query: yes ]
[ Date: 2025-10-28 04:21:51 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2025-10-28 05:47:32 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2025-10-28 05:18:23 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2025-10-28 02:31:25 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2025-10-28 02:40:29 - Bind query: yes ]
[ Date: 2025-10-28 05:38:09 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2025-10-28 00:51:49 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

Rank	Duration	Query
1	10m57s	/* * 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:* 2025-10-28 00:10:59 - Database: ctdprd51 - User: pubc - Application: psql ]
2	3m39s	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', 'FROM & TO & MK10_HUMAN & MAPK10 & P35968 & KDR & TTHY_HUMAN & TTR & CATS_HUMAN & CTSS & GSTP1_HUMAN & GSTP1 & CAH12_HUMAN & CA12 & PNPH_HUMAN & PNP & PDE4B_HUMAN & PDE4B & P07900 & HSP90AA1 & CHLE_HUMAN & BCHE & CAH2_HUMAN & CA2 & Q9NP99 & TREM1 & STS_HUMAN & STS & PYRD_HUMAN & DHODH & O15496 & PLA2G10 & CASP7_HUMAN & CASP7 & Q16539 & MAPK14 & SRC_HUMAN & SRC & SEPR_HUMAN & FAP & P11142 & HSPA8 & CHK1_HUMAN & CHEK1 & ALBU_HUMAN & ALB & CTNA1_HUMAN & CTNNA1 & EST1_HUMAN & CES1 & MK08_HUMAN & MAPK8 & P62937 & PPIA & CAH1_HUMAN & CA1 & P04745 & AMY1A & P04745 & AMY1B & P04745 & AMY1C & BACE1_HUMAN & BACE1 & PRGR_HUMAN & PGR & ESR2_HUMAN & ES') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'FROM & TO & MK10_HUMAN & MAPK10 & P35968 & KDR & TTHY_HUMAN & TTR & CATS_HUMAN & CTSS & GSTP1_HUMAN & GSTP1 & CAH12_HUMAN & CA12 & PNPH_HUMAN & PNP & PDE4B_HUMAN & PDE4B & P07900 &HSP90AA1 & CHLE_HUMAN & BCHE & CAH2_HUMAN & CA2 & Q9NP99 & TREM1 & STS_HUMAN & STS & PYRD_HUMAN & DHODH & O15496 & PLA2G10 & CASP7_HUMAN & CASP7 & Q16539 & MAPK14 & SRC_HUMAN & SRC & SEPR_HUMAN & FAP & P11142 & HSPA8 & CHK1_HUMAN & CHEK1 & ALBU_HUMAN & ALB & CTNA1_HUMAN & CTNNA1 & EST1_HUMAN & CES1 & MK08_HUMAN & MAPK8 & P62937 & PPIA & CAH1_HUMAN & CA1 & P04745 & AMY1A & P04745 & AMY1B & P04745 & AMY1C & BACE1_HUMAN & BACE1 & PRGR_HUMAN & PGR & ESR2_HUMAN & ES') 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 'FROM' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TO' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MK10_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK10' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P35968' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'KDR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TTHY_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TTR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CATS_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTSS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GSTP1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GSTP1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH12_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA12' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PNPH_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PNP' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PDE4B_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PDE4B' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P07900' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HSP90AA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHLE_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BCHE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH2_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'Q9NP99' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TREM1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STS_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PYRD_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DHODH' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'O15496' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PLA2G10' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CASP7_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CASP7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'Q16539' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK14' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SRC_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SRC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SEPR_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'FAP' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P11142' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HSPA8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHK1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEK1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ALBU_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ALB' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTNA1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTNNA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'EST1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CES1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MK08_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P62937' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PPIA' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1A' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1B' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1C' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BACE1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BACE1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PRGR_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PGR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ESR2_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ES')) 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 'FROM' OR upper(l.acc_txt) LIKE 'TO' OR upper(l.acc_txt) LIKE 'MK10_HUMAN' OR upper(l.acc_txt) LIKE 'MAPK10' OR upper(l.acc_txt) LIKE 'P35968' OR upper(l.acc_txt) LIKE 'KDR' OR upper(l.acc_txt) LIKE 'TTHY_HUMAN' OR upper(l.acc_txt) LIKE 'TTR' OR upper(l.acc_txt) LIKE 'CATS_HUMAN' OR upper(l.acc_txt) LIKE 'CTSS' OR upper(l.acc_txt) LIKE 'GSTP1_HUMAN' OR upper(l.acc_txt) LIKE 'GSTP1' OR upper(l.acc_txt) LIKE 'CAH12_HUMAN' OR upper(l.acc_txt) LIKE 'CA12' OR upper(l.acc_txt) LIKE 'PNPH_HUMAN' OR upper(l.acc_txt) LIKE 'PNP' OR upper(l.acc_txt) LIKE 'PDE4B_HUMAN' OR upper(l.acc_txt) LIKE 'PDE4B' OR upper(l.acc_txt) LIKE 'P07900' OR upper(l.acc_txt) LIKE 'HSP90AA1' OR upper(l.acc_txt) LIKE 'CHLE_HUMAN' OR upper(l.acc_txt) LIKE 'BCHE' OR upper(l.acc_txt) LIKE 'CAH2_HUMAN' OR upper(l.acc_txt) LIKE 'CA2' OR upper(l.acc_txt) LIKE 'Q9NP99' OR upper(l.acc_txt) LIKE 'TREM1' OR upper(l.acc_txt) LIKE 'STS_HUMAN' OR upper(l.acc_txt) LIKE 'STS' OR upper(l.acc_txt) LIKE 'PYRD_HUMAN' OR upper(l.acc_txt) LIKE 'DHODH' OR upper(l.acc_txt) LIKE 'O15496' OR upper(l.acc_txt) LIKE 'PLA2G10' OR upper(l.acc_txt) LIKE 'CASP7_HUMAN' OR upper(l.acc_txt) LIKE 'CASP7' OR upper(l.acc_txt) LIKE 'Q16539' OR upper(l.acc_txt) LIKE 'MAPK14' OR upper(l.acc_txt) LIKE 'SRC_HUMAN' OR upper(l.acc_txt) LIKE 'SRC' OR upper(l.acc_txt) LIKE 'SEPR_HUMAN' OR upper(l.acc_txt) LIKE 'FAP' OR upper(l.acc_txt) LIKE 'P11142' OR upper(l.acc_txt) LIKE 'HSPA8' OR upper(l.acc_txt) LIKE 'CHK1_HUMAN' OR upper(l.acc_txt) LIKE 'CHEK1' OR upper(l.acc_txt) LIKE 'ALBU_HUMAN' OR upper(l.acc_txt) LIKE 'ALB' OR upper(l.acc_txt) LIKE 'CTNA1_HUMAN' OR upper(l.acc_txt) LIKE 'CTNNA1' OR upper(l.acc_txt) LIKE 'EST1_HUMAN' OR upper(l.acc_txt) LIKE 'CES1' OR upper(l.acc_txt) LIKE 'MK08_HUMAN' OR upper(l.acc_txt) LIKE 'MAPK8' OR upper(l.acc_txt) LIKE 'P62937' OR upper(l.acc_txt) LIKE 'PPIA' OR upper(l.acc_txt) LIKE 'CAH1_HUMAN' OR upper(l.acc_txt) LIKE 'CA1' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1A' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1B' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1C' OR upper(l.acc_txt) LIKE 'BACE1_HUMAN' OR upper(l.acc_txt) LIKE 'BACE1' OR upper(l.acc_txt) LIKE 'PGR' OR upper(l.acc_txt) LIKE 'ESR2_HUMAN' OR upper(l.acc_txt) LIKE 'ES' OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd; [ Date:* 2025-10-28 04:05:31 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
3	3m38s	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', 'FROM & TO & MK10_HUMAN & MAPK10 & P35968 & KDR & TTHY_HUMAN & TTR & CATS_HUMAN & CTSS & GSTP1_HUMAN & GSTP1 & CAH12_HUMAN & CA12 & PNPH_HUMAN & PNP & PDE4B_HUMAN & PDE4B & P07900 & HSP90AA1 & CHLE_HUMAN & BCHE & CAH2_HUMAN & CA2 & Q9NP99 & TREM1 & STS_HUMAN & STS & PYRD_HUMAN & DHODH & O15496 & PLA2G10 & CASP7_HUMAN & CASP7 & Q16539 & MAPK14 & SRC_HUMAN & SRC & SEPR_HUMAN & FAP & P11142 & HSPA8 & CHK1_HUMAN & CHEK1 & ALBU_HUMAN & ALB & CTNA1_HUMAN & CTNNA1 & EST1_HUMAN & CES1 & MK08_HUMAN & MAPK8 & P62937 & PPIA & CAH1_HUMAN & CA1 & P04745 & AMY1A & P04745 & AMY1B & P04745 & AMY1C & BACE1_HUMAN & BACE1 & PRGR_HUMAN & PGR & ESR2_HUMAN & ES') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'FROM & TO & MK10_HUMAN & MAPK10 & P35968 & KDR & TTHY_HUMAN & TTR & CATS_HUMAN & CTSS & GSTP1_HUMAN & GSTP1 & CAH12_HUMAN & CA12 & PNPH_HUMAN & PNP & PDE4B_HUMAN & PDE4B & P07900 &HSP90AA1 & CHLE_HUMAN & BCHE & CAH2_HUMAN & CA2 & Q9NP99 & TREM1 & STS_HUMAN & STS & PYRD_HUMAN & DHODH & O15496 & PLA2G10 & CASP7_HUMAN & CASP7 & Q16539 & MAPK14 & SRC_HUMAN & SRC & SEPR_HUMAN & FAP & P11142 & HSPA8 & CHK1_HUMAN & CHEK1 & ALBU_HUMAN & ALB & CTNA1_HUMAN & CTNNA1 & EST1_HUMAN & CES1 & MK08_HUMAN & MAPK8 & P62937 & PPIA & CAH1_HUMAN & CA1 & P04745 & AMY1A & P04745 & AMY1B & P04745 & AMY1C & BACE1_HUMAN & BACE1 & PRGR_HUMAN & PGR & ESR2_HUMAN & ES') 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 'FROM' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TO' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MK10_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK10' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P35968' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'KDR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TTHY_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TTR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CATS_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTSS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GSTP1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GSTP1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH12_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA12' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PNPH_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PNP' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PDE4B_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PDE4B' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P07900' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HSP90AA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHLE_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BCHE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH2_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'Q9NP99' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TREM1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STS_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PYRD_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DHODH' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'O15496' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PLA2G10' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CASP7_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CASP7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'Q16539' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK14' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SRC_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SRC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SEPR_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'FAP' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P11142' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HSPA8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHK1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEK1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ALBU_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ALB' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTNA1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTNNA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'EST1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CES1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MK08_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P62937' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PPIA' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1A' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1B' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1C' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BACE1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BACE1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PRGR_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PGR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ESR2_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ES')) 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 'FROM' OR upper(l.acc_txt) LIKE 'TO' OR upper(l.acc_txt) LIKE 'MK10_HUMAN' OR upper(l.acc_txt) LIKE 'MAPK10' OR upper(l.acc_txt) LIKE 'P35968' OR upper(l.acc_txt) LIKE 'KDR' OR upper(l.acc_txt) LIKE 'TTHY_HUMAN' OR upper(l.acc_txt) LIKE 'TTR' OR upper(l.acc_txt) LIKE 'CATS_HUMAN' OR upper(l.acc_txt) LIKE 'CTSS' OR upper(l.acc_txt) LIKE 'GSTP1_HUMAN' OR upper(l.acc_txt) LIKE 'GSTP1' OR upper(l.acc_txt) LIKE 'CAH12_HUMAN' OR upper(l.acc_txt) LIKE 'CA12' OR upper(l.acc_txt) LIKE 'PNPH_HUMAN' OR upper(l.acc_txt) LIKE 'PNP' OR upper(l.acc_txt) LIKE 'PDE4B_HUMAN' OR upper(l.acc_txt) LIKE 'PDE4B' OR upper(l.acc_txt) LIKE 'P07900' OR upper(l.acc_txt) LIKE 'HSP90AA1' OR upper(l.acc_txt) LIKE 'CHLE_HUMAN' OR upper(l.acc_txt) LIKE 'BCHE' OR upper(l.acc_txt) LIKE 'CAH2_HUMAN' OR upper(l.acc_txt) LIKE 'CA2' OR upper(l.acc_txt) LIKE 'Q9NP99' OR upper(l.acc_txt) LIKE 'TREM1' OR upper(l.acc_txt) LIKE 'STS_HUMAN' OR upper(l.acc_txt) LIKE 'STS' OR upper(l.acc_txt) LIKE 'PYRD_HUMAN' OR upper(l.acc_txt) LIKE 'DHODH' OR upper(l.acc_txt) LIKE 'O15496' OR upper(l.acc_txt) LIKE 'PLA2G10' OR upper(l.acc_txt) LIKE 'CASP7_HUMAN' OR upper(l.acc_txt) LIKE 'CASP7' OR upper(l.acc_txt) LIKE 'Q16539' OR upper(l.acc_txt) LIKE 'MAPK14' OR upper(l.acc_txt) LIKE 'SRC_HUMAN' OR upper(l.acc_txt) LIKE 'SRC' OR upper(l.acc_txt) LIKE 'SEPR_HUMAN' OR upper(l.acc_txt) LIKE 'FAP' OR upper(l.acc_txt) LIKE 'P11142' OR upper(l.acc_txt) LIKE 'HSPA8' OR upper(l.acc_txt) LIKE 'CHK1_HUMAN' OR upper(l.acc_txt) LIKE 'CHEK1' OR upper(l.acc_txt) LIKE 'ALBU_HUMAN' OR upper(l.acc_txt) LIKE 'ALB' OR upper(l.acc_txt) LIKE 'CTNA1_HUMAN' OR upper(l.acc_txt) LIKE 'CTNNA1' OR upper(l.acc_txt) LIKE 'EST1_HUMAN' OR upper(l.acc_txt) LIKE 'CES1' OR upper(l.acc_txt) LIKE 'MK08_HUMAN' OR upper(l.acc_txt) LIKE 'MAPK8' OR upper(l.acc_txt) LIKE 'P62937' OR upper(l.acc_txt) LIKE 'PPIA' OR upper(l.acc_txt) LIKE 'CAH1_HUMAN' OR upper(l.acc_txt) LIKE 'CA1' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1A' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1B' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1C' OR upper(l.acc_txt) LIKE 'BACE1_HUMAN' OR upper(l.acc_txt) LIKE 'BACE1' OR upper(l.acc_txt) LIKE 'PGR' OR upper(l.acc_txt) LIKE 'ESR2_HUMAN' OR upper(l.acc_txt) LIKE 'ES' OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd; [ Date:* 2025-10-28 04:07:04 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
4	3m36s	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', 'FROM & TO & MK10_HUMAN & MAPK10 & P35968 & KDR & TTHY_HUMAN & TTR & CATS_HUMAN & CTSS & GSTP1_HUMAN & GSTP1 & CAH12_HUMAN & CA12 & PNPH_HUMAN & PNP & PDE4B_HUMAN & PDE4B & P07900 & HSP90AA1 & CHLE_HUMAN & BCHE & CAH2_HUMAN & CA2 & Q9NP99 & TREM1 & STS_HUMAN & STS & PYRD_HUMAN & DHODH & O15496 & PLA2G10 & CASP7_HUMAN & CASP7 & Q16539 & MAPK14 & SRC_HUMAN & SRC & SEPR_HUMAN & FAP & P11142 & HSPA8 & CHK1_HUMAN & CHEK1 & ALBU_HUMAN & ALB & CTNA1_HUMAN & CTNNA1 & EST1_HUMAN & CES1 & MK08_HUMAN & MAPK8 & P62937 & PPIA & CAH1_HUMAN & CA1 & P04745 & AMY1A & P04745 & AMY1B & P04745 & AMY1C & BACE1_HUMAN & BACE1 & PRGR_HUMAN & PGR & ESR2_HUMAN & ES') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'FROM & TO & MK10_HUMAN & MAPK10 & P35968 & KDR & TTHY_HUMAN & TTR & CATS_HUMAN & CTSS & GSTP1_HUMAN & GSTP1 & CAH12_HUMAN & CA12 & PNPH_HUMAN & PNP & PDE4B_HUMAN & PDE4B & P07900 &HSP90AA1 & CHLE_HUMAN & BCHE & CAH2_HUMAN & CA2 & Q9NP99 & TREM1 & STS_HUMAN & STS & PYRD_HUMAN & DHODH & O15496 & PLA2G10 & CASP7_HUMAN & CASP7 & Q16539 & MAPK14 & SRC_HUMAN & SRC & SEPR_HUMAN & FAP & P11142 & HSPA8 & CHK1_HUMAN & CHEK1 & ALBU_HUMAN & ALB & CTNA1_HUMAN & CTNNA1 & EST1_HUMAN & CES1 & MK08_HUMAN & MAPK8 & P62937 & PPIA & CAH1_HUMAN & CA1 & P04745 & AMY1A & P04745 & AMY1B & P04745 & AMY1C & BACE1_HUMAN & BACE1 & PRGR_HUMAN & PGR & ESR2_HUMAN & ES') 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 'FROM' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TO' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MK10_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK10' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P35968' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'KDR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TTHY_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TTR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CATS_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTSS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GSTP1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GSTP1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH12_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA12' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PNPH_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PNP' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PDE4B_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PDE4B' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P07900' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HSP90AA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHLE_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BCHE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH2_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'Q9NP99' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TREM1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STS_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PYRD_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DHODH' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'O15496' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PLA2G10' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CASP7_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CASP7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'Q16539' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK14' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SRC_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SRC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SEPR_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'FAP' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P11142' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HSPA8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHK1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEK1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ALBU_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ALB' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTNA1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTNNA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'EST1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CES1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MK08_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P62937' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PPIA' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1A' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1B' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1C' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BACE1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BACE1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PRGR_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PGR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ESR2_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ES')) 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 'FROM' OR upper(l.acc_txt) LIKE 'TO' OR upper(l.acc_txt) LIKE 'MK10_HUMAN' OR upper(l.acc_txt) LIKE 'MAPK10' OR upper(l.acc_txt) LIKE 'P35968' OR upper(l.acc_txt) LIKE 'KDR' OR upper(l.acc_txt) LIKE 'TTHY_HUMAN' OR upper(l.acc_txt) LIKE 'TTR' OR upper(l.acc_txt) LIKE 'CATS_HUMAN' OR upper(l.acc_txt) LIKE 'CTSS' OR upper(l.acc_txt) LIKE 'GSTP1_HUMAN' OR upper(l.acc_txt) LIKE 'GSTP1' OR upper(l.acc_txt) LIKE 'CAH12_HUMAN' OR upper(l.acc_txt) LIKE 'CA12' OR upper(l.acc_txt) LIKE 'PNPH_HUMAN' OR upper(l.acc_txt) LIKE 'PNP' OR upper(l.acc_txt) LIKE 'PDE4B_HUMAN' OR upper(l.acc_txt) LIKE 'PDE4B' OR upper(l.acc_txt) LIKE 'P07900' OR upper(l.acc_txt) LIKE 'HSP90AA1' OR upper(l.acc_txt) LIKE 'CHLE_HUMAN' OR upper(l.acc_txt) LIKE 'BCHE' OR upper(l.acc_txt) LIKE 'CAH2_HUMAN' OR upper(l.acc_txt) LIKE 'CA2' OR upper(l.acc_txt) LIKE 'Q9NP99' OR upper(l.acc_txt) LIKE 'TREM1' OR upper(l.acc_txt) LIKE 'STS_HUMAN' OR upper(l.acc_txt) LIKE 'STS' OR upper(l.acc_txt) LIKE 'PYRD_HUMAN' OR upper(l.acc_txt) LIKE 'DHODH' OR upper(l.acc_txt) LIKE 'O15496' OR upper(l.acc_txt) LIKE 'PLA2G10' OR upper(l.acc_txt) LIKE 'CASP7_HUMAN' OR upper(l.acc_txt) LIKE 'CASP7' OR upper(l.acc_txt) LIKE 'Q16539' OR upper(l.acc_txt) LIKE 'MAPK14' OR upper(l.acc_txt) LIKE 'SRC_HUMAN' OR upper(l.acc_txt) LIKE 'SRC' OR upper(l.acc_txt) LIKE 'SEPR_HUMAN' OR upper(l.acc_txt) LIKE 'FAP' OR upper(l.acc_txt) LIKE 'P11142' OR upper(l.acc_txt) LIKE 'HSPA8' OR upper(l.acc_txt) LIKE 'CHK1_HUMAN' OR upper(l.acc_txt) LIKE 'CHEK1' OR upper(l.acc_txt) LIKE 'ALBU_HUMAN' OR upper(l.acc_txt) LIKE 'ALB' OR upper(l.acc_txt) LIKE 'CTNA1_HUMAN' OR upper(l.acc_txt) LIKE 'CTNNA1' OR upper(l.acc_txt) LIKE 'EST1_HUMAN' OR upper(l.acc_txt) LIKE 'CES1' OR upper(l.acc_txt) LIKE 'MK08_HUMAN' OR upper(l.acc_txt) LIKE 'MAPK8' OR upper(l.acc_txt) LIKE 'P62937' OR upper(l.acc_txt) LIKE 'PPIA' OR upper(l.acc_txt) LIKE 'CAH1_HUMAN' OR upper(l.acc_txt) LIKE 'CA1' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1A' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1B' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1C' OR upper(l.acc_txt) LIKE 'BACE1_HUMAN' OR upper(l.acc_txt) LIKE 'BACE1' OR upper(l.acc_txt) LIKE 'PGR' OR upper(l.acc_txt) LIKE 'ESR2_HUMAN' OR upper(l.acc_txt) LIKE 'ES' OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd; [ Date:* 2025-10-28 04:07:55 - Bind query: yes ]
5	3m35s	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', 'FROM & TO & MK10_HUMAN & MAPK10 & P35968 & KDR & TTHY_HUMAN & TTR & CATS_HUMAN & CTSS & GSTP1_HUMAN & GSTP1 & CAH12_HUMAN & CA12 & PNPH_HUMAN & PNP & PDE4B_HUMAN & PDE4B & P07900 & HSP90AA1 & CHLE_HUMAN & BCHE & CAH2_HUMAN & CA2 & Q9NP99 & TREM1 & STS_HUMAN & STS & PYRD_HUMAN & DHODH & O15496 & PLA2G10 & CASP7_HUMAN & CASP7 & Q16539 & MAPK14 & SRC_HUMAN & SRC & SEPR_HUMAN & FAP & P11142 & HSPA8 & CHK1_HUMAN & CHEK1 & ALBU_HUMAN & ALB & CTNA1_HUMAN & CTNNA1 & EST1_HUMAN & CES1 & MK08_HUMAN & MAPK8 & P62937 & PPIA & CAH1_HUMAN & CA1 & P04745 & AMY1A & P04745 & AMY1B & P04745 & AMY1C & BACE1_HUMAN & BACE1 & PRGR_HUMAN & PGR & ESR2_HUMAN & ES') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'FROM & TO & MK10_HUMAN & MAPK10 & P35968 & KDR & TTHY_HUMAN & TTR & CATS_HUMAN & CTSS & GSTP1_HUMAN & GSTP1 & CAH12_HUMAN & CA12 & PNPH_HUMAN & PNP & PDE4B_HUMAN & PDE4B & P07900 &HSP90AA1 & CHLE_HUMAN & BCHE & CAH2_HUMAN & CA2 & Q9NP99 & TREM1 & STS_HUMAN & STS & PYRD_HUMAN & DHODH & O15496 & PLA2G10 & CASP7_HUMAN & CASP7 & Q16539 & MAPK14 & SRC_HUMAN & SRC & SEPR_HUMAN & FAP & P11142 & HSPA8 & CHK1_HUMAN & CHEK1 & ALBU_HUMAN & ALB & CTNA1_HUMAN & CTNNA1 & EST1_HUMAN & CES1 & MK08_HUMAN & MAPK8 & P62937 & PPIA & CAH1_HUMAN & CA1 & P04745 & AMY1A & P04745 & AMY1B & P04745 & AMY1C & BACE1_HUMAN & BACE1 & PRGR_HUMAN & PGR & ESR2_HUMAN & ES') 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 'FROM' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TO' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MK10_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK10' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P35968' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'KDR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TTHY_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TTR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CATS_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTSS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GSTP1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GSTP1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH12_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA12' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PNPH_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PNP' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PDE4B_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PDE4B' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P07900' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HSP90AA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHLE_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BCHE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH2_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'Q9NP99' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TREM1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STS_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PYRD_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DHODH' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'O15496' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PLA2G10' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CASP7_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CASP7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'Q16539' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK14' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SRC_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SRC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SEPR_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'FAP' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P11142' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HSPA8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHK1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEK1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ALBU_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ALB' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTNA1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTNNA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'EST1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CES1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MK08_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P62937' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PPIA' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1A' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1B' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1C' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BACE1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BACE1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PRGR_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PGR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ESR2_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ES')) 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 'FROM' OR upper(l.acc_txt) LIKE 'TO' OR upper(l.acc_txt) LIKE 'MK10_HUMAN' OR upper(l.acc_txt) LIKE 'MAPK10' OR upper(l.acc_txt) LIKE 'P35968' OR upper(l.acc_txt) LIKE 'KDR' OR upper(l.acc_txt) LIKE 'TTHY_HUMAN' OR upper(l.acc_txt) LIKE 'TTR' OR upper(l.acc_txt) LIKE 'CATS_HUMAN' OR upper(l.acc_txt) LIKE 'CTSS' OR upper(l.acc_txt) LIKE 'GSTP1_HUMAN' OR upper(l.acc_txt) LIKE 'GSTP1' OR upper(l.acc_txt) LIKE 'CAH12_HUMAN' OR upper(l.acc_txt) LIKE 'CA12' OR upper(l.acc_txt) LIKE 'PNPH_HUMAN' OR upper(l.acc_txt) LIKE 'PNP' OR upper(l.acc_txt) LIKE 'PDE4B_HUMAN' OR upper(l.acc_txt) LIKE 'PDE4B' OR upper(l.acc_txt) LIKE 'P07900' OR upper(l.acc_txt) LIKE 'HSP90AA1' OR upper(l.acc_txt) LIKE 'CHLE_HUMAN' OR upper(l.acc_txt) LIKE 'BCHE' OR upper(l.acc_txt) LIKE 'CAH2_HUMAN' OR upper(l.acc_txt) LIKE 'CA2' OR upper(l.acc_txt) LIKE 'Q9NP99' OR upper(l.acc_txt) LIKE 'TREM1' OR upper(l.acc_txt) LIKE 'STS_HUMAN' OR upper(l.acc_txt) LIKE 'STS' OR upper(l.acc_txt) LIKE 'PYRD_HUMAN' OR upper(l.acc_txt) LIKE 'DHODH' OR upper(l.acc_txt) LIKE 'O15496' OR upper(l.acc_txt) LIKE 'PLA2G10' OR upper(l.acc_txt) LIKE 'CASP7_HUMAN' OR upper(l.acc_txt) LIKE 'CASP7' OR upper(l.acc_txt) LIKE 'Q16539' OR upper(l.acc_txt) LIKE 'MAPK14' OR upper(l.acc_txt) LIKE 'SRC_HUMAN' OR upper(l.acc_txt) LIKE 'SRC' OR upper(l.acc_txt) LIKE 'SEPR_HUMAN' OR upper(l.acc_txt) LIKE 'FAP' OR upper(l.acc_txt) LIKE 'P11142' OR upper(l.acc_txt) LIKE 'HSPA8' OR upper(l.acc_txt) LIKE 'CHK1_HUMAN' OR upper(l.acc_txt) LIKE 'CHEK1' OR upper(l.acc_txt) LIKE 'ALBU_HUMAN' OR upper(l.acc_txt) LIKE 'ALB' OR upper(l.acc_txt) LIKE 'CTNA1_HUMAN' OR upper(l.acc_txt) LIKE 'CTNNA1' OR upper(l.acc_txt) LIKE 'EST1_HUMAN' OR upper(l.acc_txt) LIKE 'CES1' OR upper(l.acc_txt) LIKE 'MK08_HUMAN' OR upper(l.acc_txt) LIKE 'MAPK8' OR upper(l.acc_txt) LIKE 'P62937' OR upper(l.acc_txt) LIKE 'PPIA' OR upper(l.acc_txt) LIKE 'CAH1_HUMAN' OR upper(l.acc_txt) LIKE 'CA1' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1A' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1B' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1C' OR upper(l.acc_txt) LIKE 'BACE1_HUMAN' OR upper(l.acc_txt) LIKE 'BACE1' OR upper(l.acc_txt) LIKE 'PGR' OR upper(l.acc_txt) LIKE 'ESR2_HUMAN' OR upper(l.acc_txt) LIKE 'ES' OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd; [ Date:* 2025-10-28 04:10:34 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
6	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', 'FROM & TO & MK10_HUMAN & MAPK10 & P35968 & KDR & TTHY_HUMAN & TTR & CATS_HUMAN & CTSS & GSTP1_HUMAN & GSTP1 & CAH12_HUMAN & CA12 & PNPH_HUMAN & PNP & PDE4B_HUMAN & PDE4B & P07900 & HSP90AA1 & CHLE_HUMAN & BCHE & CAH2_HUMAN & CA2 & Q9NP99 & TREM1 & STS_HUMAN & STS & PYRD_HUMAN & DHODH & O15496 & PLA2G10 & CASP7_HUMAN & CASP7 & Q16539 & MAPK14 & SRC_HUMAN & SRC & SEPR_HUMAN & FAP & P11142 & HSPA8 & CHK1_HUMAN & CHEK1 & ALBU_HUMAN & ALB & CTNA1_HUMAN & CTNNA1 & EST1_HUMAN & CES1 & MK08_HUMAN & MAPK8 & P62937 & PPIA & CAH1_HUMAN & CA1 & P04745 & AMY1A & P04745 & AMY1B & P04745 & AMY1C & BACE1_HUMAN & BACE1 & PRGR_HUMAN & PGR & ESR2_HUMAN & ES') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'FROM & TO & MK10_HUMAN & MAPK10 & P35968 & KDR & TTHY_HUMAN & TTR & CATS_HUMAN & CTSS & GSTP1_HUMAN & GSTP1 & CAH12_HUMAN & CA12 & PNPH_HUMAN & PNP & PDE4B_HUMAN & PDE4B & P07900 &HSP90AA1 & CHLE_HUMAN & BCHE & CAH2_HUMAN & CA2 & Q9NP99 & TREM1 & STS_HUMAN & STS & PYRD_HUMAN & DHODH & O15496 & PLA2G10 & CASP7_HUMAN & CASP7 & Q16539 & MAPK14 & SRC_HUMAN & SRC & SEPR_HUMAN & FAP & P11142 & HSPA8 & CHK1_HUMAN & CHEK1 & ALBU_HUMAN & ALB & CTNA1_HUMAN & CTNNA1 & EST1_HUMAN & CES1 & MK08_HUMAN & MAPK8 & P62937 & PPIA & CAH1_HUMAN & CA1 & P04745 & AMY1A & P04745 & AMY1B & P04745 & AMY1C & BACE1_HUMAN & BACE1 & PRGR_HUMAN & PGR & ESR2_HUMAN & ES') 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 'FROM' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TO' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MK10_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK10' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P35968' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'KDR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TTHY_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TTR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CATS_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTSS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GSTP1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GSTP1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH12_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA12' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PNPH_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PNP' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PDE4B_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PDE4B' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P07900' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HSP90AA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHLE_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BCHE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH2_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'Q9NP99' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TREM1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STS_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PYRD_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DHODH' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'O15496' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PLA2G10' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CASP7_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CASP7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'Q16539' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK14' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SRC_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SRC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SEPR_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'FAP' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P11142' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HSPA8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHK1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHEK1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ALBU_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ALB' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTNA1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTNNA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'EST1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CES1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MK08_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MAPK8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P62937' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PPIA' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CAH1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CA1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1A' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1B' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'P04745' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AMY1C' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BACE1_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'BACE1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PRGR_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PGR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ESR2_HUMAN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ES')) 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 'FROM' OR upper(l.acc_txt) LIKE 'TO' OR upper(l.acc_txt) LIKE 'MK10_HUMAN' OR upper(l.acc_txt) LIKE 'MAPK10' OR upper(l.acc_txt) LIKE 'P35968' OR upper(l.acc_txt) LIKE 'KDR' OR upper(l.acc_txt) LIKE 'TTHY_HUMAN' OR upper(l.acc_txt) LIKE 'TTR' OR upper(l.acc_txt) LIKE 'CATS_HUMAN' OR upper(l.acc_txt) LIKE 'CTSS' OR upper(l.acc_txt) LIKE 'GSTP1_HUMAN' OR upper(l.acc_txt) LIKE 'GSTP1' OR upper(l.acc_txt) LIKE 'CAH12_HUMAN' OR upper(l.acc_txt) LIKE 'CA12' OR upper(l.acc_txt) LIKE 'PNPH_HUMAN' OR upper(l.acc_txt) LIKE 'PNP' OR upper(l.acc_txt) LIKE 'PDE4B_HUMAN' OR upper(l.acc_txt) LIKE 'PDE4B' OR upper(l.acc_txt) LIKE 'P07900' OR upper(l.acc_txt) LIKE 'HSP90AA1' OR upper(l.acc_txt) LIKE 'CHLE_HUMAN' OR upper(l.acc_txt) LIKE 'BCHE' OR upper(l.acc_txt) LIKE 'CAH2_HUMAN' OR upper(l.acc_txt) LIKE 'CA2' OR upper(l.acc_txt) LIKE 'Q9NP99' OR upper(l.acc_txt) LIKE 'TREM1' OR upper(l.acc_txt) LIKE 'STS_HUMAN' OR upper(l.acc_txt) LIKE 'STS' OR upper(l.acc_txt) LIKE 'PYRD_HUMAN' OR upper(l.acc_txt) LIKE 'DHODH' OR upper(l.acc_txt) LIKE 'O15496' OR upper(l.acc_txt) LIKE 'PLA2G10' OR upper(l.acc_txt) LIKE 'CASP7_HUMAN' OR upper(l.acc_txt) LIKE 'CASP7' OR upper(l.acc_txt) LIKE 'Q16539' OR upper(l.acc_txt) LIKE 'MAPK14' OR upper(l.acc_txt) LIKE 'SRC_HUMAN' OR upper(l.acc_txt) LIKE 'SRC' OR upper(l.acc_txt) LIKE 'SEPR_HUMAN' OR upper(l.acc_txt) LIKE 'FAP' OR upper(l.acc_txt) LIKE 'P11142' OR upper(l.acc_txt) LIKE 'HSPA8' OR upper(l.acc_txt) LIKE 'CHK1_HUMAN' OR upper(l.acc_txt) LIKE 'CHEK1' OR upper(l.acc_txt) LIKE 'ALBU_HUMAN' OR upper(l.acc_txt) LIKE 'ALB' OR upper(l.acc_txt) LIKE 'CTNA1_HUMAN' OR upper(l.acc_txt) LIKE 'CTNNA1' OR upper(l.acc_txt) LIKE 'EST1_HUMAN' OR upper(l.acc_txt) LIKE 'CES1' OR upper(l.acc_txt) LIKE 'MK08_HUMAN' OR upper(l.acc_txt) LIKE 'MAPK8' OR upper(l.acc_txt) LIKE 'P62937' OR upper(l.acc_txt) LIKE 'PPIA' OR upper(l.acc_txt) LIKE 'CAH1_HUMAN' OR upper(l.acc_txt) LIKE 'CA1' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1A' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1B' OR upper(l.acc_txt) LIKE 'P04745' OR upper(l.acc_txt) LIKE 'AMY1C' OR upper(l.acc_txt) LIKE 'BACE1_HUMAN' OR upper(l.acc_txt) LIKE 'BACE1' OR upper(l.acc_txt) LIKE 'PGR' OR upper(l.acc_txt) LIKE 'ESR2_HUMAN' OR upper(l.acc_txt) LIKE 'ES' OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd; [ Date:* 2025-10-28 04:02:33 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
7	2m	SELECT /* BatchDiseaseGeneAssnsDAO / 'kidney disease' "Input", d.nm "DiseaseName", d.acc_db_cd \|\| ':' \|\| d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '\|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '\|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '\|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '\|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2118653) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '\|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm; [ Date:* 2025-10-28 02:54:39 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
8	1m58s	SELECT /* BatchDiseaseGeneAssnsDAO / 'kidney disease' "Input", d.nm "DiseaseName", d.acc_db_cd \|\| ':' \|\| d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '\|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '\|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '\|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '\|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2118653) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '\|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm; [ Date:* 2025-10-28 03:37:20 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
9	22s513ms	SELECT /* BatchDiseasePhenotypeAssnsDAO / 'go:0006915' AS "Input", phenotypeTerm.nm as "PhenotypeName", phenotypeTerm.acc_txt as "PhenotypeID", diseaseTerm.nm as "DiseaseName", diseaseTerm.acc_db_cd \|\| ':' \|\| diseaseTerm.acc_txt "DiseaseID", ( SELECT STRING_AGG(distinct geneTerm.nm, '\|') from term geneTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = geneTerm.id and ptr.via_term_object_type_id = 4) AS "GeneInferenceNetwork", ( SELECT STRING_AGG(distinct chemTerm.nm, '\|') from term chemTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = chemTerm.id and ptr.via_term_object_type_id = 2) AS "ChemInferenceNetwork", ( SELECT STRING_AGG(distinct r.acc_txt, '\|') from reference r, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and (r.id = ptr.reference_id or r.id = ptr.term_reference_id)) AS "PubMedIDs" FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE (phenotypeTerm.id = 1270787) and diseaseTerm.object_type_id = 3; [ Date:* 2025-10-28 01:43:24 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
10	22s479ms	SELECT /* BatchDiseasePhenotypeAssnsDAO / 'go:0006915' AS "Input", phenotypeTerm.nm as "PhenotypeName", phenotypeTerm.acc_txt as "PhenotypeID", diseaseTerm.nm as "DiseaseName", diseaseTerm.acc_db_cd \|\| ':' \|\| diseaseTerm.acc_txt "DiseaseID", ( SELECT STRING_AGG(distinct geneTerm.nm, '\|') from term geneTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = geneTerm.id and ptr.via_term_object_type_id = 4) AS "GeneInferenceNetwork", ( SELECT STRING_AGG(distinct chemTerm.nm, '\|') from term chemTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = chemTerm.id and ptr.via_term_object_type_id = 2) AS "ChemInferenceNetwork", ( SELECT STRING_AGG(distinct r.acc_txt, '\|') from reference r, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and (r.id = ptr.reference_id or r.id = ptr.term_reference_id)) AS "PubMedIDs" FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE (phenotypeTerm.id = 1270787) and diseaseTerm.object_type_id = 3; [ Date:* 2025-10-28 01:55:41 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
11	22s325ms	SELECT /* BatchDiseasePhenotypeAssnsDAO / 'go:0006915' AS "Input", phenotypeTerm.nm as "PhenotypeName", phenotypeTerm.acc_txt as "PhenotypeID", diseaseTerm.nm as "DiseaseName", diseaseTerm.acc_db_cd \|\| ':' \|\| diseaseTerm.acc_txt "DiseaseID", ( SELECT STRING_AGG(distinct geneTerm.nm, '\|') from term geneTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = geneTerm.id and ptr.via_term_object_type_id = 4) AS "GeneInferenceNetwork", ( SELECT STRING_AGG(distinct chemTerm.nm, '\|') from term chemTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = chemTerm.id and ptr.via_term_object_type_id = 2) AS "ChemInferenceNetwork", ( SELECT STRING_AGG(distinct r.acc_txt, '\|') from reference r, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and (r.id = ptr.reference_id or r.id = ptr.term_reference_id)) AS "PubMedIDs" FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE (phenotypeTerm.id = 1270787) and diseaseTerm.object_type_id = 3; [ Date:* 2025-10-28 02:26:37 - Bind query: yes ]
12	22s223ms	SELECT /* BatchDiseasePhenotypeAssnsDAO / 'go:0006915' AS "Input", phenotypeTerm.nm as "PhenotypeName", phenotypeTerm.acc_txt as "PhenotypeID", diseaseTerm.nm as "DiseaseName", diseaseTerm.acc_db_cd \|\| ':' \|\| diseaseTerm.acc_txt "DiseaseID", ( SELECT STRING_AGG(distinct geneTerm.nm, '\|') from term geneTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = geneTerm.id and ptr.via_term_object_type_id = 4) AS "GeneInferenceNetwork", ( SELECT STRING_AGG(distinct chemTerm.nm, '\|') from term chemTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = chemTerm.id and ptr.via_term_object_type_id = 2) AS "ChemInferenceNetwork", ( SELECT STRING_AGG(distinct r.acc_txt, '\|') from reference r, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and (r.id = ptr.reference_id or r.id = ptr.term_reference_id)) AS "PubMedIDs" FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE (phenotypeTerm.id = 1270787) and diseaseTerm.object_type_id = 3; [ Date:* 2025-10-28 02:19:12 - Bind query: yes ]
13	22s197ms	SELECT /* BatchDiseasePhenotypeAssnsDAO / 'go:0006915' AS "Input", phenotypeTerm.nm as "PhenotypeName", phenotypeTerm.acc_txt as "PhenotypeID", diseaseTerm.nm as "DiseaseName", diseaseTerm.acc_db_cd \|\| ':' \|\| diseaseTerm.acc_txt "DiseaseID", ( SELECT STRING_AGG(distinct geneTerm.nm, '\|') from term geneTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = geneTerm.id and ptr.via_term_object_type_id = 4) AS "GeneInferenceNetwork", ( SELECT STRING_AGG(distinct chemTerm.nm, '\|') from term chemTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = chemTerm.id and ptr.via_term_object_type_id = 2) AS "ChemInferenceNetwork", ( SELECT STRING_AGG(distinct r.acc_txt, '\|') from reference r, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and (r.id = ptr.reference_id or r.id = ptr.term_reference_id)) AS "PubMedIDs" FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE (phenotypeTerm.id = 1270787) and diseaseTerm.object_type_id = 3; [ Date:* 2025-10-28 02:20:52 - Bind query: yes ]
14	22s119ms	SELECT /* BatchDiseasePhenotypeAssnsDAO / 'go:0006915' AS "Input", phenotypeTerm.nm as "PhenotypeName", phenotypeTerm.acc_txt as "PhenotypeID", diseaseTerm.nm as "DiseaseName", diseaseTerm.acc_db_cd \|\| ':' \|\| diseaseTerm.acc_txt "DiseaseID", ( SELECT STRING_AGG(distinct geneTerm.nm, '\|') from term geneTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = geneTerm.id and ptr.via_term_object_type_id = 4) AS "GeneInferenceNetwork", ( SELECT STRING_AGG(distinct chemTerm.nm, '\|') from term chemTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = chemTerm.id and ptr.via_term_object_type_id = 2) AS "ChemInferenceNetwork", ( SELECT STRING_AGG(distinct r.acc_txt, '\|') from reference r, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and (r.id = ptr.reference_id or r.id = ptr.term_reference_id)) AS "PubMedIDs" FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE (phenotypeTerm.id = 1270787) and diseaseTerm.object_type_id = 3; [ Date:* 2025-10-28 04:21:51 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
15	22s116ms	SELECT /* BatchDiseasePhenotypeAssnsDAO / 'go:0006915' AS "Input", phenotypeTerm.nm as "PhenotypeName", phenotypeTerm.acc_txt as "PhenotypeID", diseaseTerm.nm as "DiseaseName", diseaseTerm.acc_db_cd \|\| ':' \|\| diseaseTerm.acc_txt "DiseaseID", ( SELECT STRING_AGG(distinct geneTerm.nm, '\|') from term geneTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = geneTerm.id and ptr.via_term_object_type_id = 4) AS "GeneInferenceNetwork", ( SELECT STRING_AGG(distinct chemTerm.nm, '\|') from term chemTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = chemTerm.id and ptr.via_term_object_type_id = 2) AS "ChemInferenceNetwork", ( SELECT STRING_AGG(distinct r.acc_txt, '\|') from reference r, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and (r.id = ptr.reference_id or r.id = ptr.term_reference_id)) AS "PubMedIDs" FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE (phenotypeTerm.id = 1270787) and diseaseTerm.object_type_id = 3; [ Date:* 2025-10-28 05:47:32 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
16	22s97ms	SELECT /* BatchDiseasePhenotypeAssnsDAO / 'go:0006915' AS "Input", phenotypeTerm.nm as "PhenotypeName", phenotypeTerm.acc_txt as "PhenotypeID", diseaseTerm.nm as "DiseaseName", diseaseTerm.acc_db_cd \|\| ':' \|\| diseaseTerm.acc_txt "DiseaseID", ( SELECT STRING_AGG(distinct geneTerm.nm, '\|') from term geneTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = geneTerm.id and ptr.via_term_object_type_id = 4) AS "GeneInferenceNetwork", ( SELECT STRING_AGG(distinct chemTerm.nm, '\|') from term chemTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = chemTerm.id and ptr.via_term_object_type_id = 2) AS "ChemInferenceNetwork", ( SELECT STRING_AGG(distinct r.acc_txt, '\|') from reference r, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and (r.id = ptr.reference_id or r.id = ptr.term_reference_id)) AS "PubMedIDs" FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE (phenotypeTerm.id = 1270787) and diseaseTerm.object_type_id = 3; [ Date:* 2025-10-28 05:18:23 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
17	22s6ms	SELECT /* BatchDiseasePhenotypeAssnsDAO / 'go:0006915' AS "Input", phenotypeTerm.nm as "PhenotypeName", phenotypeTerm.acc_txt as "PhenotypeID", diseaseTerm.nm as "DiseaseName", diseaseTerm.acc_db_cd \|\| ':' \|\| diseaseTerm.acc_txt "DiseaseID", ( SELECT STRING_AGG(distinct geneTerm.nm, '\|') from term geneTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = geneTerm.id and ptr.via_term_object_type_id = 4) AS "GeneInferenceNetwork", ( SELECT STRING_AGG(distinct chemTerm.nm, '\|') from term chemTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = chemTerm.id and ptr.via_term_object_type_id = 2) AS "ChemInferenceNetwork", ( SELECT STRING_AGG(distinct r.acc_txt, '\|') from reference r, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and (r.id = ptr.reference_id or r.id = ptr.term_reference_id)) AS "PubMedIDs" FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE (phenotypeTerm.id = 1270787) and diseaseTerm.object_type_id = 3; [ Date:* 2025-10-28 02:31:25 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
18	21s919ms	SELECT /* BatchDiseasePhenotypeAssnsDAO / 'go:0006915' AS "Input", phenotypeTerm.nm as "PhenotypeName", phenotypeTerm.acc_txt as "PhenotypeID", diseaseTerm.nm as "DiseaseName", diseaseTerm.acc_db_cd \|\| ':' \|\| diseaseTerm.acc_txt "DiseaseID", ( SELECT STRING_AGG(distinct geneTerm.nm, '\|') from term geneTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = geneTerm.id and ptr.via_term_object_type_id = 4) AS "GeneInferenceNetwork", ( SELECT STRING_AGG(distinct chemTerm.nm, '\|') from term chemTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = chemTerm.id and ptr.via_term_object_type_id = 2) AS "ChemInferenceNetwork", ( SELECT STRING_AGG(distinct r.acc_txt, '\|') from reference r, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and (r.id = ptr.reference_id or r.id = ptr.term_reference_id)) AS "PubMedIDs" FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE (phenotypeTerm.id = 1270787) and diseaseTerm.object_type_id = 3; [ Date:* 2025-10-28 02:40:29 - Bind query: yes ]
19	21s907ms	SELECT /* BatchDiseasePhenotypeAssnsDAO / 'go:0006915' AS "Input", phenotypeTerm.nm as "PhenotypeName", phenotypeTerm.acc_txt as "PhenotypeID", diseaseTerm.nm as "DiseaseName", diseaseTerm.acc_db_cd \|\| ':' \|\| diseaseTerm.acc_txt "DiseaseID", ( SELECT STRING_AGG(distinct geneTerm.nm, '\|') from term geneTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = geneTerm.id and ptr.via_term_object_type_id = 4) AS "GeneInferenceNetwork", ( SELECT STRING_AGG(distinct chemTerm.nm, '\|') from term chemTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = chemTerm.id and ptr.via_term_object_type_id = 2) AS "ChemInferenceNetwork", ( SELECT STRING_AGG(distinct r.acc_txt, '\|') from reference r, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and (r.id = ptr.reference_id or r.id = ptr.term_reference_id)) AS "PubMedIDs" FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE (phenotypeTerm.id = 1270787) and diseaseTerm.object_type_id = 3; [ Date:* 2025-10-28 05:38:09 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
20	21s860ms	SELECT /* BatchDiseasePhenotypeAssnsDAO / 'go:0006915' AS "Input", phenotypeTerm.nm as "PhenotypeName", phenotypeTerm.acc_txt as "PhenotypeID", diseaseTerm.nm as "DiseaseName", diseaseTerm.acc_db_cd \|\| ':' \|\| diseaseTerm.acc_txt "DiseaseID", ( SELECT STRING_AGG(distinct geneTerm.nm, '\|') from term geneTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = geneTerm.id and ptr.via_term_object_type_id = 4) AS "GeneInferenceNetwork", ( SELECT STRING_AGG(distinct chemTerm.nm, '\|') from term chemTerm, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and ptr.via_term_id = chemTerm.id and ptr.via_term_object_type_id = 2) AS "ChemInferenceNetwork", ( SELECT STRING_AGG(distinct r.acc_txt, '\|') from reference r, phenotype_term_reference ptr where pt.phenotype_id = ptr.phenotype_id and pt.term_id = ptr.term_id and (r.id = ptr.reference_id or r.id = ptr.term_reference_id)) AS "PubMedIDs" FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE (phenotypeTerm.id = 1270787) and diseaseTerm.object_type_id = 3; [ Date:* 2025-10-28 00:51:49 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

Time consuming queries (N)


[ User: pubeu - Total duration: 1h10s - Times executed: 275 ]
[ User: pubeu - Total duration: 14m29s - Times executed: 4 ]
[ User: pubc - Total duration: 10m57s - Times executed: 1 ]
[ User: pubeu - Total duration: 3m58s - Times executed: 2 ]
[ User: pubeu - Total duration: 12s375ms - Times executed: 1 ]
[ User: pubeu - Total duration: 19s741ms - Times executed: 1 ]
[ User: pubeu - Total duration: 17s954ms - Times executed: 1 ]
[ User: pubeu - Total duration: 16s476ms - Times executed: 3 ]
[ User: qaeu - Total duration: 7s198ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s222ms - Times executed: 1 ]
[ User: pubeu - Total duration: 12s815ms - Times executed: 2 ]
[ User: qaeu - Total duration: 5s76ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s142ms - Times executed: 1 ]
Date: 2025-10-28 00:11:06
Duration: 6s790ms
[ User: pubeu - Total duration: 6s316ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s785ms - Times executed: 1 ]

Most frequent queries (N)


[ User: pubeu - Total duration: 1h10s - Times executed: 275 ]
[ User: pubeu - Total duration: 14m29s - Times executed: 4 ]
[ User: pubeu - Total duration: 12s375ms - Times executed: 1 ]
[ User: pubeu - Total duration: 16s476ms - Times executed: 3 ]
[ User: pubeu - Total duration: 3m58s - Times executed: 2 ]
[ User: qaeu - Total duration: 7s198ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s222ms - Times executed: 1 ]
[ User: pubeu - Total duration: 12s815ms - Times executed: 2 ]
[ User: qaeu - Total duration: 5s76ms - Times executed: 1 ]
[ User: pubc - Total duration: 10m57s - Times executed: 1 ]
[ User: pubeu - Total duration: 19s741ms - Times executed: 1 ]
[ User: pubeu - Total duration: 17s954ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s142ms - Times executed: 1 ]
Date: 2025-10-28 00:11:06
Duration: 6s790ms
[ User: pubeu - Total duration: 6s316ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s785ms - Times executed: 1 ]

Normalized slowest queries (N)


[ User: pubc - Total duration: 10m57s - Times executed: 1 ]
[ User: pubeu - Total duration: 14m29s - Times executed: 4 ]
[ User: pubeu - Total duration: 3m58s - Times executed: 2 ]
[ User: pubeu - Total duration: 19s741ms - Times executed: 1 ]
[ User: pubeu - Total duration: 17s954ms - Times executed: 1 ]
[ User: pubeu - Total duration: 1h10s - Times executed: 275 ]
[ User: pubeu - Total duration: 12s375ms - Times executed: 1 ]
[ User: qaeu - Total duration: 7s198ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s222ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s142ms - Times executed: 1 ]
Date: 2025-10-28 00:11:06
Duration: 6s790ms
[ User: pubeu - Total duration: 12s815ms - Times executed: 2 ]
[ User: pubeu - Total duration: 6s316ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s785ms - Times executed: 1 ]
[ User: pubeu - Total duration: 16s476ms - Times executed: 3 ]
[ User: qaeu - Total duration: 5s76ms - Times executed: 1 ]

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

5

Details

0ms

;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
Oct 28	04	5	0ms	0ms

[ User: pubeu - Total duration: 14m29s - Times executed: 4 ]

;

Date: Duration: 0ms Database: postgres User: ctdprd51 Remote: pubeu

Log levels

Key values

9,965 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
DETAIL	489	4.91%
ERROR	1	0.01%
EVENTLOG	4	0.04%
LOG	9,468	95.01%
STATEMENT	1	0.01%
WARNING	2	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
0 FATAL entries
1 ERROR entries
2 WARNING entries
4 EVENTLOG entries

Most Frequent Errors/Events

Key values

4 Max number of times the same event was reported
7 Total events found

Rank

Times reported

Error

1

4

Details

LOG: could not receive data from client: Connection reset by peer

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Oct 28	18	4

2

Details

WARNING: is not a PostgreSQL server process

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Oct 28	18	2

3

1

Details

ERROR: permission denied for schema ...

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Oct 28	10	1

ERROR: permission denied for schema pubc at character 15

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Average Autovacuum Duration

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Pages removed per tables

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values