#	exclusive	inclusive	rows x	rows	loops	node
1.	37.194	93.404	↑ 1.0	3,944	1	→ Sort (cost=1,356.73..1,366.59 rows=3,944 width=212) (actual time=91.832..93.404 rows=3,944 loops=1) Sort Key: precatorios.id, participantes.nome, tipo_papeis.descricao, evento_financeiros.data_evento, evento_financeiros.id, configuracao_rubrica_precatorios.ordem_apresentacao Sort Method: quicksort Memory: 2130kB
2.	18.637	56.210	↑ 1.0	3,944	1	→ Hash Join (cost=963.72..1,121.16 rows=3,944 width=212) (actual time=31.597..56.210 rows=3,944 loops=1) Hash Cond: (precatorios.processo_principal_id = processo_principais.id)
3.	5.692	36.139	↑ 1.0	3,944	1	→ Hash Right Join (cost=885.28..909.61 rows=3,944 width=195) (actual time=30.106..36.139 rows=3,944 loops=1) Hash Cond: ((configuracao_rubrica_precatorios.precatorio_id = precatorios.id) AND (configuracao_rubrica_precatorios.tipo_rubrica_id = tipo_rubricas.id))
4.	0.379	0.379	↑ 1.0	793	1	→ Seq Scan on configuracao_rubrica_precatorios (cost=0.00..15.93 rows=793 width=12) (actual time=0.010..0.379 rows=793 loops=1)
5.	5.747	30.068	↑ 1.0	3,944	1	→ Hash (cost=826.12..826.12 rows=3,944 width=191) (actual time=30.068..30.068 rows=3,944 loops=1) Buckets: 4096 Batches: 1 Memory Usage: 961kB
6.	3.308	24.321	↑ 1.0	3,944	1	→ Hash Join (cost=619.22..826.12 rows=3,944 width=191) (actual time=14.420..24.321 rows=3,944 loops=1) Hash Cond: (rubrica_eventos.tipo_rubrica_id = tipo_rubricas.id)
7.	5.315	20.978	↑ 1.0	3,944	1	→ Hash Join (cost=617.44..770.11 rows=3,944 width=168) (actual time=14.374..20.978 rows=3,944 loops=1) Hash Cond: (rubrica_eventos.evento_financeiro_id = evento_financeiros.id)
8.	1.315	1.315	↑ 1.0	3,944	1	→ Seq Scan on rubrica_eventos (cost=0.00..98.44 rows=3,944 width=32) (actual time=0.007..1.315 rows=3,944 loops=1)
9.	1.227	14.348	↑ 1.0	1,234	1	→ Hash (cost=602.01..602.01 rows=1,234 width=144) (actual time=14.348..14.348 rows=1,234 loops=1) Buckets: 2048 Batches: 1 Memory Usage: 246kB
10.	0.915	13.121	↑ 1.0	1,234	1	→ Hash Join (cost=262.73..602.01 rows=1,234 width=144) (actual time=4.927..13.121 rows=1,234 loops=1) Hash Cond: (precatorio_participantes.tipo_papel_id = tipo_papeis.id)
11.	0.964	12.198	↑ 1.0	1,234	1	→ Hash Join (cost=261.59..583.91 rows=1,234 width=136) (actual time=4.910..12.198 rows=1,234 loops=1) Hash Cond: (precatorio_participantes.participante_id = participantes.id)
12.	0.906	8.918	↑ 1.0	1,234	1	→ Hash Join (cost=131.90..437.25 rows=1,234 width=108) (actual time=2.577..8.918 rows=1,234 loops=1) Hash Cond: (precatorio_participantes.precatorio_id = precatorios.id)
13.	0.900	6.622	↑ 1.0	1,234	1	→ Hash Join (cost=46.97..335.35 rows=1,234 width=100) (actual time=1.170..6.622 rows=1,234 loops=1) Hash Cond: (evento_financeiros.tipo_evento_financeiro_id = tipo_evento_financeiros.id)
14.	2.690	5.696	↑ 1.0	1,234	1	→ Hash Join (cost=45.77..317.18 rows=1,234 width=77) (actual time=1.123..5.696 rows=1,234 loops=1) Hash Cond: (precatorio_participantes.id = evento_financeiros.precatorio_participante_id)
15.	1.919	1.919	↑ 1.0	7,524	1	→ Seq Scan on precatorio_participantes (cost=0.00..193.24 rows=7,524 width=48) (actual time=0.006..1.919 rows=7,524 loops=1)
16.	0.513	1.087	↑ 1.0	1,234	1	→ Hash (cost=30.34..30.34 rows=1,234 width=37) (actual time=1.087..1.087 rows=1,234 loops=1) Buckets: 2048 Batches: 1 Memory Usage: 113kB
17.	0.574	0.574	↑ 1.0	1,234	1	→ Seq Scan on evento_financeiros (cost=0.00..30.34 rows=1,234 width=37) (actual time=0.008..0.574 rows=1,234 loops=1)
18.	0.019	0.026	↑ 1.0	9	1	→ Hash (cost=1.09..1.09 rows=9 width=31) (actual time=0.026..0.026 rows=9 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 9kB
19.	0.007	0.007	↑ 1.0	9	1	→ Seq Scan on tipo_evento_financeiros (cost=0.00..1.09 rows=9 width=31) (actual time=0.004..0.007 rows=9 loops=1)
20.	0.605	1.390	↑ 1.0	1,908	1	→ Hash (cost=61.08..61.08 rows=1,908 width=16) (actual time=1.390..1.390 rows=1,908 loops=1) Buckets: 2048 Batches: 1 Memory Usage: 106kB
21.	0.785	0.785	↑ 1.0	1,908	1	→ Seq Scan on precatorios (cost=0.00..61.08 rows=1,908 width=16) (actual time=0.009..0.785 rows=1,908 loops=1)
22.	1.216	2.316	↑ 1.0	3,142	1	→ Hash (cost=90.42..90.42 rows=3,142 width=36) (actual time=2.316..2.316 rows=3,142 loops=1) Buckets: 4096 Batches: 1 Memory Usage: 242kB
23.	1.100	1.100	↑ 1.0	3,142	1	→ Seq Scan on participantes (cost=0.00..90.42 rows=3,142 width=36) (actual time=0.007..1.100 rows=3,142 loops=1)
24.	0.004	0.008	↑ 1.0	6	1	→ Hash (cost=1.06..1.06 rows=6 width=16) (actual time=0.008..0.008 rows=6 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 9kB
25.	0.004	0.004	↑ 1.0	6	1	→ Seq Scan on tipo_papeis (cost=0.00..1.06 rows=6 width=16) (actual time=0.003..0.004 rows=6 loops=1)
26.	0.018	0.035	↑ 1.0	35	1	→ Hash (cost=1.35..1.35 rows=35 width=31) (actual time=0.035..0.035 rows=35 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 11kB
27.	0.017	0.017	↑ 1.0	35	1	→ Seq Scan on tipo_rubricas (cost=0.00..1.35 rows=35 width=31) (actual time=0.006..0.017 rows=35 loops=1)
28.	0.712	1.434	↑ 1.0	2,064	1	→ Hash (cost=52.64..52.64 rows=2,064 width=33) (actual time=1.434..1.434 rows=2,064 loops=1) Buckets: 4096 Batches: 1 Memory Usage: 178kB
29.	0.722	0.722	↑ 1.0	2,064	1	→ Seq Scan on processo_principais (cost=0.00..52.64 rows=2,064 width=33) (actual time=0.011..0.722 rows=2,064 loops=1)

Planning time	:	6.718 ms
Execution time	:	94.165 ms

"Sort  (cost=1356.73..1366.59 rows=3944 width=212) (actual time=91.832..93.404 rows=3944 loops=1)"
"  Sort Key: precatorios.id, participantes.nome, tipo_papeis.descricao, evento_financeiros.data_evento, evento_financeiros.id, configuracao_rubrica_precatorios.ordem_apresentacao"
"  Sort Method: quicksort  Memory: 2130kB"
"  ->  Hash Join  (cost=963.72..1121.16 rows=3944 width=212) (actual time=31.597..56.210 rows=3944 loops=1)"
"        Hash Cond: (precatorios.processo_principal_id = processo_principais.id)"
"        ->  Hash Right Join  (cost=885.28..909.61 rows=3944 width=195) (actual time=30.106..36.139 rows=3944 loops=1)"
"              Hash Cond: ((configuracao_rubrica_precatorios.precatorio_id = precatorios.id) AND (configuracao_rubrica_precatorios.tipo_rubrica_id = tipo_rubricas.id))"
"              ->  Seq Scan on configuracao_rubrica_precatorios  (cost=0.00..15.93 rows=793 width=12) (actual time=0.010..0.379 rows=793 loops=1)"
"              ->  Hash  (cost=826.12..826.12 rows=3944 width=191) (actual time=30.068..30.068 rows=3944 loops=1)"
"                    Buckets: 4096  Batches: 1  Memory Usage: 961kB"
"                    ->  Hash Join  (cost=619.22..826.12 rows=3944 width=191) (actual time=14.420..24.321 rows=3944 loops=1)"
"                          Hash Cond: (rubrica_eventos.tipo_rubrica_id = tipo_rubricas.id)"
"                          ->  Hash Join  (cost=617.44..770.11 rows=3944 width=168) (actual time=14.374..20.978 rows=3944 loops=1)"
"                                Hash Cond: (rubrica_eventos.evento_financeiro_id = evento_financeiros.id)"
"                                ->  Seq Scan on rubrica_eventos  (cost=0.00..98.44 rows=3944 width=32) (actual time=0.007..1.315 rows=3944 loops=1)"
"                                ->  Hash  (cost=602.01..602.01 rows=1234 width=144) (actual time=14.348..14.348 rows=1234 loops=1)"
"                                      Buckets: 2048  Batches: 1  Memory Usage: 246kB"
"                                      ->  Hash Join  (cost=262.73..602.01 rows=1234 width=144) (actual time=4.927..13.121 rows=1234 loops=1)"
"                                            Hash Cond: (precatorio_participantes.tipo_papel_id = tipo_papeis.id)"
"                                            ->  Hash Join  (cost=261.59..583.91 rows=1234 width=136) (actual time=4.910..12.198 rows=1234 loops=1)"
"                                                  Hash Cond: (precatorio_participantes.participante_id = participantes.id)"
"                                                  ->  Hash Join  (cost=131.90..437.25 rows=1234 width=108) (actual time=2.577..8.918 rows=1234 loops=1)"
"                                                        Hash Cond: (precatorio_participantes.precatorio_id = precatorios.id)"
"                                                        ->  Hash Join  (cost=46.97..335.35 rows=1234 width=100) (actual time=1.170..6.622 rows=1234 loops=1)"
"                                                              Hash Cond: (evento_financeiros.tipo_evento_financeiro_id = tipo_evento_financeiros.id)"
"                                                              ->  Hash Join  (cost=45.77..317.18 rows=1234 width=77) (actual time=1.123..5.696 rows=1234 loops=1)"
"                                                                    Hash Cond: (precatorio_participantes.id = evento_financeiros.precatorio_participante_id)"
"                                                                    ->  Seq Scan on precatorio_participantes  (cost=0.00..193.24 rows=7524 width=48) (actual time=0.006..1.919 rows=7524 loops=1)"
"                                                                    ->  Hash  (cost=30.34..30.34 rows=1234 width=37) (actual time=1.087..1.087 rows=1234 loops=1)"
"                                                                          Buckets: 2048  Batches: 1  Memory Usage: 113kB"
"                                                                          ->  Seq Scan on evento_financeiros  (cost=0.00..30.34 rows=1234 width=37) (actual time=0.008..0.574 rows=1234 loops=1)"
"                                                              ->  Hash  (cost=1.09..1.09 rows=9 width=31) (actual time=0.026..0.026 rows=9 loops=1)"
"                                                                    Buckets: 1024  Batches: 1  Memory Usage: 9kB"
"                                                                    ->  Seq Scan on tipo_evento_financeiros  (cost=0.00..1.09 rows=9 width=31) (actual time=0.004..0.007 rows=9 loops=1)"
"                                                        ->  Hash  (cost=61.08..61.08 rows=1908 width=16) (actual time=1.390..1.390 rows=1908 loops=1)"
"                                                              Buckets: 2048  Batches: 1  Memory Usage: 106kB"
"                                                              ->  Seq Scan on precatorios  (cost=0.00..61.08 rows=1908 width=16) (actual time=0.009..0.785 rows=1908 loops=1)"
"                                                  ->  Hash  (cost=90.42..90.42 rows=3142 width=36) (actual time=2.316..2.316 rows=3142 loops=1)"
"                                                        Buckets: 4096  Batches: 1  Memory Usage: 242kB"
"                                                        ->  Seq Scan on participantes  (cost=0.00..90.42 rows=3142 width=36) (actual time=0.007..1.100 rows=3142 loops=1)"
"                                            ->  Hash  (cost=1.06..1.06 rows=6 width=16) (actual time=0.008..0.008 rows=6 loops=1)"
"                                                  Buckets: 1024  Batches: 1  Memory Usage: 9kB"
"                                                  ->  Seq Scan on tipo_papeis  (cost=0.00..1.06 rows=6 width=16) (actual time=0.003..0.004 rows=6 loops=1)"
"                          ->  Hash  (cost=1.35..1.35 rows=35 width=31) (actual time=0.035..0.035 rows=35 loops=1)"
"                                Buckets: 1024  Batches: 1  Memory Usage: 11kB"
"                                ->  Seq Scan on tipo_rubricas  (cost=0.00..1.35 rows=35 width=31) (actual time=0.006..0.017 rows=35 loops=1)"
"        ->  Hash  (cost=52.64..52.64 rows=2064 width=33) (actual time=1.434..1.434 rows=2064 loops=1)"
"              Buckets: 4096  Batches: 1  Memory Usage: 178kB"
"              ->  Seq Scan on processo_principais  (cost=0.00..52.64 rows=2064 width=33) (actual time=0.011..0.722 rows=2064 loops=1)"
"Planning time: 6.718 ms"
"Execution time: 94.165 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	9	10.061 ms	10.8 %
Hash Join	8	33.635 ms	36.0 %
Hash Right Join	1	5.692 ms	6.1 %
Seq Scan	10	6.822 ms	7.3 %
Sort	1	37.194 ms	39.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
configuracao_rubrica_precatorios	1	0.379 ms	0.4 %
Seq Scan	1	0.379 ms	100.0 %
evento_financeiros	1	0.574 ms	0.6 %
Seq Scan	1	0.574 ms	100.0 %
participantes	1	1.100 ms	1.2 %
Seq Scan	1	1.100 ms	100.0 %
precatorio_participantes	1	1.919 ms	2.1 %
Seq Scan	1	1.919 ms	100.0 %
precatorios	1	0.785 ms	0.8 %
Seq Scan	1	0.785 ms	100.0 %
processo_principais	1	0.722 ms	0.8 %
Seq Scan	1	0.722 ms	100.0 %
rubrica_eventos	1	1.315 ms	1.4 %
Seq Scan	1	1.315 ms	100.0 %
tipo_evento_financeiros	1	0.007 ms	0.0 %
Seq Scan	1	0.007 ms	100.0 %
tipo_papeis	1	0.004 ms	0.0 %
Seq Scan	1	0.004 ms	100.0 %
tipo_rubricas	1	0.017 ms	0.0 %
Seq Scan	1	0.017 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PvXc

Color mode:

Visible columns:

Per node type stats

Per table stats