explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vw1r

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 176,708.795 ↓ 0.0 0 1

Sort (cost=23,471,082.75..23,596,171.46 rows=50,035,483 width=43) (actual time=176,708.795..176,708.795 rows=0 loops=1)

  • Sort Key: psf.display_order
  • Sort Method: quicksort Memory: 25kB
2. 0.009 176,708.786 ↓ 0.0 0 1

Hash Join (cost=8,721,986.74..15,533,255.55 rows=50,035,483 width=43) (actual time=176,708.786..176,708.786 rows=0 loops=1)

  • Hash Cond: (psf.form_id = fc.id)
3. 55,862.802 176,708.430 ↓ 0.0 0 1

Hash Join (cost=8,721,970.99..15,400,465.69 rows=50,035,483 width=12) (actual time=176,708.430..176,708.430 rows=0 loops=1)

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

Seq Scan on patient_section_forms psf (cost=0.00..4,834,051.00 rows=113,287,887 width=12) (actual time=0.015..38,469.876 rows=114,526,817 loops=1)

  • Filter: ((form_type)::text = 'Form_CONS'::text)
  • Rows Removed by Filter: 140932949
5. 18,147.611 82,375.752 ↓ 1.0 112,995,498 1

Hash (cost=6,870,884.86..6,870,884.86 rows=112,828,090 width=8) (actual time=82,375.752..82,375.752 rows=112,995,498 loops=1)

  • Buckets: 2097152 Batches: 128 Memory Usage: 50886kB
6. 64,228.141 64,228.141 ↓ 1.0 112,995,498 1

Seq Scan on patient_section_details psd (cost=0.00..6,870,884.86 rows=112,828,090 width=8) (actual time=0.017..64,228.141 rows=112,995,498 loops=1)

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

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

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

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

Planning time : 4.032 ms
Execution time : 176,711.723 ms