explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LPbh

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

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

2. 6.384 5,276.136 ↓ 1.2 5 1

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

  • Workers Planned: 4
  • Workers Launched: 4
3. 3.045 5,269.752 ↑ 1.0 1 5

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

4. 5,266.707 5,266.707 ↑ 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,028.612..5,266.707 rows=24,790 loops=5)

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