explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GLE : DEF RATE

Settings
# exclusive inclusive rows x rows loops node
1. 57.945 1,435.886 ↑ 463.1 78,124 1

Gather Motion 20:1 (slice1; segments: 20) (cost=0.00..2,998.51 rows=36,178,368 width=17) (actual time=1.865..1,435.886 rows=78,124 loops=1)

  • (slice0) Executor memory: 119K bytes.
  • (slice1) Executor memory: 105K bytes avg x 20 workers, 105K bytes max (seg0).Memory used: 98304kBOptimizer: Pivotal Optimizer (GPORCA) version 3.88.0
2. 1,377.941 1,377.941 ↑ 439.9 4,112 1

Seq Scan on container (cost=0.00..1,504.59 rows=1,808,919 width=17) (actual time=0.219..1,377.941 rows=4,112 loops=1)

  • Filter: (date_part('year'::text, im_formation_date) = 2020::double precision)
Planning time : 3.108 ms
Execution time : 1,453.067 ms