explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4tY1

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 55,592.790 ↑ 1.0 1 1

Finalize Aggregate (cost=19,514,543.64..19,514,543.65 rows=1 width=8) (actual time=55,592.790..55,592.790 rows=1 loops=1)

2. 2,460.283 58,043.799 ↓ 1.5 3 1

Gather (cost=19,514,543.43..19,514,543.64 rows=2 width=8) (actual time=55,592.517..58,043.799 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.021 55,583.516 ↑ 1.0 1 3

Partial Aggregate (cost=19,513,543.43..19,513,543.44 rows=1 width=8) (actual time=55,583.516..55,583.516 rows=1 loops=3)

4. 55,583.495 55,583.495 ↓ 0.0 0 3

Parallel Seq Scan on a_mail mail0_ (cost=0.00..19,513,543.38 rows=20 width=8) (actual time=55,583.495..55,583.495 rows=0 loops=3)

  • Filter: (((from_telephone_1_)::text ~~ '%701%'::text) AND ((from_telephone_1_)::text ~~ '%7992753'::text))
  • Rows Removed by Filter: 20761226
Planning time : 6.364 ms
Execution time : 58,043.884 ms