explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nBMA

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,701.491 ↑ 1.0 1 1

Finalize Aggregate (cost=1,325,902.57..1,325,902.59 rows=1 width=16) (actual time=1,701.491..1,701.491 rows=1 loops=1)

2. 64.802 1,716.144 ↓ 1.5 3 1

Gather (cost=1,325,902.36..1,325,902.57 rows=2 width=8) (actual time=1,700.375..1,716.144 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.003 1,651.342 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=1,324,902.36..1,324,902.37 rows=1 width=8) (actual time=1,651.342..1,651.342 rows=1 loops=3)

4. 0.001 1,651.339 ↓ 0.0 0 3 / 3

Parallel Append (cost=0.00..1,324,901.56 rows=318 width=0) (actual time=1,651.339..1,651.339 rows=0 loops=3)

  • Subplans Removed: 11
5. 1,651.338 1,651.338 ↓ 0.0 0 3 / 3

Parallel Seq Scan on logtable_2020q4 (cost=0.00..662,406.66 rows=1 width=0) (actual time=1,651.338..1,651.338 rows=0 loops=3)

  • Filter: (((eventid)::text = 'Email'::text) AND ((category)::text = 'ClientAction'::text) AND (datecreated >= (now() - '00:01:00'::interval)))
  • Rows Removed by Filter: 4,274,780
Planning time : 0.356 ms