explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QSDt

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 129,721.512 ↑ 1.0 1 1

Limit (cost=43,437.60..43,437.61 rows=1 width=505) (actual time=129,721.511..129,721.512 rows=1 loops=1)

2. 0.026 129,721.508 ↑ 1.0 1 1

HashAggregate (cost=43,437.60..43,437.61 rows=1 width=505) (actual time=129,721.508..129,721.508 rows=1 loops=1)

  • Group Key: t0.clinical_item_key, t0.clinical_item_type_key, t0.activity_time, t0.availability_time, t0.created_on, t0.description, t0.end_time, t0.federated, t0.header, t0.id, t0.label, t0.negation_indicator, t0.notes, t0.source_created_on, t0.source_updated_on
3. 0.016 129,721.482 ↑ 1.0 1 1

Nested Loop (cost=2.99..43,437.52 rows=1 width=505) (actual time=383.871..129,721.482 rows=1 loops=1)

4. 0.006 129,663.651 ↑ 1.0 1 1

Nested Loop (cost=2.55..43,434.85 rows=1 width=505) (actual time=326.042..129,663.651 rows=1 loops=1)

5. 0.234 129,475.269 ↑ 1.0 1 1

Nested Loop (cost=1.98..43,432.05 rows=1 width=513) (actual time=137.665..129,475.269 rows=1 loops=1)

6. 0.521 129,337.891 ↓ 217.0 217 1

Nested Loop (cost=1.27..43,430.19 rows=1 width=505) (actual time=0.447..129,337.891 rows=217 loops=1)

7. 129,317.840 129,317.840 ↓ 217.0 217 1

Index Scan using clinical_item_subject_key_fki on clinical_item t0 (cost=0.70..43,427.40 rows=1 width=449) (actual time=0.392..129,317.840 rows=217 loops=1)

  • Index Cond: (subject_key = 9567513::numeric)
  • Filter: ((facility_key = 1070::numeric) AND (source_facility_key = 1085::numeric) AND (clinical_item_type_key = 16::numeric))
  • Rows Removed by Filter: 194725
8. 19.530 19.530 ↑ 1.0 1 217

Index Scan using advance_directive_pk on advance_directive t1 (cost=0.56..2.79 rows=1 width=56) (actual time=0.089..0.090 rows=1 loops=217)

  • Index Cond: (clinical_item_key = t0.clinical_item_key)
9. 137.144 137.144 ↓ 0.0 0 217

Index Only Scan using clinical_item_clinical_msg_pk on clinical_item_clinical_message t4 (cost=0.71..1.85 rows=1 width=17) (actual time=0.632..0.632 rows=0 loops=217)

  • Index Cond: ((clinical_item_key = t1.clinical_item_key) AND (clinical_message_key = 843421831::numeric))
  • Heap Fetches: 1
10. 188.376 188.376 ↑ 1.0 1 1

Index Only Scan using clinical_message_pk on clinical_message t3 (cost=0.57..2.79 rows=1 width=8) (actual time=188.373..188.376 rows=1 loops=1)

  • Index Cond: (clinical_message_key = 843421831::numeric)
  • Heap Fetches: 1
11. 57.815 57.815 ↑ 1.0 1 1

Index Scan using coded_element_pk on coded_element t2 (cost=0.44..2.66 rows=1 width=7) (actual time=57.814..57.815 rows=1 loops=1)

  • Index Cond: (coded_element_key = t0.code_key)
  • Filter: ((code)::text = '19000201'::text)