explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qRvn

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,057.549 ↑ 1.0 1 1

Aggregate (cost=132,235.08..132,235.09 rows=1 width=32) (actual time=1,057.549..1,057.549 rows=1 loops=1)

2. 32.895 1,061.772 ↓ 23,809.0 23,809 1

Gather (cost=1,017.87..132,235.07 rows=1 width=6) (actual time=2.737..1,061.772 rows=23,809 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 4.782 1,028.877 ↓ 11,904.0 11,904 2 / 2

Hash Join (cost=17.87..131,234.97 rows=1 width=6) (actual time=2.076..1,028.877 rows=11,904 loops=2)

  • Hash Cond: (vei.vei_cd_produto = produto.pro_cd_produto)
4. 2.555 1,023.687 ↑ 2.4 11,904 2 / 2

Nested Loop (cost=1.15..131,142.51 rows=28,852 width=10) (actual time=1.154..1,023.687 rows=11,904 loops=2)

5. 449.716 449.716 ↑ 2.4 11,904 2 / 2

Parallel Index Scan using abastecimento_abt_cd_unidade_negocio_abt_dt_fiscal_idx on abastecimento abt (cost=0.57..52,965.42 rows=28,852 width=4) (actual time=0.763..449.716 rows=11,904 loops=2)

  • Index Cond: ((abt_cd_unidade_negocio = 180) AND (abt_dt_fiscal >= (CURRENT_DATE - '30 days'::interval)) AND (abt_dt_fiscal <= CURRENT_DATE))
  • Filter: (NOT abt_bl_afericao)
  • Rows Removed by Filter: 8
6. 571.416 571.416 ↑ 1.0 1 23,809 / 2

Index Scan using venda_item_pkey on venda_item vei (cost=0.57..2.71 rows=1 width=14) (actual time=0.048..0.048 rows=1 loops=23,809)

  • Index Cond: (vei_cd_venda_item = abt.abt_cd_venda_item)
7. 0.012 0.408 ↑ 1.2 6 2 / 2

Hash (cost=16.64..16.64 rows=7 width=4) (actual time=0.408..0.408 rows=6 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.396 0.396 ↑ 1.2 6 2 / 2

Index Scan using produto_idx_produto_lmc on produto (cost=0.42..16.64 rows=7 width=4) (actual time=0.248..0.396 rows=6 loops=2)

  • Index Cond: (pro_cd_produto_lmc = ANY ('{312,308,313,311,309,310}'::integer[]))
Planning time : 4.814 ms
Execution time : 1,066.696 ms