#	exclusive	inclusive	rows x	rows	loops	node
1.	0.028	30.918	↑ 1.0	1	1	→ Aggregate (cost=13179.63..13179.64 rows=1 width=0) (actual time=30.918..30.918 rows=1 loops=1)
2.	0.092	30.890	↓ 57.3	172	1	→ Nested Loop Left Join (cost=0.00..13179.62 rows=3 width=0) (actual time=1.141..30.890 rows=172 loops=1)
3.	29.797	29.797	↓ 91.0	91	1	→ Index Scan using idx_venda_status_datahorafechamento on venda venda0_ (cost=0.00..13166.79 rows=1 width=8) (actual time=1.101..29.797 rows=91 loops=1) Index Cond: (datahorafechamento >= '2012-04-09 00:00:00'::timestamp without time zone) Filter: ((ecfid = 100001858071::bigint) AND ((coo)::integer <= 31615))
4.	1.001	1.001	↑ 1.5	2	91	→ Index Scan using idx_itemvenda_status_vendaid on itemvenda itens1_ (cost=0.00..12.79 rows=3 width=16) (actual time=0.011..0.011 rows=2 loops=91) Index Cond: ((itens1_.status = 'F'::bpchar) AND (venda0_.id = itens1_.vendaid))

"Aggregate  (cost=13179.63..13179.64 rows=1 width=0) (actual time=30.918..30.918 rows=1 loops=1)"
"  ->  Nested Loop Left Join  (cost=0.00..13179.62 rows=3 width=0) (actual time=1.141..30.890 rows=172 loops=1)"
"        ->  Index Scan using idx_venda_status_datahorafechamento on venda venda0_  (cost=0.00..13166.79 rows=1 width=8) (actual time=1.101..29.797 rows=91 loops=1)"
"              Index Cond: (datahorafechamento >= '2012-04-09 00:00:00'::timestamp without time zone)"
"              Filter: ((ecfid = 100001858071::bigint) AND ((coo)::integer <= 31615))"
"        ->  Index Scan using idx_itemvenda_status_vendaid on itemvenda itens1_  (cost=0.00..12.79 rows=3 width=16) (actual time=0.011..0.011 rows=2 loops=91)"
"              Index Cond: ((itens1_.status = 'F'::bpchar) AND (venda0_.id = itens1_.vendaid))"
"Total runtime: 31.012 ms"

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.028 ms	0.1 %
Index Scan	2	30.798 ms	99.6 %
Nested Loop Left Join	1	0.092 ms	0.3 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
itemvenda	1	1.001 ms	3.2 %
Index Scan	1	1.001 ms	100.0 %
venda	1	29.797 ms	96.4 %
Index Scan	1	29.797 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: JZP

Colorize:

Columns visibility:

Per node type stats

Per table stats