explain.depesz.com

PostgreSQL's explain analyze made readable

Result: APQ5

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

Hash Join (cost=22.48..315.02 rows=14,596 width=63) (actual rows= loops=)

  • Hash Cond: (payment.customer_id = customer.customer_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on payment (cost=0.00..253.96 rows=14,596 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=14.99..14.99 rows=599 width=49) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on customer (cost=0.00..14.99 rows=599 width=49) (actual rows= loops=)