explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WEOZ

Settings
# 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)

  • Filter: (t.rn = 1)
  • Rows Removed by Filter: 8534
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)

  • Sort Key: af.amende_id, af.id DESC
  • Sort Method: quicksort Memory: 2487kB
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)

  • Hash Cond: (af.amende_id = ad.id)
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)

  • Buckets: 8192 Batches: 1 Memory Usage: 324kB
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)