#	exclusive	inclusive	rows x	rows	loops	node
1.	26.038	220,405.675	↑ 1,267.5	462	1	→ Merge Left Join (cost=2,985.96..43,803,100,830.24 rows=585,576 width=632) (actual time=1,107.072..220,405.675 rows=462 loops=1) Merge Cond: (pt.sm001000_pi2_programmation_travauxid = tp.sm001000_pi2_programmation_travauxid)
2.	1.272	27.617	↑ 10.9	462	1	→ Merge Left Join (cost=842.44..956.32 rows=5,021 width=330) (actual time=23.007..27.617 rows=462 loops=1) Merge Cond: (pt.sm001000_pi2_programmation_travauxid = ja.sm001000_pi2_programmation_travauxid)
3.	2.109	25.720	↑ 4.5	462	1	→ Merge Left Join (cost=806.26..839.60 rows=2,092 width=322) (actual time=22.759..25.720 rows=462 loops=1) Merge Cond: (pt.sm001000_pi2_programmation_travauxid = car.sm001000_pi2_programmation_travauxid)
4.	1.054	22.912	↓ 1.2	462	1	→ Sort (cost=731.73..732.70 rows=391 width=290) (actual time=22.446..22.912 rows=462 loops=1) Sort Key: pt.sm001000_pi2_programmation_travauxid Sort Method: quicksort Memory: 238kB
5.	0.332	21.858	↓ 1.2	462	1	→ Hash Join (cost=325.15..714.89 rows=391 width=290) (actual time=6.092..21.858 rows=462 loops=1) Hash Cond: (dt.sm001000_pi1_programmeid = p.sm001000_pi1_programmeid) Join Filter: (((dt.sm001000_pi1_voletid = v.sm001000_pi1_voletid) OR (dt.sm001000_pi1_voletid IS NULL)) AND ((dt.sm001000_pi1_sous_voletid = sv.sm001000_pi1_sous_voletid) OR (dt.sm001000_pi1_sous_voletid IS NULL)))
6.	0.220	21.308	↓ 1.9	462	1	→ Hash Join (cost=307.79..690.45 rows=239 width=223) (actual time=5.866..21.308 rows=462 loops=1) Hash Cond: (o.territoryid = t.territoryid)
7.	1.400	21.079	↑ 1.0	462	1	→ Hash Join (cost=306.40..687.64 rows=484 width=221) (actual time=5.851..21.079 rows=462 loops=1) Hash Cond: (o.accountid = dt.sm001000_pi_ni_orgn_reqr)
8.	13.898	13.898	↑ 1.0	3,956	1	→ Seq Scan on accountbase o (cost=0.00..361.56 rows=3,956 width=55) (actual time=0.006..13.898 rows=3,956 loops=1)
9.	0.307	5.781	↑ 1.0	462	1	→ Hash (cost=300.35..300.35 rows=484 width=182) (actual time=5.781..5.781 rows=462 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 88kB
10.	0.337	5.474	↑ 1.0	462	1	→ Hash Join (cost=283.24..300.35 rows=484 width=182) (actual time=5.064..5.474 rows=462 loops=1) Hash Cond: (pt.sm001000_pi2_dossier_transfertid = dt.sm001000_pi2_dossier_transfertid)
11.	0.086	0.086	↑ 1.0	462	1	→ Seq Scan on progtravvers pt (cost=0.00..15.84 rows=484 width=100) (actual time=0.005..0.086 rows=462 loops=1)
12.	0.670	5.051	↓ 1.0	2,241	1	→ Hash (cost=255.33..255.33 rows=2,233 width=114) (actual time=5.051..5.051 rows=2,241 loops=1) Buckets: 4096 Batches: 1 Memory Usage: 304kB
13.	4.381	4.381	↓ 1.0	2,241	1	→ Seq Scan on sm001000_pi2_dossier_transfertbase dt (cost=0.00..255.33 rows=2,233 width=114) (actual time=0.005..4.381 rows=2,241 loops=1)
14.	0.003	0.009	↑ 1.0	17	1	→ Hash (cost=1.17..1.17 rows=17 width=34) (actual time=0.009..0.009 rows=17 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 10kB
15.	0.006	0.006	↑ 1.0	17	1	→ Seq Scan on territorybase t (cost=0.00..1.17 rows=17 width=34) (actual time=0.003..0.006 rows=17 loops=1)
16.	0.018	0.218	↓ 1.2	69	1	→ Hash (cost=16.63..16.63 rows=59 width=115) (actual time=0.218..0.218 rows=69 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 18kB
17.	0.025	0.200	↓ 1.2	69	1	→ Hash Right Join (cost=7.69..16.63 rows=59 width=115) (actual time=0.110..0.200 rows=69 loops=1) Hash Cond: (v.sm001000_pi1_programmeid = p.sm001000_pi1_programmeid)
18.	0.058	0.119	↓ 1.1	66	1	→ Hash Right Join (cost=3.88..12.64 rows=59 width=54) (actual time=0.049..0.119 rows=66 loops=1) Hash Cond: (sv.sm001000_pi1_voletid = v.sm001000_pi1_voletid)
19.	0.022	0.022	↑ 1.1	52	1	→ Seq Scan on sm001000_pi1_sous_voletbase sv (cost=0.00..8.59 rows=59 width=35) (actual time=0.003..0.022 rows=52 loops=1)
20.	0.006	0.039	↓ 1.0	40	1	→ Hash (cost=3.39..3.39 rows=39 width=35) (actual time=0.039..0.039 rows=40 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 11kB
21.	0.033	0.033	↓ 1.0	40	1	→ Seq Scan on sm001000_pi1_voletbase v (cost=0.00..3.39 rows=39 width=35) (actual time=0.004..0.033 rows=40 loops=1)
22.	0.019	0.056	↑ 1.5	24	1	→ Hash (cost=3.36..3.36 rows=36 width=77) (actual time=0.056..0.056 rows=24 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 11kB
23.	0.037	0.037	↑ 1.5	24	1	→ Seq Scan on sm001000_pi1_programmebase p (cost=0.00..3.36 rows=36 width=77) (actual time=0.009..0.037 rows=24 loops=1)
24.	0.598	0.699	↑ 2.3	458	1	→ Sort (cost=74.54..77.21 rows=1,070 width=48) (actual time=0.309..0.699 rows=458 loops=1) Sort Key: car.sm001000_pi2_programmation_travauxid Sort Method: quicksort Memory: 60kB
25.	0.101	0.101	↑ 2.3	458	1	→ Seq Scan on coutsaareal car (cost=0.00..20.70 rows=1,070 width=48) (actual time=0.012..0.101 rows=458 loops=1)
26.	0.497	0.625	↑ 1.0	462	1	→ Sort (cost=36.18..37.38 rows=480 width=24) (actual time=0.245..0.625 rows=462 loops=1) Sort Key: ja.sm001000_pi2_programmation_travauxid Sort Method: quicksort Memory: 61kB
27.	0.128	0.128	↑ 1.0	462	1	→ Seq Scan on jouractn ja (cost=0.00..14.80 rows=480 width=24) (actual time=0.009..0.128 rows=462 loops=1)
28.	310.230	314.356	↓ 1.5	33,883	1	→ Sort (cost=2,143.52..2,201.84 rows=23,326 width=48) (actual time=311.473..314.356 rows=33,883 loops=1) Sort Key: tp.sm001000_pi2_programmation_travauxid Sort Method: quicksort Memory: 3605kB
29.	4.126	4.126	↓ 1.5	34,044	1	→ Seq Scan on travprir tp (cost=0.00..451.26 rows=23,326 width=48) (actual time=0.009..4.126 rows=34,044 loops=1)
30.						SubPlan (for Merge Left Join)
31.	3.696	877.338	↑ 1.0	1	462	→ Aggregate (cost=318.08..318.09 rows=1 width=32) (actual time=1.899..1.899 rows=1 loops=462)
32.	873.642	873.642	↑ 73.0	1	462	→ Seq Scan on coutaatravprir_10 (cost=0.00..317.90 rows=73 width=32) (actual time=1.175..1.891 rows=1 loops=462) Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid) Rows Removed by Filter: 21310
33.	2.772	763.224	↑ 1.0	1	462	→ Aggregate (cost=275.99..276.00 rows=1 width=32) (actual time=1.652..1.652 rows=1 loops=462)
34.	760.452	760.452	↑ 63.0	1	462	→ Seq Scan on coutaatravprir_20 (cost=0.00..275.83 rows=63 width=32) (actual time=1.086..1.646 rows=1 loops=462) Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid) Rows Removed by Filter: 18391
35.	2.310	507.738	↑ 1.0	1	462	→ Aggregate (cost=184.77..184.78 rows=1 width=32) (actual time=1.099..1.099 rows=1 loops=462)
36.	505.428	505.428	↓ 0.0	0	462	→ Seq Scan on coutaatravprir_30 (cost=0.00..184.66 rows=42 width=32) (actual time=0.822..1.094 rows=0 loops=462) Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid) Rows Removed by Filter: 12271
37.	2.772	1,110.186	↑ 1.0	1	462	→ Aggregate (cost=402.28..402.29 rows=1 width=32) (actual time=2.403..2.403 rows=1 loops=462)
38.	1,107.414	1,107.414	↑ 92.0	1	462	→ Seq Scan on coutaatravprir_40 (cost=0.00..402.05 rows=92 width=32) (actual time=1.309..2.397 rows=1 loops=462) Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid) Rows Removed by Filter: 26971
39.	2.772	889.350	↑ 1.0	1	462	→ Aggregate (cost=322.76..322.77 rows=1 width=32) (actual time=1.925..1.925 rows=1 loops=462)
40.	886.578	886.578	↑ 74.0	1	462	→ Seq Scan on coutaatravresp_10 (cost=0.00..322.58 rows=74 width=32) (actual time=1.190..1.919 rows=1 loops=462) Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid) Rows Removed by Filter: 21638
41.	25.872	72,084.012	↑ 1.0	1	462	→ Aggregate (cost=24,433.15..24,433.16 rows=1 width=32) (actual time=156.026..156.026 rows=1 loops=462)
42.	72,058.140	72,058.140	↑ 54.5	69	462	→ Seq Scan on coutaatravprir (cost=0.00..24,423.75 rows=3,758 width=22) (actual time=18.311..155.970 rows=69 loops=462) Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid) Rows Removed by Filter: 1659107
43.	26.796	71,833.146	↑ 1.0	1	462	→ Aggregate (cost=24,433.15..24,433.16 rows=1 width=32) (actual time=155.483..155.483 rows=1 loops=462)
44.	71,806.350	71,806.350	↑ 54.5	69	462	→ Seq Scan on coutaatravprir coutaatravprir_1 (cost=0.00..24,423.75 rows=3,758 width=22) (actual time=18.177..155.425 rows=69 loops=462) Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid) Rows Removed by Filter: 1659107
45.	27.258	71,972.670	↑ 1.0	1	462	→ Aggregate (cost=24,433.15..24,433.16 rows=1 width=32) (actual time=155.785..155.785 rows=1 loops=462)
46.	71,945.412	71,945.412	↑ 54.5	69	462	→ Seq Scan on coutaatravprir coutaatravprir_2 (cost=0.00..24,423.75 rows=3,758 width=22) (actual time=18.306..155.726 rows=69 loops=462) Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid) Rows Removed by Filter: 1659107

