explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4kv1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=8.18..8.19 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using department_pkey on department (cost=0.14..8.16 rows=1 width=528) (actual rows= loops=)

  • Index Cond: ((code)::text = 'CO'::text)
3.          

SubPlan (forAggregate)

4. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)