explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mDa8

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 14.106 ↑ 10.0 1 1

Hash Join (cost=814.54..2,439.56 rows=10 width=14) (actual time=11.990..14.106 rows=1 loops=1)

  • Output: conjunto.cdprocesso
  • Inner Unique: true
  • Hash Cond: (((conjunto.cdtipomvprocesso)::character varying)::text = (tpmv.cdtipomvprocesso)::text)
  • Buffers: shared hit=954
2. 0.874 13.557 ↑ 10.0 2 1

Hash Join (cost=797.29..2,422.12 rows=20 width=18) (actual time=11.438..13.557 rows=2 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdtipomvprocesso
  • Inner Unique: true
  • Hash Cond: ((conjunto.cdassuntoprinc)::numeric = a.cdassunto)
  • Buffers: shared hit=932
3. 7.420 8.700 ↓ 23.9 954 1

Bitmap Heap Scan on saj.efmpconjunto conjunto (cost=780.04..2,404.52 rows=40 width=22) (actual time=5.713..8.700 rows=954 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
  • Recheck Cond: (conjunto.cdtipoprocesso = 801)
  • Filter: ((conjunto.cdlocal = 23029) AND ((conjunto.dtmovimento)::date >= '2020-01-01'::date) AND ((conjunto.dtmovimento)::date <= '2020-12-31'::date))
  • Rows Removed by Filter: 13900
  • Heap Blocks: exact=794
  • Buffers: shared hit=850
4. 1.280 1.280 ↑ 1.0 14,854 1

Bitmap Index Scan on idx_efmpconjunto_cdtipoprocesso (cost=0.00..780.03 rows=14,899 width=0) (actual time=1.279..1.280 rows=14,854 loops=1)

  • Index Cond: (conjunto.cdtipoprocesso = 801)
  • Buffers: shared hit=56
5. 0.003 3.983 ↑ 200.0 1 1

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

  • Output: a.cdassunto
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=82
6. 0.008 3.980 ↑ 200.0 1 1

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

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

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

  • Output: a.cdassunto
  • Function Call: fnarvoreassunto('12218'::character varying)
  • Buffers: shared hit=82
8. 0.003 0.533 ↑ 200.0 1 1

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

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

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

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

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

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