explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AKTV : Optimization for: test2; plan #j2cH

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.010 4.012 ↓ 0.0 0 1

Hash Right Join (cost=533.11..571.98 rows=29 width=216) (actual time=4.012..4.012 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.001 4.002 ↓ 0.0 0 1

Hash (cost=532.74..532.74 rows=29 width=209) (actual time=4.002..4.002 rows=0 loops=1)

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

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

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

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

6. 0.002 4.000 ↓ 0.0 0 1

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

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

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

  • Filter: ((date(inquirydate) >= '2018-01-01'::date) AND (date(inquirydate) <= '2018-01-15'::date))
  • 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 : 4.140 ms