explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yC3f

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 5,431.131 ↑ 1.0 1 1

Finalize Aggregate (cost=5,397,687.01..5,397,687.02 rows=1 width=8) (actual time=5,431.131..5,431.131 rows=1 loops=1)

2. 6.752 5,431.127 ↓ 1.2 5 1

Gather (cost=5,397,686.59..5,397,687.00 rows=4 width=8) (actual time=5,430.925..5,431.127 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 3.156 5,424.375 ↑ 1.0 1 5

Partial Aggregate (cost=5,396,686.59..5,396,686.60 rows=1 width=8) (actual time=5,424.375..5,424.375 rows=1 loops=5)

4. 5,421.219 5,421.219 ↑ 6.2 24,790 5

Parallel Seq Scan on contact (cost=0.00..5,396,303.68 rows=153,163 width=0) (actual time=1,059.848..5,421.219 rows=24,790 loops=5)

  • Filter: ((((emailaicache -> 'emails'::text) -> 0) ->> 'Email Server AI'::text) = 'valid'::text)
  • Rows Removed by Filter: 24481318