explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BstU

Settings

Optimization(s) for this plan:

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

Sort (cost=99.02..99.37 rows=141 width=306) (actual rows= loops=)

  • Sort Key: priority
2. 0.000 0.000 ↓ 0.0

Seq Scan on global_offers offer (cost=0.00..93.99 rows=141 width=306) (actual rows= loops=)

  • Filter: (active AND (now() <= ends_at) AND (now() >= date_trunc('hour'::text, starts_at)))