explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nxHf

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 6,049.966 ↑ 1.0 1 1

Finalize Aggregate (cost=5,397,620.73..5,397,620.74 rows=1 width=8) (actual time=6,049.966..6,049.966 rows=1 loops=1)

2. 6.075 6,049.962 ↓ 1.2 5 1

Gather (cost=5,397,620.31..5,397,620.72 rows=4 width=8) (actual time=6,049.494..6,049.962 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 3.855 6,043.887 ↑ 1.0 1 5

Partial Aggregate (cost=5,396,620.31..5,396,620.32 rows=1 width=8) (actual time=6,043.887..6,043.887 rows=1 loops=5)

4. 6,040.032 6,040.032 ↑ 6.2 24,790 5

Parallel Seq Scan on contact (cost=0.00..5,396,237.44 rows=153,146 width=0) (actual time=1,214.979..6,040.032 rows=24,790 loops=5)

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