explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OgiT

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

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

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