explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LSl4

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

Nested Loop (cost=0.99..17.17 rows=1 width=185) (actual time=0.173..0.174 rows=0 loops=1)

  • Buffers: shared hit=3 read=3
2. 0.004 0.173 ↓ 0.0 0 1

Nested Loop (cost=0.71..16.74 rows=1 width=154) (actual time=0.173..0.173 rows=0 loops=1)

  • Buffers: shared hit=3 read=3
3. 0.046 0.046 ↑ 1.0 1 1

Index Scan using token_token on token t (cost=0.42..8.44 rows=1 width=88) (actual time=0.045..0.046 rows=1 loops=1)

  • Index Cond: ((token)::text = 'f2435caa-04df-44e5-ae61-02fc6aca4ff4'::text)
  • Buffers: shared hit=1 read=3
4. 0.123 0.123 ↓ 0.0 0 1

Index Scan using auth_code_code_key on auth_code ac (cost=0.29..8.30 rows=1 width=102) (actual time=0.123..0.123 rows=0 loops=1)

  • Index Cond: ((code)::text = (t.auth_code)::text)
  • Buffers: shared hit=2
5. 0.000 0.000 ↓ 0.0 0

Index Scan using access_consents_resource_consent_id_key on access_consents_resource aacr (cost=0.29..0.43 rows=1 width=61) (never executed)

  • Index Cond: ((consent_id)::text = (ac.consent_id)::text)
  • Filter: ((status)::text = 'Authorized'::text)
Planning time : 0.617 ms
Execution time : 0.215 ms