#	exclusive	inclusive	rows x	rows	loops	node
1.	0.052	27.021	↓ 462.0	462	1	→ Subquery Scan on journalaction (cost=646.58..646.62 rows=1 width=116) (actual time=26.686..27.021 rows=462 loops=1) Filter: (journalaction.numero_ligne = 1) Rows Removed by Filter: 15
2.	0.971	26.969	↓ 477.0	477	1	→ WindowAgg (cost=646.58..646.61 rows=1 width=124) (actual time=26.685..26.969 rows=477 loops=1)
3.	0.325	25.998	↓ 477.0	477	1	→ Sort (cost=646.58..646.59 rows=1 width=116) (actual time=25.974..25.998 rows=477 loops=1) Sort Key: pt.sm001000_pi2_programmation_travauxid, ad.sm001000_pi_d_effc_even DESC, ad.sm001000_pi_d_fin_actn Sort Method: quicksort Memory: 92kB
4.	1.862	25.673	↓ 477.0	477	1	→ Nested Loop (cost=142.93..646.57 rows=1 width=116) (actual time=0.601..25.673 rows=477 loops=1) Join Filter: (nea.sm001000_pi9_nature_evenement_affaireid = ad.sm001000_pi9_nature_evenement_affaireid) Rows Removed by Join Filter: 4592
5.	0.774	7.775	↓ 40.1	4,009	1	→ Nested Loop (cost=142.51..584.23 rows=100 width=132) (actual time=0.577..7.775 rows=4,009 loops=1)
6.	0.155	0.761	↓ 40.0	480	1	→ Merge Join (cost=142.09..152.94 rows=12 width=132) (actual time=0.558..0.761 rows=480 loops=1) Merge Cond: ((sn.statut = pt.sm001000_pi_s_prog_redd) AND (sn.type_ptrc = pt.sm001000_pi_c_typ_prog_redd))
7.	0.019	0.339	↑ 29.7	32	1	→ Sort (cost=104.66..107.03 rows=949 width=64) (actual time=0.336..0.339 rows=32 loops=1) Sort Key: sn.statut, sn.type_ptrc Sort Method: quicksort Memory: 28kB
8.	0.019	0.320	↑ 28.8	33	1	→ Hash Join (cost=5.09..57.73 rows=949 width=64) (actual time=0.308..0.320 rows=33 loops=1) Hash Cond: (sn.nature = (nea.sm001000_pi_c_natr_even_affr)::integer)
9.	0.239	0.239	↑ 61.8	33	1	→ Seq Scan on statut_nature sn (cost=0.00..30.40 rows=2,040 width=12) (actual time=0.237..0.239 rows=33 loops=1)
10.	0.026	0.062	↑ 1.0	93	1	→ Hash (cost=3.93..3.93 rows=93 width=56) (actual time=0.062..0.062 rows=93 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 17kB
11.	0.036	0.036	↑ 1.0	93	1	→ Seq Scan on sm001000_pi9_nature_evenement_affairebase nea (cost=0.00..3.93 rows=93 width=56) (actual time=0.006..0.036 rows=93 loops=1)
12.	0.175	0.267	↑ 1.0	480	1	→ Sort (cost=37.42..38.63 rows=484 width=80) (actual time=0.218..0.267 rows=480 loops=1) Sort Key: pt.sm001000_pi_s_prog_redd, pt.sm001000_pi_c_typ_prog_redd Sort Method: quicksort Memory: 89kB
13.	0.092	0.092	↑ 1.0	462	1	→ Seq Scan on progtravvers pt (cost=0.00..15.84 rows=484 width=80) (actual time=0.006..0.092 rows=462 loops=1)
14.	6.240	6.240	↑ 1.1	8	480	→ Index Scan using ix_pi2_prog_trav00000 on sm001000_pi8_etape_dossierbase ed (cost=0.42..35.85 rows=9 width=32) (actual time=0.003..0.013 rows=8 loops=480) Index Cond: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid_actv)
15.	16.036	16.036	↑ 2.0	1	4,009	→ Index Scan using "INDEX_sm001000_pi8_etape_dossierid" on sm001000_pi8_action_dossierbase ad (cost=0.42..0.60 rows=2 width=48) (actual time=0.003..0.004 rows=1 loops=4,009) Index Cond: (sm001000_pi8_etape_dossierid = ed.sm001000_pi8_etape_dossierid)

Planning time	:	1.494 ms

