explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W7H6

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

Hash Join (cost=30.27..99.64 rows=3,412 width=667) (actual rows= loops=)

  • Hash Cond: (reservation.user_id = business_trip.btc_user_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on reservation (cost=0.00..15.56 rows=156 width=474) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=21.23..21.23 rows=723 width=193) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on business_trip (cost=0.00..21.23 rows=723 width=193) (actual rows= loops=)