explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rXLT

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 58,714.240 ↑ 1.0 1 1

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

2. 240.220 58,737.475 ↓ 1.5 3 1

Gather (cost=1,476,064.83..1,476,065.04 rows=2 width=8) (actual time=58,713.543..58,737.475 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2,441.741 58,497.255 ↑ 1.0 1 3 / 3

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

4. 56,055.514 56,055.514 ↑ 1.3 17,806,149 3 / 3

Parallel Seq Scan on gtin gtin0_ (cost=0.00..1,419,402.88 rows=22,264,782 width=8) (actual time=3.559..56,055.514 rows=17,806,149 loops=3)

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