explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0XdF

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.038 ↓ 0.0 0 1

HashAggregate (cost=288.90..288.93 rows=3 width=32) (actual time=0.038..0.038 rows=0 loops=1)

  • Group Key: cc.customer_id, cc.cip_id
  • Filter: (sum(CASE WHEN r.active THEN 1 ELSE 0 END) = 0)
2. 0.005 0.037 ↓ 0.0 0 1

Hash Join (cost=38.72..285.58 rows=442 width=33) (actual time=0.037..0.037 rows=0 loops=1)

  • Hash Cond: ((r.name)::text = (cr.requirement_name)::text)
3. 0.020 0.020 ↑ 8,032.0 1 1

Seq Scan on requirements r (cost=0.00..212.32 rows=8,032 width=19) (actual time=0.020..0.020 rows=1 loops=1)

4. 0.001 0.012 ↓ 0.0 0 1

Hash (cost=38.59..38.59 rows=11 width=64) (actual time=0.012..0.012 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
5. 0.003 0.011 ↓ 0.0 0 1

Hash Join (cost=18.16..38.59 rows=11 width=64) (actual time=0.011..0.011 rows=0 loops=1)

  • Hash Cond: (cr.cip_id = cc.cip_id)
6. 0.003 0.003 ↑ 750.0 1 1

Seq Scan on cip_requirements cr (cost=0.00..17.50 rows=750 width=48) (actual time=0.002..0.003 rows=1 loops=1)

7. 0.000 0.005 ↓ 0.0 0 1

Hash (cost=18.12..18.12 rows=3 width=32) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
8. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on customers_cip cc (cost=0.00..18.12 rows=3 width=32) (actual time=0.004..0.005 rows=0 loops=1)

  • Filter: ((status)::text = 'PENDING'::text)
  • Rows Removed by Filter: 2