explain.depesz.com

PostgreSQL's explain analyze made readable

Result: awer

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

Finalize Aggregate (cost=1,353,184.61..1,353,184.62 rows=1 width=8) (actual time=83,697.849..83,697.849 rows=1 loops=1)

2. 4.653 83,699.274 ↓ 1.5 3 1

Gather (cost=1,353,184.39..1,353,184.60 rows=2 width=8) (actual time=83,697.766..83,699.274 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 304.284 83,694.621 ↑ 1.0 1 3

Partial Aggregate (cost=1,352,184.39..1,352,184.40 rows=1 width=8) (actual time=83,694.621..83,694.621 rows=1 loops=3)

4. 83,390.337 83,390.337 ↑ 1.2 914,098 3

Parallel Seq Scan on bo_instance businessob0_ (cost=0.00..1,349,330.70 rows=1,141,478 width=8) (actual time=33,085.746..83,390.337 rows=914,098 loops=3)

  • Filter: ((NOT is_deleted) AND (NOT is_deleted) AND (bo_class_id = 34))
  • Rows Removed by Filter: 39253
Planning time : 0.493 ms
Execution time : 83,699.351 ms