explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UAQS : Removido w

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 0.431 ↑ 1.8 45 1

Limit (cost=22.32..25.52 rows=80 width=729) (actual time=0.389..0.431 rows=45 loops=1)

  • Buffers: shared hit=8
2. 0.040 0.429 ↑ 1.8 45 1

Aggregate (cost=22.32..25.52 rows=80 width=729) (actual time=0.389..0.429 rows=45 loops=1)

  • Buffers: shared hit=8
3. 0.067 0.389 ↑ 1.1 72 1

Sort (cost=22.32..22.52 rows=80 width=704) (actual time=0.384..0.389 rows=72 loops=1)

  • Sort Key: documentoeletronicoven.dt_cadastro DESC, documentoeletronicoven.nr_documento DESC, documentoeletronicoven.nr_serie, documentoeletronicochaveven.tx_chave, documentoeletronicoven.cd_status, documentoeletronicoeventoven.cd_situacao, documentoeletronicoeventoven.tx_motivo, vendapdv.id_vendapdv, integracaovendaven.fl_integrado
  • Sort Method: quicksort Memory: 44kB
  • Buffers: shared hit=8
4. 0.027 0.322 ↑ 1.1 72 1

Hash Join (cost=15.76..19.79 rows=80 width=704) (actual time=0.291..0.322 rows=72 loops=1)

  • Buffers: shared hit=8
5. 0.033 0.033 ↑ 1.0 89 1

Seq Scan on tb_vendaitempdv vendaitempdv (cost=0..2.89 rows=89 width=12) (actual time=0.022..0.033 rows=89 loops=1)

  • Buffers: shared hit=2
6. 0.016 0.262 ↓ 1.0 45 1

Hash (cost=15.23..15.23 rows=43 width=737) (actual time=0.262..0.262 rows=45 loops=1)

  • Buffers: shared hit=6
7. 0.015 0.246 ↓ 1.0 45 1

Hash Join (cost=10.29..15.23 rows=43 width=737) (actual time=0.175..0.246 rows=45 loops=1)

  • Buffers: shared hit=6
8. 0.049 0.207 ↓ 1.0 45 1

Hash Join (cost=8.23..12.58 rows=43 width=269) (actual time=0.148..0.207 rows=45 loops=1)

  • Buffers: shared hit=5
9. 0.019 0.136 ↓ 1.0 45 1

Hash Join (cost=6.17..9.93 rows=43 width=143) (actual time=0.089..0.136 rows=45 loops=1)

  • Buffers: shared hit=4
10. 0.016 0.096 ↓ 1.0 45 1

Hash Join (cost=4.12..7.28 rows=43 width=77) (actual time=0.062..0.096 rows=45 loops=1)

  • Buffers: shared hit=3
11. 0.017 0.059 ↓ 1.0 45 1

Hash Join (cost=2.06..4.63 rows=44 width=49) (actual time=0.036..0.059 rows=45 loops=1)

  • Buffers: shared hit=2
12. 0.022 0.022 ↓ 1.0 46 1

Seq Scan on tb_vendapdv vendapdv (cost=0..1.96 rows=45 width=9) (actual time=0.01..0.022 rows=46 loops=1)

  • Filter: ((vendapdv.dt_movimento >= '2019-11-22'::date) AND (vendapdv.dt_movimento <= '2019-11-27'::date) AND (vendapdv.cd_pdv = '1'::numeric) AND (vendapdv.cd_empresa = '1'::numeric))
  • Buffers: shared hit=1
13. 0.010 0.020 ↑ 1.0 47 1

Hash (cost=1.47..1.47 rows=47 width=40) (actual time=0.02..0.02 rows=47 loops=1)

  • Buffers: shared hit=1
14. 0.010 0.010 ↑ 1.0 47 1

Seq Scan on tb_documentoeletrvendaven documentoeletronicovendaven (cost=0..1.47 rows=47 width=40) (actual time=0.008..0.01 rows=47 loops=1)

  • Buffers: shared hit=1
15. 0.011 0.021 ↑ 1.0 47 1

Hash (cost=1.47..1.47 rows=47 width=28) (actual time=0.021..0.021 rows=47 loops=1)

  • Buffers: shared hit=1
16. 0.010 0.010 ↑ 1.0 47 1

Seq Scan on tb_integracaovendaven integracaovendaven (cost=0..1.47 rows=47 width=28) (actual time=0.007..0.01 rows=47 loops=1)

  • Buffers: shared hit=1
17. 0.010 0.021 ↑ 1.0 47 1

Hash (cost=1.47..1.47 rows=47 width=66) (actual time=0.021..0.021 rows=47 loops=1)

  • Buffers: shared hit=1
18. 0.011 0.011 ↑ 1.0 47 1

Seq Scan on tb_documentoeletrven documentoeletronicoven (cost=0..1.47 rows=47 width=66) (actual time=0.006..0.011 rows=47 loops=1)

  • Buffers: shared hit=1
19. 0.011 0.022 ↑ 1.0 47 1

Hash (cost=1.47..1.47 rows=47 width=126) (actual time=0.022..0.022 rows=47 loops=1)

  • Buffers: shared hit=1
20. 0.011 0.011 ↑ 1.0 47 1

Seq Scan on tb_documentoeletrchaveven documentoeletronicochaveven (cost=0..1.47 rows=47 width=126) (actual time=0.007..0.011 rows=47 loops=1)

  • Buffers: shared hit=1
21. 0.012 0.024 ↑ 1.0 47 1

Hash (cost=1.47..1.47 rows=47 width=548) (actual time=0.024..0.024 rows=47 loops=1)

  • Buffers: shared hit=1
22. 0.012 0.012 ↑ 1.0 47 1

Seq Scan on tb_documentoeletreventoven documentoeletronicoeventoven (cost=0..1.47 rows=47 width=548) (actual time=0.008..0.012 rows=47 loops=1)

  • Buffers: shared hit=1
Planning time : 10.376 ms
Execution time : 0.517 ms