Planning time	:	23.378 ms

"Merge Left Join  (cost=2985.96..43803100830.24 rows=585576 width=632) (actual time=1107.072..220405.675 rows=462 loops=1)"
"  Merge Cond: (pt.sm001000_pi2_programmation_travauxid = tp.sm001000_pi2_programmation_travauxid)"
"  ->  Merge Left Join  (cost=842.44..956.32 rows=5021 width=330) (actual time=23.007..27.617 rows=462 loops=1)"
"        Merge Cond: (pt.sm001000_pi2_programmation_travauxid = ja.sm001000_pi2_programmation_travauxid)"
"        ->  Merge Left Join  (cost=806.26..839.60 rows=2092 width=322) (actual time=22.759..25.720 rows=462 loops=1)"
"              Merge Cond: (pt.sm001000_pi2_programmation_travauxid = car.sm001000_pi2_programmation_travauxid)"
"              ->  Sort  (cost=731.73..732.70 rows=391 width=290) (actual time=22.446..22.912 rows=462 loops=1)"
"                    Sort Key: pt.sm001000_pi2_programmation_travauxid"
"                    Sort Method: quicksort  Memory: 238kB"
"                    ->  Hash Join  (cost=325.15..714.89 rows=391 width=290) (actual time=6.092..21.858 rows=462 loops=1)"
"                          Hash Cond: (dt.sm001000_pi1_programmeid = p.sm001000_pi1_programmeid)"
"                          Join Filter: (((dt.sm001000_pi1_voletid = v.sm001000_pi1_voletid) OR (dt.sm001000_pi1_voletid IS NULL)) AND ((dt.sm001000_pi1_sous_voletid = sv.sm001000_pi1_sous_voletid) OR (dt.sm001000_pi1_sous_voletid IS NULL)))"
"                          ->  Hash Join  (cost=307.79..690.45 rows=239 width=223) (actual time=5.866..21.308 rows=462 loops=1)"
"                                Hash Cond: (o.territoryid = t.territoryid)"
"                                ->  Hash Join  (cost=306.40..687.64 rows=484 width=221) (actual time=5.851..21.079 rows=462 loops=1)"
"                                      Hash Cond: (o.accountid = dt.sm001000_pi_ni_orgn_reqr)"
"                                      ->  Seq Scan on accountbase o  (cost=0.00..361.56 rows=3956 width=55) (actual time=0.006..13.898 rows=3956 loops=1)"
"                                      ->  Hash  (cost=300.35..300.35 rows=484 width=182) (actual time=5.781..5.781 rows=462 loops=1)"
"                                            Buckets: 1024  Batches: 1  Memory Usage: 88kB"
"                                            ->  Hash Join  (cost=283.24..300.35 rows=484 width=182) (actual time=5.064..5.474 rows=462 loops=1)"
"                                                  Hash Cond: (pt.sm001000_pi2_dossier_transfertid = dt.sm001000_pi2_dossier_transfertid)"
"                                                  ->  Seq Scan on progtravvers pt  (cost=0.00..15.84 rows=484 width=100) (actual time=0.005..0.086 rows=462 loops=1)"
"                                                  ->  Hash  (cost=255.33..255.33 rows=2233 width=114) (actual time=5.051..5.051 rows=2241 loops=1)"
"                                                        Buckets: 4096  Batches: 1  Memory Usage: 304kB"
"                                                        ->  Seq Scan on sm001000_pi2_dossier_transfertbase dt  (cost=0.00..255.33 rows=2233 width=114) (actual time=0.005..4.381 rows=2241 loops=1)"
"                                ->  Hash  (cost=1.17..1.17 rows=17 width=34) (actual time=0.009..0.009 rows=17 loops=1)"
"                                      Buckets: 1024  Batches: 1  Memory Usage: 10kB"
"                                      ->  Seq Scan on territorybase t  (cost=0.00..1.17 rows=17 width=34) (actual time=0.003..0.006 rows=17 loops=1)"
"                          ->  Hash  (cost=16.63..16.63 rows=59 width=115) (actual time=0.218..0.218 rows=69 loops=1)"
"                                Buckets: 1024  Batches: 1  Memory Usage: 18kB"
"                                ->  Hash Right Join  (cost=7.69..16.63 rows=59 width=115) (actual time=0.110..0.200 rows=69 loops=1)"
"                                      Hash Cond: (v.sm001000_pi1_programmeid = p.sm001000_pi1_programmeid)"
"                                      ->  Hash Right Join  (cost=3.88..12.64 rows=59 width=54) (actual time=0.049..0.119 rows=66 loops=1)"
"                                            Hash Cond: (sv.sm001000_pi1_voletid = v.sm001000_pi1_voletid)"
"                                            ->  Seq Scan on sm001000_pi1_sous_voletbase sv  (cost=0.00..8.59 rows=59 width=35) (actual time=0.003..0.022 rows=52 loops=1)"
"                                            ->  Hash  (cost=3.39..3.39 rows=39 width=35) (actual time=0.039..0.039 rows=40 loops=1)"
"                                                  Buckets: 1024  Batches: 1  Memory Usage: 11kB"
"                                                  ->  Seq Scan on sm001000_pi1_voletbase v  (cost=0.00..3.39 rows=39 width=35) (actual time=0.004..0.033 rows=40 loops=1)"
"                                      ->  Hash  (cost=3.36..3.36 rows=36 width=77) (actual time=0.056..0.056 rows=24 loops=1)"
"                                            Buckets: 1024  Batches: 1  Memory Usage: 11kB"
"                                            ->  Seq Scan on sm001000_pi1_programmebase p  (cost=0.00..3.36 rows=36 width=77) (actual time=0.009..0.037 rows=24 loops=1)"
"              ->  Sort  (cost=74.54..77.21 rows=1070 width=48) (actual time=0.309..0.699 rows=458 loops=1)"
"                    Sort Key: car.sm001000_pi2_programmation_travauxid"
"                    Sort Method: quicksort  Memory: 60kB"
"                    ->  Seq Scan on coutsaareal car  (cost=0.00..20.70 rows=1070 width=48) (actual time=0.012..0.101 rows=458 loops=1)"
"        ->  Sort  (cost=36.18..37.38 rows=480 width=24) (actual time=0.245..0.625 rows=462 loops=1)"
"              Sort Key: ja.sm001000_pi2_programmation_travauxid"
"              Sort Method: quicksort  Memory: 61kB"
"              ->  Seq Scan on jouractn ja  (cost=0.00..14.80 rows=480 width=24) (actual time=0.009..0.128 rows=462 loops=1)"
"  ->  Sort  (cost=2143.52..2201.84 rows=23326 width=48) (actual time=311.473..314.356 rows=33883 loops=1)"
"        Sort Key: tp.sm001000_pi2_programmation_travauxid"
"        Sort Method: quicksort  Memory: 3605kB"
"        ->  Seq Scan on travprir tp  (cost=0.00..451.26 rows=23326 width=48) (actual time=0.009..4.126 rows=34044 loops=1)"
"  SubPlan 1"
"    ->  Aggregate  (cost=318.08..318.09 rows=1 width=32) (actual time=1.899..1.899 rows=1 loops=462)"
"          ->  Seq Scan on coutaatravprir_10  (cost=0.00..317.90 rows=73 width=32) (actual time=1.175..1.891 rows=1 loops=462)"
"                Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)"
"                Rows Removed by Filter: 21310"
"  SubPlan 2"
"    ->  Aggregate  (cost=275.99..276.00 rows=1 width=32) (actual time=1.652..1.652 rows=1 loops=462)"
"          ->  Seq Scan on coutaatravprir_20  (cost=0.00..275.83 rows=63 width=32) (actual time=1.086..1.646 rows=1 loops=462)"
"                Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)"
"                Rows Removed by Filter: 18391"
"  SubPlan 3"
"    ->  Aggregate  (cost=184.77..184.78 rows=1 width=32) (actual time=1.099..1.099 rows=1 loops=462)"
"          ->  Seq Scan on coutaatravprir_30  (cost=0.00..184.66 rows=42 width=32) (actual time=0.822..1.094 rows=0 loops=462)"
"                Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)"
"                Rows Removed by Filter: 12271"
"  SubPlan 4"
"    ->  Aggregate  (cost=402.28..402.29 rows=1 width=32) (actual time=2.403..2.403 rows=1 loops=462)"
"          ->  Seq Scan on coutaatravprir_40  (cost=0.00..402.05 rows=92 width=32) (actual time=1.309..2.397 rows=1 loops=462)"
"                Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)"
"                Rows Removed by Filter: 26971"
"  SubPlan 5"
"    ->  Aggregate  (cost=322.76..322.77 rows=1 width=32) (actual time=1.925..1.925 rows=1 loops=462)"
"          ->  Seq Scan on coutaatravresp_10  (cost=0.00..322.58 rows=74 width=32) (actual time=1.190..1.919 rows=1 loops=462)"
"                Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)"
"                Rows Removed by Filter: 21638"
"  SubPlan 6"
"    ->  Aggregate  (cost=24433.15..24433.16 rows=1 width=32) (actual time=156.026..156.026 rows=1 loops=462)"
"          ->  Seq Scan on coutaatravprir  (cost=0.00..24423.75 rows=3758 width=22) (actual time=18.311..155.970 rows=69 loops=462)"
"                Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)"
"                Rows Removed by Filter: 1659107"
"  SubPlan 7"
"    ->  Aggregate  (cost=24433.15..24433.16 rows=1 width=32) (actual time=155.483..155.483 rows=1 loops=462)"
"          ->  Seq Scan on coutaatravprir coutaatravprir_1  (cost=0.00..24423.75 rows=3758 width=22) (actual time=18.177..155.425 rows=69 loops=462)"
"                Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)"
"                Rows Removed by Filter: 1659107"
"  SubPlan 8"
"    ->  Aggregate  (cost=24433.15..24433.16 rows=1 width=32) (actual time=155.785..155.785 rows=1 loops=462)"
"          ->  Seq Scan on coutaatravprir coutaatravprir_2  (cost=0.00..24423.75 rows=3758 width=22) (actual time=18.306..155.726 rows=69 loops=462)"
"                Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)"
"                Rows Removed by Filter: 1659107"
"Planning time: 23.378 ms"
"Execution time: 220406.418 ms"

