explain.depesz.com

PostgreSQL's explain analyze made readable

Result: COIR

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,412.587 4,276.374 ↓ 1.0 447,047 1

Hash Join (cost=329,192.62..507,626.19 rows=427,347 width=150) (actual time=1,643.840..4,276.374 rows=447,047 loops=1)

  • Hash Cond: (r.request_id = t.request_id)
2. 1,249.037 1,249.037 ↓ 1.0 1,852,963 1

Seq Scan on request r (cost=0.00..116,124.89 rows=1,850,989 width=72) (actual time=0.010..1,249.037 rows=1,852,963 loops=1)

3. 291.588 1,614.750 ↑ 1.2 456,274 1

Hash (cost=314,434.01..314,434.01 rows=563,889 width=82) (actual time=1,614.750..1,614.750 rows=456,274 loops=1)

  • Buckets: 32768 Batches: 32 Memory Usage: 2154kB
4. 1,295.755 1,323.162 ↑ 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=27.575..1,323.162 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
5. 27.407 27.407 ↓ 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=27.407..27.407 rows=2,988,800 loops=1)

  • Index Cond: (trip_form_date >= '2019-01-01 00:00:00'::timestamp without time zone)
Planning time : 0.483 ms
Execution time : 4,301.067 ms