"Subquery Scan on journalaction  (cost=646.58..646.62 rows=1 width=116) (actual time=26.686..27.021 rows=462 loops=1)"
"  Filter: (journalaction.numero_ligne = 1)"
"  Rows Removed by Filter: 15"
"  ->  WindowAgg  (cost=646.58..646.61 rows=1 width=124) (actual time=26.685..26.969 rows=477 loops=1)"
"        ->  Sort  (cost=646.58..646.59 rows=1 width=116) (actual time=25.974..25.998 rows=477 loops=1)"
"              Sort Key: pt.sm001000_pi2_programmation_travauxid, ad.sm001000_pi_d_effc_even DESC, ad.sm001000_pi_d_fin_actn"
"              Sort Method: quicksort  Memory: 92kB"
"              ->  Nested Loop  (cost=142.93..646.57 rows=1 width=116) (actual time=0.601..25.673 rows=477 loops=1)"
"                    Join Filter: (nea.sm001000_pi9_nature_evenement_affaireid = ad.sm001000_pi9_nature_evenement_affaireid)"
"                    Rows Removed by Join Filter: 4592"
"                    ->  Nested Loop  (cost=142.51..584.23 rows=100 width=132) (actual time=0.577..7.775 rows=4009 loops=1)"
"                          ->  Merge Join  (cost=142.09..152.94 rows=12 width=132) (actual time=0.558..0.761 rows=480 loops=1)"
"                                Merge Cond: ((sn.statut = pt.sm001000_pi_s_prog_redd) AND (sn.type_ptrc = pt.sm001000_pi_c_typ_prog_redd))"
"                                ->  Sort  (cost=104.66..107.03 rows=949 width=64) (actual time=0.336..0.339 rows=32 loops=1)"
"                                      Sort Key: sn.statut, sn.type_ptrc"
"                                      Sort Method: quicksort  Memory: 28kB"
"                                      ->  Hash Join  (cost=5.09..57.73 rows=949 width=64) (actual time=0.308..0.320 rows=33 loops=1)"
"                                            Hash Cond: (sn.nature = (nea.sm001000_pi_c_natr_even_affr)::integer)"
"                                            ->  Seq Scan on statut_nature sn  (cost=0.00..30.40 rows=2040 width=12) (actual time=0.237..0.239 rows=33 loops=1)"
"                                            ->  Hash  (cost=3.93..3.93 rows=93 width=56) (actual time=0.062..0.062 rows=93 loops=1)"
"                                                  Buckets: 1024  Batches: 1  Memory Usage: 17kB"
"                                                  ->  Seq Scan on sm001000_pi9_nature_evenement_affairebase nea  (cost=0.00..3.93 rows=93 width=56) (actual time=0.006..0.036 rows=93 loops=1)"
"                                ->  Sort  (cost=37.42..38.63 rows=484 width=80) (actual time=0.218..0.267 rows=480 loops=1)"
"                                      Sort Key: pt.sm001000_pi_s_prog_redd, pt.sm001000_pi_c_typ_prog_redd"
"                                      Sort Method: quicksort  Memory: 89kB"
"                                      ->  Seq Scan on progtravvers pt  (cost=0.00..15.84 rows=484 width=80) (actual time=0.006..0.092 rows=462 loops=1)"
"                          ->  Index Scan using ix_pi2_prog_trav00000 on sm001000_pi8_etape_dossierbase ed  (cost=0.42..35.85 rows=9 width=32) (actual time=0.003..0.013 rows=8 loops=480)"
"                                Index Cond: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid_actv)"
"                    ->  Index Scan using "INDEX_sm001000_pi8_etape_dossierid" on sm001000_pi8_action_dossierbase ad  (cost=0.42..0.60 rows=2 width=48) (actual time=0.003..0.004 rows=1 loops=4009)"
"                          Index Cond: (sm001000_pi8_etape_dossierid = ed.sm001000_pi8_etape_dossierid)"
"Planning time: 1.494 ms"
"Execution time: 27.132 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.026 ms	0.1 %
Hash Join	1	0.019 ms	0.1 %
Index Scan	2	22.276 ms	82.4 %
Merge Join	1	0.155 ms	0.6 %
Nested Loop	2	2.636 ms	9.8 %
Seq Scan	3	0.367 ms	1.4 %
Sort	3	0.519 ms	1.9 %
Subquery Scan	1	0.052 ms	0.2 %
WindowAgg	1	0.971 ms	3.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
progtravvers	1	0.092 ms	0.3 %
Seq Scan	1	0.092 ms	100.0 %
sm001000_pi8_action_dossierbase	1	16.036 ms	59.3 %
Index Scan	1	16.036 ms	100.0 %
sm001000_pi8_etape_dossierbase	1	6.240 ms	23.1 %
Index Scan	1	6.240 ms	100.0 %
sm001000_pi9_nature_evenement_affairebase	1	0.036 ms	0.1 %
Seq Scan	1	0.036 ms	100.0 %
statut_nature	1	0.239 ms	0.9 %
Seq Scan	1	0.239 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uIOw

Color mode:

Visible columns:

Per node type stats

Per table stats