explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S5Ol

Settings
# exclusive inclusive rows x rows loops node
1. 27.892 8,123.163 ↑ 909.1 11 1

Limit (cost=1,001.41..120,967.98 rows=10,000 width=2,176) (actual time=6,591.487..8,123.163 rows=11 loops=1)

  • Functions: 121
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 29.531 ms, Inlining 0.000 ms, Optimization 18.481 ms, Emission 235.085 ms, Total 283.097 ms"Execution Time: 8,127.419 ms
2. 1,560.635 8,095.271 ↑ 25,258.3 11 1

Gather Merge (cost=1,001.41..3,334,164.78 rows=277,841 width=2,176) (actual time=6,563.623..8,095.271 rows=11 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
3. 0.016 6,534.636 ↑ 39,692.0 1 8 / 8

Nested Loop Left Join (cost=1.29..3,299,129.13 rows=39,692 width=2,176) (actual time=6,534.569..6,534.636 rows=1 loops=8)

4. 0.054 6,534.604 ↑ 39,692.0 1 8 / 8

Nested Loop (cost=0.86..3,271,095.19 rows=39,692 width=1,809) (actual time=6,534.563..6,534.604 rows=1 loops=8)

5. 6,534.511 6,534.511 ↑ 19,846.0 2 8 / 8

Parallel Index Scan using annonce_pkey on annonce a (cost=0.43..3,251,218.92 rows=39,692 width=1,683) (actual time=5,776.122..6,534.511 rows=2 loops=8)

  • Filter: ((id_doublon IS NULL) AND (id_modele > 0))
  • Rows Removed by Filter: 1,139,597
6. 0.039 0.039 ↑ 1.0 1 13 / 8

Index Scan using geographie_pkey on geographie g (cost=0.42..0.50 rows=1 width=130) (actual time=0.023..0.024 rows=1 loops=13)

  • Index Cond: (id_geographie = a.id_geographie)
  • Filter: (id_pays <> 'AD'::bpchar)
  • Rows Removed by Filter: 0
7. 0.017 0.017 ↑ 1.0 1 11 / 8

Index Scan using vendeur_pkey on vendeur (cost=0.43..0.71 rows=1 width=367) (actual time=0.012..0.012 rows=1 loops=11)

  • Index Cond: (id_vendeur = a.id_vendeur)