explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gjn

Settings
# exclusive inclusive rows x rows loops node
1. 1,388.000 7,721.344 ↓ 0.0 0 1

Nested Loop (cost=1,321.76..2,446,059,760.24 rows=814,985,731 width=122) (actual time=7,721.344..7,721.344 rows=0 loops=1)

  • Join Filter: (vo.ids_ann @> ARRAY[a.id_ann])
2. 605.467 6,333.344 ↓ 1.0 12,087,430 1

Append (cost=0.00..1,019,703.08 rows=12,087,293 width=34) (actual time=0.013..6,333.344 rows=12,087,430 loops=1)

3. 5,727.877 5,727.877 ↓ 1.0 12,087,430 1

Seq Scan on vo_all_partition_es vo (cost=0.00..959,266.61 rows=12,087,293 width=34) (actual time=0.012..5,727.877 rows=12,087,430 loops=1)

  • Filter: ((id_dealer IS NULL) AND (id_pays = 'ES'::bpchar))
  • Rows Removed by Filter: 122,779
4. 0.000 0.000 ↓ 0.0 0 12,087,430

Materialize (cost=1,321.76..82,899.30 rows=13,485 width=92) (actual time=0.000..0.000 rows=0 loops=12,087,430)

5. 0.001 105.254 ↓ 0.0 0 1

Nested Loop (cost=1,321.76..82,831.87 rows=13,485 width=92) (actual time=105.254..105.254 rows=0 loops=1)

6. 0.000 105.253 ↓ 0.0 0 1

Nested Loop (cost=1,321.34..30,861.37 rows=157 width=92) (actual time=105.253..105.253 rows=0 loops=1)

7. 0.018 0.018 ↑ 1.0 1 1

Seq Scan on network ne (cost=0.00..1.50 rows=1 width=64) (actual time=0.014..0.018 rows=1 loops=1)

  • Filter: ((id_network)::text = 'OPEL'::text)
  • Rows Removed by Filter: 39
8. 8.843 105.334 ↓ 0.0 0 1

Gather (cost=1,321.34..30,858.30 rows=157 width=64) (actual time=105.234..105.334 rows=0 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
9. 0.001 96.491 ↓ 0.0 0 4 / 4

Nested Loop (cost=321.34..29,842.60 rows=51 width=64) (actual time=96.491..96.491 rows=0 loops=4)

10. 41.639 96.490 ↓ 0.0 0 4 / 4

Hash Join (cost=320.91..29,220.68 rows=917 width=68) (actual time=96.490..96.490 rows=0 loops=4)

  • Hash Cond: ((ve.id_dealer_pro)::text = (de.id_dealer)::text)
11. 50.360 50.360 ↑ 1.3 339,823 4 / 4

Parallel Seq Scan on vendeur ve (cost=0.00..27,748.75 rows=438,475 width=20) (actual time=0.030..50.360 rows=339,823 loops=4)

12. 0.011 4.491 ↑ 1.0 10 4 / 4

Hash (cost=320.79..320.79 rows=10 width=60) (actual time=4.490..4.491 rows=10 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
13. 4.480 4.480 ↑ 1.0 10 4 / 4

Seq Scan on dealer de (cost=0.00..320.79 rows=10 width=60) (actual time=0.296..4.480 rows=10 loops=4)

  • Filter: ((id_network)::text = 'OPEL'::text)
  • Rows Removed by Filter: 4,803
14. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using geographie_pkey on geographie ge (cost=0.42..0.68 rows=1 width=4) (never executed)

  • Index Cond: (id_geographie = ve.id_geographie)
  • Filter: (id_pays = 'ES'::bpchar)
15. 0.000 0.000 ↓ 0.0 0

Append (cost=0.42..317.52 rows=1,350 width=8) (never executed)

  • Subplans Removed: 6
16. 0.000 0.000 ↓ 0.0 0

Index Scan using index_dead_id_vendeur_partition_2018 on annonce_dead_partition_2018 a (cost=0.57..157.12 rows=365 width=8) (never executed)

  • Index Cond: (id_vendeur = ve.id_vendeur)
  • Filter: (dt_dead >= (now() - '1 year'::interval))
17. 0.000 0.000 ↓ 0.0 0

Index Scan using annonce_dead_partition_2019_id_vendeur_idx on annonce_dead_partition_2019 a_1 (cost=0.57..145.10 rows=979 width=8) (never executed)

  • Index Cond: (id_vendeur = ve.id_vendeur)
  • Filter: (dt_dead >= (now() - '1 year'::interval))