explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6qcp

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 21.909 ↑ 12.0 1 1

Hash Semi Join (cost=819.07..2,407.48 rows=12 width=14) (actual time=18.541..21.909 rows=1 loops=1)

  • Output: conjunto.cdprocesso
  • Hash Cond: (conjunto.cdlocal = (((unnest('{23029}'::text[])))::integer))
  • Buffers: shared hit=898 read=56
2. 0.036 21.865 ↑ 4.5 4 1

Hash Join (cost=814.55..2,402.78 rows=18 width=18) (actual time=16.138..21.865 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=898 read=56
3. 1.986 21.006 ↑ 4.1 9 1

Hash Join (cost=797.30..2,385.19 rows=37 width=22) (actual time=15.299..21.006 rows=9 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdlocal, conjunto.cdtipomvprocesso
  • Inner Unique: true
  • Hash Cond: ((conjunto.cdassuntoprinc)::numeric = a.cdassunto)
  • Buffers: shared hit=876 read=56
4. 10.799 13.948 ↓ 21.1 1,560 1

Bitmap Heap Scan on saj.efmpconjunto conjunto (cost=780.05..2,367.28 rows=74 width=26) (actual time=9.391..13.948 rows=1,560 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.dtmovimento)::date >= '2020-01-01'::date) AND ((conjunto.dtmovimento)::date <= '2020-12-31'::date))
  • Rows Removed by Filter: 13294
  • Heap Blocks: exact=794
  • Buffers: shared hit=794 read=56
5. 3.149 3.149 ↑ 1.0 14,854 1

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

  • Index Cond: (conjunto.cdtipoprocesso = 801)
  • Buffers: shared read=56
6. 0.005 5.072 ↑ 200.0 1 1

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

  • Output: a.cdassunto
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=82
7. 0.013 5.067 ↑ 200.0 1 1

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

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

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

  • Output: a.cdassunto
  • Function Call: fnarvoreassunto('12218'::character varying)
  • Buffers: shared hit=82
9. 0.004 0.823 ↑ 200.0 1 1

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

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

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

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

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

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

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

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

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

  • Output: ((unnest('{23029}'::text[])))::integer
14. 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[])
15. 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.811 ms
Execution time : 22.180 ms