explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VivD

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 30.564 ↑ 1,756.0 1 1

Merge Join (cost=2,508.05..2,551.92 rows=1,756 width=14) (actual time=30.559..30.564 rows=1 loops=1)

  • Output: conjunto.cdprocesso
  • Merge Cond: (((conjunto.cdtipomvprocesso)::numeric) = ((fnarvoremovimentacao.cdtipomvprocesso)::numeric))
  • Buffers: shared hit=1360
2. 0.052 29.889 ↑ 117.0 3 1

Sort (cost=2,447.97..2,448.85 rows=351 width=18) (actual time=29.887..29.889 rows=3 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdtipomvprocesso, ((conjunto.cdtipomvprocesso)::numeric)
  • Sort Key: ((conjunto.cdtipomvprocesso)::numeric)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1338
3. 0.792 29.837 ↑ 87.8 4 1

Hash Join (cost=31.79..2,433.13 rows=351 width=18) (actual time=22.316..29.837 rows=4 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdtipomvprocesso, (conjunto.cdtipomvprocesso)::numeric
  • Hash Cond: ((conjunto.cdassuntoprinc)::numeric = fnarvoreassunto.cdassunto)
  • Buffers: shared hit=1334
4. 2.656 26.400 ↓ 14.2 994 1

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

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

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

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

Seq Scan on saj.efmpconjunto conjunto (cost=0.00..2,376.44 rows=281 width=30) (actual time=4.177..18.274 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
7. 0.006 0.025 ↑ 50.0 2 1

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

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

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

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

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

  • Output: unnest('{0801,0802}'::text[])
10. 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)

11. 0.005 0.033 ↑ 100.0 1 1

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

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

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

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

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

  • Output: unnest('{23029}'::text[])
14. 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)

15. 0.004 2.645 ↑ 1,000.0 1 1

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

  • Output: fnarvoreassunto.cdassunto
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=82
16. 2.641 2.641 ↑ 1,000.0 1 1

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

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

Sort (cost=60.08..62.58 rows=1,000 width=32) (actual time=0.661..0.662 rows=1 loops=1)

  • Output: fnarvoremovimentacao.cdtipomvprocesso, ((fnarvoremovimentacao.cdtipomvprocesso)::numeric)
  • Sort Key: ((fnarvoremovimentacao.cdtipomvprocesso)::numeric)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=22
18. 0.641 0.641 ↑ 1,000.0 1 1

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

  • Output: fnarvoremovimentacao.cdtipomvprocesso, (fnarvoremovimentacao.cdtipomvprocesso)::numeric
  • Function Call: fnarvoremovimentacao('920246'::character varying)
  • Buffers: shared hit=22
Planning time : 0.704 ms
Execution time : 30.810 ms