explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 66wx : Optimization for: plan #4tY1

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 43,263.569 ↑ 1.0 1 1

Finalize Aggregate (cost=19,523,551.16..19,523,551.18 rows=1 width=8) (actual time=43,263.569..43,263.569 rows=1 loops=1)

2. 2,111.605 45,366.365 ↓ 1.5 3 1

Gather (cost=19,523,550.95..19,523,551.16 rows=2 width=8) (actual time=43,263.437..45,366.365 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.013 43,254.760 ↑ 1.0 1 3

Partial Aggregate (cost=19,522,550.95..19,522,550.96 rows=1 width=8) (actual time=43,254.760..43,254.760 rows=1 loops=3)

4. 43,254.747 43,254.747 ↓ 0.0 0 3

Parallel Seq Scan on a_mail mail0_ (cost=0.00..19,522,550.90 rows=20 width=8) (actual time=43,254.747..43,254.747 rows=0 loops=3)

  • Filter: (((from_telephone_1_)::text ~~ '%7992753'::text) AND ((from_telephone_1_)::text ~~ '%701%'::text))
  • Rows Removed by Filter: 20763492
Planning time : 1.415 ms
Execution time : 45,366.644 ms