explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SdH

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..15.62 rows=1 width=828) (actual rows= loops=)

  • Join Filter: ((s.account_id)::text = (a.ref)::text)
2. 0.000 0.000 ↓ 0.0

Seq Scan on schedule s (cost=0.00..14.50 rows=1 width=304) (actual rows= loops=)

  • Filter: ((date_part('minute'::text, timezone((timezone)::text, now())) < '30'::double precision) AND (date_part('hour'::text, timezone((timezone)::text, now())) = '11'::double precision))
3. 0.000 0.000 ↓ 0.0

Seq Scan on account a (cost=0.00..1.05 rows=5 width=662) (actual rows= loops=)