explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sBuH

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

Nested Loop (cost=0.56..4.60 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)

2. 0.010 0.010 ↓ 0.0 0 1

Index Scan using cred_lookup on api_credentials (cost=0.28..2.30 rows=1 width=5) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((client_id = 'ac'::text) AND (client_secret = 'ddqidw'::text))
3. 0.000 0.000 ↓ 0.0 0

Index Scan using api_consumers_pkey on api_consumers (cost=0.28..2.30 rows=1 width=26) (never executed)

  • Index Cond: (id = api_credentials.api_consumer_id)