explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vsvfu

Settings
# exclusive inclusive rows x rows loops node
1. 0.068 855.050 ↑ 29.0 900 1

Append (cost=337.34..10,509,918.20 rows=26,060 width=700) (actual time=164.897..855.050 rows=900 loops=1)

2. 2.474 826.245 ↑ 52.6 491 1

Nested Loop (cost=337.34..10,460,449.11 rows=25,846 width=700) (actual time=164.897..826.245 rows=491 loops=1)

3. 0.371 805.604 ↑ 52.6 491 1

Hash Join (cost=337.05..5,213,067.04 rows=25,846 width=87) (actual time=164.699..805.604 rows=491 loops=1)

  • Hash Cond: ((em.em_fichaorc)::bigint = despesa.de_codigo)
4. 0.221 801.783 ↑ 52.6 491 1

Nested Loop (cost=0.71..5,212,375.32 rows=25,846 width=53) (actual time=161.184..801.783 rows=491 loops=1)

5. 103.188 800.580 ↑ 52.7 491 1

Index Scan using idx_empenho_ano on empenho em (cost=0.29..5,199,630.29 rows=25,854 width=45) (actual time=161.162..800.580 rows=491 loops=1)

  • Index Cond: ((em_ano)::integer < 2020)
  • Filter: ((((((em_valor)::numeric - (SubPlan 17)) - (SubPlan 19)) - (SubPlan 20)) + (SubPlan 21)) > 0.00)
  • Rows Removed by Filter: 76,997
6.          

SubPlan (for Index Scan)

7. 0.000 77.488 ↑ 1.0 1 77,488

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=77,488)

8. 77.488 77.488 ↓ 0.0 0 77,488

Index Scan using idx_fk_ae_empenho_auto on anulemp anulemp_2 (cost=0.28..8.30 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=77,488)

  • Index Cond: ((ae_empenho)::bigint = em.em_codigo)
  • Filter: ((ae_ano)::integer < 2020)
9. 51.898 464.928 ↑ 1.0 1 77,488

Aggregate (cost=41.98..41.99 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=77,488)

10. 43.456 309.952 ↑ 2.0 1 77,488

Nested Loop (cost=0.83..25.35 rows=2 width=14) (actual time=0.003..0.004 rows=1 loops=77,488)

11. 77.488 77.488 ↑ 2.0 1 77,488

Index Only Scan using idx_liquidacao_empenho on liquidacao liquidacao_4 (cost=0.42..8.45 rows=2 width=8) (actual time=0.001..0.001 rows=1 loops=77,488)

  • Index Cond: (li_empenho = em.em_codigo)
  • Heap Fetches: 811
12. 189.008 189.008 ↑ 1.0 1 94,504

Index Scan using idx_ordempag on ordempag op_2 (cost=0.42..8.44 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=94,504)

  • Index Cond: ((op_liquidacao)::bigint = liquidacao_4.li_codigo)
  • Filter: ((op_ano)::integer < 2020)
  • Rows Removed by Filter: 0
13.          

SubPlan (for Aggregate)

14. 0.000 103.078 ↑ 1.0 1 103,078

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=103,078)

15. 103.078 103.078 ↓ 0.0 0 103,078

Index Scan using idx_fk_eo_op_auto on estornoop estornoop_2 (cost=0.27..8.29 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=103,078)

  • Index Cond: ((eo_op)::bigint = op_2.op_codigo)
  • Filter: ((eo_ano)::integer < 2020)
16. 0.000 77.488 ↑ 1.0 1 77,488

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=77,488)

17. 77.488 77.488 ↓ 0.0 0 77,488

Index Scan using idx_fk_cs_empenho_auto on cancelarestos cancelarestos_4 (cost=0.27..8.30 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=77,488)

  • Index Cond: ((cs_empenho)::bigint = em.em_codigo)
  • Filter: (((cs_tipo)::bpchar < '3'::bpchar) AND ((cs_ano)::integer < 2020))
  • Rows Removed by Filter: 0
