explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b4dq

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.030 ↓ 0.0 0 1

Sort (cost=130,478.26..130,478.27 rows=4 width=426) (actual time=0.030..0.030 rows=0 loops=1)

  • Sort Key: "*SELECT* 1".section_detail_id, "*SELECT* 1".section_id, "*SELECT* 1".field_display_order, "*SELECT* 1".option_display_order
  • Sort Method: quicksort Memory: 25kB
2.          

Initplan (forSort)

3. 0.016 0.016 ↓ 0.0 0 1

Index Scan using pat_dyn_pres_idx on patient_dynamic_section_details (cost=0.43..4.47 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (prescription_id = 22135775)
  • Filter: (visit_type = 'o'::text)
4. 0.018 0.018 ↓ 0.0 0 1

Result (cost=1,001.27..130,473.75 rows=4 width=426) (actual time=0.018..0.018 rows=0 loops=1)

  • One-Time Filter: $0
5. 0.000 0.000 ↓ 0.0 0

Append (cost=1,001.27..130,473.63 rows=4 width=620) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1 (cost=1,001.27..130,473.63 rows=3 width=262) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,001.27..130,473.52 rows=3 width=206) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
8. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.27..129,473.22 rows=1 width=206) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.99..129,468.90 rows=1 width=111) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..129,464.58 rows=1 width=77) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..129,464.26 rows=1 width=43) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on patient_dynamic_section_values v (cost=0.00..129,455.32 rows=2 width=37) (never executed)

  • Filter: (prescription_id = 22135775)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_dynamic_section_details_pkey on patient_dynamic_section_details psd (cost=0.43..4.47 rows=1 width=10) (never executed)

  • Index Cond: (section_detail_id = v.section_detail_id)
  • Filter: (visit_type = 'o'::text)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using physician_form_desc_pkey on section_master sm (cost=0.28..0.32 rows=1 width=38) (never executed)

  • Index Cond: (section_id = psd.section_id)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using sfd_field_id_idx on section_field_desc sfd (cost=0.28..4.32 rows=1 width=38) (never executed)

  • Index Cond: (field_id = v.field_id)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using sfo_option_id_idx on section_field_options o (cost=0.29..4.32 rows=1 width=23) (never executed)

  • Index Cond: (v.option_id = option_id)
17. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=187) (never executed)

  • One-Time Filter: false
Planning time : 3.212 ms
Execution time : 0.302 ms