explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N6Du

Settings
# exclusive inclusive rows x rows loops node
1. 99,052.436 1,317,374.547 ↑ 1.1 262,193 1

Bitmap Heap Scan on retail_portfolio_fact (cost=829,943.05..6,357,716.80 rows=288,619 width=97) (actual time=1,218,833.500..1,317,374.547 rows=262,193 loops=1)

  • Recheck Cond: (supply_year = 2,022)
  • Filter: ((effective_to_ts > '4000-01-01 00:00:00'::timestamp without time zone) AND (supply_month = 11))
  • Rows Removed by Filter: 27,831,352
  • Heap Blocks: exact=1,287,720
2. 1,218,322.111 1,218,322.111 ↓ 1.3 35,952,758 1

Bitmap Index Scan on ixfk_supply_year (cost=0.00..829,870.90 rows=26,637,643 width=0) (actual time=1,218,322.111..1,218,322.111 rows=35,952,758 loops=1)

  • Index Cond: (supply_year = 2,022)