explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X9qB

Settings
# exclusive inclusive rows x rows loops node
1. 182.150 304,567.626 ↓ 61.0 1,281 1

Result (cost=2,494.64..6,624.34 rows=21 width=252) (actual time=862.028..304,567.626 rows=1,281 loops=1)

  • Output: t.cdassuntoext, t.deassunto, t.cdassuntounif, ((date_part('year'::text, (t.first_day)::timestamp without time zone))::bigint), ((date_part('month'::text, (t.first_day)::timestamp without time zone))::bigint), (SubPlan 1), (SubPlan 2), ((SubPlan 3))::bigint, (SubPlan 4), (SubPlan 5), ((SubPlan 6))::bigint, (SubPlan 7), (SubPlan 8), ((SubPlan 9))::bigint, (SubPlan 10), (SubPlan 11), ((SubPlan 12))::bigint, t.first_day, t.last_day, t.cdlocal, ((((((((((((('{
  • "cdassuntoext": "'::text || (t.cdassuntoext)::text) || '",
  • "tipocadastro": "'::text) || (fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying))::text) || '",
  • "recebidos": "'::text) || '920246'::text) || '",
  • "recurso": "'::text) || '920211'::text) || '",
  • "manifestacao_2grau": "'::text) || '920271'::text) || '",
  • "manifestacao_tribunais_superiores": "'::text) || '920270'::text) || '
  • }'::text))::json
  • Buffers: shared hit=21018366
2. 7.249 488.722 ↓ 61.0 1,281 1

Sort (cost=2,494.64..2,494.69 rows=21 width=124) (actual time=486.267..488.722 rows=1,281 loops=1)

  • Output: t.cdassuntoext, t.deassunto, t.cdassuntounif, ((date_part('year'::text, (t.first_day)::timestamp without time zone))::bigint), ((date_part('month'::text, (t.first_day)::timestamp without time zone))::bigint), t.first_day, t.last_day, t.cdlocal
  • Sort Key: ((date_part('year'::text, (t.first_day)::timestamp without time zone))::bigint), ((date_part('month'::text, (t.first_day)::timestamp without time zone))::bigint), t.cdassuntoext, t.deassunto, t.cdassuntounif
  • Sort Method: quicksort Memory: 252kB
  • Buffers: shared hit=30462
3. 3.459 481.473 ↓ 61.0 1,281 1

Subquery Scan on t (cost=2,482.68..2,494.18 rows=21 width=124) (actual time=426.818..481.473 rows=1,281 loops=1)

  • Output: t.cdassuntoext, t.deassunto, t.cdassuntounif, (date_part('year'::text, (t.first_day)::timestamp without time zone))::bigint, (date_part('month'::text, (t.first_day)::timestamp without time zone))::bigint, t.first_day, t.last_day, t.cdlocal
  • Buffers: shared hit=30462
4. 37.867 478.014 ↓ 61.0 1,281 1

Group (cost=2,482.68..2,493.65 rows=21 width=116) (actual time=426.810..478.014 rows=1,281 loops=1)

  • Output: fnfirst_day(((p.dtmovimento)::date)), fnlast_day(((p.dtmovimento)::date)), p.cdlocal, "*SELECT* 1".cdassuntoext, "*SELECT* 1".deassunto, "*SELECT* 1".cdassuntounif, ((p.dtmovimento)::date), p.cdlocal
  • Group Key: ((p.dtmovimento)::date), p.cdlocal, "*SELECT* 1".cdassuntoext, "*SELECT* 1".deassunto, "*SELECT* 1".cdassuntounif
  • Buffers: shared hit=30462
5. 78.479 440.147 ↓ 641.0 13,461 1

Sort (cost=2,482.68..2,482.73 rows=21 width=112) (actual time=426.534..440.147 rows=13,461 loops=1)

  • Output: "*SELECT* 1".cdassuntoext, "*SELECT* 1".deassunto, "*SELECT* 1".cdassuntounif, ((p.dtmovimento)::date), p.cdlocal, p.dtmovimento
  • Sort Key: ((p.dtmovimento)::date), p.cdlocal, "*SELECT* 1".cdassuntoext, "*SELECT* 1".deassunto, "*SELECT* 1".cdassuntounif
  • Sort Method: quicksort Memory: 2318kB
  • Buffers: shared hit=30462
6. 38.019 361.668 ↓ 641.0 13,461 1

Nested Loop (cost=44.32..2,482.22 rows=21 width=112) (actual time=3.079..361.668 rows=13,461 loops=1)

  • Output: "*SELECT* 1".cdassuntoext, "*SELECT* 1".deassunto, "*SELECT* 1".cdassuntounif, (p.dtmovimento)::date, p.cdlocal, p.dtmovimento
  • Buffers: shared hit=30462
7. 9.234 162.117 ↓ 641.0 641 1

Nested Loop Semi Join (cost=0.00..2,406.71 rows=1 width=12) (actual time=2.894..162.117 rows=641 loops=1)

  • Output: p.dtmovimento, p.cdlocal
  • Join Filter: (p.cdtipoprocesso = (((unnest(string_to_array(replace((fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying))::text, ' '::text, ''::text), ','::text))))::integer))
  • Rows Removed by Join Filter: 2206
  • Buffers: shared hit=2899
8. 54.063 54.063 ↓ 1,647.0 1,647 1

Seq Scan on saj.efmpconjunto p (cost=0.00..2,376.44 rows=1 width=16) (actual time=2.526..54.063 rows=1,647 loops=1)

  • Output: p.conjuntoid, p.cdclasseprocesso, p.cdassuntoprinc, p.cdassuntoext, p.cdtipolocal, p.detipolocal, p.cdlocal, p.delocal, p.cdprocesso, p.nuprocesso, p.cdtipomvprocesso, p.nuseqprocessomv, p.dtmovimento, p.cdtipoprocesso, p.cdtipomvext
  • Filter: ((date_part('year'::text, p.dtmovimento) = '2019'::double precision) AND (date_part('month'::text, p.dtmovimento) = '1'::double precision))
  • Rows Removed by Filter: 54575
  • Buffers: shared hit=1252
9. 8.235 98.820 ↑ 50.0 2 1,647

Result (cost=0.00..28.02 rows=100 width=4) (actual time=0.054..0.060 rows=2 loops=1,647)

  • Output: ((unnest(string_to_array(replace((fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying))::text, ' '::text, ''::text), ','::text))))::integer
  • Buffers: shared hit=1647
10. 87.291 90.585 ↑ 50.0 2 1,647

ProjectSet (cost=0.00..0.77 rows=100 width=32) (actual time=0.052..0.055 rows=2 loops=1,647)

  • Output: unnest(string_to_array(replace((fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying))::text, ' '::text, ''::text), ','::text))
  • Buffers: shared hit=1647
11. 3.294 3.294 ↑ 1.0 1 1,647

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

12. 31.409 161.532 ↑ 1.0 21 641

Append (cost=44.32..75.24 rows=21 width=96) (actual time=0.068..0.252 rows=21 loops=641)

  • Buffers: shared hit=27563
13. 21.153 107.047 ↑ 1.0 15 641

Subquery Scan on *SELECT* 1 (cost=44.32..75.12 rows=15 width=96) (actual time=0.066..0.167 rows=15 loops=641)

  • Output: "*SELECT* 1".cdassuntoext, "*SELECT* 1".deassunto, "*SELECT* 1".cdassuntounif
  • Buffers: shared hit=27563
14. 51.921 85.894 ↑ 1.0 15 641

Bitmap Heap Scan on saj.esajassunto a (cost=44.32..74.97 rows=15 width=96) (actual time=0.064..0.134 rows=15 loops=641)

  • Output: (a.cdassuntoext)::character varying, (a.cdassuntounif)::character varying, initcap((a.deassunto)::text)
  • Recheck Cond: (a.cdassuntoext = ANY ('{12218,3463,3400,3618,3415,11410,3631,3632,3633,3613,12221,12219,12220,930421,10949}'::numeric[]))
  • Heap Blocks: exact=7692
  • Buffers: shared hit=27563
15. 33.973 33.973 ↑ 1.0 15 641

Bitmap Index Scan on idx_esajassunto_cdassuntoext (cost=0.00..44.31 rows=15 width=0) (actual time=0.053..0.053 rows=15 loops=641)

  • Index Cond: (a.cdassuntoext = ANY ('{12218,3463,3400,3618,3415,11410,3631,3632,3633,3613,12221,12219,12220,930421,10949}'::numeric[]))
  • Buffers: shared hit=19871
16. 2.564 3.846 ↑ 1.0 1 641

Subquery Scan on *SELECT* 2 (cost=0.00..0.02 rows=1 width=96) (actual time=0.003..0.006 rows=1 loops=641)

  • Output: "*SELECT* 2"."?column?", "*SELECT* 2"."?column?_2", "*SELECT* 2"."?column?_1
17. 1.282 1.282 ↑ 1.0 1 641

Result (cost=0.00..0.01 rows=1 width=96) (actual time=0.001..0.002 rows=1 loops=641)

  • Output: '5873, 5872, 3547'::character varying, '5873), (5872), (3547'::character varying, 'Crimes contra a Administra��o P�blica'::text
18. 2.564 3.846 ↑ 1.0 1 641

Subquery Scan on *SELECT* 3 (cost=0.00..0.02 rows=1 width=96) (actual time=0.003..0.006 rows=1 loops=641)

  • Output: "*SELECT* 3"."?column?", "*SELECT* 3"."?column?_2", "*SELECT* 3"."?column?_1
19. 1.282 1.282 ↑ 1.0 1 641

Result (cost=0.00..0.01 rows=1 width=96) (actual time=0.001..0.002 rows=1 loops=641)

  • Output: '10984, 10983, 10982, 3628'::character varying, '10984), (10983), (10982), (3628'::character varying, 'Crimes de "Lavagem" ou Oculta��o de Bens, Direitos ou Valores'::text
20. 2.564 3.846 ↑ 1.0 1 641

Subquery Scan on *SELECT* 4 (cost=0.00..0.02 rows=1 width=96) (actual time=0.003..0.006 rows=1 loops=641)

  • Output: "*SELECT* 4"."?column?", "*SELECT* 4"."?column?_2", "*SELECT* 4"."?column?_1
21. 1.282 1.282 ↑ 1.0 1 641

Result (cost=0.00..0.01 rows=1 width=96) (actual time=0.001..0.002 rows=1 loops=641)

  • Output: '5897, 3608'::character varying, '5897), (3608'::character varying, 'Crimes de Tr�fico Il�cito e Associa��o para a Produ��o e Tr�fico'::text
22. 2.564 3.846 ↑ 1.0 1 641

Subquery Scan on *SELECT* 5 (cost=0.00..0.02 rows=1 width=96) (actual time=0.003..0.006 rows=1 loops=641)

  • Output: "*SELECT* 5"."?column?", "*SELECT* 5"."?column?_2", "*SELECT* 5"."?column?_1
23. 1.282 1.282 ↑ 1.0 1 641

Result (cost=0.00..0.01 rows=1 width=96) (actual time=0.001..0.002 rows=1 loops=641)

  • Output: '11429, 3654'::character varying, '11429), (3654'::character varying, 'Crimes Eleitorais'::text
24. 2.564 3.846 ↑ 1.0 1 641

Subquery Scan on *SELECT* 6 (cost=0.00..0.02 rows=1 width=96) (actual time=0.003..0.006 rows=1 loops=641)

  • Output: "*SELECT* 6"."?column?", "*SELECT* 6"."?column?_2", "*SELECT* 6"."?column?_1
25. 1.282 1.282 ↑ 1.0 1 641

Result (cost=0.00..0.01 rows=1 width=96) (actual time=0.001..0.002 rows=1 loops=641)

  • Output: '900142, 12091'::character varying, '900142), (12091'::character varying, 'Feminic�dio'::text
26. 2.564 3.846 ↑ 1.0 1 641

Subquery Scan on *SELECT* 7 (cost=0.00..0.02 rows=1 width=96) (actual time=0.003..0.006 rows=1 loops=641)

  • Output: "*SELECT* 7"."?column?", "*SELECT* 7"."?column?_2", "*SELECT* 7"."?column?_1
27. 1.282 1.282 ↑ 1.0 1 641

Result (cost=0.00..0.01 rows=1 width=96) (actual time=0.001..0.002 rows=1 loops=641)

  • Output: '3372, 3370'::character varying, '3372), (3370'::character varying, 'Homic�dio Simples e Qualificado'::text
28.          

SubPlan (for Result)

29. 23.058 23,050.314 ↑ 1.0 1 1,281

Aggregate (cost=13.00..13.01 rows=1 width=8) (actual time=17.993..17.994 rows=1 loops=1,281)

  • Output: count(DISTINCT fnresolucao195baseassunto.cdprocesso)
  • Buffers: shared hit=1738317
30. 23,027.256 23,027.256 ↑ 1,000.0 1 1,281

Function Scan on saj.fnresolucao195baseassunto (cost=0.50..10.50 rows=1,000 width=32) (actual time=17.975..17.976 rows=1 loops=1,281)

  • Output: fnresolucao195baseassunto.cdprocesso
  • Function Call: fnresolucao195baseassunto(fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying), (t.cdlocal)::character varying, '920246'::character varying, t.cdassuntoext, t.first_day, t.last_day, NULL::character varying, NULL::integer, NULL::character varying)
  • Buffers: shared hit=1738317
31. 7.686 23,064.405 ↑ 1.0 1 1,281

Aggregate (cost=13.00..13.01 rows=1 width=8) (actual time=18.004..18.005 rows=1 loops=1,281)

  • Output: count(fnresolucao195baseassunto_1.cdprocesso)
  • Buffers: shared hit=1738317
32. 23,056.719 23,056.719 ↑ 1,000.0 1 1,281

Function Scan on saj.fnresolucao195baseassunto fnresolucao195baseassunto_1 (cost=0.50..10.50 rows=1,000 width=32) (actual time=17.999..17.999 rows=1 loops=1,281)

  • Output: fnresolucao195baseassunto_1.cdprocesso
  • Function Call: fnresolucao195baseassunto(fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying), (t.cdlocal)::character varying, '920246'::character varying, t.cdassuntoext, t.first_day, t.last_day, NULL::character varying, NULL::integer, NULL::character varying)
  • Buffers: shared hit=1738317
33. 12.810 29,474.529 ↑ 1.0 1 1,281

Aggregate (cost=23.04..23.05 rows=1 width=32) (actual time=23.008..23.009 rows=1 loops=1,281)

  • Output: COALESCE(sum(((count(*)) - 1)), '0'::numeric)
  • Buffers: shared hit=1738317
34. 14.091 29,461.719 ↑ 200.0 1 1,281

HashAggregate (cost=18.04..20.04 rows=200 width=40) (actual time=22.998..22.999 rows=1 loops=1,281)

  • Output: fnresolucao195baseassunto_2.cdprocesso, count(*)
  • Group Key: fnresolucao195baseassunto_2.cdprocesso
  • Filter: (count(*) > 1)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=1738317
35. 29,447.628 29,447.628 ↑ 166.7 6 1,281

Function Scan on saj.fnresolucao195baseassunto fnresolucao195baseassunto_2 (cost=0.54..10.54 rows=1,000 width=32) (actual time=22.985..22.988 rows=6 loops=1,281)

  • Output: fnresolucao195baseassunto_2.cdprocesso
  • Function Call: fnresolucao195baseassunto(fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying), (t.cdlocal)::character varying, '920246'::character varying, t.cdassuntoext, ((((date_part('year'::text, (t.first_day)::timestamp without time zone))::character varying)::text || '-01-01'::text))::date, ((((date_part('year'::text, (t.first_day)::timestamp without time zone))::character varying)::text || '-12-31'::text))::date, NULL::character varying, NULL::integer, NULL::character varying)
  • Buffers: shared hit=1738317
36. 19.215 23,490.978 ↑ 1.0 1 1,281

Aggregate (cost=13.00..13.01 rows=1 width=8) (actual time=18.337..18.338 rows=1 loops=1,281)

  • Output: count(DISTINCT fnresolucao195baseassunto_3.cdprocesso)
  • Buffers: shared hit=1780590
37. 23,471.763 23,471.763 ↓ 0.0 0 1,281

Function Scan on saj.fnresolucao195baseassunto fnresolucao195baseassunto_3 (cost=0.50..10.50 rows=1,000 width=32) (actual time=18.323..18.323 rows=0 loops=1,281)

  • Output: fnresolucao195baseassunto_3.cdprocesso
  • Function Call: fnresolucao195baseassunto(fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying), (t.cdlocal)::character varying, '920211'::character varying, t.cdassuntoext, t.first_day, t.last_day, NULL::character varying, NULL::integer, NULL::character varying)
  • Buffers: shared hit=1780590
38. 7.686 23,561.433 ↑ 1.0 1 1,281

Aggregate (cost=13.00..13.01 rows=1 width=8) (actual time=18.392..18.393 rows=1 loops=1,281)

  • Output: count(fnresolucao195baseassunto_4.cdprocesso)
  • Buffers: shared hit=1780590
39. 23,553.747 23,553.747 ↓ 0.0 0 1,281

Function Scan on saj.fnresolucao195baseassunto fnresolucao195baseassunto_4 (cost=0.50..10.50 rows=1,000 width=32) (actual time=18.387..18.387 rows=0 loops=1,281)

  • Output: fnresolucao195baseassunto_4.cdprocesso
  • Function Call: fnresolucao195baseassunto(fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying), (t.cdlocal)::character varying, '920211'::character varying, t.cdassuntoext, t.first_day, t.last_day, NULL::character varying, NULL::integer, NULL::character varying)
  • Buffers: shared hit=1780590
40. 11.529 30,048.417 ↑ 1.0 1 1,281

Aggregate (cost=23.04..23.05 rows=1 width=32) (actual time=23.457..23.457 rows=1 loops=1,281)

  • Output: COALESCE(sum(((count(*)) - 1)), '0'::numeric)
  • Buffers: shared hit=1780590
41. 6.405 30,036.888 ↓ 0.0 0 1,281

HashAggregate (cost=18.04..20.04 rows=200 width=40) (actual time=23.448..23.448 rows=0 loops=1,281)

  • Output: fnresolucao195baseassunto_5.cdprocesso, count(*)
  • Group Key: fnresolucao195baseassunto_5.cdprocesso
  • Filter: (count(*) > 1)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1780590
42. 30,030.483 30,030.483 ↓ 0.0 0 1,281

Function Scan on saj.fnresolucao195baseassunto fnresolucao195baseassunto_5 (cost=0.54..10.54 rows=1,000 width=32) (actual time=23.443..23.443 rows=0 loops=1,281)

  • Output: fnresolucao195baseassunto_5.cdprocesso
  • Function Call: fnresolucao195baseassunto(fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying), (t.cdlocal)::character varying, '920211'::character varying, t.cdassuntoext, ((((date_part('year'::text, (t.first_day)::timestamp without time zone))::character varying)::text || '-01-01'::text))::date, ((((date_part('year'::text, (t.first_day)::timestamp without time zone))::character varying)::text || '-12-31'::text))::date, NULL::character varying, NULL::integer, NULL::character varying)
  • Buffers: shared hit=1780590
43. 20.496 23,014.446 ↑ 1.0 1 1,281

Aggregate (cost=13.00..13.01 rows=1 width=8) (actual time=17.966..17.966 rows=1 loops=1,281)

  • Output: count(DISTINCT fnresolucao195baseassunto_6.cdprocesso)
  • Buffers: shared hit=1738317
44. 22,993.950 22,993.950 ↓ 0.0 0 1,281

Function Scan on saj.fnresolucao195baseassunto fnresolucao195baseassunto_6 (cost=0.50..10.50 rows=1,000 width=32) (actual time=17.950..17.950 rows=0 loops=1,281)

  • Output: fnresolucao195baseassunto_6.cdprocesso
  • Function Call: fnresolucao195baseassunto(fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying), (t.cdlocal)::character varying, '920271'::character varying, t.cdassuntoext, t.first_day, t.last_day, NULL::character varying, NULL::integer, NULL::character varying)
  • Buffers: shared hit=1738317
45. 7.686 23,018.289 ↑ 1.0 1 1,281

Aggregate (cost=13.00..13.01 rows=1 width=8) (actual time=17.968..17.969 rows=1 loops=1,281)

  • Output: count(fnresolucao195baseassunto_7.cdprocesso)
  • Buffers: shared hit=1738317
46. 23,010.603 23,010.603 ↓ 0.0 0 1,281

Function Scan on saj.fnresolucao195baseassunto fnresolucao195baseassunto_7 (cost=0.50..10.50 rows=1,000 width=32) (actual time=17.963..17.963 rows=0 loops=1,281)

  • Output: fnresolucao195baseassunto_7.cdprocesso
  • Function Call: fnresolucao195baseassunto(fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying), (t.cdlocal)::character varying, '920271'::character varying, t.cdassuntoext, t.first_day, t.last_day, NULL::character varying, NULL::integer, NULL::character varying)
  • Buffers: shared hit=1738317
47. 11.529 29,542.422 ↑ 1.0 1 1,281

Aggregate (cost=23.04..23.05 rows=1 width=32) (actual time=23.062..23.062 rows=1 loops=1,281)

  • Output: COALESCE(sum(((count(*)) - 1)), '0'::numeric)
  • Buffers: shared hit=1738317
48. 6.405 29,530.893 ↓ 0.0 0 1,281

HashAggregate (cost=18.04..20.04 rows=200 width=40) (actual time=23.053..23.053 rows=0 loops=1,281)

  • Output: fnresolucao195baseassunto_8.cdprocesso, count(*)
  • Group Key: fnresolucao195baseassunto_8.cdprocesso
  • Filter: (count(*) > 1)
  • Buffers: shared hit=1738317
49. 29,524.488 29,524.488 ↓ 0.0 0 1,281

Function Scan on saj.fnresolucao195baseassunto fnresolucao195baseassunto_8 (cost=0.54..10.54 rows=1,000 width=32) (actual time=23.048..23.048 rows=0 loops=1,281)

  • Output: fnresolucao195baseassunto_8.cdprocesso
  • Function Call: fnresolucao195baseassunto(fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying), (t.cdlocal)::character varying, '920271'::character varying, t.cdassuntoext, ((((date_part('year'::text, (t.first_day)::timestamp without time zone))::character varying)::text || '-01-01'::text))::date, ((((date_part('year'::text, (t.first_day)::timestamp without time zone))::character varying)::text || '-12-31'::text))::date, NULL::character varying, NULL::integer, NULL::character varying)
  • Buffers: shared hit=1738317
