explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b7vj

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 996.527 ↓ 10.0 10 1

Limit (cost=465.86..465.86 rows=1 width=320) (actual time=996.526..996.527 rows=10 loops=1)

2.          

Initplan (forLimit)

3. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on tb_tipo_customizacao (cost=0.00..1.66 rows=1 width=3) (actual time=0.005..0.007 rows=1 loops=1)

  • Filter: ((id_customizacao = 20) AND (ativo = 'S'::bpchar))
  • Rows Removed by Filter: 43
4. 0.000 0.008 ↑ 1.0 1 1

Aggregate (cost=16.60..16.61 rows=1 width=0) (actual time=0.008..0.008 rows=1 loops=1)

5.          

Initplan (forAggregate)

6. 0.005 0.005 ↓ 0.0 0 1

Index Scan using pk_tb_convenio_edicao on tb_convenio_edicao (cost=0.28..8.30 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (id_convenio_edicao = 55452)
7. 0.006 0.006 ↓ 0.0 0 1

Index Only Scan using idx_tb_plt_convenio_id_convenio on tb_plt_convenio (cost=0.28..8.30 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (id_convenio = $15)
  • Heap Fetches: 0
8. 1.345 996.524 ↓ 120.0 120 1

Sort (cost=447.59..447.59 rows=1 width=320) (actual time=996.518..996.524 rows=120 loops=1)

  • Sort Key: ipdc.dt_prestacao, forn.ds_razao_social, ipdc.vlr_despesa
  • Sort Method: quicksort Memory: 141kB
9. 11.473 995.179 ↓ 225.0 225 1

Nested Loop Left Join (cost=20.22..447.58 rows=1 width=320) (actual time=3.396..995.179 rows=225 loops=1)

10. 0.379 8.443 ↓ 225.0 225 1

Nested Loop Left Join (cost=20.08..51.83 rows=1 width=303) (actual time=0.185..8.443 rows=225 loops=1)

11. 0.369 5.364 ↓ 225.0 225 1

Nested Loop Left Join (cost=19.81..50.38 rows=1 width=281) (actual time=0.177..5.364 rows=225 loops=1)

12. 0.326 4.545 ↓ 225.0 225 1

Nested Loop Left Join (cost=19.67..50.19 rows=1 width=251) (actual time=0.158..4.545 rows=225 loops=1)

13. 0.325 3.544 ↓ 225.0 225 1

Nested Loop Left Join (cost=19.40..49.17 rows=1 width=221) (actual time=0.151..3.544 rows=225 loops=1)

14. 0.347 2.094 ↓ 225.0 225 1

Nested Loop Left Join (cost=19.11..43.10 rows=1 width=164) (actual time=0.144..2.094 rows=225 loops=1)

15. 0.295 0.847 ↓ 225.0 225 1

Nested Loop (cost=18.83..38.90 rows=1 width=156) (actual time=0.131..0.847 rows=225 loops=1)

16. 0.002 0.025 ↑ 1.0 1 1

Nested Loop (cost=0.58..16.63 rows=1 width=24) (actual time=0.022..0.025 rows=1 loops=1)

17. 0.014 0.014 ↑ 1.0 1 1

Index Scan using pk_tb_ed_item_pdc on tb_edicao_pdc epdc (cost=0.29..8.31 rows=1 width=8) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (id_edicao_pdc = 55452)
18. 0.009 0.009 ↑ 1.0 1 1

Index Scan using idx_id_prestacao_contas1 on tb_prestacao_contas pdc (cost=0.29..8.31 rows=1 width=16) (actual time=0.007..0.009 rows=1 loops=1)

  • Index Cond: (id_prestacao_contas = epdc.id_prestacao_contas)
19. 0.437 0.527 ↓ 225.0 225 1

Bitmap Heap Scan on tb_item_pdc ipdc (cost=18.25..22.27 rows=1 width=140) (actual time=0.104..0.527 rows=225 loops=1)

  • Recheck Cond: ((id_prestacao_contas = pdc.id_prestacao_contas) AND (id_edicao_pdc = 55452))
  • Filter: (NOT (hashed SubPlan 24))
20. 0.009 0.083 ↓ 0.0 0 1

BitmapAnd (cost=9.80..9.80 rows=1 width=0) (actual time=0.083..0.083 rows=0 loops=1)

21. 0.048 0.048 ↓ 1.2 450 1

Bitmap Index Scan on fki_id_prestacao_contas (cost=0.00..4.11 rows=362 width=0) (actual time=0.048..0.048 rows=450 loops=1)

  • Index Cond: (id_prestacao_contas = pdc.id_prestacao_contas)
22. 0.026 0.026 ↓ 1.7 225 1

Bitmap Index Scan on idx_id_edicao_pdc (cost=0.00..5.42 rows=133 width=0) (actual time=0.026..0.026 rows=225 loops=1)

  • Index Cond: (id_edicao_pdc = 55452)
23.          

SubPlan (forBitmap Heap Scan)

24. 0.007 0.007 ↓ 0.0 0 1

Index Scan using idx_tb_status_item_pdc_id_status_item on tb_status_item_pdc tb_status_item_pdc_8 (cost=0.43..8.45 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (id_status_item = 4)
25. 0.900 0.900 ↓ 0.0 0 225

Index Scan using idx_tb_pdc_movto on tb_pdc_movto pmovto (cost=0.29..4.18 rows=1 width=12) (actual time=0.004..0.004 rows=0 loops=225)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
26. 1.125 1.125 ↑ 1.0 1 225

Index Scan using pk_tb_fornecedor on tb_fornecedor forn (cost=0.29..6.06 rows=1 width=61) (actual time=0.004..0.005 rows=1 loops=225)

  • Index Cond: (ipdc.id_fornecedor = id_fornecedor)
27. 0.675 0.675 ↑ 1.0 1 225

Index Scan using idx_id_item_despesa1 on tb_item_despesa item_desp (cost=0.27..1.02 rows=1 width=30) (actual time=0.002..0.003 rows=1 loops=225)

  • Index Cond: (ipdc.id_item_despesa = id_item_despesa)
28. 0.450 0.450 ↑ 1.0 1 225

Index Scan using pk_tb_despesas on tb_despesa desp (cost=0.14..0.18 rows=1 width=30) (actual time=0.002..0.002 rows=1 loops=225)

  • Index Cond: (id_despesa = item_desp.id_despesa)
29. 2.700 2.700 ↑ 1.0 1 225

Index Scan using pk_tb_usuario on tb_usuario usu (cost=0.28..1.44 rows=1 width=30) (actual time=0.011..0.012 rows=1 loops=225)

  • Index Cond: (id_usuario = ipdc.id_usu_analise)
30. 3.375 3.375 ↑ 1.0 1 225

Index Scan using pk_tb_tipo_doc on tb_tipo_doc doc (cost=0.14..0.33 rows=1 width=21) (actual time=0.014..0.015 rows=1 loops=225)

  • Index Cond: (id_tipo_doc = ipdc.id_tipo_doc)
31.          

SubPlan (forNested Loop Left Join)

32. 3.150 3.150 ↑ 1.0 1 225

Index Scan using pk_tb_item_prestacao_contas on tb_item_pdc (cost=0.43..8.45 rows=1 width=116) (actual time=0.013..0.014 rows=1 loops=225)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
33. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_tb_item_prestacao_contas on tb_item_pdc tb_item_pdc_2 (cost=23.93..31.95 rows=1 width=116) (never executed)

  • Index Cond: (id_item_pdc = $2)
34.          

Initplan (forIndex Scan)

35. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=23.49..23.50 rows=1 width=4) (never executed)

36. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_id_item on tb_item_pdc tb_item_pdc_1 (cost=0.43..23.49 rows=2 width=4) (never executed)

  • Index Cond: (id_item = ipdc.id_item)
  • Filter: ((ds_analise IS NOT NULL) AND (ds_analise <> ''::text))
37. 0.450 0.450 ↑ 1.0 1 225

Index Scan using pk_tb_item_prestacao_contas on tb_item_pdc tb_item_pdc_3 (cost=0.43..8.45 rows=1 width=116) (actual time=0.002..0.002 rows=1 loops=225)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
38. 0.450 1.800 ↑ 1.0 1 225

Aggregate (cost=8.48..8.49 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=225)

39. 1.350 1.350 ↑ 2.0 1 225

Index Only Scan using fki_id_item_pdc on tb_status_item_pdc (cost=0.43..8.48 rows=2 width=4) (actual time=0.005..0.006 rows=1 loops=225)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
  • Heap Fetches: 249
40. 0.405 6.765 ↑ 2.0 1 205

Hash Join (cost=1.56..9.64 rows=2 width=9) (actual time=0.033..0.033 rows=1 loops=205)

  • Hash Cond: (stp.id_status_item = st.id_status_item)
41. 6.355 6.355 ↑ 2.0 1 205

Index Scan using fki_id_item_pdc on tb_status_item_pdc stp (cost=0.43..8.48 rows=2 width=4) (actual time=0.030..0.031 rows=1 loops=205)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
42. 0.003 0.005 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=13) (actual time=0.005..0.005 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
43. 0.002 0.002 ↑ 1.0 6 1

Seq Scan on tb_status_item st (cost=0.00..1.06 rows=6 width=13) (actual time=0.002..0.002 rows=6 loops=1)

44. 0.450 0.900 ↑ 1.0 1 225

Aggregate (cost=8.48..8.49 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=225)

45. 0.450 0.450 ↑ 2.0 1 225

Index Only Scan using fki_id_item_pdc on tb_status_item_pdc tb_status_item_pdc_1 (cost=0.43..8.48 rows=2 width=4) (actual time=0.002..0.002 rows=1 loops=225)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
  • Heap Fetches: 249
46. 0.202 0.615 ↑ 2.0 1 205

Hash Join (cost=1.56..9.64 rows=2 width=4) (actual time=0.003..0.003 rows=1 loops=205)

  • Hash Cond: (stp_1.id_status_item = st_1.id_status_item)
47. 0.410 0.410 ↑ 2.0 1 205

Index Scan using fki_id_item_pdc on tb_status_item_pdc stp_1 (cost=0.43..8.48 rows=2 width=4) (actual time=0.002..0.002 rows=1 loops=205)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
48. 0.002 0.003 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=4) (actual time=0.003..0.003 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
49. 0.001 0.001 ↑ 1.0 6 1

Seq Scan on tb_status_item st_1 (cost=0.00..1.06 rows=6 width=4) (actual time=0.001..0.001 rows=6 loops=1)

50. 0.450 0.900 ↑ 1.0 1 225

Aggregate (cost=8.49..8.50 rows=1 width=6) (actual time=0.004..0.004 rows=1 loops=225)

51. 0.450 0.450 ↑ 1.0 1 225

Index Scan using fki_id_item_pdc on tb_status_item_pdc tb_status_item_pdc_2 (cost=0.43..8.48 rows=1 width=6) (actual time=0.002..0.002 rows=1 loops=225)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
  • Filter: (id_status_item = 1)
  • Rows Removed by Filter: 0
52. 0.000 12.600 ↑ 1.0 1 225

Aggregate (cost=8.49..8.50 rows=1 width=6) (actual time=0.056..0.056 rows=1 loops=225)

53. 12.600 12.600 ↓ 0.0 0 225

Index Scan using fki_id_item_pdc on tb_status_item_pdc tb_status_item_pdc_3 (cost=0.43..8.48 rows=1 width=6) (actual time=0.056..0.056 rows=0 loops=225)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
  • Filter: (id_status_item = 2)
  • Rows Removed by Filter: 1
54. 0.225 1.125 ↑ 1.0 1 225

Aggregate (cost=8.49..8.50 rows=1 width=6) (actual time=0.005..0.005 rows=1 loops=225)

55. 0.900 0.900 ↓ 0.0 0 225

Index Scan using fki_id_item_pdc on tb_status_item_pdc tb_status_item_pdc_4 (cost=0.43..8.48 rows=1 width=6) (actual time=0.004..0.004 rows=0 loops=225)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
  • Filter: (id_status_item = 5)
  • Rows Removed by Filter: 1
56. 0.225 0.675 ↑ 1.0 1 225

Aggregate (cost=8.49..8.50 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=225)

57. 0.450 0.450 ↓ 0.0 0 225

Index Scan using fki_id_item_pdc on tb_status_item_pdc tb_status_item_pdc_5 (cost=0.43..8.48 rows=1 width=6) (actual time=0.002..0.002 rows=0 loops=225)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
  • Filter: (id_status_item = 6)
  • Rows Removed by Filter: 1
58. 1.125 1.125 ↑ 1.0 1 225

Seq Scan on tb_tipo_doc_unidade (cost=0.00..1.21 rows=1 width=2) (actual time=0.003..0.005 rows=1 loops=225)

  • Filter: ((id_tipo_doc = ipdc.id_tipo_doc) AND (flg_status = 'A'::bpchar) AND (id_unidade_adm = 2))
  • Rows Removed by Filter: 11
59. 0.450 6.975 ↑ 1.0 1 225

Aggregate (cost=8.48..8.49 rows=1 width=6) (actual time=0.031..0.031 rows=1 loops=225)

60. 6.525 6.525 ↑ 2.0 1 225

Index Scan using fki_id_item_pdc on tb_status_item_pdc tb_status_item_pdc_6 (cost=0.43..8.48 rows=2 width=6) (actual time=0.029..0.029 rows=1 loops=225)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
61. 0.450 22.950 ↑ 1.0 1 225

Result (cost=16.73..16.75 rows=1 width=0) (actual time=0.102..0.102 rows=1 loops=225)

62.          

Initplan (forResult)

63. 0.900 22.500 ↑ 1.0 1 225

Aggregate (cost=16.72..16.73 rows=1 width=0) (actual time=0.100..0.100 rows=1 loops=225)

64. 0.225 21.600 ↓ 0.0 0 225

HashAggregate (cost=16.70..16.71 rows=1 width=60) (actual time=0.096..0.096 rows=0 loops=225)

65. 20.025 21.375 ↓ 0.0 0 225

Nested Loop (cost=8.64..16.70 rows=1 width=60) (actual time=0.095..0.095 rows=0 loops=225)

66. 0.675 1.350 ↑ 1.0 1 225

HashAggregate (cost=8.49..8.50 rows=1 width=10) (actual time=0.006..0.006 rows=1 loops=225)

67. 0.675 0.675 ↑ 2.0 1 225

Index Scan using fki_id_item_pdc on tb_status_item_pdc sip (cost=0.43..8.48 rows=2 width=10) (actual time=0.002..0.003 rows=1 loops=225)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
68. 0.000 0.000 ↓ 0.0 0 225

Index Scan using pk_tb_pdc_fr on tb_pdc_fr (cost=0.15..8.18 rows=1 width=32) (actual time=0.000..0.000 rows=0 loops=225)

  • Index Cond: (id_pdc_fr = sip.id_pdc_fr)
  • Filter: ((id_item_pdc = ipdc.id_item_pdc) AND CASE WHEN ((sum(sip.vlr_item)) <> valor) THEN true ELSE false END)
69. 336.879 885.150 ↓ 70.0 70 225

Nested Loop (cost=2.10..100.05 rows=1 width=4) (actual time=2.361..3.934 rows=70 loops=225)

  • Join Filter: (i.id_item_despesa = du.id_item_despesa)
  • Rows Removed by Join Filter: 11478
70. 10.575 10.575 ↓ 1.4 66 225

Seq Scan on tb_despesa_unidade du (cost=0.00..9.55 rows=48 width=8) (actual time=0.005..0.047 rows=66 loops=225)

  • Filter: ((id_despesa = item_desp.id_despesa) AND (id_unidade_adm = 2))
  • Rows Removed by Filter: 104
71. 216.171 537.696 ↓ 14.5 174 14,936

Materialize (cost=2.10..81.88 rows=12 width=12) (actual time=0.003..0.036 rows=174 loops=14,936)

72. 18.071 321.525 ↓ 12.8 153 225

Nested Loop (cost=2.10..81.82 rows=12 width=12) (actual time=0.165..1.429 rows=153 loops=225)

73. 13.050 166.050 ↓ 12.8 153 225

Nested Loop (cost=1.82..78.14 rows=12 width=8) (actual time=0.161..0.738 rows=153 loops=225)

74. 0.675 0.675 ↑ 1.0 1 225

Seq Scan on tb_despesa d (cost=0.00..1.14 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=225)

  • Filter: (id_despesa = item_desp.id_despesa)
  • Rows Removed by Filter: 10
75. 6.813 152.325 ↓ 12.8 153 225

Nested Loop (cost=1.82..76.88 rows=12 width=8) (actual time=0.118..0.677 rows=153 loops=225)

76. 1.317 94.500 ↓ 2.4 19 225

Nested Loop (cost=1.41..62.59 rows=8 width=4) (actual time=0.109..0.420 rows=19 loops=225)

77. 0.988 59.175 ↓ 2.7 19 225

Nested Loop (cost=1.12..59.89 rows=7 width=4) (actual time=0.046..0.263 rows=19 loops=225)

78. 0.984 42.075 ↓ 3.0 18 225

Nested Loop (cost=0.84..56.97 rows=6 width=4) (actual time=0.042..0.187 rows=18 loops=225)

79. 0.765 22.275 ↑ 1.0 6 225

Nested Loop (cost=0.56..54.30 rows=6 width=8) (actual time=0.020..0.099 rows=6 loops=225)

80. 1.350 1.350 ↑ 1.0 6 225

Index Scan using idx_tb_plt_convenio_id_convenio on tb_plt_convenio plt_conv (cost=0.28..8.44 rows=6 width=4) (actual time=0.004..0.006 rows=6 loops=225)

  • Index Cond: (id_convenio = 2373)
81. 20.160 20.160 ↑ 1.0 1 1,344

Index Only Scan using pk_tb_plano_trabalho on tb_plt_entidade plt (cost=0.28..7.63 rows=1 width=4) (actual time=0.015..0.015 rows=1 loops=1,344)

  • Index Cond: (id_plt_entidade = plt_conv.id_plt_entidade)
  • Heap Fetches: 1344
82. 18.816 18.816 ↓ 3.0 3 1,344

Index Scan using idx_tb_plt_edicao_id_plt_entidade on tb_plt_edicao plt_ed (cost=0.28..0.43 rows=1 width=8) (actual time=0.008..0.014 rows=3 loops=1,344)

  • Index Cond: (id_plt_entidade = plt.id_plt_entidade)
  • Filter: (id_status_plt = 5)
  • Rows Removed by Filter: 2
83. 16.112 16.112 ↑ 1.0 1 4,028

Index Scan using idx_tb_item_plt_id_plt_edicao on tb_item_plt item (cost=0.28..0.48 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=4,028)

  • Index Cond: (id_plt_edicao = plt_ed.id_plt_edicao)
84. 34.008 34.008 ↑ 1.0 1 4,251

Index Scan using idx_tb_subitem_plt_id_item_plt on tb_subitem_plt sub (cost=0.28..0.38 rows=1 width=8) (actual time=0.007..0.008 rows=1 loops=4,251)

  • Index Cond: (id_item_plt = item.id_item_plt)
85. 51.012 51.012 ↓ 4.0 8 4,251

Index Scan using idx_tb_desp_subitem_id_subitem_plt on tb_desp_subitem desp_1 (cost=0.42..1.77 rows=2 width=12) (actual time=0.008..0.012 rows=8 loops=4,251)

  • Index Cond: (id_subitem_plt = sub.id_subitem_plt)
  • Filter: (id_despesa = item_desp.id_despesa)
  • Rows Removed by Filter: 16
86. 137.404 137.404 ↑ 1.0 1 34,351

Index Only Scan using idx_id_item_despesa1 on tb_item_despesa i (cost=0.27..0.30 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=34,351)

  • Index Cond: (id_item_despesa = desp_1.id_item_despesa)
  • Heap Fetches: 34351
87. 0.050 25.808 ↓ 4.0 4 8

Nested Loop (cost=29.15..346.98 rows=1 width=4) (actual time=3.056..3.226 rows=4 loops=8)

88. 0.083 25.584 ↓ 4.0 4 8

Nested Loop (cost=28.88..346.58 rows=1 width=8) (actual time=3.049..3.198 rows=4 loops=8)

89. 0.033 25.240 ↓ 4.0 4 8

Nested Loop (cost=28.88..345.43 rows=1 width=16) (actual time=3.015..3.155 rows=4 loops=8)

  • Join Filter: (plt_conv_1.id_plt_entidade = plt_1.id_plt_entidade)
90. 1.852 25.120 ↓ 4.0 4 8

Nested Loop (cost=28.60..344.96 rows=1 width=24) (actual time=3.007..3.140 rows=4 loops=8)

  • Join Filter: (ped.id_plt_entidade = plt_conv_1.id_plt_entidade)
  • Rows Removed by Join Filter: 1823
91. 1.420 20.832 ↓ 13.2 304 8

Nested Loop (cost=28.32..334.44 rows=23 width=20) (actual time=0.493..2.604 rows=304 loops=8)

92. 2.376 8.192 ↓ 6.5 351 8

Hash Join (cost=28.04..297.84 rows=54 width=20) (actual time=0.483..1.024 rows=351 loops=8)

  • Hash Cond: (item_ped_nova.id_item_despesa_nova = du_1.id_item_despesa)
93. 2.384 3.080 ↑ 1.3 351 8

Bitmap Heap Scan on tb_item_pedido_nova item_ped_nova (cost=17.88..284.84 rows=460 width=12) (actual time=0.125..0.385 rows=351 loops=8)

  • Recheck Cond: (id_despesa_nova = item_desp.id_despesa)
  • Filter: (id_status_item_ped = 2)
  • Rows Removed by Filter: 202
94. 0.696 0.696 ↓ 1.3 969 8

Bitmap Index Scan on idx_tb_item_pedido_nova_id_despesa_nova (cost=0.00..17.77 rows=731 width=0) (actual time=0.087..0.087 rows=969 loops=8)

  • Index Cond: (id_despesa_nova = item_desp.id_despesa)
95. 0.088 2.736 ↓ 1.1 53 8

Hash (cost=9.55..9.55 rows=48 width=8) (actual time=0.342..0.342 rows=53 loops=8)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
96. 2.648 2.648 ↓ 1.1 53 8

Seq Scan on tb_despesa_unidade du_1 (cost=0.00..9.55 rows=48 width=8) (actual time=0.284..0.331 rows=53 loops=8)

  • Filter: ((id_despesa = item_desp.id_despesa) AND (id_unidade_adm = 2))
  • Rows Removed by Filter: 384
97. 11.220 11.220 ↑ 1.0 1 2,805

Index Scan using pk_tb_pedido_alteracao on tb_pedido_alteracao ped (cost=0.28..0.67 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=2,805)

  • Index Cond: (id_pedido_alteracao = item_ped_nova.id_pedido_alteracao)
  • Filter: (id_status_ped = 3)
  • Rows Removed by Filter: 0
98. 2.431 2.436 ↑ 1.0 6 2,436

Materialize (cost=0.28..8.47 rows=6 width=4) (actual time=0.000..0.001 rows=6 loops=2,436)

99. 0.005 0.005 ↑ 1.0 6 1

Index Scan using idx_tb_plt_convenio_id_convenio on tb_plt_convenio plt_conv_1 (cost=0.28..8.44 rows=6 width=4) (actual time=0.003..0.005 rows=6 loops=1)

  • Index Cond: (id_convenio = 2373)
100. 0.087 0.087 ↑ 1.0 1 29

Index Only Scan using pk_tb_plano_trabalho on tb_plt_entidade plt_1 (cost=0.28..0.46 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=29)

  • Index Cond: (id_plt_entidade = ped.id_plt_entidade)
  • Heap Fetches: 29
101. 0.261 0.261 ↑ 1.0 1 29

Seq Scan on tb_despesa d_1 (cost=0.00..1.14 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=29)

  • Filter: (id_despesa = item_desp.id_despesa)
  • Rows Removed by Filter: 8
102. 0.174 0.174 ↑ 1.0 1 29

Index Only Scan using idx_id_item_despesa1 on tb_item_despesa i_1 (cost=0.27..0.40 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=29)

  • Index Cond: (id_item_despesa = item_ped_nova.id_item_despesa_nova)
  • Heap Fetches: 29
103. 0.900 0.900 ↑ 1.0 1 225

Seq Scan on tb_status_pdc (cost=0.00..1.05 rows=1 width=2) (actual time=0.004..0.004 rows=1 loops=225)

  • Filter: (id_status_pdc = epdc.id_status_pdc)
  • Rows Removed by Filter: 3
104. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=9.62..9.63 rows=1 width=0) (never executed)

105. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=0.43..9.62 rows=1 width=0) (never executed)

  • Join Filter: (tb_status_item_pdc_7.id_status_item = tb_status_item.id_status_item)
106. 0.000 0.000 ↓ 0.0 0

Index Scan using fki_id_item_pdc on tb_status_item_pdc tb_status_item_pdc_7 (cost=0.43..8.48 rows=2 width=4) (never executed)

  • Index Cond: (id_item_pdc = ipdc.id_item_pdc)
107. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.08 rows=2 width=4) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Seq Scan on tb_status_item (cost=0.00..1.07 rows=2 width=4) (never executed)

  • Filter: (flg_alt_item = 'S'::bpchar)