explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9O8d

Settings
# exclusive inclusive rows x rows loops node
1. 1.340 60.129 ↑ 176.0 1 1

Hash Join (cost=49.03..2,449.16 rows=176 width=14) (actual time=54.483..60.129 rows=1 loops=1)

  • Output: conjunto.cdprocesso
  • Hash Cond: ((conjunto.cdtipomvprocesso)::numeric = (fnarvoremovimentacao.cdtipomvprocesso)::numeric)
  • Buffers: shared hit=1,356
2. 0.668 44.819 ↑ 8.8 4 1

Hash Join (cost=26.29..2,407.08 rows=35 width=18) (actual time=39.171..44.819 rows=4 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdtipomvprocesso
  • Inner Unique: true
  • Hash Cond: ((conjunto.cdassuntoprinc)::numeric = a.cdassunto)
  • Buffers: shared hit=1,334
3. 2.689 20.461 ↓ 14.2 994 1

Hash Semi Join (cost=9.04..2,389.21 rows=70 width=22) (actual time=7.968..20.461 rows=994 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdtipomvprocesso, conjunto.cdassuntoprinc
  • Hash Cond: ((conjunto.cdlocal)::numeric = (((unnest('{23029}'::text[])))::numeric))
  • Buffers: shared hit=1,252
4. 3.983 17.758 ↓ 15.2 2,131 1

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

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

Seq Scan on saj.efmpconjunto conjunto (cost=0.00..2,376.44 rows=281 width=30) (actual time=3.116..13.757 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: 52,195
  • Buffers: shared hit=1,252
6. 0.004 0.018 ↑ 50.0 2 1

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

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

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

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

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

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

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

10. 0.003 0.014 ↑ 100.0 1 1

Hash (cost=3.27..3.27 rows=100 width=32) (actual time=0.014..0.014 rows=1 loops=1)

  • Output: (((unnest('{23029}'::text[])))::numeric)
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
11. 0.003 0.011 ↑ 100.0 1 1

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.008..0.011 rows=1 loops=1)

  • Output: ((unnest('{23029}'::text[])))::numeric
12. 0.007 0.008 ↑ 100.0 1 1

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

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

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

14. 0.004 23.690 ↑ 200.0 1 1

Hash (cost=14.75..14.75 rows=200 width=32) (actual time=23.689..23.690 rows=1 loops=1)

  • Output: a.cdassunto
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=82
15. 0.683 23.686 ↑ 200.0 1 1

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

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

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

  • Output: a.cdassunto
  • Function Call: fnarvoreassunto('12218'::character varying)
  • Buffers: shared hit=82
17. 0.007 13.970 ↑ 1,000.0 1 1

Hash (cost=10.25..10.25 rows=1,000 width=32) (actual time=13.969..13.970 rows=1 loops=1)

  • Output: fnarvoremovimentacao.cdtipomvprocesso
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=22
18. 13.963 13.963 ↑ 1,000.0 1 1

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

  • Output: fnarvoremovimentacao.cdtipomvprocesso
  • Function Call: fnarvoremovimentacao('920246'::character varying)
  • Buffers: shared hit=22
Planning time : 22.181 ms
Execution time : 66.759 ms