explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aix6

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.089 ↑ 75.0 2 1

Sort (cost=729.42..729.80 rows=150 width=171) (actual time=0.089..0.089 rows=2 loops=1)

  • Sort Key: saleitem0_.id
  • Sort Method: quicksort Memory: 25kB
2. 0.003 0.085 ↑ 75.0 2 1

Hash Left Join (cost=256.08..724.00 rows=150 width=171) (actual time=0.080..0.085 rows=2 loops=1)

  • Hash Cond: (saleitem0_.category_id = naturezafi2_.id_natureza_financeira)
3. 0.004 0.023 ↑ 75.0 2 1

Nested Loop Left Join (cost=1.14..468.67 rows=150 width=148) (actual time=0.018..0.023 rows=2 loops=1)

4. 0.009 0.009 ↑ 75.0 2 1

Index Scan using idx_negotiationitem_negotiation_id on negotiationitem saleitem0_ (cost=0.57..50.54 rows=150 width=86) (actual time=0.008..0.009 rows=2 loops=1)

  • Index Cond: (negotiation_id = '170268144'::bigint)
  • Filter: ((direction)::text = 'OUT'::text)
5. 0.010 0.010 ↑ 1.0 1 2

Index Scan using ef_produto_pkey on ef_produto item1_ (cost=0.57..2.79 rows=1 width=70) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: (saleitem0_.item_id_produto = id_produto)
  • Filter: (id_empresa = '2183212'::bigint)
6. 0.020 0.059 ↑ 3.5 136 1

Hash (cost=248.93..248.93 rows=481 width=31) (actual time=0.059..0.059 rows=136 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 18kB
7. 0.039 0.039 ↑ 3.5 136 1

Index Scan using idx1_natureza_financeira on ef_natureza_financeira naturezafi2_ (cost=0.57..248.93 rows=481 width=31) (actual time=0.010..0.039 rows=136 loops=1)

  • Index Cond: (id_empresa = '2183212'::bigint)
Planning time : 0.624 ms
Execution time : 0.126 ms