explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Br9ZW

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 20.590 ↑ 1.0 1 1

Aggregate (cost=5,426.35..5,426.36 rows=1 width=1) (actual time=20.590..20.590 rows=1 loops=1)

2. 20.588 20.588 ↓ 0.0 0 1

Seq Scan on customer_oauth_token customeroa0_ (cost=0.00..5,426.34 rows=1 width=37) (actual time=20.588..20.588 rows=0 loops=1)

  • Filter: (((expiration_date IS NULL) OR (expiration_date > '2020-06-17 13:03:36.719064+00'::timestamp with time zone)) AND (fk_customer = '1768352094'::bigint) AND ((client_id)::text = 'nox-api'::text))
  • Rows Removed by Filter: 156,495
Planning time : 0.140 ms
Execution time : 20.612 ms