explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RTwG

Settings
# exclusive inclusive rows x rows loops node
1. 6,551.298 6,629.528 ↑ 1.0 851,359 1

Bitmap Heap Scan on linear_exposure_14 l (cost=30,742.85..52,324.24 rows=851,359 width=52) (actual time=79.548..6,629.528 rows=851,359 loops=1)

  • Recheck Cond: ((internal_id = 14) AND (end_date >= '2020-07-09 20:00:00-04'::timestamp with time zone))
  • Heap Blocks: exact=8,811
2. 78.230 78.230 ↑ 1.0 851,359 1

Bitmap Index Scan on linear_exposure_14_pkey (cost=0.00..30,530.01 rows=851,359 width=0) (actual time=78.222..78.230 rows=851,359 loops=1)

  • Index Cond: ((internal_id = 14) AND (end_date >= '2020-07-09 20:00:00-04'::timestamp with time zone))