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

Subquery Scan on t  (cost=1966.97..2474.36 rows=78 width=46) (actual time=33.921..58.122 rows=7025 loops=1)
  Filter: (t.rn = 1)
  Rows Removed by Filter: 8534
  ->  WindowAgg  (cost=1966.97..2279.21 rows=15612 width=62) (actual time=33.917..55.352 rows=15559 loops=1)
        ->  Sort  (cost=1966.97..2006.00 rows=15612 width=54) (actual time=33.893..35.328 rows=15559 loops=1)
              Sort Key: af.amende_id, af.id DESC
              Sort Method: quicksort  Memory: 2487kB
              ->  Hash Join  (cost=317.37..879.57 rows=15612 width=54) (actual time=4.317..16.638 rows=15559 loops=1)
                    Hash Cond: (af.amende_id = ad.id)
                    ->  Seq Scan on t_amende_fichier af  (cost=0.00..365.12 rows=15612 width=50) (actual time=0.033..3.412 rows=15612 loops=1)
                    ->  Hash  (cost=224.94..224.94 rows=7394 width=4) (actual time=4.210..4.210 rows=7394 loops=1)
                          Buckets: 8192  Batches: 1  Memory Usage: 324kB
                          ->  Seq Scan on t_amende_dossier ad  (cost=0.00..224.94 rows=7394 width=4) (actual time=0.014..2.065 rows=7394 loops=1)
Planning time: 0.930 ms
Execution time: 59.565 ms

Per node type stats

node type	count	sum of times	% of query
Hash	1	2.145 ms	3.7 %
Hash Join	1	9.016 ms	15.5 %
Seq Scan	2	5.477 ms	9.4 %
Sort	1	18.690 ms	32.2 %
Subquery Scan	1	2.770 ms	4.8 %
WindowAgg	1	20.024 ms	34.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
t_amende_dossier	1	2.065 ms	3.6 %
Seq Scan	1	2.065 ms	100.0 %
t_amende_fichier	1	3.412 ms	5.9 %
Seq Scan	1	3.412 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WEOZ

Color mode:

Visible columns:

Per node type stats

Per table stats