explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bLvc

Settings
# exclusive inclusive rows x rows loops node
1. 0.116 130,326.493 ↓ 6.0 6 1

GroupAggregate (cost=4,419,017.24..4,419,017.26 rows=1 width=12) (actual time=130,272.488..130,326.493 rows=6 loops=1)

  • Group Key: vehicule.oid
  • Functions: 103
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 38.806 ms, Inlining 732.470 ms, Optimization 3534.147 ms, Emission 2006.517 ms, Total 6311.941 ms"Execution Time: 130,332.346 ms
2. 0.688 130,326.377 ↓ 581.0 581 1

Sort (cost=4,419,017.24..4,419,017.24 rows=1 width=4) (actual time=130,272.384..130,326.377 rows=581 loops=1)

  • Sort Key: vehicule.oid
  • Sort Method: quicksort Memory: 52kB
3. 85.964 130,325.689 ↓ 581.0 581 1

Gather (cost=1,000.42..4,419,017.23 rows=1 width=4) (actual time=893.282..130,325.689 rows=581 loops=1)

  • Workers Planned: 8
  • Workers Launched: 8
4. 121.485 130,239.725 ↓ 65.0 65 9 / 9

Nested Loop (cost=0.42..4,418,017.13 rows=1 width=4) (actual time=1,526.168..130,239.725 rows=65 loops=9)

5. 129,321.423 129,321.423 ↓ 527.0 113,831 9 / 9

Parallel Seq Scan on vo_all_partition_fr a (cost=0.00..4,417,512.67 rows=216 width=4) (actual time=699.621..129,321.423 rows=113,831 loops=9)

  • Filter: (dead AND (id_pays = 'FR'::bpchar) AND (date_part('year'::text, dt_dead) = '2019'::double precision) AND (date_part('year'::text, (dt_mec)::timestamp without time zone) = '2019'::double precision))
  • Rows Removed by Filter: 7,684,343
6. 796.817 796.817 ↓ 0.0 0 1,024,479 / 9

Index Scan using vehicule_pkey on vehicule (cost=0.42..2.33 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1,024,479)

  • Index Cond: (id_veh = a.id_veh)
  • Filter: (oid = ANY ('{1712472,1712102,1712473,2004958,2004957,2004959}'::integer[]))
  • Rows Removed by Filter: 1