explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kdxm

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 180,520.065 ↓ 0.0 0 1

Sort (cost=23,471,093.76..23,596,182.47 rows=50,035,483 width=43) (actual time=180,520.065..180,520.065 rows=0 loops=1)

  • Sort Key: psf.display_order
  • Sort Method: quicksort Memory: 25kB
2. 0.013 180,520.033 ↓ 0.0 0 1

Hash Join (cost=8,721,996.75..15,533,266.56 rows=50,035,483 width=43) (actual time=180,520.033..180,520.033 rows=0 loops=1)

  • Hash Cond: (psf.form_id = fc.id)
3. 56,457.380 180,519.716 ↓ 0.0 0 1

Hash Join (cost=8,721,981.00..15,400,476.70 rows=50,035,483 width=12) (actual time=180,519.716..180,519.716 rows=0 loops=1)

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

Seq Scan on patient_section_forms psf (cost=0.00..4,834,051.00 rows=113,287,887 width=12) (actual time=0.801..39,632.806 rows=114,526,848 loops=1)

  • Filter: ((form_type)::text = 'Form_CONS'::text)
  • Rows Removed by Filter: 140932977
5. 18,062.329 84,429.530 ↓ 1.0 112,995,526 1

Hash (cost=6,870,892.34..6,870,892.34 rows=112,828,213 width=8) (actual time=84,429.530..84,429.530 rows=112,995,526 loops=1)

  • Buckets: 2097152 Batches: 128 Memory Usage: 50886kB
6. 66,367.201 66,367.201 ↓ 1.0 112,995,526 1

Seq Scan on patient_section_details psd (cost=0.00..6,870,892.34 rows=112,828,213 width=8) (actual time=1.102..66,367.201 rows=112,995,526 loops=1)

  • Filter: (section_item_id = 0)
  • Rows Removed by Filter: 142464294
7. 0.138 0.304 ↓ 1.0 390 1

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

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

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

Planning time : 22.527 ms
Execution time : 180,522.014 ms