explain.depesz.com

PostgreSQL's explain analyze made readable

Result: acF5

Settings
# exclusive inclusive rows x rows loops node
1. 334,077.777 412,652.498 ↑ 1.0 557,255 1

Hash Right Join (cost=329,192.62..505,243.60 rows=563,889 width=150) (actual time=128,539.867..412,652.498 rows=557,255 loops=1)

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

Seq Scan on request r (cost=0.00..113,684.07 rows=1,853,007 width=72) (actual time=0.044..1,319.947 rows=1,852,963 loops=1)

3. 8,199.293 77,254.774 ↑ 1.0 557,255 1

Hash (cost=314,434.01..314,434.01 rows=563,889 width=82) (actual time=77,254.774..77,254.774 rows=557,255 loops=1)

  • Buckets: 32768 (originally 32768) Batches: 32768 (originally 32) Memory Usage: 13281kB
4. 69,031.321 69,055.481 ↑ 1.0 557,255 1

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

  • Index Cond: (trip_form_date >= '2019-01-01 00:00:00'::timestamp without time zone)
Planning time : 2.562 ms
Execution time : 412,739.239 ms