explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y3OD : Optimization for: Test query; plan #m8ip

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 31.833 45.719 ↓ 2.0 152 1

Bitmap Heap Scan on busint_order_cube (cost=2,373.00..156,735.18 rows=76 width=18) (actual time=14.118..45.719 rows=152 loops=1)

  • Recheck Cond: ((entity_1 = (-1)::numeric) AND (category_1 = (-1)::numeric) AND (category_id = (-1)::numeric))
  • Filter: ((year <> (-1)::numeric) AND (deployment = (-1)::numeric) AND (entity_2 = (-1)::numeric) AND (entity_3 = (-1)::numeric) AND (category_2 = (-1)::numeric) AND (category_3 = (-1)::numeric) AND (category_4 = (-1)::numeric) AND (panel_id = (-1)::numer (...)
  • Rows Removed by Filter: 41,744
  • Heap Blocks: exact=836
2. 13.886 13.886 ↑ 1.7 41,896 1

Bitmap Index Scan on test (cost=0.00..2,372.99 rows=73,314 width=0) (actual time=13.886..13.886 rows=41,896 loops=1)

  • Index Cond: ((entity_1 = (-1)::numeric) AND (category_1 = (-1)::numeric) AND (category_id = (-1)::numeric))
Planning time : 0.658 ms
Execution time : 45.818 ms