explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j2cH : test2

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.013 5.786 ↓ 0.0 0 1

Hash Right Join (cost=535.61..574.48 rows=29 width=216) (actual time=5.786..5.786 rows=0 loops=1)

  • Hash Cond: (f.folderid = r.categoryid)
2. 0.000 0.000 ↓ 0.0 0

Seq Scan on folders f (cost=0.00..33.96 rows=1,296 width=15) (never executed)

3. 0.000 5.773 ↓ 0.0 0 1

Hash (cost=535.25..535.25 rows=29 width=209) (actual time=5.773..5.773 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
4. 0.001 5.773 ↓ 0.0 0 1

Merge Join (cost=388.62..535.25 rows=29 width=209) (actual time=5.773..5.773 rows=0 loops=1)

  • Merge Cond: (i.uniqueid = s.id)
5. 0.003 5.772 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..609.61 rows=29 width=173) (actual time=5.772..5.772 rows=0 loops=1)

6. 0.001 5.769 ↓ 0.0 0 1

Nested Loop (cost=0.00..397.51 rows=29 width=147) (actual time=5.769..5.769 rows=0 loops=1)

  • Join Filter: (i.interfaceid = "int".id)
7. 5.768 5.768 ↓ 0.0 0 1

Index Scan using i_inquiries_uniqueid on inquiries i (cost=0.00..369.61 rows=29 width=130) (actual time=5.768..5.768 rows=0 loops=1)

  • Filter: (date(inquirydate) = (('now'::cstring)::date - 1))
  • Rows Removed by Filter: 5,796
8. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..10.60 rows=40 width=25) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Seq Scan on userinterfaces "int" (cost=0.00..10.40 rows=40 width=25) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_responses on responses r (cost=0.00..7.30 rows=1 width=34) (never executed)

  • Index Cond: (i.responseid = id)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using pk__sessions__52e34c9d on sessions s (cost=0.00..414.15 rows=6,277 width=40) (never executed)

Total runtime : 5.978 ms