explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kyMF

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 5.514 ↓ 0.0 0 1

Limit (cost=0.43..4.97 rows=1 width=4) (actual time=5.514..5.514 rows=0 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=5.442
2. 5.512 5.512 ↓ 0.0 0 1

Index Scan using index_personal_access_tokens_on_user_id on public.personal_access_tokens (cost=0.43..4.97 rows=1 width=4) (actual time=5.512..5.512 rows=0 loops=1)

  • Index Cond: (personal_access_tokens.user_id = 644)
  • Filter: ((NOT personal_access_tokens.impersonation) AND (NOT personal_access_tokens.revoked) AND (personal_access_tokens.created_at >= '2020-06-13 00:00:00'::timestamp without time zone) AND ((personal_access_tokens.expires_at >= now()) OR (personal_access_tokens.expires_at IS NULL)))
  • Rows Removed by Filter: 1
  • Buffers: shared read=4
  • I/O Timings: read=5.442