explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yWQu

Settings
# exclusive inclusive rows x rows loops node
1. 234.159 10,140.788 ↑ 24,795,362,722.4 171 1

Hash Join (cost=120,842.97..134,868,024,407.21 rows=4,240,007,025,527 width=121) (actual time=5,556.560..10,140.788 rows=171 loops=1)

  • Hash Cond: (a.id_vendeur = ve.id_vendeur)
2. 0.000 8,913.232 ↑ 5,754,459.9 828,837 1

Nested Loop (cost=0.42..58,567,792.42 rows=4,769,509,313,992 width=37) (actual time=0.084..8,913.232 rows=828,837 loops=1)

3. 50.200 565.623 ↓ 1.0 837,792 1

Append (cost=0.00..85,795.68 rows=837,133 width=33) (actual time=0.015..565.623 rows=837,792 loops=1)

4. 515.423 515.423 ↓ 1.0 837,792 1

Seq Scan on vo_all_partition_ch vo (cost=0.00..81,610.01 rows=837,133 width=33) (actual time=0.014..515.423 rows=837,792 loops=1)

  • Filter: ((id_dealer IS NULL) AND (id_pays = 'CH'::bpchar))
  • Rows Removed by Filter: 18,289
5. 837.792 8,377.920 ↑ 19.0 1 837,792

Append (cost=0.42..69.67 rows=19 width=8) (actual time=0.007..0.010 rows=1 loops=837,792)

  • Subplans Removed: 6
6. 3,351.168 3,351.168 ↓ 0.0 0 837,792

Index Scan using id_ann_index_dead_partition_2018 on annonce_dead_partition_2018 a (cost=0.57..14.49 rows=3 width=8) (actual time=0.003..0.004 rows=0 loops=837,792)

  • Index Cond: (id_ann = ANY (vo.ids_ann))
  • Filter: (dt_dead >= (now() - '1 year'::interval))
  • Rows Removed by Filter: 0
7. 4,188.960 4,188.960 ↑ 10.0 1 837,792

Index Scan using annonce_dead_partition_2019_pkey on annonce_dead_partition_2019 a_1 (cost=0.57..10.90 rows=10 width=8) (actual time=0.004..0.005 rows=1 loops=837,792)

  • Index Cond: (id_ann = ANY (vo.ids_ann))
  • Filter: (dt_dead >= (now() - '1 year'::interval))
8. 2.477 993.397 ↑ 142.6 8,474 1

Hash (cost=88,036.92..88,036.92 rows=1,208,370 width=92) (actual time=993.397..993.397 rows=8,474 loops=1)

  • Buckets: 131,072 Batches: 16 Memory Usage: 1,069kB
9. 58.532 990.920 ↑ 142.6 8,474 1

Hash Join (cost=23,744.75..88,036.92 rows=1,208,370 width=92) (actual time=490.857..990.920 rows=8,474 loops=1)

  • Hash Cond: ((ve.id_dealer_pro)::text = (de.id_dealer)::text)
10. 391.722 925.783 ↓ 1.0 1,359,291 1

Hash Join (cost=23,326.79..82,428.65 rows=1,359,274 width=16) (actual time=194.201..925.783 rows=1,359,291 loops=1)

  • Hash Cond: (ve.id_geographie = ge.id_geographie)
11. 341.318 341.318 ↓ 1.0 1,359,291 1

Seq Scan on vendeur ve (cost=0.00..36,956.74 rows=1,359,274 width=20) (actual time=0.007..341.318 rows=1,359,291 loops=1)

12. 97.433 192.743 ↓ 1.0 677,792 1

Hash (cost=12,210.58..12,210.58 rows=677,537 width=4) (actual time=192.743..192.743 rows=677,792 loops=1)

  • Buckets: 524,288 Batches: 4 Memory Usage: 10,062kB
13. 95.310 95.310 ↓ 1.0 677,792 1

Index Only Scan using geographie_pkey on geographie ge (cost=0.42..12,210.58 rows=677,537 width=4) (actual time=0.351..95.310 rows=677,792 loops=1)

  • Heap Fetches: 0
14. 1.560 6.605 ↑ 1.0 4,252 1

Hash (cost=364.81..364.81 rows=4,252 width=88) (actual time=6.605..6.605 rows=4,252 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 382kB
15. 0.864 5.045 ↑ 1.0 4,252 1

Nested Loop (cost=0.00..364.81 rows=4,252 width=88) (actual time=0.025..5.045 rows=4,252 loops=1)

16. 0.015 0.015 ↑ 1.0 1 1

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

  • Filter: ((id_network)::text = 'REN'::text)
  • Rows Removed by Filter: 39
17. 4.166 4.166 ↑ 1.0 4,252 1

Seq Scan on dealer de (cost=0.00..320.79 rows=4,252 width=60) (actual time=0.014..4.166 rows=4,252 loops=1)

  • Filter: ((id_network)::text = 'REN'::text)
  • Rows Removed by Filter: 561