18. 0.000 77.488 ↑ 1.0 1 77,488

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=77,488)

19. 77.488 77.488 ↓ 0.0 0 77,488

Index Scan using idx_fk_cs_empenho_auto on cancelarestos cancelarestos_5 (cost=0.27..8.30 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=77,488)

  • Index Cond: ((cs_empenho)::bigint = em.em_codigo)
  • Filter: (((cs_ano)::integer <= 2,020) AND ((cs_tipo)::bpchar = '3'::bpchar))
  • Rows Removed by Filter: 0
20. 0.982 0.982 ↑ 1.0 1 491

Index Only Scan using uk_fonteemp on fonteemp f (cost=0.42..0.48 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=491)

  • Index Cond: (fe_empenho = em.em_codigo)
  • Heap Fetches: 0
21. 0.892 3.450 ↑ 1.0 4,618 1

Hash (cost=278.62..278.62 rows=4,618 width=50) (actual time=3.450..3.450 rows=4,618 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 443kB
22. 0.766 2.558 ↑ 1.0 4,618 1

Hash Join (cost=7.44..278.62 rows=4,618 width=50) (actual time=0.103..2.558 rows=4,618 loops=1)

  • Hash Cond: ((despesa.de_programa)::bigint = programa.pr_codigo)
23. 1.331 1.771 ↑ 1.0 4,618 1

Hash Join (cost=5.72..213.40 rows=4,618 width=54) (actual time=0.062..1.771 rows=4,618 loops=1)

  • Hash Cond: ((despesa.de_acao)::bigint = acao.ao_codigo)
24. 0.398 0.398 ↑ 1.0 4,618 1

Seq Scan on despesa (cost=0.00..144.18 rows=4,618 width=56) (actual time=0.007..0.398 rows=4,618 loops=1)

25. 0.015 0.042 ↑ 1.0 121 1

Hash (cost=4.21..4.21 rows=121 width=14) (actual time=0.042..0.042 rows=121 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
26. 0.027 0.027 ↑ 1.0 121 1

Seq Scan on acao (cost=0.00..4.21 rows=121 width=14) (actual time=0.005..0.027 rows=121 loops=1)

27. 0.006 0.021 ↑ 1.0 32 1

Hash (cost=1.32..1.32 rows=32 width=12) (actual time=0.021..0.021 rows=32 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
28. 0.015 0.015 ↑ 1.0 32 1

Seq Scan on programa (cost=0.00..1.32 rows=32 width=12) (actual time=0.008..0.015 rows=32 loops=1)

29. 1.473 1.473 ↑ 1.0 1 491

Index Scan using pk_pessoa on pessoa (cost=0.29..0.47 rows=1 width=49) (actual time=0.002..0.003 rows=1 loops=491)

  • Index Cond: (ps_codigo = (em.em_fornecedor)::bigint)
30.          

SubPlan (for Nested Loop)

31. 0.000 0.491 ↑ 1.0 1 491

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=491)

32. 0.491 0.491 ↓ 0.0 0 491

Index Scan using idx_fk_ae_empenho_auto on anulemp (cost=0.28..8.30 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=491)

  • Index Cond: ((ae_empenho)::bigint = em.em_codigo)
  • Filter: ((ae_ano)::integer < 2020)
33. 0.773 3.437 ↑ 1.0 1 491

Aggregate (cost=41.98..41.99 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=491)

34. 0.000 1.964 ↑ 2.0 1 491

Nested Loop (cost=0.83..25.35 rows=2 width=14) (actual time=0.003..0.004 rows=1 loops=491)

35. 0.491 0.491 ↑ 1.0 2 491

Index Only Scan using idx_liquidacao_empenho on liquidacao (cost=0.42..8.45 rows=2 width=8) (actual time=0.001..0.001 rows=2 loops=491)

  • Index Cond: (li_empenho = em.em_codigo)
  • Heap Fetches: 36
36. 1.562 1.562 ↑ 1.0 1 781

Index Scan using idx_ordempag on ordempag op (cost=0.42..8.44 rows=1 width=22) (actual time=0.001..0.002 rows=1 loops=781)

  • Index Cond: ((op_liquidacao)::bigint = liquidacao.li_codigo)
  • Filter: ((op_ano)::integer < 2020)
  • Rows Removed by Filter: 0
37.          

SubPlan (for Aggregate)

38. 0.000 0.700 ↑ 1.0 1 700

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=700)

39. 0.700 0.700 ↓ 0.0 0 700

Index Scan using idx_fk_eo_op_auto on estornoop (cost=0.27..8.29 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=700)

  • Index Cond: ((eo_op)::bigint = op.op_codigo)
  • Filter: ((eo_ano)::integer < 2020)
40. 0.735 2.946 ↑ 1.0 1 491

Aggregate (cost=33.67..33.69 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=491)

41. 0.000 1.964 ↑ 1.0 1 491

Nested Loop (cost=0.83..25.35 rows=1 width=14) (actual time=0.004..0.004 rows=1 loops=491)

42. 0.491 0.491 ↑ 1.0 2 491

Index Only Scan using idx_liquidacao_empenho on liquidacao liquidacao_1 (cost=0.42..8.45 rows=2 width=8) (actual time=0.001..0.001 rows=2 loops=491)

  • Index Cond: (li_empenho = em.em_codigo)
  • Heap Fetches: 36
43. 1.562 1.562 ↓ 0.0 0 781

Index Scan using idx_ordempag on ordempag op_1 (cost=0.42..8.44 rows=1 width=22) (actual time=0.002..0.002 rows=0 loops=781)

  • Index Cond: ((op_liquidacao)::bigint = liquidacao_1.li_codigo)
  • Filter: (((op_mes)::bpchar <= '03'::bpchar) AND ((op_ano)::integer = 2,020))
  • Rows Removed by Filter: 1
44.          

SubPlan (for Aggregate)

45. 0.000 0.247 ↑ 1.0 1 247

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=247)

