explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VuL2 : Optimization for: plan #IIS4

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.707 ↓ 5.0 10 1

Hash Join (cost=36.67..62.06 rows=2 width=64) (actual time=0.439..0.707 rows=10 loops=1)

  • Hash Cond: ((e.department)::text = (d.department)::text)
2.          

Initplan (for Hash Join)

3. 0.011 0.321 ↑ 1.0 1 1

Aggregate (cost=24.52..24.53 rows=1 width=4) (actual time=0.320..0.321 rows=1 loops=1)

4. 0.310 0.310 ↑ 1.0 8 1

Seq Scan on employees e2 (cost=0.00..24.50 rows=8 width=4) (actual time=0.065..0.310 rows=8 loops=1)

  • Filter: ((department)::text = 'Maintenance'::text)
  • Rows Removed by Filter: 992
5. 0.589 0.589 ↑ 2.2 154 1

Seq Scan on employees e (cost=0.00..24.50 rows=333 width=64) (actual time=0.347..0.589 rows=154 loops=1)

  • Filter: (hire_date > $0)
  • Rows Removed by Filter: 846
6. 0.005 0.022 ↓ 2.0 2 1

Hash (cost=12.12..12.12 rows=1 width=218) (actual time=0.022..0.022 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.017 0.017 ↓ 2.0 2 1

Seq Scan on departments d (cost=0.00..12.12 rows=1 width=218) (actual time=0.014..0.017 rows=2 loops=1)

  • Filter: ((division)::text = 'Kids'::text)
  • Rows Removed by Filter: 22
Planning time : 0.401 ms
Execution time : 0.762 ms