explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oSew

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

Nested Loop (cost=0.28..234.98 rows=1 width=27) (actual time=0.770..0.770 rows=0 loops=1)

2. 0.769 0.769 ↓ 0.0 0 1

Seq Scan on api_credentials (cost=0.00..232.68 rows=1 width=5) (actual time=0.769..0.769 rows=0 loops=1)

  • Filter: ((client_id = 'ac'::text) AND (client_secret = 'ddqidw'::text))
  • Rows Removed by Filter: 8181
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)