46. 0.247 0.247 ↓ 0.0 0 247

Index Scan using idx_fk_eo_op_auto on estornoop estornoop_1 (cost=0.27..8.30 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=247)

  • Index Cond: ((eo_op)::bigint = op_1.op_codigo)
  • Filter: (((eo_mes)::bpchar <= '03'::bpchar) AND ((eo_ano)::integer = 2,020))
  • Rows Removed by Filter: 0
47. 0.000 0.491 ↑ 1.0 1 491

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=491)

48. 0.491 0.491 ↓ 0.0 0 491

Index Scan using idx_fk_cs_empenho_auto on cancelarestos (cost=0.27..8.30 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=491)

  • Index Cond: ((cs_empenho)::bigint = em.em_codigo)
  • Filter: (((cs_tipo)::bpchar < '3'::bpchar) AND ((cs_ano)::integer < 2020))
  • Rows Removed by Filter: 0
49. 0.000 0.491 ↑ 1.0 1 491

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=491)

50. 0.491 0.491 ↓ 0.0 0 491

Index Scan using idx_fk_cs_empenho_auto on cancelarestos cancelarestos_1 (cost=0.27..8.30 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=491)

  • Index Cond: ((cs_empenho)::bigint = em.em_codigo)
  • Filter: (((cs_tipo)::bpchar < '3'::bpchar) AND ((cs_mes)::bpchar <= '03'::bpchar) AND ((cs_ano)::integer = 2,020))
  • Rows Removed by Filter: 0
51. 0.479 2.455 ↑ 1.0 1 491

Aggregate (cost=17.28..17.30 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=491)

52. 1.964 1.964 ↓ 0.0 0 491

Index Scan using idx_fk_li_empenho_auto on liquidacao li (cost=0.42..8.96 rows=1 width=14) (actual time=0.004..0.004 rows=0 loops=491)

  • Index Cond: ((li_empenho)::bigint = em.em_codigo)
  • Filter: (((li_mes)::bpchar <= '03'::bpchar) AND ((li_ano)::integer = 2,020))
  • Rows Removed by Filter: 2
