# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 2.770 | 58.122 | ↓ 90.1 | 7,025 | 1 |
→
Subquery Scan on t (cost=1,966.97..2,474.36 rows=78 width=46) (actual time=33.921..58.122 rows=7,025 loops=1)
|
2. | 20.024 | 55.352 | ↑ 1.0 | 15,559 | 1 |
→
WindowAgg (cost=1,966.97..2,279.21 rows=15,612 width=62) (actual time=33.917..55.352 rows=15,559 loops=1) |
3. | 18.690 | 35.328 | ↑ 1.0 | 15,559 | 1 |
→
Sort (cost=1,966.97..2,006.00 rows=15,612 width=54) (actual time=33.893..35.328 rows=15,559 loops=1)
|
4. | 9.016 | 16.638 | ↑ 1.0 | 15,559 | 1 |
→
Hash Join (cost=317.37..879.57 rows=15,612 width=54) (actual time=4.317..16.638 rows=15,559 loops=1)
|
5. | 3.412 | 3.412 | ↑ 1.0 | 15,612 | 1 |
→
Seq Scan on t_amende_fichier af (cost=0.00..365.12 rows=15,612 width=50) (actual time=0.033..3.412 rows=15,612 loops=1) |
6. | 2.145 | 4.210 | ↑ 1.0 | 7,394 | 1 |
→
Hash (cost=224.94..224.94 rows=7,394 width=4) (actual time=4.210..4.210 rows=7,394 loops=1)
|
7. | 2.065 | 2.065 | ↑ 1.0 | 7,394 | 1 |
→
Seq Scan on t_amende_dossier ad (cost=0.00..224.94 rows=7,394 width=4) (actual time=0.014..2.065 rows=7,394 loops=1) |