explain.depesz.com

A tool for finding a real cause for slow queries.

Result: JZP

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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))