53.          

SubPlan (for Aggregate)

54. 0.006 0.012 ↑ 1.0 1 6

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=6)

55. 0.006 0.006 ↓ 0.0 0 6

Index Scan using idx_fk_al_liquidacao_auto on anulaliq (cost=0.28..8.30 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=6)

  • Index Cond: ((al_liquidacao)::bigint = li.li_codigo)
  • Filter: (((al_mes)::bpchar <= '03'::bpchar) AND ((al_ano)::integer = 2,020))
56. 0.699 2.455 ↑ 1.0 1 491

Aggregate (cost=25.59..25.61 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=491)

57. 0.982 0.982 ↑ 1.0 2 491

Index Scan using idx_fk_li_empenho_auto on liquidacao li_1 (cost=0.42..8.95 rows=2 width=14) (actual time=0.001..0.002 rows=2 loops=491)

  • Index Cond: ((li_empenho)::bigint = em.em_codigo)
  • Filter: ((li_ano)::integer < 2020)
  • Rows Removed by Filter: 0
58.          

SubPlan (for Aggregate)

59. 0.000 0.774 ↑ 1.0 1 774

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=774)

60. 0.774 0.774 ↓ 0.0 0 774

Index Scan using idx_fk_al_liquidacao_auto on anulaliq anulaliq_1 (cost=0.28..8.30 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=774)

  • Index Cond: ((al_liquidacao)::bigint = li_1.li_codigo)
  • Filter: ((al_ano)::integer < 2020)
  • Rows Removed by Filter: 0
61. 0.000 0.491 ↑ 1.0 1 491

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=491)

62. 0.491 0.491 ↓ 0.0 0 491

Index Scan using idx_fk_cs_empenho_auto on cancelarestos cancelarestos_2 (cost=0.27..8.30 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=491)

  • Index Cond: ((cs_empenho)::bigint = em.em_codigo)
  • Filter: (((cs_ano)::integer < 2020) AND ((cs_tipo)::bpchar = '3'::bpchar))
  • Rows Removed by Filter: 0
63. 0.000 0.491 ↑ 1.0 1 491

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=491)

64. 0.491 0.491 ↓ 0.0 0 491

Index Scan using idx_fk_cs_empenho_auto on cancelarestos cancelarestos_3 (cost=0.27..8.30 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=491)

  • Index Cond: ((cs_empenho)::bigint = em.em_codigo)
  • Filter: (((cs_mes)::bpchar <= '03'::bpchar) AND ((cs_tipo)::bpchar = '3'::bpchar) AND ((cs_ano)::integer = 2,020))
  • Rows Removed by Filter: 0
65. 0.000 0.982 ↑ 1.0 1 491

Aggregate (cost=8.96..8.97 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=491)

66. 0.982 0.982 ↑ 1.0 2 491

Index Scan using idx_fk_li_empenho_auto on liquidacao liquidacao_2 (cost=0.42..8.95 rows=2 width=6) (actual time=0.001..0.002 rows=2 loops=491)

  • Index Cond: ((li_empenho)::bigint = em.em_codigo)
  • Filter: ((li_ano)::integer < 2020)
  • Rows Removed by Filter: 0
67. 0.000 1.473 ↑ 1.0 1 491

Aggregate (cost=25.07..25.08 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=491)

68. 0.201 1.473 ↓ 0.0 0 491

Nested Loop (cost=0.70..25.07 rows=1 width=6) (actual time=0.003..0.003 rows=0 loops=491)

69. 0.491 0.491 ↑ 1.0 2 491

Index Only Scan using idx_liquidacao_empenho on liquidacao liquidacao_3 (cost=0.42..8.45 rows=2 width=8) (actual time=0.001..0.001 rows=2 loops=491)

  • Index Cond: (li_empenho = em.em_codigo)
  • Heap Fetches: 36
70. 0.781 0.781 ↓ 0.0 0 781

