explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OTv1 : test 123

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

Finalize Aggregate (cost=392,725.58..392,725.59 rows=1 width=8) (actual time=7,646.279..7,646.279 rows=1 loops=1)

2. 4.832 7,646.652 ↓ 1.5 3 1

Gather (cost=392,725.36..392,725.58 rows=2 width=8) (actual time=7,646.268..7,646.652 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2,764.867 7,641.820 ↑ 1.0 1 3

Partial Aggregate (cost=391,725.36..391,725.38 rows=1 width=8) (actual time=7,641.820..7,641.820 rows=1 loops=3)

4. 4,876.953 4,876.953 ↑ 1.2 6,211,523 3

Parallel Seq Scan on pet_analytics (cost=0.00..372,358.44 rows=7,746,771 width=0) (actual time=0.008..4,876.953 rows=6,211,523 loops=3)

  • Filter: (area_id = 1)
  • Rows Removed by Filter: 1783769