50. 19.215 22,981.140 ↑ 1.0 1 1,281

Aggregate (cost=13.00..13.01 rows=1 width=8) (actual time=17.939..17.940 rows=1 loops=1,281)

  • Output: count(DISTINCT fnresolucao195baseassunto_9.cdprocesso)
  • Buffers: shared hit=1738317
51. 22,961.925 22,961.925 ↓ 0.0 0 1,281

Function Scan on saj.fnresolucao195baseassunto fnresolucao195baseassunto_9 (cost=0.50..10.50 rows=1,000 width=32) (actual time=17.925..17.925 rows=0 loops=1,281)

  • Output: fnresolucao195baseassunto_9.cdprocesso
  • Function Call: fnresolucao195baseassunto(fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying), (t.cdlocal)::character varying, '920270'::character varying, t.cdassuntoext, t.first_day, t.last_day, NULL::character varying, NULL::integer, NULL::character varying)
  • Buffers: shared hit=1738317
52. 6.405 23,064.405 ↑ 1.0 1 1,281

Aggregate (cost=13.00..13.01 rows=1 width=8) (actual time=18.005..18.005 rows=1 loops=1,281)

  • Output: count(fnresolucao195baseassunto_10.cdprocesso)
  • Buffers: shared hit=1738317
53. 23,058.000 23,058.000 ↓ 0.0 0 1,281

