explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HXHd

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

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

  • Buffers: shared read=4
  • I/O Timings: read=8.351
2. 8.423 8.423 ↓ 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=8.423..8.423 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=8.351