explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s0n3

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 180,771.722 ↓ 0.0 0 1

Sort (cost=23,471,105.43..23,596,194.17 rows=50,035,496 width=43) (actual time=180,771.722..180,771.722 rows=0 loops=1)

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

Hash Join (cost=8,722,001.25..15,533,272.97 rows=50,035,496 width=43) (actual time=180,771.713..180,771.713 rows=0 loops=1)

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

Hash Join (cost=8,721,985.50..15,400,483.08 rows=50,035,496 width=12) (actual time=180,771.323..180,771.323 rows=0 loops=1)

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

Seq Scan on patient_section_forms psf (cost=0.00..4,834,052.80 rows=113,287,916 width=12) (actual time=0.021..44,003.032 rows=114,526,848 loops=1)

  • Filter: ((form_type)::text = 'Form_CONS'::text)
  • Rows Removed by Filter: 140933003
5. 18,090.239 79,845.398 ↓ 1.0 112,995,552 1

Hash (cost=6,870,896.08..6,870,896.08 rows=112,828,274 width=8) (actual time=79,845.398..79,845.398 rows=112,995,552 loops=1)

  • Buckets: 2097152 Batches: 128 Memory Usage: 50886kB
6. 61,755.159 61,755.159 ↓ 1.0 112,995,552 1

Seq Scan on patient_section_details psd (cost=0.00..6,870,896.08 rows=112,828,274 width=8) (actual time=1.169..61,755.159 rows=112,995,552 loops=1)

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

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

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

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

Planning time : 1.354 ms
Execution time : 180,771.940 ms