explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tOL4

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

Finalize Aggregate (cost=53,342.92..53,342.93 rows=1 width=8) (actual time=39,293.440..39,293.440 rows=1 loops=1)

2. 281.263 39,351.538 ↓ 1.5 3 1

Gather (cost=53,342.71..53,342.92 rows=2 width=8) (actual time=39,290.695..39,351.538 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 96.447 39,070.275 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=52,342.71..52,342.72 rows=1 width=8) (actual time=39,070.275..39,070.275 rows=1 loops=3)

4. 38,973.828 38,973.828 ↑ 1.3 672,847 3 / 3

Parallel Seq Scan on chat_business_rule (cost=0.00..50,239.97 rows=841,097 width=8) (actual time=6.939..38,973.828 rows=672,847 loops=3)