Index Scan using idx_fk_al_liquidacao_auto on anulaliq anulaliq_2 (cost=0.28..8.30 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=781)

  • Index Cond: ((al_liquidacao)::bigint = liquidacao_3.li_codigo)
  • Filter: ((al_ano)::integer < 2020)
  • Rows Removed by Filter: 0
71. 0.000 0.491 ↑ 1.0 1 491

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=491)

72. 0.491 0.491 ↓ 0.0 0 491

Index Scan using idx_fk_ae_empenho_auto on anulemp anulemp_1 (cost=0.28..8.30 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=491)

  • Index Cond: ((ae_empenho)::bigint = em.em_codigo)
  • Filter: ((ae_ano)::integer < 2020)
73. 1.273 28.737 ↓ 1.9 409 1

Hash Join (cost=682.76..49,208.49 rows=214 width=700) (actual time=5.486..28.737 rows=409 loops=1)

  • Hash Cond: ((despesa_1.de_programa)::bigint = programa_1.pr_codigo)
74. 0.132 20.487 ↓ 1.9 409 1

Hash Join (cost=681.04..31,136.56 rows=214 width=124) (actual time=5.382..20.487 rows=409 loops=1)

  • Hash Cond: ((despesa_1.de_acao)::bigint = acao_1.ao_codigo)
75. 0.237 20.307 ↓ 1.9 409 1

Hash Join (cost=675.32..31,127.89 rows=214 width=126) (actual time=5.320..20.307 rows=409 loops=1)

  • Hash Cond: ((em_1.em_fichaorc)::bigint = despesa_1.de_codigo)
76. 0.196 18.225 ↓ 1.9 409 1

Nested Loop (cost=473.42..30,923.04 rows=214 width=86) (actual time=3.423..18.225 rows=409 loops=1)

77. 0.273 17.211 ↓ 1.9 409 1

Nested Loop (cost=473.13..29,739.63 rows=214 width=53) (actual time=3.415..17.211 rows=409 loops=1)

78. 2.281 16.529 ↓ 1.9 409 1

Bitmap Heap Scan on empenho em_1 (cost=472.71..29,004.40 rows=214 width=45) (actual time=3.408..16.529 rows=409 loops=1)

  • Recheck Cond: (((em_ano)::integer = 2,020) AND ((em_mes)::bpchar <= '03'::bpchar))
  • Filter: ((((em_valor)::numeric - (SubPlan 28)) - (SubPlan 30)) > 0.00)
  • Rows Removed by Filter: 963
  • Heap Blocks: exact=420
79. 0.048 3.272 ↓ 0.0 0 1

BitmapAnd (cost=472.71..472.71 rows=641 width=0) (actual time=3.272..3.272 rows=0 loops=1)

80. 0.194 0.194 ↓ 1.0 2,324 1

Bitmap Index Scan on idx_empenho_ano (cost=0.00..45.11 rows=2,242 width=0) (actual time=0.194..0.194 rows=2,324 loops=1)

  • Index Cond: ((em_ano)::integer = 2,020)
81. 3.030 3.030 ↓ 1.0 22,890 1

Bitmap Index Scan on idx_empenho_mes (cost=0.00..427.25 rows=22,794 width=0) (actual time=3.029..3.030 rows=22,890 loops=1)

  • Index Cond: ((em_mes)::bpchar <= '03'::bpchar)
82.          

SubPlan (for Bitmap Heap Scan)

83. 0.000 1.372 ↑ 1.0 1 1,372

Aggregate (cost=8.31..8.32 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1,372)

84. 1.372 1.372 ↓ 0.0 0 1,372

Index Scan using idx_fk_ae_empenho_auto on anulemp anulemp_5 (cost=0.28..8.30 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=1,372)

  • Index Cond: ((ae_empenho)::bigint = em_1.em_codigo)
  • Filter: (((ae_mes)::bpchar <= '03'::bpchar) AND ((ae_ano)::integer = 2,020))
  • Rows Removed by Filter: 0
85. 1.056 9.604 ↑ 1.0 1 1,372

