explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KtiE

Settings
# exclusive inclusive rows x rows loops node
1. 3.546 111.121 ↓ 90.1 7,025 1

Subquery Scan on t (cost=0.57..2,129.24 rows=78 width=46) (actual time=19.746..111.121 rows=7,025 loops=1)

  • Filter: (t.rn = 1)
  • Rows Removed by Filter: 8534
2. 30.016 107.575 ↑ 1.0 15,559 1

WindowAgg (cost=0.57..1,934.09 rows=15,612 width=62) (actual time=19.742..107.575 rows=15,559 loops=1)

3. 11.803 77.559 ↑ 1.0 15,559 1

Merge Join (cost=0.57..1,660.88 rows=15,612 width=54) (actual time=19.700..77.559 rows=15,559 loops=1)

  • Merge Cond: (af.amende_id = ad.id)
4. 22.485 22.485 ↑ 1.0 15,612 1

Index Scan using t_fichier_index on t_amende_fichier af (cost=0.29..1,225.89 rows=15,612 width=50) (actual time=0.030..22.485 rows=15,612 loops=1)

5. 43.271 43.271 ↑ 1.0 7,394 1

Index Only Scan using t_amende_dossier_pkey on t_amende_dossier ad (cost=0.28..227.19 rows=7,394 width=4) (actual time=19.654..43.271 rows=7,394 loops=1)

  • Heap Fetches: 0