explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aFk

Settings
# exclusive inclusive rows x rows loops node
1. 34.354 579.994 ↓ 1.0 1,119 1

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

  • Workers Planned: 2
  • Workers Launched: 2
  • Functions: 12
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 6.891 ms, Inlining 0.000 ms, Optimization 2.238 ms, Emission 28.818 ms, Total 37.947 ms
2. 0.777 545.640 ↑ 1.4 373 3 / 3

Sort (cost=322,336.37..322,337.72 rows=540 width=106) (actual time=545.614..545.640 rows=373 loops=3)

  • Sort Key: "OpportunityIndex", "StartTime
  • Sort Method: quicksort Memory: 132kB
  • Worker 0: Sort Method: quicksort Memory: 115kB
  • Worker 1: Sort Method: quicksort Memory: 124kB
3. 544.863 544.863 ↑ 1.4 373 3 / 3

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

  • 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))))
  • Rows Removed by Filter: 3,332,960
Execution time : 581.061 ms