Per node type stats

node type	count	sum of times	% of query
Aggregate	8	94.248 ms	0.0 %
Hash	6	1.023 ms	0.0 %
Hash Join	4	2.289 ms	0.0 %
Hash Right Join	2	0.083 ms	0.0 %
Merge Left Join	3	29.419 ms	0.0 %
Seq Scan	18	219,966.234 ms	99.8 %
Sort	4	312.379 ms	0.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
accountbase	1	13.898 ms	0.0 %
Seq Scan	1	13.898 ms	100.0 %
coutaatravprir	3	215,809.902 ms	97.9 %
Seq Scan	3	215,809.902 ms	100.0 %
coutaatravprir_10	1	873.642 ms	0.4 %
Seq Scan	1	873.642 ms	100.0 %
coutaatravprir_20	1	760.452 ms	0.3 %
Seq Scan	1	760.452 ms	100.0 %
coutaatravprir_30	1	505.428 ms	0.2 %
Seq Scan	1	505.428 ms	100.0 %
coutaatravprir_40	1	1,107.414 ms	0.5 %
Seq Scan	1	1,107.414 ms	100.0 %
coutaatravresp_10	1	886.578 ms	0.4 %
Seq Scan	1	886.578 ms	100.0 %
coutsaareal	1	0.101 ms	0.0 %
Seq Scan	1	0.101 ms	100.0 %
jouractn	1	0.128 ms	0.0 %
Seq Scan	1	0.128 ms	100.0 %
progtravvers	1	0.086 ms	0.0 %
Seq Scan	1	0.086 ms	100.0 %
sm001000_pi1_programmebase	1	0.037 ms	0.0 %
Seq Scan	1	0.037 ms	100.0 %
sm001000_pi1_sous_voletbase	1	0.022 ms	0.0 %
Seq Scan	1	0.022 ms	100.0 %
sm001000_pi1_voletbase	1	0.033 ms	0.0 %
Seq Scan	1	0.033 ms	100.0 %
sm001000_pi2_dossier_transfertbase	1	4.381 ms	0.0 %
Seq Scan	1	4.381 ms	100.0 %
territorybase	1	0.006 ms	0.0 %
Seq Scan	1	0.006 ms	100.0 %
travprir	1	4.126 ms	0.0 %
Seq Scan	1	4.126 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gc5F

Color mode:

Visible columns:

Per node type stats

Per table stats