explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ejD4

Settings

Optimization(s) for this plan:

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

Hash Join (cost=16.09..30.70 rows=21 width=248) (actual rows= loops=)

  • Hash Cond: (i.id = pp.interest_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on interest i (cost=0.00..13.20 rows=320 width=256) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=15.83..15.83 rows=21 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=5.32..15.83 rows=21 width=4) (actual rows= loops=)

  • Hash Cond: (pp.id = pb.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on purchase_plan pp (cost=0.00..10.40 rows=40 width=12) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=4.92..4.92 rows=32 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on plan_bundle pb (cost=0.00..4.92 rows=32 width=8) (actual rows= loops=)

  • Filter: (('2020-02-01'::date >= start_date) AND ('2020-02-01'::date <= end_date))