explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LHaY : explain

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 310.508 ↑ 1.0 1 1

Limit (cost=1,000.00..55,884.57 rows=1 width=87) (actual time=0.241..310.508 rows=1 loops=1)

2. 113.227 310.506 ↑ 1.0 1 1

Gather (cost=1,000.00..55,884.57 rows=1 width=87) (actual time=0.240..310.506 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 197.279 197.279 ↓ 0.0 0 3

Parallel Seq Scan on counters (cost=0.00..54,884.47 rows=1 width=87) (actual time=197.279..197.279 rows=0 loops=3)

  • Filter: ((enterprise = 25) AND (customer = 13) AND ((date)::text = '2019_03'::text) AND ((channel)::text = 'incoming'::text))
  • Rows Removed by Filter: 757643