Function Scan on saj.fnresolucao195baseassunto fnresolucao195baseassunto_10 (cost=0.50..10.50 rows=1,000 width=32) (actual time=18.000..18.000 rows=0 loops=1,281)

  • Output: fnresolucao195baseassunto_10.cdprocesso
  • Function Call: fnresolucao195baseassunto(fngetvaluejsonparam('51524'::numeric, 'AnexoIIC'::character varying), (t.cdlocal)::character varying, '920270'::character varying, t.cdassuntoext, t.first_day, t.last_day, NULL::character varying, NULL::integer, NULL::character varying)
  • Buffers: shared hit=1738317
54. 11.529 29,585.976 ↑ 1.0 1 1,281

Aggregate (cost=23.04..23.05 rows=1 width=32) (actual time=23.095..23.096 rows=1 loops=1,281)

  • Output: COALESCE(sum(((count(*)) - 1)), '0'::numeric)
  • Buffers: shared hit=1738317
55. 6.405 29,574.447 ↓ 0.0 0 1,281

HashAggregate (cost=18.04..20.04 rows=200 width=40) (actual time=23.087..23.087 rows=0 loops=1,281)

  • Output: fnresolucao195baseassunto_11.cdprocesso, count(*)
  • Group Key: fnresolucao195baseassunto_11.cdprocesso
  • Filter: (count(*) > 1)
  • Buffers: shared hit=1738317
56. 29,568.042 29,568.042 ↓ 0.0 0 1,281

Function Scan on saj.fnresolucao195baseassunto fnresolucao195baseassunto_11 (cost=0.54..10.54 rows=1,000 width=32) (actual time=23.082..23.082 rows=0 loops=1,281)

  • Output: fnresolucao195baseassunto_11.cdprocesso