explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CFrW : Optimization for: Optimization for: plan #XVuv; plan #aI2T

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 542.250 3,760.228 ↓ 1.0 447,047 1

Nested Loop (cost=4,418.56..986,595.51 rows=428,358 width=150) (actual time=21.544..3,760.228 rows=447,047 loops=1)

2. 967.275 988.618 ↑ 1.0 557,340 1

Bitmap Heap Scan on trip_form t (cost=4,418.14..314,434.01 rows=563,889 width=82) (actual time=21.512..988.618 rows=557,340 loops=1)

  • Recheck Cond: (trip_form_date >= '2019-01-01 00:00:00'::timestamp without time zone)
  • Rows Removed by Index Recheck: 1880877
  • Heap Blocks: lossy=298766
3. 21.343 21.343 ↓ 5.3 2,988,800 1

Bitmap Index Scan on trip_form_date_brin_index (cost=0.00..4,277.16 rows=563,889 width=0) (actual time=21.343..21.343 rows=2,988,800 loops=1)

  • Index Cond: (trip_form_date >= '2019-01-01 00:00:00'::timestamp without time zone)
4. 2,229.360 2,229.360 ↑ 1.0 1 557,340

Index Scan using idx_request_id on request r (cost=0.43..1.18 rows=1 width=72) (actual time=0.003..0.004 rows=1 loops=557,340)

  • Index Cond: (request_id = t.request_id)
Planning time : 0.285 ms
Execution time : 3,780.612 ms