explain.depesz.com

PostgreSQL's explain analyze made readable

Result: getT

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

Nested Loop (cost=0.14..8.13 rows=1 width=17) (actual time=0.018..0.018 rows=0 loops=1)

2. 0.018 0.018 ↓ 0.0 0 1

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

  • Filter: ((client_id = 'ac'::text) AND (client_secret = 'ddqidw'::text))
  • Rows Removed by Filter: 160
3. 0.000 0.000 ↓ 0.0 0

Index Scan using api_consumers_pkey on api_consumers (cost=0.14..2.16 rows=1 width=16) (never executed)

  • Index Cond: (id = api_credentials.api_consumer_id)