explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XlVo

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 119.130 ↑ 351,388.0 1 1

Merge Join (cost=10,911.71..17,068.54 rows=351,388 width=14) (actual time=119.127..119.130 rows=1 loops=1)

  • Output: conjunto.cdprocesso
  • Merge Cond: (fnarvoreassunto.cdassunto = ((conjunto.cdassuntoprinc)::numeric))
  • Buffers: shared hit=1356
2. 0.010 2.861 ↑ 1,000.0 1 1

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

  • Output: fnarvoreassunto.cdassunto
  • Sort Key: fnarvoreassunto.cdassunto
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=82
3. 2.851 2.851 ↑ 1,000.0 1 1

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

  • Output: fnarvoreassunto.cdassunto
  • Function Call: fnarvoreassunto('12218'::character varying)
  • Buffers: shared hit=82
4. 0.362 116.262 ↑ 14,055.6 5 1

Sort (cost=10,851.63..11,027.33 rows=70,278 width=18) (actual time=116.259..116.262 rows=5 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdassuntoprinc, ((conjunto.cdassuntoprinc)::numeric)
  • Sort Key: ((conjunto.cdassuntoprinc)::numeric)
  • Sort Method: quicksort Memory: 60kB
  • Buffers: shared hit=1274
5. 2.880 115.900 ↑ 153.8 457 1

Merge Join (cost=3,600.18..5,193.98 rows=70,278 width=18) (actual time=115.158..115.900 rows=457 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdassuntoprinc, conjunto.cdassuntoprinc
  • Merge Cond: (((fnarvoremovimentacao.cdtipomvprocesso)::numeric) = ((conjunto.cdtipomvprocesso)::numeric))
  • Buffers: shared hit=1274
6. 0.006 0.362 ↑ 1,000.0 1 1

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

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

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

  • Output: fnarvoremovimentacao.cdtipomvprocesso, (fnarvoremovimentacao.cdtipomvprocesso)::numeric
  • Function Call: fnarvoremovimentacao('920246'::character varying)
  • Buffers: shared hit=22
8. 9.103 112.658 ↑ 3.3 4,309 1

Sort (cost=3,540.10..3,575.24 rows=14,056 width=22) (actual time=110.680..112.658 rows=4,309 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdtipomvprocesso, conjunto.cdassuntoprinc, ((conjunto.cdtipomvprocesso)::numeric)
  • Sort Key: ((conjunto.cdtipomvprocesso)::numeric)
  • Sort Method: quicksort Memory: 730kB
  • Buffers: shared hit=1252
9. 18.709 103.555 ↑ 2.0 6,878 1

Hash Semi Join (cost=9.04..2,571.72 rows=14,056 width=22) (actual time=0.591..103.555 rows=6,878 loops=1)

  • Output: conjunto.cdprocesso, conjunto.cdtipomvprocesso, conjunto.cdassuntoprinc, (conjunto.cdtipomvprocesso)::numeric
  • Hash Cond: ((conjunto.cdlocal)::numeric = (((unnest('{23029}'::text[])))::numeric))
  • Buffers: shared hit=1252
10. 55.216 84.836 ↑ 1.4 20,670 1

Hash Semi Join (cost=4.52..2,317.71 rows=28,111 width=26) (actual time=0.038..84.836 rows=20,670 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
11. 29.607 29.607 ↑ 1.0 56,222 1

Seq Scan on saj.efmpconjunto conjunto (cost=0.00..1,814.22 rows=56,222 width=30) (actual time=0.006..29.607 rows=56,222 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
  • Buffers: shared hit=1252
12. 0.003 0.013 ↑ 50.0 2 1

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

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

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

  • Output: ((unnest('{0801,0802}'::text[])))::numeric
14. 0.004 0.006 ↑ 50.0 2 1

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

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

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

16. 0.002 0.010 ↑ 100.0 1 1

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

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

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

  • Output: ((unnest('{23029}'::text[])))::numeric
18. 0.003 0.005 ↑ 100.0 1 1

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

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

Planning time : 0.597 ms
Execution time : 119.278 ms