explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JVVB

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.064 ↑ 1.0 1 1

Aggregate (cost=8.30..8.31 rows=1 width=8) (actual time=0.064..0.064 rows=1 loops=1)

2. 0.060 0.060 ↓ 0.0 0 1

Index Scan using delegation_to_user on delegation delegation0_ (cost=0.28..8.30 rows=1 width=8) (actual time=0.060..0.060 rows=0 loops=1)

  • Index Cond: (to_user = '8664'::bigint)
  • Filter: ((state)::text = 'WAITING'::text)