explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SHqy

Settings
# exclusive inclusive rows x rows loops node
1. 1,154.086 5,067.539 ↓ 1.0 447,047 1

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

  • Hash Cond: (r.request_id = t.request_id)
2. 996.547 996.547 ↑ 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.032..996.547 rows=1,852,963 loops=1)

3. 270.554 2,916.906 ↑ 1.2 456,229 1

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

  • Buckets: 32768 Batches: 32 Memory Usage: 2154kB
4. 2,624.741 2,646.352 ↑ 1.0 557,305 1

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

  • Index Cond: (trip_form_date >= '2019-01-01 00:00:00'::timestamp without time zone)
Planning time : 2.443 ms
Execution time : 5,089.132 ms