explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lL9A

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 47.497 ↑ 24.0 1 1

Hash Semi Join (cost=43.53..2,424.73 rows=24 width=14) (actual time=37.941..47.497 rows=1 loops=1)

  • Output: conjunto.cdprocesso
  • Hash Cond: (conjunto.cdlocal = (((unnest('{23029}'::text[])))::integer))
  • Buffers: shared hit=1356
2. 0.047 47.453 ↑ 8.8 4 1

Hash Join (cost=39.02..2,419.86 rows=35 width=18) (actual time=26.780..47.453 rows=4 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdlocal
  • Inner Unique: true
  • Hash Cond: (((conjunto.cdtipomvprocesso)::character varying)::text = (tpmv.cdtipomvprocesso)::text)
  • Buffers: shared hit=1356
3. 2.868 46.827 ↑ 6.4 11 1

Hash Join (cost=21.77..2,401.94 rows=70 width=22) (actual time=26.184..46.827 rows=11 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdlocal, conjunto.cdtipomvprocesso
  • Inner Unique: true
  • Hash Cond: ((conjunto.cdassuntoprinc)::numeric = a.cdassunto)
  • Buffers: shared hit=1334
4. 8.763 37.455 ↓ 15.2 2,131 1

Hash Semi Join (cost=4.52..2,383.45 rows=140 width=26) (actual time=14.145..37.455 rows=2,131 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdlocal, conjunto.cdtipomvprocesso, conjunto.cdassuntoprinc
  • Hash Cond: ((conjunto.cdtipoprocesso)::numeric = (((unnest('{0801,0802}'::text[])))::numeric))
  • Buffers: shared hit=1252
5. 28.661 28.661 ↓ 14.3 4,027 1

Seq Scan on saj.efmpconjunto conjunto (cost=0.00..2,376.44 rows=281 width=30) (actual time=6.364..28.661 rows=4,027 loops=1)

  • Output: conjunto.conjuntoid, conjunto.cdclasseprocesso, conjunto.cdassuntoprinc, conjunto.cdassuntoext, conjunto.cdtipolocal, conjunto.detipolocal, conjunto.cdlocal, conjunto.delocal, conjunto.cdprocesso, conjunto.nuprocesso, conjunto.cdtipomvprocesso, conjunto.nuseqprocessomv, conjunto.dtmovimento, conjunto.cdtipoprocesso, conjunto.cdtipomvext
  • Filter: (((conjunto.dtmovimento)::date >= '2020-01-01'::date) AND ((conjunto.dtmovimento)::date <= '2020-12-31'::date))
  • Rows Removed by Filter: 52195
  • Buffers: shared hit=1252
6. 0.007 0.031 ↑ 50.0 2 1

Hash (cost=3.27..3.27 rows=100 width=32) (actual time=0.030..0.031 rows=2 loops=1)

  • Output: (((unnest('{0801,0802}'::text[])))::numeric)
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.011 0.024 ↑ 50.0 2 1

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.014..0.024 rows=2 loops=1)

  • Output: ((unnest('{0801,0802}'::text[])))::numeric
8. 0.010 0.013 ↑ 50.0 2 1

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.007..0.013 rows=2 loops=1)

  • Output: unnest('{0801,0802}'::text[])
9. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.003 rows=1 loops=1)

10. 0.006 6.504 ↑ 200.0 1 1

Hash (cost=14.75..14.75 rows=200 width=32) (actual time=6.503..6.504 rows=1 loops=1)

  • Output: a.cdassunto
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=82
11. 0.019 6.498 ↑ 200.0 1 1

HashAggregate (cost=12.75..14.75 rows=200 width=32) (actual time=6.494..6.498 rows=1 loops=1)

  • Output: a.cdassunto
  • Group Key: a.cdassunto
  • Buffers: shared hit=82
12. 6.479 6.479 ↑ 1,000.0 1 1

Function Scan on saj.fnarvoreassunto a (cost=0.25..10.25 rows=1,000 width=32) (actual time=6.476..6.479 rows=1 loops=1)

  • Output: a.cdassunto
  • Function Call: fnarvoreassunto('12218'::character varying)
  • Buffers: shared hit=82
13. 0.005 0.579 ↑ 200.0 1 1

Hash (cost=14.75..14.75 rows=200 width=32) (actual time=0.578..0.579 rows=1 loops=1)

  • Output: tpmv.cdtipomvprocesso
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=22
14. 0.011 0.574 ↑ 200.0 1 1

HashAggregate (cost=12.75..14.75 rows=200 width=32) (actual time=0.572..0.574 rows=1 loops=1)

  • Output: tpmv.cdtipomvprocesso
  • Group Key: (tpmv.cdtipomvprocesso)::text
  • Buffers: shared hit=22
15. 0.563 0.563 ↑ 1,000.0 1 1

Function Scan on saj.fnarvoremovimentacao tpmv (cost=0.25..10.25 rows=1,000 width=32) (actual time=0.561..0.563 rows=1 loops=1)

  • Output: tpmv.cdtipomvprocesso, tpmv.cdtipomvprocesso
  • Function Call: fnarvoremovimentacao('920246'::character varying)
  • Buffers: shared hit=22
16. 0.005 0.024 ↑ 100.0 1 1

Hash (cost=3.27..3.27 rows=100 width=4) (actual time=0.023..0.024 rows=1 loops=1)

  • Output: (((unnest('{23029}'::text[])))::integer)
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 0.006 0.019 ↑ 100.0 1 1

Result (cost=0.00..2.27 rows=100 width=4) (actual time=0.012..0.019 rows=1 loops=1)

  • Output: ((unnest('{23029}'::text[])))::integer
18. 0.010 0.013 ↑ 100.0 1 1

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.007..0.013 rows=1 loops=1)

  • Output: unnest('{23029}'::text[])
19. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.003 rows=1 loops=1)

Planning time : 0.925 ms
Execution time : 47.704 ms