explain.depesz.com

A tool for finding a real cause for slow queries.

Result: uXK

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.242 3,248.697 ↑ 1.0 1 1

Aggregate (cost=29,497.30..29,497.31 rows=1 width=0) (actual time=3,248.697..3,248.697 rows=1 loops=1)

2. 0.785 3,248.455 ↓ 57.3 172 1

Nested Loop Left Join (cost=0.00..29,497.29 rows=3 width=0) (actual time=2.441..3,248.455 rows=172 loops=1)

3. 30.092 30.092 ↓ 91.0 91 1

Index Scan using idx_venda_status_datahorafechamento on venda venda0_ (cost=0.00..13,166.79 rows=1 width=8) (actual time=1.249..30.092 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. 3,217.578 3,217.578 ↑ 1.5 2 91

Index Scan using idx_itemvenda_status_vendaid on itemvenda itens1_ (cost=0.00..16,330.46 rows=3 width=16) (actual time=23.360..35.358 rows=2 loops=91)

  • Index Cond: (venda0_.id = itens1_.vendaid)