explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fLa4 : MINE - 4

Settings
# exclusive inclusive rows x rows loops node
1. 0.055 0.532 ↓ 1.1 100 1

Hash Join (cost=52.40..341.34 rows=91 width=4) (actual time=0.430..0.532 rows=100 loops=1)

  • Hash Cond: (xfiler_checklist.id = xfiler_checklistitemextra.checklist_id)
  • Join Filter: ((xfiler_tx.location_id = 145) OR ((xfiler_tx.location_id = 145) AND (xfiler_checklist.tx_id = ANY ('{25728,25729,25730,25731,25732,25733,25713,25726}'::integer[])) AND ((xfiler_checklistitemextra.visibility)::text = 'admins'::text)) OR ((xfiler_checklist.tx_id = ANY ('{25728,25729,25730,25731,25732,25733,25713,25726}'::integer[])) AND ((xfiler_checklistitemextra.visibility)::text = ''::text)) OR ((xfiler_checklist.tx_id = ANY ('{25728,25729,25730,25731,25732,25733,25713,25726}'::integer[])) AND ((xfiler_checklistitemextra.visibility)::text = 'agents'::text)) OR ((xfiler_checklist.tx_id = ANY ('{25728,25729,25731,25732,25733,25713,25726}'::integer[])) AND ((xfiler_checklistitemextra.visibility)::text = 'listing'::text)) OR ((xfiler_checklist.tx_id = ANY ('{25728,25729,25730,25731,25726}'::integer[])) AND ((xfiler_checklistitemextra.visibility)::text = 'selling'::text)))
2. 0.044 0.229 ↑ 1.0 48 1

Hash Join (cost=25.95..305.27 rows=50 width=12) (actual time=0.159..0.229 rows=48 loops=1)

  • Hash Cond: (xfiler_checklist.tx_id = xfiler_tx.id)
3. 0.044 0.044 ↓ 1.0 54 1

Index Scan using xfiler_checklist_pkey on xfiler_checklist (cost=0.00..278.62 rows=53 width=8) (actual time=0.003..0.044 rows=54 loops=1)

4. 0.033 0.141 ↓ 1.0 115 1

Hash (cost=24.52..24.52 rows=114 width=8) (actual time=0.141..0.141 rows=115 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
5. 0.108 0.108 ↓ 1.0 115 1

Seq Scan on xfiler_tx (cost=0.00..24.52 rows=114 width=8) (actual time=0.007..0.108 rows=115 loops=1)

  • Filter: ((NOT all_checked) AND (NOT is_deleted) AND (company_id = 26))
6. 0.040 0.248 ↑ 1.1 104 1

Hash (cost=25.05..25.05 rows=112 width=9) (actual time=0.248..0.248 rows=104 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
7. 0.208 0.208 ↑ 1.1 104 1

Seq Scan on xfiler_checklistitemextra (cost=0.00..25.05 rows=112 width=9) (actual time=0.011..0.208 rows=104 loops=1)

  • Filter: ((NOT is_checked) AND (due_on IS NOT NULL))