explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VU3I

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=313,711.64..466,637.31 rows=493,486 width=147) (actual rows= loops=)

  • Hash Cond: (r.request_id = tf.request_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on request r (cost=0.00..108,558.75 rows=1,833,175 width=32) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=298,868.06..298,868.06 rows=493,486 width=119) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on trip_form tf (cost=3,868.51..298,868.06 rows=493,486 width=119) (actual rows= loops=)

  • Recheck Cond: (trip_form_date >= '2019-01-01 00:00:00'::timestamp without time zone)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on trip_form_date_index (cost=0.00..3,745.14 rows=493,486 width=0) (actual rows= loops=)

  • Index Cond: (trip_form_date >= '2019-01-01 00:00:00'::timestamp without time zone)