explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SAUm

Settings

Optimization(s) for this plan:

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

Sort (cost=2,775.40..2,775.42 rows=10 width=128) (actual rows= loops=)

  • Sort Key: id
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on override_rules (cost=117.72..2,775.23 rows=10 width=128) (actual rows= loops=)

  • Recheck Cond: (surge_group_id = 111)
  • Filter: ((begin_at <= '15:00:00'::time without time zone) AND (end_at > '19:00:00'::time without time zone) AND ((date = '2019-07-10'::date) OR (date IS NULL)) AND (enabled OR ((NOT enabled) AND (updated_at > '2019-07-10 17:16:56+03'::timestamp with time zone))) AND (target = 0) AND ((day_of_week = 3) OR (day_of_week = '-1'::integer)))
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on override_rules_surge_group (cost=0.00..117.72 rows=706 width=0) (actual rows= loops=)

  • Index Cond: (surge_group_id = 111)