explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fDxy

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

Limit (cost=25.18..85,673.17 rows=10 width=393) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=25.18..428,265.16 rows=50 width=393) (actual rows= loops=)

  • Hash Cond: (jobs.customer_id = customers.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on jobs (cost=0.00..396,395.99 rows=8,491,599 width=393) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=24.85..24.85 rows=26 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using index_customers_on_unique_customer_id on customers (cost=0.43..24.85 rows=26 width=4) (actual rows= loops=)

  • Index Cond: (unique_customer_id = 1974700)