explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f4su

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

Finalize Aggregate (cost=1,325,950.23..1,325,950.25 rows=1 width=16) (actual time=3,365.452..3,365.452 rows=1 loops=1)

2. 62.132 3,382.832 ↓ 1.5 3 1

Gather (cost=1,325,950.01..1,325,950.22 rows=2 width=8) (actual time=3,365.200..3,382.832 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.005 3,320.700 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=1,324,950.01..1,324,950.02 rows=1 width=8) (actual time=3,320.700..3,320.700 rows=1 loops=3)

4. 3,320.695 3,320.695 ↓ 0.0 0 3 / 3

Parallel Seq Scan on log (cost=0.00..1,324,949.23 rows=313 width=0) (actual time=3,320.695..3,320.695 rows=0 loops=3)

  • Filter: (((eventid)::text = 'Email'::text) AND ((category)::text = 'ClientAction'::text) AND (""timestamp"" >= (now() - '00:01:00'::interval)))
  • Rows Removed by Filter: 8,549,560
Planning time : 0.079 ms