Aggregate (cost=33.67..33.69 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=1,372)

86. 1.634 6.860 ↑ 1.0 1 1,372

Nested Loop (cost=0.83..25.35 rows=1 width=14) (actual time=0.004..0.005 rows=1 loops=1,372)

87. 1.372 1.372 ↑ 2.0 1 1,372

Index Only Scan using idx_liquidacao_empenho on liquidacao liquidacao_8 (cost=0.42..8.45 rows=2 width=8) (actual time=0.001..0.001 rows=1 loops=1,372)

  • Index Cond: (li_empenho = em_1.em_codigo)
  • Heap Fetches: 319
88. 3.854 3.854 ↑ 1.0 1 1,927

Index Scan using idx_ordempag on ordempag op_4 (cost=0.42..8.44 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=1,927)

  • Index Cond: ((op_liquidacao)::bigint = liquidacao_8.li_codigo)
  • Filter: (((op_mes)::bpchar <= '03'::bpchar) AND ((op_ano)::integer = 2,020))
  • Rows Removed by Filter: 0
89.          

SubPlan (for Aggregate)

90. 0.000 1.688 ↑ 1.0 1 1,688

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1,688)

91. 1.688 1.688 ↓ 0.0 0 1,688

Index Scan using idx_fk_eo_op_auto on estornoop estornoop_4 (cost=0.27..8.30 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=1,688)

  • Index Cond: ((eo_op)::bigint = op_4.op_codigo)
  • Filter: (((eo_mes)::bpchar <= '03'::bpchar) AND ((eo_ano)::integer = 2,020))
  • Rows Removed by Filter: 0
92. 0.409 0.409 ↑ 1.0 1 409

Index Only Scan using uk_fonteemp on fonteemp f_1 (cost=0.42..3.43 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=409)

  • Index Cond: (fe_empenho = em_1.em_codigo)
  • Heap Fetches: 0
93. 0.818 0.818 ↑ 1.0 1 409

Index Scan using pk_pessoa on pessoa pessoa_1 (cost=0.29..5.52 rows=1 width=49) (actual time=0.002..0.002 rows=1 loops=409)

  • Index Cond: (ps_codigo = (em_1.em_fornecedor)::bigint)
94. 0.908 1.845 ↑ 1.0 4,618 1

