explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kBeB

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

Finalize Aggregate (cost=59,792.02..59,792.03 rows=1 width=8) (actual time=161.465..161.466 rows=1 loops=1)

2. 17.548 170.967 ↓ 1.5 3 1

Gather (cost=59,791.81..59,792.02 rows=2 width=8) (actual time=161.198..170.967 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 7.866 153.419 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=58,791.81..58,791.82 rows=1 width=8) (actual time=153.419..153.419 rows=1 loops=3)

4. 145.553 145.553 ↑ 1.3 63,085 3 / 3

Parallel Seq Scan on products (cost=0.00..58,594.26 rows=79,020 width=0) (actual time=0.023..145.553 rows=63,085 loops=3)

  • Filter: (status = ANY ('{published,reserved,sold}'::prod_status[]))
  • Rows Removed by Filter: 44,037