explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JikW

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize Aggregate (cost=1,476,065.04..1,476,065.05 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=1,476,064.83..1,476,065.04 rows=2 width=8) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=1,475,064.83..1,475,064.84 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on gtin gtin0_ (cost=0.00..1,419,402.88 rows=22,264,782 width=8) (actual rows= loops=)

  • Filter: ((mo_id)::text = '3c2fbf31-3468-e111-a4f6-00155d644633'::text)