explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BaSe

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 46,925.268 ↑ 27.7 30 1

Nested Loop (cost=33,969.44..36,035,338.12 rows=832 width=56) (actual time=41,522.553..46,925.268 rows=30 loops=1)

2. 0.031 0.077 ↑ 1.0 1 1

Hash Join (cost=2.51..4.02 rows=1 width=50) (actual time=0.075..0.077 rows=1 loops=1)

  • Hash Cond: ((ne.id_network)::text = (de.id_network)::text)
3. 0.019 0.019 ↑ 1.0 39 1

Seq Scan on network ne (cost=0.00..1.39 rows=39 width=19) (actual time=0.010..0.019 rows=39 loops=1)

4. 0.006 0.027 ↑ 1.0 1 1

Hash (cost=2.50..2.50 rows=1 width=39) (actual time=0.026..0.027 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
5. 0.021 0.021 ↑ 1.0 1 1

Index Scan using dealer_pkey on dealer de (cost=0.28..2.50 rows=1 width=39) (actual time=0.020..0.021 rows=1 loops=1)

  • Index Cond: ((id_dealer)::text = 'PVO2-11'::text)
6. 420.975 47,338.795 ↑ 27.7 30 1

Gather (cost=33,966.93..36,035,325.79 rows=832 width=18) (actual time=41,522.475..47,338.795 rows=30 loops=1)

  • Workers Planned: 8
  • Workers Launched: 8
7. 0.014 46,917.820 ↑ 34.7 3 9 / 9

Nested Loop (cost=32,966.93..36,034,242.59 rows=104 width=18) (actual time=42,002.803..46,917.820 rows=3 loops=9)

8. 19.829 46,917.726 ↑ 34.7 3 9 / 9

Parallel Hash Join (cost=32,966.51..36,033,967.77 rows=104 width=22) (actual time=42,002.753..46,917.726 rows=3 loops=9)

  • Hash Cond: (a.id_vendeur = ve.id_vendeur)
9. 5,362.486 46,844.944 ↑ 405.0 168,960 9 / 9

Nested Loop (cost=0.44..35,821,367.22 rows=68,432,073 width=11) (actual time=32,455.915..46,844.944 rows=168,960 loops=9)

10. 351.088 11,034.455 ↑ 1.1 6,089,601 9 / 9

Parallel Append (cost=0.00..3,470,135.79 rows=6,843,209 width=34) (actual time=0.038..11,034.455 rows=6,089,601 loops=9)

11. 10,683.367 10,683.367 ↑ 1.1 6,089,601 9 / 9

Parallel Seq Scan on vo_all_partition_fr vo (cost=0.00..3,435,919.74 rows=6,843,209 width=34) (actual time=0.037..10,683.367 rows=6,089,601 loops=9)

  • Filter: ((id_dealer IS NULL) AND (id_pays = 'FR'::bpchar))
  • Rows Removed by Filter: 7,267
12. 30,448.003 30,448.003 ↓ 0.0 0 54,806,406 / 9

Index Scan using annonce_pkey on annonce a (cost=0.44..4.63 rows=10 width=8) (actual time=0.005..0.005 rows=0 loops=54,806,406)

  • Index Cond: (id_ann = ANY (vo.ids_ann))
13. 0.067 52.953 ↓ 0.0 0 9 / 9

Parallel Hash (cost=32,966.06..32,966.06 rows=1 width=19) (actual time=52.953..52.953 rows=0 loops=9)

  • Buckets: 1,024 Batches: 1 Memory Usage: 72kB
14. 52.886 52.886 ↓ 0.0 0 9 / 9

Parallel Seq Scan on vendeur ve (cost=0.00..32,966.06 rows=1 width=19) (actual time=52.835..52.886 rows=0 loops=9)

  • Filter: ((id_dealer_pro)::text = 'PVO2-11'::text)
  • Rows Removed by Filter: 167,927
15. 0.080 0.080 ↑ 1.0 1 30 / 9

Index Only Scan using geographie_id_geographie_location_idx on geographie ge (cost=0.42..2.64 rows=1 width=4) (actual time=0.024..0.024 rows=1 loops=30)

  • Index Cond: (id_geographie = ve.id_geographie)
  • Heap Fetches: 30