Hash (cost=144.18..144.18 rows=4,618 width=56) (actual time=1.845..1.845 rows=4,618 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 461kB
95. 0.937 0.937 ↑ 1.0 4,618 1

Seq Scan on despesa despesa_1 (cost=0.00..144.18 rows=4,618 width=56) (actual time=0.006..0.937 rows=4,618 loops=1)

96. 0.018 0.048 ↑ 1.0 121 1

Hash (cost=4.21..4.21 rows=121 width=14) (actual time=0.048..0.048 rows=121 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
97. 0.030 0.030 ↑ 1.0 121 1

Seq Scan on acao acao_1 (cost=0.00..4.21 rows=121 width=14) (actual time=0.007..0.030 rows=121 loops=1)

98. 0.009 0.024 ↑ 1.0 32 1

Hash (cost=1.32..1.32 rows=32 width=12) (actual time=0.024..0.024 rows=32 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
99. 0.015 0.015 ↑ 1.0 32 1

Seq Scan on programa programa_1 (cost=0.00..1.32 rows=32 width=12) (actual time=0.009..0.015 rows=32 loops=1)

100.          

SubPlan (for Hash Join)

101. 0.000 0.409 ↑ 1.0 1 409

Aggregate (cost=8.31..8.32 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=409)

102. 0.409 0.409 ↓ 0.0 0 409

Index Scan using idx_fk_ae_empenho_auto on anulemp anulemp_3 (cost=0.28..8.30 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=409)

  • Index Cond: ((ae_empenho)::bigint = em_1.em_codigo)
  • Filter: (((ae_mes)::bpchar <= '03'::bpchar) AND ((ae_ano)::integer = 2,020))
  • Rows Removed by Filter: 0
103. 0.435 2.863 ↑ 1.0 1 409

Aggregate (cost=33.67..33.69 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=409)

104. 0.000 2.045 ↑ 1.0 1 409

Nested Loop (cost=0.83..25.35 rows=1 width=14) (actual time=0.003..0.005 rows=1 loops=409)

105. 0.409 0.409 ↑ 1.0 2 409

Index Only Scan using idx_liquidacao_empenho on liquidacao liquidacao_5 (cost=0.42..8.45 rows=2 width=8) (actual time=0.001..0.001 rows=2 loops=409)

  • Index Cond: (li_empenho = em_1.em_codigo)
  • Heap Fetches: 231
106. 1.850 1.850 ↓ 0.0 0 925

Index Scan using idx_ordempag on ordempag op_3 (cost=0.42..8.44 rows=1 width=22) (actual time=0.001..0.002 rows=0 loops=925)

  • Index Cond: ((op_liquidacao)::bigint = liquidacao_5.li_codigo)
  • Filter: (((op_mes)::bpchar <= '03'::bpchar) AND ((op_ano)::integer = 2,020))
  • Rows Removed by Filter: 1
107.          

SubPlan (for Aggregate)

108. 0.000 0.383 ↑ 1.0 1 383

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=383)

109. 0.383 0.383 ↓ 0.0 0 383

Index Scan using idx_fk_eo_op_auto on estornoop estornoop_3 (cost=0.27..8.30 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=383)

  • Index Cond: ((eo_op)::bigint = op_3.op_codigo)
  • Filter: (((eo_mes)::bpchar <= '03'::bpchar) AND ((eo_ano)::integer = 2,020))
  • Rows Removed by Filter: 0
110. 0.409 1.636 ↑ 1.0 1 409

Aggregate (cost=8.96..8.97 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=409)

111. 1.227 1.227 ↑ 1.0 1 409

Index Scan using idx_fk_li_empenho_auto on liquidacao liquidacao_6 (cost=0.42..8.96 rows=1 width=6) (actual time=0.002..0.003 rows=1 loops=409)

  • Index Cond: ((li_empenho)::bigint = em_1.em_codigo)
  • Filter: (((li_mes)::bpchar <= '03'::bpchar) AND ((li_ano)::integer = 2,020))
  • Rows Removed by Filter: 1
112. 0.409 1.636 ↑ 1.0 1 409

Aggregate (cost=25.08..25.09 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=409)

113. 0.000 1.227 ↓ 0.0 0 409

Nested Loop (cost=0.70..25.07 rows=1 width=6) (actual time=0.003..0.003 rows=0 loops=409)

114. 0.409 0.409 ↑ 1.0 2 409

Index Only Scan using idx_liquidacao_empenho on liquidacao liquidacao_7 (cost=0.42..8.45 rows=2 width=8) (actual time=0.001..0.001 rows=2 loops=409)

  • Index Cond: (li_empenho = em_1.em_codigo)
  • Heap Fetches: 231
115. 0.925 0.925 ↓ 0.0 0 925

Index Scan using idx_fk_al_liquidacao_auto on anulaliq anulaliq_3 (cost=0.28..8.30 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=925)

  • Index Cond: ((al_liquidacao)::bigint = liquidacao_7.li_codigo)
  • Filter: (((al_mes)::bpchar <= '03'::bpchar) AND ((al_ano)::integer = 2,020))
  • Rows Removed by Filter: 0
116. 0.000 0.409 ↑ 1.0 1 409

Aggregate (cost=8.31..8.32 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=409)

117. 0.409 0.409 ↓ 0.0 0 409

Index Scan using idx_fk_ae_empenho_auto on anulemp anulemp_4 (cost=0.28..8.30 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=409)

  • Index Cond: ((ae_empenho)::bigint = em_1.em_codigo)
  • Filter: (((ae_mes)::bpchar <= '03'::bpchar) AND ((ae_ano)::integer = 2,020))
  • Rows Removed by Filter: 0