pgBadger-
Global information
- Generated on Tue Aug 5 04:10:03 2025
- Log file: /project/archive/log/postgres/dbdev51/postgresql.log-20250804
- Parsed 583 log entries in 2s
- Log start from 2025-08-04 10:40:53 to 2025-08-04 16:20:57
-
Overview
Global Stats
- 2 Number of unique normalized queries
- 12 Number of queries
- 40s223ms Total query duration
- 2025-08-04 14:45:21 First query
- 2025-08-04 15:34:26 Last query
- 3 queries/s at 2025-08-04 14:45:21 Query peak
- 40s223ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 40s223ms Execute total duration
- 12 Number of events
- 4 Number of unique normalized events
- 9 Max number of times the same event was reported
- 0 Number of cancellation
- 1 Total number of automatic vacuums
- 1 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 55 Total number of sessions
- 15 sessions at 2025-08-04 15:15:02 Session peak
- 22h6m11s Total duration of sessions
- 24m6s Average duration of sessions
- 0 Average queries per session
- 731ms Average queries duration per session
- 24m6s Average idle time per session
- 63 Total number of connections
- 9 connections/s at 2025-08-04 14:47:09 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-08-04 14:45:21 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2025-08-04 14:45:21 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 40s223ms 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) Aug 04 10 0 0ms 0ms 0ms 0ms 0ms 0ms 14 6 0ms 5s352ms 3s256ms 12s94ms 12s94ms 12s94ms 15 6 0ms 4s419ms 3s447ms 7s484ms 7s486ms 7s486ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 04 10 0 0 0ms 0ms 0ms 0ms 14 6 0 3s256ms 7s444ms 12s94ms 12s94ms 15 6 0 3s447ms 5s713ms 7s484ms 7s486ms 16 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 04 10 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 Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 04 10 0 0 0.00 0.00% 14 0 6 6.00 0.00% 15 0 6 6.00 0.00% 16 0 0 0.00 0.00% Day Hour Count Average / Second Aug 04 10 4 0.00/s 14 22 0.01/s 15 36 0.01/s 16 1 0.00/s Day Hour Count Average Duration Average idle time Aug 04 10 2 2m19s 2m19s 14 13 38m43s 38m41s 15 33 10m36s 10m36s 16 7 1h6m50s 1h6m50s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2025-08-04 14:47:09 Date
Connections per database
Key values
- ctddev51 Main Database
- 63 connections Total
Connections per user
Key values
- editeu Main User
- 63 connections Total
-
Sessions
Simultaneous sessions
Key values
- 15 sessions Session Peak
- 2025-08-04 15:15:02 Date
Histogram of session times
Key values
- 20 60000-600000ms duration
Sessions per database
Key values
- ctddev51 Main Database
- 55 sessions Total
Sessions per user
Key values
- editeu Main User
- 55 sessions Total
Sessions per host
Key values
- 10.12.5.40 Main Host
- 55 sessions Total
Sessions per application
Key values
- unknown Main Application
- 55 sessions Total
Application Count Total Duration Average Duration pgAdmin 4 - CONN:1477352 1 8s780ms 8s780ms pgAdmin 4 - CONN:2215091 1 5m36s 5m36s pgAdmin 4 - CONN:2756446 8 19s473ms 2s434ms pgAdmin 4 - CONN:6006054 1 34m41s 34m41s pgAdmin 4 - CONN:8727819 2 7m42s 3m51s pgAdmin 4 - DB:ctddev51 1 74ms 74ms unknown 41 21h17m41s 31m9s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,097 buffers Checkpoint Peak
- 2025-08-04 15:54:04 Date
- 210.211 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2025-08-04 15:54:04 Date
Checkpoints distance
Key values
- 51.77 Mo Distance Peak
- 2025-08-04 15:54:04 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 04 10 0 0s 0s 0s 14 144 14.566s 0.001s 14.581s 15 2,256 226.259s 0.004s 226.341s 16 221 22.243s 0.002s 22.264s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 04 10 0 0 0 0 0s 0s 14 0 0 0 84 0.001s 0.001s 15 0 0 1 200 0.001s 0.002s 16 0 0 0 92 0.001s 0.001s Day Hour Count Avg time (sec) Aug 04 10 0 0s 14 0 0s 15 0 0s 16 0 0s Day Hour Mean distance Mean estimate Aug 04 10 0.00 kB 0.00 kB 14 857.00 kB 857.00 kB 15 13,783.50 kB 13,783.50 kB 16 2,125.00 kB 24,069.00 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 Aug 04 10 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.05 sec Highest CPU-cost vacuum
Table edit.exp_outcome
Database ctddev51 - 2025-08-04 15:32:07 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctddev51 - Date
Average Autovacuum Duration
Key values
- 0.05 sec Highest CPU-cost vacuum
Table edit.exp_outcome
Database ctddev51 - 2025-08-04 15:32:07 Date
Analyzes per table
Key values
- edit.exp_outcome (1) Main table analyzed (database ctddev51)
- 1 analyzes Total
Vacuums per table
Key values
- edit.exp_outcome (1) Main table vacuumed on database ctddev51
- 1 vacuums Total
Tuples removed per table
Key values
- edit.exp_outcome (18561) Main table with removed tuples on database ctddev51
- 18561 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 Aug 04 10 0 0 14 0 0 15 1 1 16 0 0 - 0.05 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
- 12 Total read queries
- 0 Total write queries
Queries by database
Key values
- ctddev51 Main database
- 10 Requests
- 34s509ms (ctddev51)
- Main time consuming database
Queries by user
Key values
- editeu Main user
- 10 Requests
User Request type Count Duration editeu Total 10 34s509ms select 10 34s509ms unknown Total 2 5s713ms select 2 5s713ms Duration by user
Key values
- 34s509ms (editeu) Main time consuming user
User Request type Count Duration editeu Total 10 34s509ms select 10 34s509ms unknown Total 2 5s713ms select 2 5s713ms Queries by host
Key values
- unknown Main host
- 12 Requests
- 40s223ms (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 12 Requests
- 40s223ms (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-08-04 14:47:09 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 12 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 5s352ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 1 and t.id = l.TERM_ID;[ Date: 2025-08-04 14:45:25 - Database: ctddev51 - User: editeu - Bind query: yes ]
2 4s419ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;[ Date: 2025-08-04 15:18:47 - Database: ctddev51 - User: editeu - Bind query: yes ]
3 4s331ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;[ Date: 2025-08-04 14:47:14 - Database: ctddev51 - User: editeu - Bind query: yes ]
4 4s304ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;[ Date: 2025-08-04 15:21:10 - Database: ctddev51 - User: editeu - Bind query: yes ]
5 3s180ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 1 and t.id = l.TERM_ID;[ Date: 2025-08-04 15:21:09 - Database: ctddev51 - User: editeu - Bind query: yes ]
6 3s112ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 1 and t.id = l.TERM_ID;[ Date: 2025-08-04 14:47:13 - Database: ctddev51 - User: editeu - Bind query: yes ]
7 3s67ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 1 and t.id = l.TERM_ID;[ Date: 2025-08-04 15:18:46 - Database: ctddev51 - User: editeu - Bind query: yes ]
8 2s980ms select distinct e.reference_acc_txt, referenceExp.create_by, referenceExp.create_tm, pref.abbr_authors_txt as author, referenceExp.email_addr, ( Select STRING_AGG(distinct studyFactor.cd, '|')) as studyFactor, referenceExp.author_summary, referenceExp.curator_comments, ( Select STRING_AGG(distinct eventproject.project_nm, '|')) as associatedStudyTitles, CONCAT(eevent.collection_start_yr, '-', eevent.collection_end_yr) as enrollmentYears, ( Select STRING_AGG(distinct studyFactor.nm, '|')) as studyFactor, ( Select STRING_AGG(distinct stressorSrcType.cd, '|')) as stressorSourceCategory, stressor.chem_term_nm, stressor.src_details as stressorSrcDetails, stressor.sample_qty as stressorSampleQty, stressor.note as stressorNote, ereceptor.qty as nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, ereceptor.note as receptor_note, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ' || tobaccoUse.nm, COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ', tobaccoUse.nm)), '|')) as smokerStatus, ereceptor.age || ' ' || age_uom.nm || ' (' || COALESCE(age_qualifier.nm, '') || ')' as ageRange, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ' || gender.nm_html, COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ', gender.nm_html)), '|') from edit.exp_receptor_gender expgender left outer join edit.gender on expgender.gender_id = gender.id where exp_receptor_id = ereceptor.id) as genderDetails, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ' || race.nm, COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ', race.nm)), '|')) as raceDetails, ( Select STRING_AGG(distinct eventAssayMethod.nm, '|')) as assayMethods, CONCAT(eevent.detection_limit, ' ', eevent.detection_limit_uom) as detectionLimit, eevent.detection_freq as detectionFreq, medium.nm as medium_nm, eevent.exp_marker_term_nm, CONCAT(eevent.exp_marker_lvl, ' ', eevent.assay_uom) as markerLevel, eevent.assay_measurement_stat, eevent.assay_note, ( Select STRING_AGG(distinct country.nm, '|')) as country, ( Select STRING_AGG(distinct eventLocation.geographic_region_nm, '|')) as stateOrProvince, ( Select STRING_AGG(distinct eventLocation.locality_txt, '|')) as region, eevent.note as eventNote, eiot.description as outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, ( Select STRING_AGG(distinct expAnatomy.anatomy_term_nm, '|')) as anatomy, outcome.note as outcomeNote, markerQual.actor_type_cd || markerQual.ixn_type_id || markerQual.cd as markerQualifier, markerType.nm as markerType_nm from edit.exposure e left outer join pub2.reference pref on pref.acc_txt = e.reference_acc_txt left outer join edit.reference_exp referenceExp on referenceExp.reference_acc_txt = e.reference_acc_txt left outer join edit.exp_study_factor expStudyFactor on referenceExp.id = expStudyFactor.reference_exp_id left outer join edit.study_factor studyFactor on studyFactor.id = expStudyFactor.study_factor_id left outer join edit.exp_event_project eventproject on eventproject.exp_event_id = e.exp_event_id inner join edit.exp_stressor stressor on e.exp_stressor_id = stressor.id left outer join edit.exp_receptor ereceptor on e.exp_receptor_id = ereceptor.id left outer join edit.receptor receptor on ereceptor.receptor_id = receptor.id left outer join edit.age_uom age_uom on ereceptor.age_uom_id = age_uom.id left outer join edit.age_qualifier age_qualifier on ereceptor.age_qualifier_id = age_qualifier.id left outer join edit.exp_event eevent on e.exp_event_id = eevent.id left outer join edit.medium medium on eevent.medium_id = medium.id left outer join edit.exp_stressor_stressor_src esss on stressor.id = esss.exp_stressor_id left outer join edit.exp_stressor_src_type stressorSrcType on esss.exp_stressor_src_type_id = stressorSrcType.id left outer join edit.exp_receptor_tobacco_use receptorTobaccoUse on ereceptor.id = receptorTobaccoUse.exp_receptor_id left outer join edit.tobacco_use tobaccoUse on receptorTobaccoUse.tobacco_use_id = tobaccoUse.id left outer join edit.exp_receptor_race receptorRace on ereceptor.id = receptorRace.exp_receptor_id left outer join edit.race race on receptorRace.race_id = race.id left outer join edit.exp_event_location eventLocation on eevent.id = eventLocation.exp_event_id left outer join edit.country on eventLocation.country_id = country.id left outer join edit.exp_outcome outcome on e.exp_outcome_id = outcome.id left outer join edit.exp_outcome_ixn_type eiot on outcome.exp_outcome_ixn_type_id = eiot.id left outer join edit.exp_anatomy expAnatomy on outcome.id = expAnatomy.exp_outcome_id left outer join edit.exp_event_assay_method eventAssayMethod on eevent.id = eventAssayMethod.exp_event_id left outer join edit.actor_form_type markerQual on markerQual.id = eevent.exp_marker_actor_form_type_id left outer join edit.exp_marker_type markerType on eevent.exp_marker_type_id = markerType.id where e.reference_acc_txt = '31103473' group by e.reference_acc_txt, author, referenceExp.create_by, referenceExp.create_tm, referenceExp.email_addr, referenceExp.author_summary, referenceExp.curator_comments, pref.abbr_authors_txt, enrollmentYears, stressor.chem_term_nm, stressorSrcDetails, stressorSampleQty, stressorNote, nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, receptor_note, ageRange, detectionLimit, detectionFreq, medium_nm, eevent.exp_marker_term_nm, markerLevel, eevent.assay_measurement_stat, eevent.assay_note, eventNote, outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, outcomeNote, ereceptor.id, markerQualifier, markerType_nm, eevent.id;[ Date: 2025-08-04 15:34:26 - Bind query: yes ]
9 2s733ms select distinct e.reference_acc_txt, referenceExp.create_by, referenceExp.create_tm, pref.abbr_authors_txt as author, referenceExp.email_addr, ( Select STRING_AGG(distinct studyFactor.cd, '|')) as studyFactor, referenceExp.author_summary, referenceExp.curator_comments, ( Select STRING_AGG(distinct eventproject.project_nm, '|')) as associatedStudyTitles, CONCAT(eevent.collection_start_yr, '-', eevent.collection_end_yr) as enrollmentYears, ( Select STRING_AGG(distinct studyFactor.nm, '|')) as studyFactor, ( Select STRING_AGG(distinct stressorSrcType.cd, '|')) as stressorSourceCategory, stressor.chem_term_nm, stressor.src_details as stressorSrcDetails, stressor.sample_qty as stressorSampleQty, stressor.note as stressorNote, ereceptor.qty as nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, ereceptor.note as receptor_note, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ' || tobaccoUse.nm, COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ', tobaccoUse.nm)), '|')) as smokerStatus, ereceptor.age || ' ' || age_uom.nm || ' (' || COALESCE(age_qualifier.nm, '') || ')' as ageRange, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ' || gender.nm_html, COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ', gender.nm_html)), '|') from edit.exp_receptor_gender expgender left outer join edit.gender on expgender.gender_id = gender.id where exp_receptor_id = ereceptor.id) as genderDetails, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ' || race.nm, COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ', race.nm)), '|')) as raceDetails, ( Select STRING_AGG(distinct eventAssayMethod.nm, '|')) as assayMethods, CONCAT(eevent.detection_limit, ' ', eevent.detection_limit_uom) as detectionLimit, eevent.detection_freq as detectionFreq, medium.nm as medium_nm, eevent.exp_marker_term_nm, CONCAT(eevent.exp_marker_lvl, ' ', eevent.assay_uom) as markerLevel, eevent.assay_measurement_stat, eevent.assay_note, ( Select STRING_AGG(distinct country.nm, '|')) as country, ( Select STRING_AGG(distinct eventLocation.geographic_region_nm, '|')) as stateOrProvince, ( Select STRING_AGG(distinct eventLocation.locality_txt, '|')) as region, eevent.note as eventNote, eiot.description as outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, ( Select STRING_AGG(distinct expAnatomy.anatomy_term_nm, '|')) as anatomy, outcome.note as outcomeNote, markerQual.actor_type_cd || markerQual.ixn_type_id || markerQual.cd as markerQualifier, markerType.nm as markerType_nm from edit.exposure e left outer join pub2.reference pref on pref.acc_txt = e.reference_acc_txt left outer join edit.reference_exp referenceExp on referenceExp.reference_acc_txt = e.reference_acc_txt left outer join edit.exp_study_factor expStudyFactor on referenceExp.id = expStudyFactor.reference_exp_id left outer join edit.study_factor studyFactor on studyFactor.id = expStudyFactor.study_factor_id left outer join edit.exp_event_project eventproject on eventproject.exp_event_id = e.exp_event_id inner join edit.exp_stressor stressor on e.exp_stressor_id = stressor.id left outer join edit.exp_receptor ereceptor on e.exp_receptor_id = ereceptor.id left outer join edit.receptor receptor on ereceptor.receptor_id = receptor.id left outer join edit.age_uom age_uom on ereceptor.age_uom_id = age_uom.id left outer join edit.age_qualifier age_qualifier on ereceptor.age_qualifier_id = age_qualifier.id left outer join edit.exp_event eevent on e.exp_event_id = eevent.id left outer join edit.medium medium on eevent.medium_id = medium.id left outer join edit.exp_stressor_stressor_src esss on stressor.id = esss.exp_stressor_id left outer join edit.exp_stressor_src_type stressorSrcType on esss.exp_stressor_src_type_id = stressorSrcType.id left outer join edit.exp_receptor_tobacco_use receptorTobaccoUse on ereceptor.id = receptorTobaccoUse.exp_receptor_id left outer join edit.tobacco_use tobaccoUse on receptorTobaccoUse.tobacco_use_id = tobaccoUse.id left outer join edit.exp_receptor_race receptorRace on ereceptor.id = receptorRace.exp_receptor_id left outer join edit.race race on receptorRace.race_id = race.id left outer join edit.exp_event_location eventLocation on eevent.id = eventLocation.exp_event_id left outer join edit.country on eventLocation.country_id = country.id left outer join edit.exp_outcome outcome on e.exp_outcome_id = outcome.id left outer join edit.exp_outcome_ixn_type eiot on outcome.exp_outcome_ixn_type_id = eiot.id left outer join edit.exp_anatomy expAnatomy on outcome.id = expAnatomy.exp_outcome_id left outer join edit.exp_event_assay_method eventAssayMethod on eevent.id = eventAssayMethod.exp_event_id left outer join edit.actor_form_type markerQual on markerQual.id = eevent.exp_marker_actor_form_type_id left outer join edit.exp_marker_type markerType on eevent.exp_marker_type_id = markerType.id where e.reference_acc_txt = '31103473' group by e.reference_acc_txt, author, referenceExp.create_by, referenceExp.create_tm, referenceExp.email_addr, referenceExp.author_summary, referenceExp.curator_comments, pref.abbr_authors_txt, enrollmentYears, stressor.chem_term_nm, stressorSrcDetails, stressorSampleQty, stressorNote, nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, receptor_note, ageRange, detectionLimit, detectionFreq, medium_nm, eevent.exp_marker_term_nm, markerLevel, eevent.assay_measurement_stat, eevent.assay_note, eventNote, outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, outcomeNote, ereceptor.id, markerQualifier, markerType_nm, eevent.id;[ Date: 2025-08-04 15:34:14 - Bind query: yes ]
10 2s279ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 5 and t.id = l.TERM_ID;[ Date: 2025-08-04 14:45:21 - Database: ctddev51 - User: editeu - Bind query: yes ]
11 2s231ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 3 and t.id = l.TERM_ID;[ Date: 2025-08-04 14:45:21 - Database: ctddev51 - User: editeu - Bind query: yes ]
12 2s231ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 2 and t.id = l.TERM_ID;[ Date: 2025-08-04 14:45:21 - Database: ctddev51 - User: editeu - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 34s509ms 10 2s231ms 5s352ms 3s450ms select t.id, t.object_type_id, t.acc_txt, t.acc_db_cd, t.nm, t.nm_sort, t.secondary_nm, t.description, t.note, l.nm from pub2.term t, pub2.term_label l where t.object_type_id = ? and t.id = l.term_id;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 04 14 6 19s538ms 3s256ms 15 4 14s971ms 3s742ms [ User: editeu - Total duration: 34s509ms - Times executed: 10 ]
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 1 and t.id = l.TERM_ID;
Date: 2025-08-04 14:45:25 Duration: 5s352ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-08-04 15:18:47 Duration: 4s419ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-08-04 14:47:14 Duration: 4s331ms Database: ctddev51 User: editeu Bind query: yes
2 5s713ms 2 2s733ms 2s980ms 2s856ms select distinct e.reference_acc_txt, referenceexp.create_by, referenceexp.create_tm, pref.abbr_authors_txt as author, referenceexp.email_addr, ( select string_agg(distinct studyfactor.cd, ?)) as studyfactor, referenceexp.author_summary, referenceexp.curator_comments, ( select string_agg(distinct eventproject.project_nm, ?)) as associatedstudytitles, concat(eevent.collection_start_yr, ?, eevent.collection_end_yr) as enrollmentyears, ( select string_agg(distinct studyfactor.nm, ?)) as studyfactor, ( select string_agg(distinct stressorsrctype.cd, ?)) as stressorsourcecategory, stressor.chem_term_nm, stressor.src_details as stressorsrcdetails, stressor.sample_qty as stressorsampleqty, stressor.note as stressornote, ereceptor.qty as nbrreceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, ereceptor.note as receptor_note, ( select string_agg(distinct coalesce(coalesce(nullif (cast(receptortobaccouse.pct as int), ?)) || ? || tobaccouse.nm, coalesce(coalesce(nullif (cast(receptortobaccouse.pct as int), ?)) || ?, tobaccouse.nm)), ?)) as smokerstatus, ereceptor.age || ? || age_uom.nm || ? || coalesce(age_qualifier.nm, ?) || ? as agerange, ( select string_agg(distinct coalesce(coalesce(nullif (cast(pct as int), ?)) || ? || gender.nm_html, coalesce(coalesce(nullif (cast(pct as int), ?)) || ?, gender.nm_html)), ?) from edit.exp_receptor_gender expgender left outer join edit.gender on expgender.gender_id = gender.id where exp_receptor_id = ereceptor.id) as genderdetails, ( select string_agg(distinct coalesce(coalesce(nullif (cast(receptorrace.pct as int), ?)) || ? || race.nm, coalesce(coalesce(nullif (cast(receptorrace.pct as int), ?)) || ?, race.nm)), ?)) as racedetails, ( select string_agg(distinct eventassaymethod.nm, ?)) as assaymethods, concat(eevent.detection_limit, ?, eevent.detection_limit_uom) as detectionlimit, eevent.detection_freq as detectionfreq, medium.nm as medium_nm, eevent.exp_marker_term_nm, concat(eevent.exp_marker_lvl, ?, eevent.assay_uom) as markerlevel, eevent.assay_measurement_stat, eevent.assay_note, ( select string_agg(distinct country.nm, ?)) as country, ( select string_agg(distinct eventlocation.geographic_region_nm, ?)) as stateorprovince, ( select string_agg(distinct eventlocation.locality_txt, ?)) as region, eevent.note as eventnote, eiot.description as outcomerelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, ( select string_agg(distinct expanatomy.anatomy_term_nm, ?)) as anatomy, outcome.note as outcomenote, markerqual.actor_type_cd || markerqual.ixn_type_id || markerqual.cd as markerqualifier, markertype.nm as markertype_nm from edit.exposure e left outer join pub2.reference pref on pref.acc_txt = e.reference_acc_txt left outer join edit.reference_exp referenceexp on referenceexp.reference_acc_txt = e.reference_acc_txt left outer join edit.exp_study_factor expstudyfactor on referenceexp.id = expstudyfactor.reference_exp_id left outer join edit.study_factor studyfactor on studyfactor.id = expstudyfactor.study_factor_id left outer join edit.exp_event_project eventproject on eventproject.exp_event_id = e.exp_event_id inner join edit.exp_stressor stressor on e.exp_stressor_id = stressor.id left outer join edit.exp_receptor ereceptor on e.exp_receptor_id = ereceptor.id left outer join edit.receptor receptor on ereceptor.receptor_id = receptor.id left outer join edit.age_uom age_uom on ereceptor.age_uom_id = age_uom.id left outer join edit.age_qualifier age_qualifier on ereceptor.age_qualifier_id = age_qualifier.id left outer join edit.exp_event eevent on e.exp_event_id = eevent.id left outer join edit.medium medium on eevent.medium_id = medium.id left outer join edit.exp_stressor_stressor_src esss on stressor.id = esss.exp_stressor_id left outer join edit.exp_stressor_src_type stressorsrctype on esss.exp_stressor_src_type_id = stressorsrctype.id left outer join edit.exp_receptor_tobacco_use receptortobaccouse on ereceptor.id = receptortobaccouse.exp_receptor_id left outer join edit.tobacco_use tobaccouse on receptortobaccouse.tobacco_use_id = tobaccouse.id left outer join edit.exp_receptor_race receptorrace on ereceptor.id = receptorrace.exp_receptor_id left outer join edit.race race on receptorrace.race_id = race.id left outer join edit.exp_event_location eventlocation on eevent.id = eventlocation.exp_event_id left outer join edit.country on eventlocation.country_id = country.id left outer join edit.exp_outcome outcome on e.exp_outcome_id = outcome.id left outer join edit.exp_outcome_ixn_type eiot on outcome.exp_outcome_ixn_type_id = eiot.id left outer join edit.exp_anatomy expanatomy on outcome.id = expanatomy.exp_outcome_id left outer join edit.exp_event_assay_method eventassaymethod on eevent.id = eventassaymethod.exp_event_id left outer join edit.actor_form_type markerqual on markerqual.id = eevent.exp_marker_actor_form_type_id left outer join edit.exp_marker_type markertype on eevent.exp_marker_type_id = markertype.id where e.reference_acc_txt = ? group by e.reference_acc_txt, author, referenceexp.create_by, referenceexp.create_tm, referenceexp.email_addr, referenceexp.author_summary, referenceexp.curator_comments, pref.abbr_authors_txt, enrollmentyears, stressor.chem_term_nm, stressorsrcdetails, stressorsampleqty, stressornote, nbrreceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, receptor_note, agerange, detectionlimit, detectionfreq, medium_nm, eevent.exp_marker_term_nm, markerlevel, eevent.assay_measurement_stat, eevent.assay_note, eventnote, outcomerelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, outcomenote, ereceptor.id, markerqualifier, markertype_nm, eevent.id;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 04 15 2 5s713ms 2s856ms -
select distinct e.reference_acc_txt, referenceExp.create_by, referenceExp.create_tm, pref.abbr_authors_txt as author, referenceExp.email_addr, ( Select STRING_AGG(distinct studyFactor.cd, '|')) as studyFactor, referenceExp.author_summary, referenceExp.curator_comments, ( Select STRING_AGG(distinct eventproject.project_nm, '|')) as associatedStudyTitles, CONCAT(eevent.collection_start_yr, '-', eevent.collection_end_yr) as enrollmentYears, ( Select STRING_AGG(distinct studyFactor.nm, '|')) as studyFactor, ( Select STRING_AGG(distinct stressorSrcType.cd, '|')) as stressorSourceCategory, stressor.chem_term_nm, stressor.src_details as stressorSrcDetails, stressor.sample_qty as stressorSampleQty, stressor.note as stressorNote, ereceptor.qty as nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, ereceptor.note as receptor_note, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ' || tobaccoUse.nm, COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ', tobaccoUse.nm)), '|')) as smokerStatus, ereceptor.age || ' ' || age_uom.nm || ' (' || COALESCE(age_qualifier.nm, '') || ')' as ageRange, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ' || gender.nm_html, COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ', gender.nm_html)), '|') from edit.exp_receptor_gender expgender left outer join edit.gender on expgender.gender_id = gender.id where exp_receptor_id = ereceptor.id) as genderDetails, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ' || race.nm, COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ', race.nm)), '|')) as raceDetails, ( Select STRING_AGG(distinct eventAssayMethod.nm, '|')) as assayMethods, CONCAT(eevent.detection_limit, ' ', eevent.detection_limit_uom) as detectionLimit, eevent.detection_freq as detectionFreq, medium.nm as medium_nm, eevent.exp_marker_term_nm, CONCAT(eevent.exp_marker_lvl, ' ', eevent.assay_uom) as markerLevel, eevent.assay_measurement_stat, eevent.assay_note, ( Select STRING_AGG(distinct country.nm, '|')) as country, ( Select STRING_AGG(distinct eventLocation.geographic_region_nm, '|')) as stateOrProvince, ( Select STRING_AGG(distinct eventLocation.locality_txt, '|')) as region, eevent.note as eventNote, eiot.description as outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, ( Select STRING_AGG(distinct expAnatomy.anatomy_term_nm, '|')) as anatomy, outcome.note as outcomeNote, markerQual.actor_type_cd || markerQual.ixn_type_id || markerQual.cd as markerQualifier, markerType.nm as markerType_nm from edit.exposure e left outer join pub2.reference pref on pref.acc_txt = e.reference_acc_txt left outer join edit.reference_exp referenceExp on referenceExp.reference_acc_txt = e.reference_acc_txt left outer join edit.exp_study_factor expStudyFactor on referenceExp.id = expStudyFactor.reference_exp_id left outer join edit.study_factor studyFactor on studyFactor.id = expStudyFactor.study_factor_id left outer join edit.exp_event_project eventproject on eventproject.exp_event_id = e.exp_event_id inner join edit.exp_stressor stressor on e.exp_stressor_id = stressor.id left outer join edit.exp_receptor ereceptor on e.exp_receptor_id = ereceptor.id left outer join edit.receptor receptor on ereceptor.receptor_id = receptor.id left outer join edit.age_uom age_uom on ereceptor.age_uom_id = age_uom.id left outer join edit.age_qualifier age_qualifier on ereceptor.age_qualifier_id = age_qualifier.id left outer join edit.exp_event eevent on e.exp_event_id = eevent.id left outer join edit.medium medium on eevent.medium_id = medium.id left outer join edit.exp_stressor_stressor_src esss on stressor.id = esss.exp_stressor_id left outer join edit.exp_stressor_src_type stressorSrcType on esss.exp_stressor_src_type_id = stressorSrcType.id left outer join edit.exp_receptor_tobacco_use receptorTobaccoUse on ereceptor.id = receptorTobaccoUse.exp_receptor_id left outer join edit.tobacco_use tobaccoUse on receptorTobaccoUse.tobacco_use_id = tobaccoUse.id left outer join edit.exp_receptor_race receptorRace on ereceptor.id = receptorRace.exp_receptor_id left outer join edit.race race on receptorRace.race_id = race.id left outer join edit.exp_event_location eventLocation on eevent.id = eventLocation.exp_event_id left outer join edit.country on eventLocation.country_id = country.id left outer join edit.exp_outcome outcome on e.exp_outcome_id = outcome.id left outer join edit.exp_outcome_ixn_type eiot on outcome.exp_outcome_ixn_type_id = eiot.id left outer join edit.exp_anatomy expAnatomy on outcome.id = expAnatomy.exp_outcome_id left outer join edit.exp_event_assay_method eventAssayMethod on eevent.id = eventAssayMethod.exp_event_id left outer join edit.actor_form_type markerQual on markerQual.id = eevent.exp_marker_actor_form_type_id left outer join edit.exp_marker_type markerType on eevent.exp_marker_type_id = markerType.id where e.reference_acc_txt = '31103473' group by e.reference_acc_txt, author, referenceExp.create_by, referenceExp.create_tm, referenceExp.email_addr, referenceExp.author_summary, referenceExp.curator_comments, pref.abbr_authors_txt, enrollmentYears, stressor.chem_term_nm, stressorSrcDetails, stressorSampleQty, stressorNote, nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, receptor_note, ageRange, detectionLimit, detectionFreq, medium_nm, eevent.exp_marker_term_nm, markerLevel, eevent.assay_measurement_stat, eevent.assay_note, eventNote, outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, outcomeNote, ereceptor.id, markerQualifier, markerType_nm, eevent.id;
Date: 2025-08-04 15:34:26 Duration: 2s980ms Bind query: yes
-
select distinct e.reference_acc_txt, referenceExp.create_by, referenceExp.create_tm, pref.abbr_authors_txt as author, referenceExp.email_addr, ( Select STRING_AGG(distinct studyFactor.cd, '|')) as studyFactor, referenceExp.author_summary, referenceExp.curator_comments, ( Select STRING_AGG(distinct eventproject.project_nm, '|')) as associatedStudyTitles, CONCAT(eevent.collection_start_yr, '-', eevent.collection_end_yr) as enrollmentYears, ( Select STRING_AGG(distinct studyFactor.nm, '|')) as studyFactor, ( Select STRING_AGG(distinct stressorSrcType.cd, '|')) as stressorSourceCategory, stressor.chem_term_nm, stressor.src_details as stressorSrcDetails, stressor.sample_qty as stressorSampleQty, stressor.note as stressorNote, ereceptor.qty as nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, ereceptor.note as receptor_note, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ' || tobaccoUse.nm, COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ', tobaccoUse.nm)), '|')) as smokerStatus, ereceptor.age || ' ' || age_uom.nm || ' (' || COALESCE(age_qualifier.nm, '') || ')' as ageRange, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ' || gender.nm_html, COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ', gender.nm_html)), '|') from edit.exp_receptor_gender expgender left outer join edit.gender on expgender.gender_id = gender.id where exp_receptor_id = ereceptor.id) as genderDetails, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ' || race.nm, COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ', race.nm)), '|')) as raceDetails, ( Select STRING_AGG(distinct eventAssayMethod.nm, '|')) as assayMethods, CONCAT(eevent.detection_limit, ' ', eevent.detection_limit_uom) as detectionLimit, eevent.detection_freq as detectionFreq, medium.nm as medium_nm, eevent.exp_marker_term_nm, CONCAT(eevent.exp_marker_lvl, ' ', eevent.assay_uom) as markerLevel, eevent.assay_measurement_stat, eevent.assay_note, ( Select STRING_AGG(distinct country.nm, '|')) as country, ( Select STRING_AGG(distinct eventLocation.geographic_region_nm, '|')) as stateOrProvince, ( Select STRING_AGG(distinct eventLocation.locality_txt, '|')) as region, eevent.note as eventNote, eiot.description as outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, ( Select STRING_AGG(distinct expAnatomy.anatomy_term_nm, '|')) as anatomy, outcome.note as outcomeNote, markerQual.actor_type_cd || markerQual.ixn_type_id || markerQual.cd as markerQualifier, markerType.nm as markerType_nm from edit.exposure e left outer join pub2.reference pref on pref.acc_txt = e.reference_acc_txt left outer join edit.reference_exp referenceExp on referenceExp.reference_acc_txt = e.reference_acc_txt left outer join edit.exp_study_factor expStudyFactor on referenceExp.id = expStudyFactor.reference_exp_id left outer join edit.study_factor studyFactor on studyFactor.id = expStudyFactor.study_factor_id left outer join edit.exp_event_project eventproject on eventproject.exp_event_id = e.exp_event_id inner join edit.exp_stressor stressor on e.exp_stressor_id = stressor.id left outer join edit.exp_receptor ereceptor on e.exp_receptor_id = ereceptor.id left outer join edit.receptor receptor on ereceptor.receptor_id = receptor.id left outer join edit.age_uom age_uom on ereceptor.age_uom_id = age_uom.id left outer join edit.age_qualifier age_qualifier on ereceptor.age_qualifier_id = age_qualifier.id left outer join edit.exp_event eevent on e.exp_event_id = eevent.id left outer join edit.medium medium on eevent.medium_id = medium.id left outer join edit.exp_stressor_stressor_src esss on stressor.id = esss.exp_stressor_id left outer join edit.exp_stressor_src_type stressorSrcType on esss.exp_stressor_src_type_id = stressorSrcType.id left outer join edit.exp_receptor_tobacco_use receptorTobaccoUse on ereceptor.id = receptorTobaccoUse.exp_receptor_id left outer join edit.tobacco_use tobaccoUse on receptorTobaccoUse.tobacco_use_id = tobaccoUse.id left outer join edit.exp_receptor_race receptorRace on ereceptor.id = receptorRace.exp_receptor_id left outer join edit.race race on receptorRace.race_id = race.id left outer join edit.exp_event_location eventLocation on eevent.id = eventLocation.exp_event_id left outer join edit.country on eventLocation.country_id = country.id left outer join edit.exp_outcome outcome on e.exp_outcome_id = outcome.id left outer join edit.exp_outcome_ixn_type eiot on outcome.exp_outcome_ixn_type_id = eiot.id left outer join edit.exp_anatomy expAnatomy on outcome.id = expAnatomy.exp_outcome_id left outer join edit.exp_event_assay_method eventAssayMethod on eevent.id = eventAssayMethod.exp_event_id left outer join edit.actor_form_type markerQual on markerQual.id = eevent.exp_marker_actor_form_type_id left outer join edit.exp_marker_type markerType on eevent.exp_marker_type_id = markerType.id where e.reference_acc_txt = '31103473' group by e.reference_acc_txt, author, referenceExp.create_by, referenceExp.create_tm, referenceExp.email_addr, referenceExp.author_summary, referenceExp.curator_comments, pref.abbr_authors_txt, enrollmentYears, stressor.chem_term_nm, stressorSrcDetails, stressorSampleQty, stressorNote, nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, receptor_note, ageRange, detectionLimit, detectionFreq, medium_nm, eevent.exp_marker_term_nm, markerLevel, eevent.assay_measurement_stat, eevent.assay_note, eventNote, outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, outcomeNote, ereceptor.id, markerQualifier, markerType_nm, eevent.id;
Date: 2025-08-04 15:34:14 Duration: 2s733ms Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 10 34s509ms 2s231ms 5s352ms 3s450ms select t.id, t.object_type_id, t.acc_txt, t.acc_db_cd, t.nm, t.nm_sort, t.secondary_nm, t.description, t.note, l.nm from pub2.term t, pub2.term_label l where t.object_type_id = ? and t.id = l.term_id;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 04 14 6 19s538ms 3s256ms 15 4 14s971ms 3s742ms [ User: editeu - Total duration: 34s509ms - Times executed: 10 ]
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 1 and t.id = l.TERM_ID;
Date: 2025-08-04 14:45:25 Duration: 5s352ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-08-04 15:18:47 Duration: 4s419ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-08-04 14:47:14 Duration: 4s331ms Database: ctddev51 User: editeu Bind query: yes
2 2 5s713ms 2s733ms 2s980ms 2s856ms select distinct e.reference_acc_txt, referenceexp.create_by, referenceexp.create_tm, pref.abbr_authors_txt as author, referenceexp.email_addr, ( select string_agg(distinct studyfactor.cd, ?)) as studyfactor, referenceexp.author_summary, referenceexp.curator_comments, ( select string_agg(distinct eventproject.project_nm, ?)) as associatedstudytitles, concat(eevent.collection_start_yr, ?, eevent.collection_end_yr) as enrollmentyears, ( select string_agg(distinct studyfactor.nm, ?)) as studyfactor, ( select string_agg(distinct stressorsrctype.cd, ?)) as stressorsourcecategory, stressor.chem_term_nm, stressor.src_details as stressorsrcdetails, stressor.sample_qty as stressorsampleqty, stressor.note as stressornote, ereceptor.qty as nbrreceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, ereceptor.note as receptor_note, ( select string_agg(distinct coalesce(coalesce(nullif (cast(receptortobaccouse.pct as int), ?)) || ? || tobaccouse.nm, coalesce(coalesce(nullif (cast(receptortobaccouse.pct as int), ?)) || ?, tobaccouse.nm)), ?)) as smokerstatus, ereceptor.age || ? || age_uom.nm || ? || coalesce(age_qualifier.nm, ?) || ? as agerange, ( select string_agg(distinct coalesce(coalesce(nullif (cast(pct as int), ?)) || ? || gender.nm_html, coalesce(coalesce(nullif (cast(pct as int), ?)) || ?, gender.nm_html)), ?) from edit.exp_receptor_gender expgender left outer join edit.gender on expgender.gender_id = gender.id where exp_receptor_id = ereceptor.id) as genderdetails, ( select string_agg(distinct coalesce(coalesce(nullif (cast(receptorrace.pct as int), ?)) || ? || race.nm, coalesce(coalesce(nullif (cast(receptorrace.pct as int), ?)) || ?, race.nm)), ?)) as racedetails, ( select string_agg(distinct eventassaymethod.nm, ?)) as assaymethods, concat(eevent.detection_limit, ?, eevent.detection_limit_uom) as detectionlimit, eevent.detection_freq as detectionfreq, medium.nm as medium_nm, eevent.exp_marker_term_nm, concat(eevent.exp_marker_lvl, ?, eevent.assay_uom) as markerlevel, eevent.assay_measurement_stat, eevent.assay_note, ( select string_agg(distinct country.nm, ?)) as country, ( select string_agg(distinct eventlocation.geographic_region_nm, ?)) as stateorprovince, ( select string_agg(distinct eventlocation.locality_txt, ?)) as region, eevent.note as eventnote, eiot.description as outcomerelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, ( select string_agg(distinct expanatomy.anatomy_term_nm, ?)) as anatomy, outcome.note as outcomenote, markerqual.actor_type_cd || markerqual.ixn_type_id || markerqual.cd as markerqualifier, markertype.nm as markertype_nm from edit.exposure e left outer join pub2.reference pref on pref.acc_txt = e.reference_acc_txt left outer join edit.reference_exp referenceexp on referenceexp.reference_acc_txt = e.reference_acc_txt left outer join edit.exp_study_factor expstudyfactor on referenceexp.id = expstudyfactor.reference_exp_id left outer join edit.study_factor studyfactor on studyfactor.id = expstudyfactor.study_factor_id left outer join edit.exp_event_project eventproject on eventproject.exp_event_id = e.exp_event_id inner join edit.exp_stressor stressor on e.exp_stressor_id = stressor.id left outer join edit.exp_receptor ereceptor on e.exp_receptor_id = ereceptor.id left outer join edit.receptor receptor on ereceptor.receptor_id = receptor.id left outer join edit.age_uom age_uom on ereceptor.age_uom_id = age_uom.id left outer join edit.age_qualifier age_qualifier on ereceptor.age_qualifier_id = age_qualifier.id left outer join edit.exp_event eevent on e.exp_event_id = eevent.id left outer join edit.medium medium on eevent.medium_id = medium.id left outer join edit.exp_stressor_stressor_src esss on stressor.id = esss.exp_stressor_id left outer join edit.exp_stressor_src_type stressorsrctype on esss.exp_stressor_src_type_id = stressorsrctype.id left outer join edit.exp_receptor_tobacco_use receptortobaccouse on ereceptor.id = receptortobaccouse.exp_receptor_id left outer join edit.tobacco_use tobaccouse on receptortobaccouse.tobacco_use_id = tobaccouse.id left outer join edit.exp_receptor_race receptorrace on ereceptor.id = receptorrace.exp_receptor_id left outer join edit.race race on receptorrace.race_id = race.id left outer join edit.exp_event_location eventlocation on eevent.id = eventlocation.exp_event_id left outer join edit.country on eventlocation.country_id = country.id left outer join edit.exp_outcome outcome on e.exp_outcome_id = outcome.id left outer join edit.exp_outcome_ixn_type eiot on outcome.exp_outcome_ixn_type_id = eiot.id left outer join edit.exp_anatomy expanatomy on outcome.id = expanatomy.exp_outcome_id left outer join edit.exp_event_assay_method eventassaymethod on eevent.id = eventassaymethod.exp_event_id left outer join edit.actor_form_type markerqual on markerqual.id = eevent.exp_marker_actor_form_type_id left outer join edit.exp_marker_type markertype on eevent.exp_marker_type_id = markertype.id where e.reference_acc_txt = ? group by e.reference_acc_txt, author, referenceexp.create_by, referenceexp.create_tm, referenceexp.email_addr, referenceexp.author_summary, referenceexp.curator_comments, pref.abbr_authors_txt, enrollmentyears, stressor.chem_term_nm, stressorsrcdetails, stressorsampleqty, stressornote, nbrreceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, receptor_note, agerange, detectionlimit, detectionfreq, medium_nm, eevent.exp_marker_term_nm, markerlevel, eevent.assay_measurement_stat, eevent.assay_note, eventnote, outcomerelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, outcomenote, ereceptor.id, markerqualifier, markertype_nm, eevent.id;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 04 15 2 5s713ms 2s856ms -
select distinct e.reference_acc_txt, referenceExp.create_by, referenceExp.create_tm, pref.abbr_authors_txt as author, referenceExp.email_addr, ( Select STRING_AGG(distinct studyFactor.cd, '|')) as studyFactor, referenceExp.author_summary, referenceExp.curator_comments, ( Select STRING_AGG(distinct eventproject.project_nm, '|')) as associatedStudyTitles, CONCAT(eevent.collection_start_yr, '-', eevent.collection_end_yr) as enrollmentYears, ( Select STRING_AGG(distinct studyFactor.nm, '|')) as studyFactor, ( Select STRING_AGG(distinct stressorSrcType.cd, '|')) as stressorSourceCategory, stressor.chem_term_nm, stressor.src_details as stressorSrcDetails, stressor.sample_qty as stressorSampleQty, stressor.note as stressorNote, ereceptor.qty as nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, ereceptor.note as receptor_note, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ' || tobaccoUse.nm, COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ', tobaccoUse.nm)), '|')) as smokerStatus, ereceptor.age || ' ' || age_uom.nm || ' (' || COALESCE(age_qualifier.nm, '') || ')' as ageRange, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ' || gender.nm_html, COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ', gender.nm_html)), '|') from edit.exp_receptor_gender expgender left outer join edit.gender on expgender.gender_id = gender.id where exp_receptor_id = ereceptor.id) as genderDetails, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ' || race.nm, COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ', race.nm)), '|')) as raceDetails, ( Select STRING_AGG(distinct eventAssayMethod.nm, '|')) as assayMethods, CONCAT(eevent.detection_limit, ' ', eevent.detection_limit_uom) as detectionLimit, eevent.detection_freq as detectionFreq, medium.nm as medium_nm, eevent.exp_marker_term_nm, CONCAT(eevent.exp_marker_lvl, ' ', eevent.assay_uom) as markerLevel, eevent.assay_measurement_stat, eevent.assay_note, ( Select STRING_AGG(distinct country.nm, '|')) as country, ( Select STRING_AGG(distinct eventLocation.geographic_region_nm, '|')) as stateOrProvince, ( Select STRING_AGG(distinct eventLocation.locality_txt, '|')) as region, eevent.note as eventNote, eiot.description as outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, ( Select STRING_AGG(distinct expAnatomy.anatomy_term_nm, '|')) as anatomy, outcome.note as outcomeNote, markerQual.actor_type_cd || markerQual.ixn_type_id || markerQual.cd as markerQualifier, markerType.nm as markerType_nm from edit.exposure e left outer join pub2.reference pref on pref.acc_txt = e.reference_acc_txt left outer join edit.reference_exp referenceExp on referenceExp.reference_acc_txt = e.reference_acc_txt left outer join edit.exp_study_factor expStudyFactor on referenceExp.id = expStudyFactor.reference_exp_id left outer join edit.study_factor studyFactor on studyFactor.id = expStudyFactor.study_factor_id left outer join edit.exp_event_project eventproject on eventproject.exp_event_id = e.exp_event_id inner join edit.exp_stressor stressor on e.exp_stressor_id = stressor.id left outer join edit.exp_receptor ereceptor on e.exp_receptor_id = ereceptor.id left outer join edit.receptor receptor on ereceptor.receptor_id = receptor.id left outer join edit.age_uom age_uom on ereceptor.age_uom_id = age_uom.id left outer join edit.age_qualifier age_qualifier on ereceptor.age_qualifier_id = age_qualifier.id left outer join edit.exp_event eevent on e.exp_event_id = eevent.id left outer join edit.medium medium on eevent.medium_id = medium.id left outer join edit.exp_stressor_stressor_src esss on stressor.id = esss.exp_stressor_id left outer join edit.exp_stressor_src_type stressorSrcType on esss.exp_stressor_src_type_id = stressorSrcType.id left outer join edit.exp_receptor_tobacco_use receptorTobaccoUse on ereceptor.id = receptorTobaccoUse.exp_receptor_id left outer join edit.tobacco_use tobaccoUse on receptorTobaccoUse.tobacco_use_id = tobaccoUse.id left outer join edit.exp_receptor_race receptorRace on ereceptor.id = receptorRace.exp_receptor_id left outer join edit.race race on receptorRace.race_id = race.id left outer join edit.exp_event_location eventLocation on eevent.id = eventLocation.exp_event_id left outer join edit.country on eventLocation.country_id = country.id left outer join edit.exp_outcome outcome on e.exp_outcome_id = outcome.id left outer join edit.exp_outcome_ixn_type eiot on outcome.exp_outcome_ixn_type_id = eiot.id left outer join edit.exp_anatomy expAnatomy on outcome.id = expAnatomy.exp_outcome_id left outer join edit.exp_event_assay_method eventAssayMethod on eevent.id = eventAssayMethod.exp_event_id left outer join edit.actor_form_type markerQual on markerQual.id = eevent.exp_marker_actor_form_type_id left outer join edit.exp_marker_type markerType on eevent.exp_marker_type_id = markerType.id where e.reference_acc_txt = '31103473' group by e.reference_acc_txt, author, referenceExp.create_by, referenceExp.create_tm, referenceExp.email_addr, referenceExp.author_summary, referenceExp.curator_comments, pref.abbr_authors_txt, enrollmentYears, stressor.chem_term_nm, stressorSrcDetails, stressorSampleQty, stressorNote, nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, receptor_note, ageRange, detectionLimit, detectionFreq, medium_nm, eevent.exp_marker_term_nm, markerLevel, eevent.assay_measurement_stat, eevent.assay_note, eventNote, outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, outcomeNote, ereceptor.id, markerQualifier, markerType_nm, eevent.id;
Date: 2025-08-04 15:34:26 Duration: 2s980ms Bind query: yes
-
select distinct e.reference_acc_txt, referenceExp.create_by, referenceExp.create_tm, pref.abbr_authors_txt as author, referenceExp.email_addr, ( Select STRING_AGG(distinct studyFactor.cd, '|')) as studyFactor, referenceExp.author_summary, referenceExp.curator_comments, ( Select STRING_AGG(distinct eventproject.project_nm, '|')) as associatedStudyTitles, CONCAT(eevent.collection_start_yr, '-', eevent.collection_end_yr) as enrollmentYears, ( Select STRING_AGG(distinct studyFactor.nm, '|')) as studyFactor, ( Select STRING_AGG(distinct stressorSrcType.cd, '|')) as stressorSourceCategory, stressor.chem_term_nm, stressor.src_details as stressorSrcDetails, stressor.sample_qty as stressorSampleQty, stressor.note as stressorNote, ereceptor.qty as nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, ereceptor.note as receptor_note, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ' || tobaccoUse.nm, COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ', tobaccoUse.nm)), '|')) as smokerStatus, ereceptor.age || ' ' || age_uom.nm || ' (' || COALESCE(age_qualifier.nm, '') || ')' as ageRange, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ' || gender.nm_html, COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ', gender.nm_html)), '|') from edit.exp_receptor_gender expgender left outer join edit.gender on expgender.gender_id = gender.id where exp_receptor_id = ereceptor.id) as genderDetails, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ' || race.nm, COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ', race.nm)), '|')) as raceDetails, ( Select STRING_AGG(distinct eventAssayMethod.nm, '|')) as assayMethods, CONCAT(eevent.detection_limit, ' ', eevent.detection_limit_uom) as detectionLimit, eevent.detection_freq as detectionFreq, medium.nm as medium_nm, eevent.exp_marker_term_nm, CONCAT(eevent.exp_marker_lvl, ' ', eevent.assay_uom) as markerLevel, eevent.assay_measurement_stat, eevent.assay_note, ( Select STRING_AGG(distinct country.nm, '|')) as country, ( Select STRING_AGG(distinct eventLocation.geographic_region_nm, '|')) as stateOrProvince, ( Select STRING_AGG(distinct eventLocation.locality_txt, '|')) as region, eevent.note as eventNote, eiot.description as outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, ( Select STRING_AGG(distinct expAnatomy.anatomy_term_nm, '|')) as anatomy, outcome.note as outcomeNote, markerQual.actor_type_cd || markerQual.ixn_type_id || markerQual.cd as markerQualifier, markerType.nm as markerType_nm from edit.exposure e left outer join pub2.reference pref on pref.acc_txt = e.reference_acc_txt left outer join edit.reference_exp referenceExp on referenceExp.reference_acc_txt = e.reference_acc_txt left outer join edit.exp_study_factor expStudyFactor on referenceExp.id = expStudyFactor.reference_exp_id left outer join edit.study_factor studyFactor on studyFactor.id = expStudyFactor.study_factor_id left outer join edit.exp_event_project eventproject on eventproject.exp_event_id = e.exp_event_id inner join edit.exp_stressor stressor on e.exp_stressor_id = stressor.id left outer join edit.exp_receptor ereceptor on e.exp_receptor_id = ereceptor.id left outer join edit.receptor receptor on ereceptor.receptor_id = receptor.id left outer join edit.age_uom age_uom on ereceptor.age_uom_id = age_uom.id left outer join edit.age_qualifier age_qualifier on ereceptor.age_qualifier_id = age_qualifier.id left outer join edit.exp_event eevent on e.exp_event_id = eevent.id left outer join edit.medium medium on eevent.medium_id = medium.id left outer join edit.exp_stressor_stressor_src esss on stressor.id = esss.exp_stressor_id left outer join edit.exp_stressor_src_type stressorSrcType on esss.exp_stressor_src_type_id = stressorSrcType.id left outer join edit.exp_receptor_tobacco_use receptorTobaccoUse on ereceptor.id = receptorTobaccoUse.exp_receptor_id left outer join edit.tobacco_use tobaccoUse on receptorTobaccoUse.tobacco_use_id = tobaccoUse.id left outer join edit.exp_receptor_race receptorRace on ereceptor.id = receptorRace.exp_receptor_id left outer join edit.race race on receptorRace.race_id = race.id left outer join edit.exp_event_location eventLocation on eevent.id = eventLocation.exp_event_id left outer join edit.country on eventLocation.country_id = country.id left outer join edit.exp_outcome outcome on e.exp_outcome_id = outcome.id left outer join edit.exp_outcome_ixn_type eiot on outcome.exp_outcome_ixn_type_id = eiot.id left outer join edit.exp_anatomy expAnatomy on outcome.id = expAnatomy.exp_outcome_id left outer join edit.exp_event_assay_method eventAssayMethod on eevent.id = eventAssayMethod.exp_event_id left outer join edit.actor_form_type markerQual on markerQual.id = eevent.exp_marker_actor_form_type_id left outer join edit.exp_marker_type markerType on eevent.exp_marker_type_id = markerType.id where e.reference_acc_txt = '31103473' group by e.reference_acc_txt, author, referenceExp.create_by, referenceExp.create_tm, referenceExp.email_addr, referenceExp.author_summary, referenceExp.curator_comments, pref.abbr_authors_txt, enrollmentYears, stressor.chem_term_nm, stressorSrcDetails, stressorSampleQty, stressorNote, nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, receptor_note, ageRange, detectionLimit, detectionFreq, medium_nm, eevent.exp_marker_term_nm, markerLevel, eevent.assay_measurement_stat, eevent.assay_note, eventNote, outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, outcomeNote, ereceptor.id, markerQualifier, markerType_nm, eevent.id;
Date: 2025-08-04 15:34:14 Duration: 2s733ms Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2s231ms 5s352ms 3s450ms 10 34s509ms select t.id, t.object_type_id, t.acc_txt, t.acc_db_cd, t.nm, t.nm_sort, t.secondary_nm, t.description, t.note, l.nm from pub2.term t, pub2.term_label l where t.object_type_id = ? and t.id = l.term_id;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 04 14 6 19s538ms 3s256ms 15 4 14s971ms 3s742ms [ User: editeu - Total duration: 34s509ms - Times executed: 10 ]
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 1 and t.id = l.TERM_ID;
Date: 2025-08-04 14:45:25 Duration: 5s352ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-08-04 15:18:47 Duration: 4s419ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-08-04 14:47:14 Duration: 4s331ms Database: ctddev51 User: editeu Bind query: yes
2 2s733ms 2s980ms 2s856ms 2 5s713ms select distinct e.reference_acc_txt, referenceexp.create_by, referenceexp.create_tm, pref.abbr_authors_txt as author, referenceexp.email_addr, ( select string_agg(distinct studyfactor.cd, ?)) as studyfactor, referenceexp.author_summary, referenceexp.curator_comments, ( select string_agg(distinct eventproject.project_nm, ?)) as associatedstudytitles, concat(eevent.collection_start_yr, ?, eevent.collection_end_yr) as enrollmentyears, ( select string_agg(distinct studyfactor.nm, ?)) as studyfactor, ( select string_agg(distinct stressorsrctype.cd, ?)) as stressorsourcecategory, stressor.chem_term_nm, stressor.src_details as stressorsrcdetails, stressor.sample_qty as stressorsampleqty, stressor.note as stressornote, ereceptor.qty as nbrreceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, ereceptor.note as receptor_note, ( select string_agg(distinct coalesce(coalesce(nullif (cast(receptortobaccouse.pct as int), ?)) || ? || tobaccouse.nm, coalesce(coalesce(nullif (cast(receptortobaccouse.pct as int), ?)) || ?, tobaccouse.nm)), ?)) as smokerstatus, ereceptor.age || ? || age_uom.nm || ? || coalesce(age_qualifier.nm, ?) || ? as agerange, ( select string_agg(distinct coalesce(coalesce(nullif (cast(pct as int), ?)) || ? || gender.nm_html, coalesce(coalesce(nullif (cast(pct as int), ?)) || ?, gender.nm_html)), ?) from edit.exp_receptor_gender expgender left outer join edit.gender on expgender.gender_id = gender.id where exp_receptor_id = ereceptor.id) as genderdetails, ( select string_agg(distinct coalesce(coalesce(nullif (cast(receptorrace.pct as int), ?)) || ? || race.nm, coalesce(coalesce(nullif (cast(receptorrace.pct as int), ?)) || ?, race.nm)), ?)) as racedetails, ( select string_agg(distinct eventassaymethod.nm, ?)) as assaymethods, concat(eevent.detection_limit, ?, eevent.detection_limit_uom) as detectionlimit, eevent.detection_freq as detectionfreq, medium.nm as medium_nm, eevent.exp_marker_term_nm, concat(eevent.exp_marker_lvl, ?, eevent.assay_uom) as markerlevel, eevent.assay_measurement_stat, eevent.assay_note, ( select string_agg(distinct country.nm, ?)) as country, ( select string_agg(distinct eventlocation.geographic_region_nm, ?)) as stateorprovince, ( select string_agg(distinct eventlocation.locality_txt, ?)) as region, eevent.note as eventnote, eiot.description as outcomerelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, ( select string_agg(distinct expanatomy.anatomy_term_nm, ?)) as anatomy, outcome.note as outcomenote, markerqual.actor_type_cd || markerqual.ixn_type_id || markerqual.cd as markerqualifier, markertype.nm as markertype_nm from edit.exposure e left outer join pub2.reference pref on pref.acc_txt = e.reference_acc_txt left outer join edit.reference_exp referenceexp on referenceexp.reference_acc_txt = e.reference_acc_txt left outer join edit.exp_study_factor expstudyfactor on referenceexp.id = expstudyfactor.reference_exp_id left outer join edit.study_factor studyfactor on studyfactor.id = expstudyfactor.study_factor_id left outer join edit.exp_event_project eventproject on eventproject.exp_event_id = e.exp_event_id inner join edit.exp_stressor stressor on e.exp_stressor_id = stressor.id left outer join edit.exp_receptor ereceptor on e.exp_receptor_id = ereceptor.id left outer join edit.receptor receptor on ereceptor.receptor_id = receptor.id left outer join edit.age_uom age_uom on ereceptor.age_uom_id = age_uom.id left outer join edit.age_qualifier age_qualifier on ereceptor.age_qualifier_id = age_qualifier.id left outer join edit.exp_event eevent on e.exp_event_id = eevent.id left outer join edit.medium medium on eevent.medium_id = medium.id left outer join edit.exp_stressor_stressor_src esss on stressor.id = esss.exp_stressor_id left outer join edit.exp_stressor_src_type stressorsrctype on esss.exp_stressor_src_type_id = stressorsrctype.id left outer join edit.exp_receptor_tobacco_use receptortobaccouse on ereceptor.id = receptortobaccouse.exp_receptor_id left outer join edit.tobacco_use tobaccouse on receptortobaccouse.tobacco_use_id = tobaccouse.id left outer join edit.exp_receptor_race receptorrace on ereceptor.id = receptorrace.exp_receptor_id left outer join edit.race race on receptorrace.race_id = race.id left outer join edit.exp_event_location eventlocation on eevent.id = eventlocation.exp_event_id left outer join edit.country on eventlocation.country_id = country.id left outer join edit.exp_outcome outcome on e.exp_outcome_id = outcome.id left outer join edit.exp_outcome_ixn_type eiot on outcome.exp_outcome_ixn_type_id = eiot.id left outer join edit.exp_anatomy expanatomy on outcome.id = expanatomy.exp_outcome_id left outer join edit.exp_event_assay_method eventassaymethod on eevent.id = eventassaymethod.exp_event_id left outer join edit.actor_form_type markerqual on markerqual.id = eevent.exp_marker_actor_form_type_id left outer join edit.exp_marker_type markertype on eevent.exp_marker_type_id = markertype.id where e.reference_acc_txt = ? group by e.reference_acc_txt, author, referenceexp.create_by, referenceexp.create_tm, referenceexp.email_addr, referenceexp.author_summary, referenceexp.curator_comments, pref.abbr_authors_txt, enrollmentyears, stressor.chem_term_nm, stressorsrcdetails, stressorsampleqty, stressornote, nbrreceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, receptor_note, agerange, detectionlimit, detectionfreq, medium_nm, eevent.exp_marker_term_nm, markerlevel, eevent.assay_measurement_stat, eevent.assay_note, eventnote, outcomerelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, outcomenote, ereceptor.id, markerqualifier, markertype_nm, eevent.id;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 04 15 2 5s713ms 2s856ms -
select distinct e.reference_acc_txt, referenceExp.create_by, referenceExp.create_tm, pref.abbr_authors_txt as author, referenceExp.email_addr, ( Select STRING_AGG(distinct studyFactor.cd, '|')) as studyFactor, referenceExp.author_summary, referenceExp.curator_comments, ( Select STRING_AGG(distinct eventproject.project_nm, '|')) as associatedStudyTitles, CONCAT(eevent.collection_start_yr, '-', eevent.collection_end_yr) as enrollmentYears, ( Select STRING_AGG(distinct studyFactor.nm, '|')) as studyFactor, ( Select STRING_AGG(distinct stressorSrcType.cd, '|')) as stressorSourceCategory, stressor.chem_term_nm, stressor.src_details as stressorSrcDetails, stressor.sample_qty as stressorSampleQty, stressor.note as stressorNote, ereceptor.qty as nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, ereceptor.note as receptor_note, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ' || tobaccoUse.nm, COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ', tobaccoUse.nm)), '|')) as smokerStatus, ereceptor.age || ' ' || age_uom.nm || ' (' || COALESCE(age_qualifier.nm, '') || ')' as ageRange, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ' || gender.nm_html, COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ', gender.nm_html)), '|') from edit.exp_receptor_gender expgender left outer join edit.gender on expgender.gender_id = gender.id where exp_receptor_id = ereceptor.id) as genderDetails, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ' || race.nm, COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ', race.nm)), '|')) as raceDetails, ( Select STRING_AGG(distinct eventAssayMethod.nm, '|')) as assayMethods, CONCAT(eevent.detection_limit, ' ', eevent.detection_limit_uom) as detectionLimit, eevent.detection_freq as detectionFreq, medium.nm as medium_nm, eevent.exp_marker_term_nm, CONCAT(eevent.exp_marker_lvl, ' ', eevent.assay_uom) as markerLevel, eevent.assay_measurement_stat, eevent.assay_note, ( Select STRING_AGG(distinct country.nm, '|')) as country, ( Select STRING_AGG(distinct eventLocation.geographic_region_nm, '|')) as stateOrProvince, ( Select STRING_AGG(distinct eventLocation.locality_txt, '|')) as region, eevent.note as eventNote, eiot.description as outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, ( Select STRING_AGG(distinct expAnatomy.anatomy_term_nm, '|')) as anatomy, outcome.note as outcomeNote, markerQual.actor_type_cd || markerQual.ixn_type_id || markerQual.cd as markerQualifier, markerType.nm as markerType_nm from edit.exposure e left outer join pub2.reference pref on pref.acc_txt = e.reference_acc_txt left outer join edit.reference_exp referenceExp on referenceExp.reference_acc_txt = e.reference_acc_txt left outer join edit.exp_study_factor expStudyFactor on referenceExp.id = expStudyFactor.reference_exp_id left outer join edit.study_factor studyFactor on studyFactor.id = expStudyFactor.study_factor_id left outer join edit.exp_event_project eventproject on eventproject.exp_event_id = e.exp_event_id inner join edit.exp_stressor stressor on e.exp_stressor_id = stressor.id left outer join edit.exp_receptor ereceptor on e.exp_receptor_id = ereceptor.id left outer join edit.receptor receptor on ereceptor.receptor_id = receptor.id left outer join edit.age_uom age_uom on ereceptor.age_uom_id = age_uom.id left outer join edit.age_qualifier age_qualifier on ereceptor.age_qualifier_id = age_qualifier.id left outer join edit.exp_event eevent on e.exp_event_id = eevent.id left outer join edit.medium medium on eevent.medium_id = medium.id left outer join edit.exp_stressor_stressor_src esss on stressor.id = esss.exp_stressor_id left outer join edit.exp_stressor_src_type stressorSrcType on esss.exp_stressor_src_type_id = stressorSrcType.id left outer join edit.exp_receptor_tobacco_use receptorTobaccoUse on ereceptor.id = receptorTobaccoUse.exp_receptor_id left outer join edit.tobacco_use tobaccoUse on receptorTobaccoUse.tobacco_use_id = tobaccoUse.id left outer join edit.exp_receptor_race receptorRace on ereceptor.id = receptorRace.exp_receptor_id left outer join edit.race race on receptorRace.race_id = race.id left outer join edit.exp_event_location eventLocation on eevent.id = eventLocation.exp_event_id left outer join edit.country on eventLocation.country_id = country.id left outer join edit.exp_outcome outcome on e.exp_outcome_id = outcome.id left outer join edit.exp_outcome_ixn_type eiot on outcome.exp_outcome_ixn_type_id = eiot.id left outer join edit.exp_anatomy expAnatomy on outcome.id = expAnatomy.exp_outcome_id left outer join edit.exp_event_assay_method eventAssayMethod on eevent.id = eventAssayMethod.exp_event_id left outer join edit.actor_form_type markerQual on markerQual.id = eevent.exp_marker_actor_form_type_id left outer join edit.exp_marker_type markerType on eevent.exp_marker_type_id = markerType.id where e.reference_acc_txt = '31103473' group by e.reference_acc_txt, author, referenceExp.create_by, referenceExp.create_tm, referenceExp.email_addr, referenceExp.author_summary, referenceExp.curator_comments, pref.abbr_authors_txt, enrollmentYears, stressor.chem_term_nm, stressorSrcDetails, stressorSampleQty, stressorNote, nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, receptor_note, ageRange, detectionLimit, detectionFreq, medium_nm, eevent.exp_marker_term_nm, markerLevel, eevent.assay_measurement_stat, eevent.assay_note, eventNote, outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, outcomeNote, ereceptor.id, markerQualifier, markerType_nm, eevent.id;
Date: 2025-08-04 15:34:26 Duration: 2s980ms Bind query: yes
-
select distinct e.reference_acc_txt, referenceExp.create_by, referenceExp.create_tm, pref.abbr_authors_txt as author, referenceExp.email_addr, ( Select STRING_AGG(distinct studyFactor.cd, '|')) as studyFactor, referenceExp.author_summary, referenceExp.curator_comments, ( Select STRING_AGG(distinct eventproject.project_nm, '|')) as associatedStudyTitles, CONCAT(eevent.collection_start_yr, '-', eevent.collection_end_yr) as enrollmentYears, ( Select STRING_AGG(distinct studyFactor.nm, '|')) as studyFactor, ( Select STRING_AGG(distinct stressorSrcType.cd, '|')) as stressorSourceCategory, stressor.chem_term_nm, stressor.src_details as stressorSrcDetails, stressor.sample_qty as stressorSampleQty, stressor.note as stressorNote, ereceptor.qty as nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, ereceptor.note as receptor_note, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ' || tobaccoUse.nm, COALESCE(COALESCE(NULLIF (CAST(receptorTobaccoUse.pct as int), 0)) || '% ', tobaccoUse.nm)), '|')) as smokerStatus, ereceptor.age || ' ' || age_uom.nm || ' (' || COALESCE(age_qualifier.nm, '') || ')' as ageRange, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ' || gender.nm_html, COALESCE(COALESCE(NULLIF (CAST(pct as int), 0)) || '% ', gender.nm_html)), '|') from edit.exp_receptor_gender expgender left outer join edit.gender on expgender.gender_id = gender.id where exp_receptor_id = ereceptor.id) as genderDetails, ( Select STRING_AGG(distinct COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ' || race.nm, COALESCE(COALESCE(NULLIF (CAST(receptorRace.pct as int), 0)) || '% ', race.nm)), '|')) as raceDetails, ( Select STRING_AGG(distinct eventAssayMethod.nm, '|')) as assayMethods, CONCAT(eevent.detection_limit, ' ', eevent.detection_limit_uom) as detectionLimit, eevent.detection_freq as detectionFreq, medium.nm as medium_nm, eevent.exp_marker_term_nm, CONCAT(eevent.exp_marker_lvl, ' ', eevent.assay_uom) as markerLevel, eevent.assay_measurement_stat, eevent.assay_note, ( Select STRING_AGG(distinct country.nm, '|')) as country, ( Select STRING_AGG(distinct eventLocation.geographic_region_nm, '|')) as stateOrProvince, ( Select STRING_AGG(distinct eventLocation.locality_txt, '|')) as region, eevent.note as eventNote, eiot.description as outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, ( Select STRING_AGG(distinct expAnatomy.anatomy_term_nm, '|')) as anatomy, outcome.note as outcomeNote, markerQual.actor_type_cd || markerQual.ixn_type_id || markerQual.cd as markerQualifier, markerType.nm as markerType_nm from edit.exposure e left outer join pub2.reference pref on pref.acc_txt = e.reference_acc_txt left outer join edit.reference_exp referenceExp on referenceExp.reference_acc_txt = e.reference_acc_txt left outer join edit.exp_study_factor expStudyFactor on referenceExp.id = expStudyFactor.reference_exp_id left outer join edit.study_factor studyFactor on studyFactor.id = expStudyFactor.study_factor_id left outer join edit.exp_event_project eventproject on eventproject.exp_event_id = e.exp_event_id inner join edit.exp_stressor stressor on e.exp_stressor_id = stressor.id left outer join edit.exp_receptor ereceptor on e.exp_receptor_id = ereceptor.id left outer join edit.receptor receptor on ereceptor.receptor_id = receptor.id left outer join edit.age_uom age_uom on ereceptor.age_uom_id = age_uom.id left outer join edit.age_qualifier age_qualifier on ereceptor.age_qualifier_id = age_qualifier.id left outer join edit.exp_event eevent on e.exp_event_id = eevent.id left outer join edit.medium medium on eevent.medium_id = medium.id left outer join edit.exp_stressor_stressor_src esss on stressor.id = esss.exp_stressor_id left outer join edit.exp_stressor_src_type stressorSrcType on esss.exp_stressor_src_type_id = stressorSrcType.id left outer join edit.exp_receptor_tobacco_use receptorTobaccoUse on ereceptor.id = receptorTobaccoUse.exp_receptor_id left outer join edit.tobacco_use tobaccoUse on receptorTobaccoUse.tobacco_use_id = tobaccoUse.id left outer join edit.exp_receptor_race receptorRace on ereceptor.id = receptorRace.exp_receptor_id left outer join edit.race race on receptorRace.race_id = race.id left outer join edit.exp_event_location eventLocation on eevent.id = eventLocation.exp_event_id left outer join edit.country on eventLocation.country_id = country.id left outer join edit.exp_outcome outcome on e.exp_outcome_id = outcome.id left outer join edit.exp_outcome_ixn_type eiot on outcome.exp_outcome_ixn_type_id = eiot.id left outer join edit.exp_anatomy expAnatomy on outcome.id = expAnatomy.exp_outcome_id left outer join edit.exp_event_assay_method eventAssayMethod on eevent.id = eventAssayMethod.exp_event_id left outer join edit.actor_form_type markerQual on markerQual.id = eevent.exp_marker_actor_form_type_id left outer join edit.exp_marker_type markerType on eevent.exp_marker_type_id = markerType.id where e.reference_acc_txt = '31103473' group by e.reference_acc_txt, author, referenceExp.create_by, referenceExp.create_tm, referenceExp.email_addr, referenceExp.author_summary, referenceExp.curator_comments, pref.abbr_authors_txt, enrollmentYears, stressor.chem_term_nm, stressorSrcDetails, stressorSampleQty, stressorNote, nbrReceptors, receptor.nm, ereceptor.term_nm, ereceptor.term_acc_txt, receptor_note, ageRange, detectionLimit, detectionFreq, medium_nm, eevent.exp_marker_term_nm, markerLevel, eevent.assay_measurement_stat, eevent.assay_note, eventNote, outcomeRelationship, outcome.disease_term_nm, outcome.phenotype_action_degree_type_nm, outcome.phenotype_term_nm, outcomeNote, ereceptor.id, markerQualifier, markerType_nm, eevent.id;
Date: 2025-08-04 15:34:14 Duration: 2s733ms Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 282 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 1 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
- 10 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 9 Max number of times the same event was reported
- 12 Total events found
Rank Times reported Error 1 9 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 04 10 2 16 7 2 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 04 14 1 - FATAL: connection to client lost
Statement: select t.ID ,t.OBJECT_TYPE_ID ,t.ACC_TXT ,t.ACC_DB_CD ,t.NM ,t.NM_SORT ,t.SECONDARY_NM ,t.DESCRIPTION ,t.NOTE ,l.NM from pub2.TERM t ,pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID
Date: 2025-08-04 14:47:08
3 1 LOG: could not send data to client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 04 14 1 - LOG: could not send data to client: Connection reset by peer
Statement: select t.ID ,t.OBJECT_TYPE_ID ,t.ACC_TXT ,t.ACC_DB_CD ,t.NM ,t.NM_SORT ,t.SECONDARY_NM ,t.DESCRIPTION ,t.NOTE ,l.NM from pub2.TERM t ,pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID
Date: 2025-08-04 14:47:08 Database: ctddev51 Application: User: editeu Remote:
4 1 ERROR: permission denied for table ...
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 04 15 1 - ERROR: permission denied for table exp_event
Statement: UPDATE exp_event SET detection_limit_uom = NULL WHERE trim(detection_limit_uom) = '';
Date: 2025-08-04 15:30:27 Database: ctddev51 Application: pgAdmin 4 - CONN:688485 User: editeu Remote: