explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D9GQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 38.889 ↑ 48.0 1 1

Hash Semi Join (cost=69.29..2,450.93 rows=48 width=14) (actual time=32.211..38.889 rows=1 loops=1)

  • Output: conjunto.cdprocesso
  • Hash Cond: (conjunto.cdtipoprocesso = (((unnest(string_to_array(replace((fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying))::text, ' '::text, ''::text), ','::text))))::integer))
  • Buffers: shared hit=1357
2. 0.018 38.752 ↑ 48.0 1 1

Hash Semi Join (cost=39.02..2,420.00 rows=48 width=18) (actual time=32.076..38.752 rows=1 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdtipoprocesso
  • Hash Cond: (conjunto.cdlocal = (((unnest('{23029}'::text[])))::integer))
  • Buffers: shared hit=1356
3. 0.053 38.653 ↑ 17.5 4 1

Hash Join (cost=34.50..2,414.77 rows=70 width=22) (actual time=23.532..38.653 rows=4 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdtipoprocesso, conjunto.cdlocal
  • Inner Unique: true
  • Hash Cond: (((conjunto.cdtipomvprocesso)::character varying)::text = (tpmv.cdtipomvprocesso)::text)
  • Buffers: shared hit=1356
4. 5.037 38.016 ↑ 12.7 11 1

Hash Join (cost=17.25..2,396.18 rows=140 width=26) (actual time=22.921..38.016 rows=11 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdtipoprocesso, conjunto.cdlocal, conjunto.cdtipomvprocesso
  • Inner Unique: true
  • Hash Cond: ((conjunto.cdassuntoprinc)::numeric = a.cdassunto)
  • Buffers: shared hit=1334
5. 28.275 28.275 ↓ 14.3 4,027 1

Seq Scan on saj.efmpconjunto conjunto (cost=0.00..2,376.44 rows=281 width=30) (actual time=7.463..28.275 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.006 4.704 ↑ 200.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

Hash (cost=3.27..3.27 rows=100 width=4) (actual time=0.080..0.081 rows=1 loops=1)

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

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

  • Output: ((unnest('{23029}'::text[])))::integer
14. 0.008 0.011 ↑ 100.0 1 1

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.007..0.011 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)

16. 0.006 0.122 ↑ 50.0 2 1

Hash (cost=29.02..29.02 rows=100 width=4) (actual time=0.121..0.122 rows=2 loops=1)

  • Output: (((unnest(string_to_array(replace((fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying))::text, ' '::text, ''::text), ','::text))))::integer)
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
17. 0.009 0.116 ↑ 50.0 2 1

Result (cost=0.00..28.02 rows=100 width=4) (actual time=0.105..0.116 rows=2 loops=1)

  • Output: ((unnest(string_to_array(replace((fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying))::text, ' '::text, ''::text), ','::text))))::integer
  • Buffers: shared hit=1
18. 0.104 0.107 ↑ 50.0 2 1

ProjectSet (cost=0.00..0.77 rows=100 width=32) (actual time=0.101..0.107 rows=2 loops=1)

  • Output: unnest(string_to_array(replace((fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying))::text, ' '::text, ''::text), ','::text))
  • Buffers: shared hit=1
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 : 1.195 ms
Execution time : 39.092 ms