explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3W4g

Settings
# exclusive inclusive rows x rows loops node
1. 0.182 36.592 ↑ 16.4 54 1

Nested Loop (cost=11,350.01..52,014.83 rows=884 width=850) (actual time=10.807..36.592 rows=54 loops=1)

2. 0.026 0.026 ↓ 24.0 24 1

Seq Scan on entity_category ec (cost=0.00..3.14 rows=1 width=852) (actual time=0.008..0.026 rows=24 loops=1)

  • Filter: ((entitygroupid)::text = 'INC'::text)
  • Rows Removed by Filter: 68
3. 31.245 36.384 ↑ 718.0 2 24

Bitmap Heap Scan on entity d (cost=11,350.01..51,990.70 rows=1,436 width=161) (actual time=0.769..1.516 rows=2 loops=24)

  • Recheck Cond: ((entity_category)::text = (ec.nsa_code)::text)
  • Filter: (active AND (published = 1) AND (end_date >= LOCALTIMESTAMP) AND (publish_date < LOCALTIMESTAMP) AND ((hashed SubPlan 1) OR (entity_type <> 2)))
  • Rows Removed by Filter: 1299
  • Heap Blocks: exact=21723
4. 5.088 5.088 ↑ 8.1 1,331 24

Bitmap Index Scan on idx_entity_category (cost=0.00..11,345.34 rows=10,772 width=0) (actual time=0.212..0.212 rows=1,331 loops=24)

  • Index Cond: ((entity_category)::text = (ec.nsa_code)::text)
5.          

SubPlan (forBitmap Heap Scan)

6. 0.051 0.051 ↓ 47.5 95 1

Index Only Scan using organisation_extended_funcs_pkey on organisation_extended_funcs (cost=0.27..4.31 rows=2 width=4) (actual time=0.011..0.051 rows=95 loops=1)

  • Index Cond: (extended_function_id = 14)
  • Heap Fetches: 95