explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nWEB : Optimization for: plan #pU4v

Settings

Optimization path:

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

Gather Merge (cost=323,336.40..323,462.40 rows=1,080 width=106) (actual rows= loops=)

  • Workers Planned: 2
  • Functions: 4
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
2. 0.000 0.000 ↓ 0.0

Sort (cost=322,336.37..322,337.72 rows=540 width=106) (actual rows= loops=)

  • Sort Key: "OpportunityIndex", "StartTime
3. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "Facts" fa_1 (cost=0.00..322,311.86 rows=540 width=106) (actual rows= loops=)

  • Filter: ((NOT "isDeleted") AND ("Owner" = 2) AND ((("StartTime" <= '2020-03-01 00:00:00'::timestamp without time zone) AND ("EndTime" > '2020-03-01 00:00:00'::timestamp without time zone)) OR (("StartTime" <= '2020-03-20 00:00:00'::timestamp without time zone) AND ("EndTime" > '2020-03-20 00:00:00'::timestamp without time zone) AND ("Status" = 4))))JIT: