explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CrBS

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

GroupAggregate (cost=146.09..146.11 rows=1 width=32) (actual time=0.036..0.036 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.019 0.035 ↓ 0.0 0 1

Sort (cost=146.09..146.09 rows=1 width=33) (actual time=0.035..0.035 rows=0 loops=1)

  • Sort Key: cc.customer_id, cc.cip_id
  • Sort Method: quicksort Memory: 25kB
3. 0.006 0.016 ↓ 0.0 0 1

Hash Join (cost=119.19..146.08 rows=1 width=33) (actual time=0.016..0.016 rows=0 loops=1)

  • Hash Cond: ((cr.cip_id = cc.cip_id) AND ((cr.requirement_name)::text = (r.name)::text))
4. 0.004 0.004 ↑ 750.0 1 1

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

5. 0.000 0.006 ↓ 0.0 0 1

Hash (cost=118.73..118.73 rows=31 width=51) (actual time=0.006..0.006 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
6. 0.001 0.006 ↓ 0.0 0 1

Nested Loop (cost=4.36..118.73 rows=31 width=51) (actual time=0.006..0.006 rows=0 loops=1)

7. 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.005..0.005 rows=0 loops=1)

  • Filter: ((status)::text = 'PENDING'::text)
  • Rows Removed by Filter: 2
8. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on requirements r (cost=4.36..33.43 rows=10 width=35) (never executed)

  • Recheck Cond: (customer_id = cc.customer_id)
9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on requirements_customer (cost=0.00..4.36 rows=10 width=0) (never executed)

  • Index Cond: (customer_id = cc.customer_id)