explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p72C : Optimization for: plan #COIR

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 912.929 3,410.062 ↓ 1.0 447,047 1

Nested Loop (cost=4,418.56..1,000,399.51 rows=427,347 width=150) (actual time=26.133..3,410.062 rows=447,047 loops=1)

2. 799.187 825.077 ↑ 1.0 557,352 1

Bitmap Heap Scan on trip_form t (cost=4,418.14..314,434.01 rows=563,889 width=82) (actual time=26.055..825.077 rows=557,352 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. 25.890 25.890 ↓ 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=25.890..25.890 rows=2,988,800 loops=1)

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

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

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