explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XVuv

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 24,651.727 28,744.140 ↓ 1.0 447,047 1

Hash Join (cost=329,192.62..505,351.29 rows=428,441 width=150) (actual time=2,438.857..28,744.140 rows=447,047 loops=1)

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

Seq Scan on request r (cost=0.00..113,711.28 rows=1,855,728 width=72) (actual time=0.010..1,655.455 rows=1,852,963 loops=1)

3. 446.131 2,436.958 ↑ 1.2 456,238 1

Hash (cost=314,434.01..314,434.01 rows=563,889 width=82) (actual time=2,436.958..2,436.958 rows=456,238 loops=1)

  • Buckets: 32,768 Batches: 32 Memory Usage: 2,154kB
4. 1,958.777 1,990.827 ↑ 1.0 557,311 1

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

  • Index Cond: (trip_form_date >= '2019-01-01 00:00:00'::timestamp without time zone)
Planning time : 0.516 ms
Execution time : 28,782.652 ms