explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z4Zv : MINE - 5

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 0.730 ↑ 1.0 1 1

Aggregate (cost=341.57..341.58 rows=1 width=0) (actual time=0.730..0.730 rows=1 loops=1)

2. 0.066 0.708 ↓ 1.1 100 1

Hash Join (cost=52.40..341.34 rows=91 width=0) (actual time=0.589..0.708 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)))
3. 0.050 0.274 ↑ 1.0 48 1

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

  • Hash Cond: (xfiler_checklist.tx_id = xfiler_tx.id)
4. 0.056 0.056 ↓ 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.006..0.056 rows=54 loops=1)

5. 0.050 0.168 ↓ 1.0 115 1

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

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

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

  • Filter: ((NOT all_checked) AND (NOT is_deleted) AND (company_id = 26))
7. 0.041 0.368 ↑ 1.1 104 1

Hash (cost=25.05..25.05 rows=112 width=5) (actual time=0.368..0.368 rows=104 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
8. 0.327 0.327 ↑ 1.1 104 1

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

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