explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cKGi

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 182,866.537 ↓ 0.0 0 1

Sort (cost=23,471,751.77..23,596,840.60 rows=50,035,531 width=43) (actual time=182,866.537..182,866.537 rows=0 loops=1)

  • Sort Key: psf.display_order
  • Sort Method: quicksort Memory: 25kB
2. 0.007 182,866.529 ↓ 0.0 0 1

Hash Join (cost=8,722,587.29..15,533,914.59 rows=50,035,531 width=43) (actual time=182,866.529..182,866.529 rows=0 loops=1)

  • Hash Cond: (psf.form_id = fc.id)
3. 56,568.876 182,866.177 ↓ 0.0 0 1

Hash Join (cost=8,722,571.54..15,401,124.60 rows=50,035,531 width=12) (actual time=182,866.177..182,866.177 rows=0 loops=1)

  • Hash Cond: (psf.section_detail_id = psd.section_detail_id)
4. 39,001.991 39,001.991 ↓ 1.0 114,526,817 1

Seq Scan on patient_section_forms psf (cost=0.00..4,834,054.08 rows=113,287,996 width=12) (actual time=0.014..39,001.991 rows=114,526,817 loops=1)

  • Filter: ((form_type)::text = 'Form_CONS'::text)
  • Rows Removed by Filter: 140932931
5. 18,351.729 87,295.310 ↓ 1.0 112,995,480 1

Hash (cost=6,871,264.36..6,871,264.36 rows=112,841,534 width=8) (actual time=87,295.310..87,295.310 rows=112,995,480 loops=1)

  • Buckets: 2097152 Batches: 128 Memory Usage: 50886kB
6. 68,943.581 68,943.581 ↓ 1.0 112,995,480 1

Seq Scan on patient_section_details psd (cost=0.00..6,871,264.36 rows=112,841,534 width=8) (actual time=0.021..68,943.581 rows=112,995,480 loops=1)

  • Filter: (section_item_id = 0)
  • Rows Removed by Filter: 142464263
7. 0.163 0.345 ↓ 1.0 390 1

Hash (cost=10.89..10.89 rows=389 width=35) (actual time=0.344..0.345 rows=390 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
8. 0.182 0.182 ↓ 1.0 390 1

Seq Scan on form_components fc (cost=0.00..10.89 rows=389 width=35) (actual time=0.011..0.182 rows=390 loops=1)

Planning time : 0.739 ms
Execution time : 182,868.509 ms