#	exclusive	inclusive	rows x	rows	loops	node
1.	0.057	24.893	↓ 462.0	462	1	→ Subquery Scan on journalaction (cost=646.58..646.62 rows=1 width=116) (actual time=24.559..24.893 rows=462 loops=1) Filter: (journalaction.numero_ligne = 1) Rows Removed by Filter: 15
2.	0.259	24.836	↓ 477.0	477	1	→ WindowAgg (cost=646.58..646.61 rows=1 width=124) (actual time=24.558..24.836 rows=477 loops=1)
3.	0.310	24.577	↓ 477.0	477	1	→ Sort (cost=646.58..646.59 rows=1 width=116) (actual time=24.551..24.577 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.	4.793	24.267	↓ 477.0	477	1	→ Nested Loop (cost=142.93..646.57 rows=1 width=116) (actual time=0.959..24.267 rows=477 loops=1) Join Filter: (nea.sm001000_pi9_nature_evenement_affaireid = ad.sm001000_pi9_nature_evenement_affaireid) Rows Removed by Join Filter: 4,592
5.	0.578	7.447	↓ 40.1	4,009	1	→ Nested Loop (cost=142.51..584.23 rows=100 width=132) (actual time=0.930..7.447 rows=4,009 loops=1)
6.	0.152	1.109	↓ 40.0	480	1	→ Merge Join (cost=142.09..152.94 rows=12 width=132) (actual time=0.911..1.109 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.018	0.673	↑ 29.7	32	1	→ Sort (cost=104.66..107.03 rows=949 width=64) (actual time=0.670..0.673 rows=32 loops=1) Sort Key: sn.statut, sn.type_ptrc Sort Method: quicksort Memory: 28kB
8.	0.019	0.655	↑ 28.8	33	1	→ Hash Join (cost=5.09..57.73 rows=949 width=64) (actual time=0.644..0.655 rows=33 loops=1) Hash Cond: (sn.nature = (nea.sm001000_pi_c_natr_even_affr)::integer)
9.	0.582	0.582	↑ 61.8	33	1	→ Seq Scan on statut_nature sn (cost=0.00..30.40 rows=2,040 width=12) (actual time=0.580..0.582 rows=33 loops=1)
10.	0.025	0.054	↑ 1.0	93	1	→ Hash (cost=3.93..3.93 rows=93 width=56) (actual time=0.054..0.054 rows=93 loops=1) Buckets: 1,024 Batches: 1 Memory Usage: 17kB
11.	0.029	0.029	↑ 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.029 rows=93 loops=1)
12.	0.175	0.284	↑ 1.0	480	1	→ Sort (cost=37.42..38.63 rows=484 width=80) (actual time=0.236..0.284 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.109	0.109	↑ 1.0	462	1	→ Seq Scan on progtravvers pt (cost=0.00..15.84 rows=484 width=80) (actual time=0.005..0.109 rows=462 loops=1)
14.	5.760	5.760	↑ 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.012 rows=8 loops=480) Index Cond: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid_actv)
15.	12.027	12.027	↑ 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.003 rows=1 loops=4,009) Index Cond: (sm001000_pi8_etape_dossierid = ed.sm001000_pi8_etape_dossierid)

"Subquery Scan on journalaction  (cost=646.58..646.62 rows=1 width=116) (actual time=24.559..24.893 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=24.558..24.836 rows=477 loops=1)"
"        ->  Sort  (cost=646.58..646.59 rows=1 width=116) (actual time=24.551..24.577 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.959..24.267 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.930..7.447 rows=4009 loops=1)"
"                          ->  Merge Join  (cost=142.09..152.94 rows=12 width=132) (actual time=0.911..1.109 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.670..0.673 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.644..0.655 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.580..0.582 rows=33 loops=1)"
"                                            ->  Hash  (cost=3.93..3.93 rows=93 width=56) (actual time=0.054..0.054 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.029 rows=93 loops=1)"
"                                ->  Sort  (cost=37.42..38.63 rows=484 width=80) (actual time=0.236..0.284 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.005..0.109 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.012 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.003 rows=1 loops=4009)"
"                          Index Cond: (sm001000_pi8_etape_dossierid = ed.sm001000_pi8_etape_dossierid)"
"Planning time: 2.415 ms"
"Execution time: 25.011 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.025 ms	0.1 %
Hash Join	1	0.019 ms	0.1 %
Index Scan	2	17.787 ms	71.5 %
Merge Join	1	0.152 ms	0.6 %
Nested Loop	2	5.371 ms	21.6 %
Seq Scan	3	0.720 ms	2.9 %
Sort	3	0.503 ms	2.0 %
Subquery Scan	1	0.057 ms	0.2 %
WindowAgg	1	0.259 ms	1.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
progtravvers	1	0.109 ms	0.4 %
Seq Scan	1	0.109 ms	100.0 %
sm001000_pi8_action_dossierbase	1	12.027 ms	48.3 %
Index Scan	1	12.027 ms	100.0 %
sm001000_pi8_etape_dossierbase	1	5.760 ms	23.1 %
Index Scan	1	5.760 ms	100.0 %
sm001000_pi9_nature_evenement_affairebase	1	0.029 ms	0.1 %
Seq Scan	1	0.029 ms	100.0 %
statut_nature	1	0.582 ms	2.3 %
Seq Scan	1	0.582 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7MlF

Color mode:

Visible columns:

Per node type stats

Per table stats