explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aI2T : Optimization for: plan #XVuv

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 435.016 5,284.097 ↓ 1.0 447,047 1

Merge Join (cost=422,270.41..873,840.93 rows=428,358 width=150) (actual time=4,083.884..5,284.097 rows=447,047 loops=1)

  • Merge Cond: (t.request_id = r.request_id)
2. 711.667 2,090.697 ↑ 1.2 455,750 1

Sort (cost=422,269.65..423,679.38 rows=563,889 width=82) (actual time=1,896.386..2,090.697 rows=455,750 loops=1)

  • Sort Key: t.request_id
  • Sort Method: external merge Disk: 61,592kB
3. 1,358.083 1,379.030 ↑ 1.0 557,339 1

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

  • Recheck Cond: (trip_form_date >= '2019-01-01 00:00:00'::timestamp without time zone)
  • Rows Removed by Index Recheck: 1,880,877
  • Heap Blocks: lossy=298,766
4. 20.947 20.947 ↓ 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=20.947..20.947 rows=2,988,800 loops=1)

  • Index Cond: (trip_form_date >= '2019-01-01 00:00:00'::timestamp without time zone)
5. 2,758.384 2,758.384 ↑ 1.0 1,852,963 1

Index Scan using idx_request_id on request r (cost=0.43..439,976.77 rows=1,855,367 width=72) (actual time=0.036..2,758.384 rows=1,852,963 loops=1)

Planning time : 0.391 ms
Execution time : 5,318.400 ms