explain.depesz.com

PostgreSQL's explain analyze made readable

Result: df9Am

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

Nested Loop (cost=2,544.35..5,941.71 rows=5 width=548) (actual time=240.514..240.514 rows=0 loops=1)

2. 0.007 240.514 ↓ 0.0 0 1

Nested Loop (cost=2,544.07..5,930.11 rows=5 width=548) (actual time=240.514..240.514 rows=0 loops=1)

3. 0.017 0.017 ↑ 1.0 1 1

Index Only Scan using physician_form_desc_pkey on section_master sm (cost=0.28..2.31 rows=1 width=4) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: (section_id = 349)
  • Heap Fetches: 0
4. 0.002 240.490 ↓ 0.0 0 1

Append (cost=2,543.79..5,927.49 rows=5 width=548) (actual time=240.490..240.490 rows=0 loops=1)

5. 0.000 126.834 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=2,543.79..3,377.34 rows=4 width=233) (actual time=126.834..126.834 rows=0 loops=1)

6. 0.002 126.834 ↓ 0.0 0 1

Nested Loop (cost=2,543.79..3,377.20 rows=4 width=177) (actual time=126.834..126.834 rows=0 loops=1)

  • Join Filter: (psd.section_detail_id = v.section_detail_id)
7. 0.004 126.821 ↑ 1.0 1 1

Nested Loop (cost=2,543.22..2,549.32 rows=1 width=80) (actual time=126.820..126.821 rows=1 loops=1)

8. 0.018 126.802 ↑ 1.0 1 1

Bitmap Heap Scan on patient_section_details psd (cost=2,542.65..2,544.68 rows=1 width=63) (actual time=126.802..126.802 rows=1 loops=1)

  • Recheck Cond: (((mr_no)::text = 'UL0300000321641'::text) AND (section_id = 349))
  • Filter: (section_status = 'A'::bpchar)
  • Rows Removed by Filter: 3
  • Heap Blocks: exact=4
9. 2.598 126.784 ↓ 0.0 0 1

BitmapAnd (cost=2,542.65..2,542.65 rows=1 width=0) (actual time=126.784..126.784 rows=0 loops=1)

10. 0.257 0.257 ↑ 1.5 1,111 1

Bitmap Index Scan on patient_section_details_mr_no_idx (cost=0.00..33.23 rows=1,688 width=0) (actual time=0.257..0.257 rows=1,111 loops=1)

  • Index Cond: ((mr_no)::text = 'UL0300000321641'::text)
11. 123.929 123.929 ↓ 3.5 437,085 1

Bitmap Index Scan on psd_section_id_idx (cost=0.00..2,509.16 rows=125,146 width=0) (actual time=123.929..123.929 rows=437,085 loops=1)

  • Index Cond: (section_id = 349)
12. 0.015 0.015 ↑ 1.0 1 1

Index Scan using psf_section_detail_id_idx on patient_section_forms psf (cost=0.57..4.61 rows=1 width=17) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: (section_detail_id = psd.section_detail_id)
13. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ppfv_form_detail_id on patient_section_values v (cost=0.57..572.27 rows=7,865 width=29) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (section_detail_id = psf.section_detail_id)
  • Filter: (available = 'Y'::bpchar)
14. 0.001 113.654 ↓ 0.0 0 1

Nested Loop (cost=2,543.65..2,550.12 rows=1 width=145) (actual time=113.654..113.654 rows=0 loops=1)

  • Join Filter: (psd_1.section_detail_id = img.section_detail_id)
15. 0.003 113.644 ↑ 1.0 1 1

Nested Loop (cost=2,543.22..2,549.32 rows=1 width=80) (actual time=113.643..113.644 rows=1 loops=1)

16. 0.016 113.628 ↑ 1.0 1 1

Bitmap Heap Scan on patient_section_details psd_1 (cost=2,542.65..2,544.68 rows=1 width=63) (actual time=113.628..113.628 rows=1 loops=1)

  • Recheck Cond: (((mr_no)::text = 'UL0300000321641'::text) AND (section_id = 349))
  • Filter: (section_status = 'A'::bpchar)
  • Rows Removed by Filter: 3
  • Heap Blocks: exact=4
17. 2.511 113.612 ↓ 0.0 0 1

BitmapAnd (cost=2,542.65..2,542.65 rows=1 width=0) (actual time=113.612..113.612 rows=0 loops=1)

18. 0.090 0.090 ↑ 1.5 1,111 1

Bitmap Index Scan on patient_section_details_mr_no_idx (cost=0.00..33.23 rows=1,688 width=0) (actual time=0.090..0.090 rows=1,111 loops=1)

  • Index Cond: ((mr_no)::text = 'UL0300000321641'::text)
19. 111.011 111.011 ↓ 3.5 437,085 1

Bitmap Index Scan on psd_section_id_idx (cost=0.00..2,509.16 rows=125,146 width=0) (actual time=111.011..111.011 rows=437,085 loops=1)

  • Index Cond: (section_id = 349)
20. 0.013 0.013 ↑ 1.0 1 1

Index Scan using psf_section_detail_id_idx on patient_section_forms psf_1 (cost=0.57..4.61 rows=1 width=17) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (section_detail_id = psd_1.section_detail_id)
21. 0.009 0.009 ↓ 0.0 0 1

Index Scan using ppfg_form_detail_id on patient_section_image_details img (cost=0.43..0.63 rows=5 width=29) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (section_detail_id = psf_1.section_detail_id)
  • Filter: (available = 'Y'::bpchar)
22. 0.000 0.000 ↓ 0.0 0

Index Only Scan using sfd_field_id_idx on section_field_desc sfd (cost=0.28..2.32 rows=1 width=4) (never executed)

  • Index Cond: (field_id = "*SELECT* 1".field_id)
  • Heap Fetches: 0
Planning time : 3.170 ms
Execution time : 240.754 ms