explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G4XY

Settings
# exclusive inclusive rows x rows loops node
1. 1.616 177.962 ↑ 2.3 110 1

Nested Loop Left Join (cost=3,929.97..137,113.84 rows=256 width=694) (actual time=31.881..177.962 rows=110 loops=1)

  • Join Filter: ((ec_1.id_prod_com = ec.id_prod_com) AND (fo.id_uf = tm.id_uf))
2. 0.155 39.589 ↑ 2.3 110 1

Hash Join (cost=3,567.00..4,254.02 rows=256 width=407) (actual time=31.264..39.589 rows=110 loops=1)

  • Hash Cond: (ep.id_unid_v = un.id_unid)
3. 0.149 39.371 ↑ 2.3 110 1

Hash Left Join (cost=3,565.51..4,251.71 rows=256 width=404) (actual time=31.184..39.371 rows=110 loops=1)

  • Hash Cond: (eq.id_tipo_estoque = tt.id_tipo_estoque)
  • Join Filter: (eq.id_tipo_estoque = 1)
4. 0.165 39.174 ↑ 2.3 110 1

Hash Left Join (cost=3,564.44..4,248.82 rows=256 width=386) (actual time=31.115..39.174 rows=110 loops=1)

  • Hash Cond: (ep.id_pes_for = fr.id_pes)
5. 0.132 38.170 ↑ 2.3 110 1

Hash Left Join (cost=3,526.89..4,210.60 rows=256 width=363) (actual time=30.239..38.170 rows=110 loops=1)

  • Hash Cond: (ep.id_pes_fab = ff.id_pes)
6. 0.133 37.069 ↑ 2.3 110 1

Nested Loop (cost=3,489.35..4,172.38 rows=256 width=340) (actual time=29.226..37.069 rows=110 loops=1)

7. 0.003 0.031 ↑ 1.0 1 1

Nested Loop (cost=0.28..9.33 rows=1 width=8) (actual time=0.030..0.031 rows=1 loops=1)

8. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on cg_emp cg (cost=0.00..1.02 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (id_emp = 1)
  • Rows Removed by Filter: 1
9. 0.013 0.013 ↑ 1.0 1 1

Index Scan using pk_tb_municipio on tb_municipio tm (cost=0.28..8.30 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (id_municipio = cg.id_municipio)
10. 0.129 36.905 ↑ 2.3 110 1

Hash Left Join (cost=3,489.06..4,160.49 rows=256 width=340) (actual time=29.154..36.905 rows=110 loops=1)

  • Hash Cond: (ep.id_pes_lab = fl.id_pes)
11. 0.135 35.580 ↑ 2.3 110 1

Hash Left Join (cost=3,451.52..4,122.27 rows=256 width=317) (actual time=27.941..35.580 rows=110 loops=1)

  • Hash Cond: (ep.id_tipo_prod = tp.id_tipo_prod)
12. 0.126 35.398 ↑ 2.3 110 1

Hash Join (cost=3,450.18..4,120.07 rows=256 width=317) (actual time=27.872..35.398 rows=110 loops=1)

  • Hash Cond: (ep.id_marca = em.id_marca)
13. 0.163 35.251 ↑ 2.3 110 1

Hash Join (cost=3,449.13..4,116.93 rows=256 width=317) (actual time=27.840..35.251 rows=110 loops=1)

  • Hash Cond: (ep.id_dpto_d = ed.id_dpto)
14. 0.428 35.037 ↑ 2.3 110 1

Hash Left Join (cost=3,447.73..4,114.70 rows=256 width=312) (actual time=27.777..35.037 rows=110 loops=1)

  • Hash Cond: (ep.id_ncm = tn.id_ncm)
15. 2.975 29.722 ↑ 2.3 110 1

Hash Right Join (cost=3,013.71..3,680.01 rows=256 width=308) (actual time=22.609..29.722 rows=110 loops=1)

  • Hash Cond: (eq.id_prod = ec.id_prod)
16. 4.257 4.257 ↑ 1.0 26,340 1

Seq Scan on eq_prod_qtde eq (cost=0.00..565.01 rows=26,340 width=55) (actual time=0.028..4.257 rows=26,340 loops=1)

  • Filter: (id_emp = 1)
  • Rows Removed by Filter: 61
17. 0.112 22.490 ↑ 2.3 110 1

Hash (cost=3,010.51..3,010.51 rows=256 width=261) (actual time=22.490..22.490 rows=110 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
18. 2.025 22.378 ↑ 2.3 110 1

Hash Join (cost=1,128.37..3,010.51 rows=256 width=261) (actual time=12.515..22.378 rows=110 loops=1)

  • Hash Cond: (ec.id_prod = ep.id_prod)
19. 7.945 7.945 ↑ 1.0 26,811 1

Seq Scan on eq_prod_com ec (cost=0.00..1,811.36 rows=26,962 width=41) (actual time=0.019..7.945 rows=26,811 loops=1)

  • Filter: ((id_emp = 1) AND (id_tipo_situacao = 4))
  • Rows Removed by Filter: 26813
20. 0.140 12.408 ↑ 2.3 110 1

Hash (cost=1,125.18..1,125.18 rows=255 width=220) (actual time=12.408..12.408 rows=110 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
21. 12.268 12.268 ↑ 2.3 110 1

Seq Scan on eq_prod ep (cost=0.00..1,125.18 rows=255 width=220) (actual time=0.123..12.268 rows=110 loops=1)

  • Filter: (((descricaor)::text ~~ '%ARROZ%'::text) AND ((especial)::text = 'NAO'::text))
  • Rows Removed by Filter: 26702
22. 2.793 4.887 ↑ 1.0 12,534 1

Hash (cost=277.34..277.34 rows=12,534 width=12) (actual time=4.887..4.887 rows=12,534 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 716kB
23. 2.094 2.094 ↑ 1.0 12,534 1

Seq Scan on tb_ncm tn (cost=0.00..277.34 rows=12,534 width=12) (actual time=0.033..2.094 rows=12,534 loops=1)

24. 0.029 0.051 ↑ 1.0 18 1

Hash (cost=1.18..1.18 rows=18 width=13) (actual time=0.051..0.051 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
25. 0.022 0.022 ↑ 1.0 18 1

Seq Scan on eq_dpto ed (cost=0.00..1.18 rows=18 width=13) (actual time=0.014..0.022 rows=18 loops=1)

26. 0.006 0.021 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=8) (actual time=0.021..0.021 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
27. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on eq_marca em (cost=0.00..1.02 rows=2 width=8) (actual time=0.014..0.015 rows=2 loops=1)

28. 0.019 0.047 ↑ 1.0 15 1

Hash (cost=1.15..1.15 rows=15 width=4) (actual time=0.047..0.047 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.028 0.028 ↑ 1.0 15 1

Seq Scan on tb_tipo_prod tp (cost=0.00..1.15 rows=15 width=4) (actual time=0.025..0.028 rows=15 loops=1)

30. 0.542 1.196 ↑ 1.0 691 1

Hash (cost=28.91..28.91 rows=691 width=31) (actual time=1.196..1.196 rows=691 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
31. 0.654 0.654 ↑ 1.0 691 1

Seq Scan on fn_pes fl (cost=0.00..28.91 rows=691 width=31) (actual time=0.018..0.654 rows=691 loops=1)

32. 0.544 0.969 ↑ 1.0 691 1

Hash (cost=28.91..28.91 rows=691 width=31) (actual time=0.969..0.969 rows=691 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
33. 0.425 0.425 ↑ 1.0 691 1

Seq Scan on fn_pes ff (cost=0.00..28.91 rows=691 width=31) (actual time=0.024..0.425 rows=691 loops=1)

34. 0.490 0.839 ↑ 1.0 691 1

Hash (cost=28.91..28.91 rows=691 width=31) (actual time=0.839..0.839 rows=691 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
35. 0.349 0.349 ↑ 1.0 691 1

Seq Scan on fn_pes fr (cost=0.00..28.91 rows=691 width=31) (actual time=0.033..0.349 rows=691 loops=1)

36. 0.021 0.048 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=22) (actual time=0.048..0.048 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
37. 0.027 0.027 ↑ 1.0 3 1

Seq Scan on tb_tipo_estoque tt (cost=0.00..1.03 rows=3 width=22) (actual time=0.025..0.027 rows=3 loops=1)

38. 0.025 0.063 ↑ 1.0 22 1

Hash (cost=1.22..1.22 rows=22 width=7) (actual time=0.063..0.063 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
39. 0.038 0.038 ↑ 1.0 22 1

Seq Scan on tb_unid un (cost=0.00..1.22 rows=22 width=7) (actual time=0.028..0.038 rows=22 loops=1)

40. 0.032 0.110 ↓ 0.0 0 110

Materialize (cost=362.97..691.30 rows=1 width=72) (actual time=0.001..0.001 rows=0 loops=110)

41. 0.001 0.078 ↓ 0.0 0 1

Nested Loop (cost=362.97..691.29 rows=1 width=72) (actual time=0.078..0.078 rows=0 loops=1)

42. 0.012 0.077 ↓ 0.0 0 1

Hash Join (cost=362.83..691.13 rows=1 width=80) (actual time=0.077..0.077 rows=0 loops=1)

  • Hash Cond: (fd.id_grade_trib_aliq = gd.id_grade_trib_aliq)
43. 0.021 0.021 ↑ 1,286.0 1 1

Seq Scan on fs_grade_trib_ufd fd (cost=0.00..323.48 rows=1,286 width=4) (actual time=0.021..0.021 rows=1 loops=1)

  • Filter: (id_uf = 26)
44. 0.000 0.044 ↓ 0.0 0 1

Hash (cost=362.81..362.81 rows=1 width=96) (actual time=0.044..0.044 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
45. 0.012 0.044 ↓ 0.0 0 1

Hash Join (cost=125.37..362.81 rows=1 width=96) (actual time=0.044..0.044 rows=0 loops=1)

  • Hash Cond: (fo.id_grade_trib_aliq = gd.id_grade_trib_aliq)
46. 0.019 0.019 ↑ 12,389.0 1 1

Seq Scan on fs_grade_trib_ufo fo (cost=0.00..190.89 rows=12,389 width=8) (actual time=0.019..0.019 rows=1 loops=1)

47. 0.000 0.013 ↓ 0.0 0 1

Hash (cost=125.36..125.36 rows=1 width=88) (actual time=0.013..0.013 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
48. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=102.97..125.36 rows=1 width=88) (actual time=0.013..0.013 rows=0 loops=1)

  • Join Filter: (ga.id_grade_trib = ec_1.id_grade_trib)
49. 0.001 0.012 ↓ 0.0 0 1

Hash Join (cost=102.68..120.96 rows=1 width=84) (actual time=0.012..0.012 rows=0 loops=1)

  • Hash Cond: (el.id_simbologia = ga.id_simbologia)
50. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on eq_prod_com_lista_preco el (cost=0.00..16.00 rows=600 width=72) (actual time=0.011..0.011 rows=0 loops=1)

51. 0.000 0.000 ↓ 0.0 0

Hash (cost=102.67..102.67 rows=1 width=20) (never executed)

52. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=75.70..102.67 rows=1 width=20) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=75.42..101.67 rows=1 width=8) (never executed)

  • Hash Cond: (gd.id_grade_trib_aliq = ge.id_grade_trib_aliq)
54. 0.000 0.000 ↓ 0.0 0

Seq Scan on fs_grade_trib_dcto gd (cost=0.00..25.43 rows=215 width=4) (never executed)

  • Filter: (id_tipo_dcto = 41)
55. 0.000 0.000 ↓ 0.0 0

Hash (cost=75.41..75.41 rows=1 width=4) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Seq Scan on fs_grade_trib_entidade ge (cost=0.00..75.41 rows=1 width=4) (never executed)

  • Filter: (id_tipo_entidade = 3)
57. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_fs_grade_trib_aliq on fs_grade_trib_aliq ga (cost=0.28..1.00 rows=1 width=12) (never executed)

  • Index Cond: (id_grade_trib_aliq = gd.id_grade_trib_aliq)
58. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_eq_prod_com on eq_prod_com ec_1 (cost=0.29..4.39 rows=1 width=8) (never executed)

  • Index Cond: (id_prod_com = el.id_prod_com)
59. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_fs_grade_trib on fs_grade_trib gt (cost=0.14..0.16 rows=1 width=4) (never executed)

  • Index Cond: (id_grade_trib = ec_1.id_grade_trib)
  • Heap Fetches: 0
60.          

SubPlan (forNested Loop Left Join)

61. 0.000 0.000 ↓ 0.0 0

Seq Scan on eq_prod_pdc pd (cost=0.00..35.50 rows=10 width=0) (never executed)

  • Filter: (id_prod = ep.id_prod)
62. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on eq_prod_pdc pd_1 (cost=0.00..30.40 rows=2,040 width=4) (actual time=0.015..0.015 rows=0 loops=1)

63. 0.000 0.000 ↓ 0.0 0

Seq Scan on eq_prod_apr pa (cost=0.00..17.50 rows=3 width=0) (never executed)

  • Filter: (id_prod = ep.id_prod)
64. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on eq_prod_apr pa_1 (cost=0.00..16.00 rows=600 width=4) (actual time=0.012..0.012 rows=0 loops=1)

65. 0.110 2.860 ↑ 1.0 1 110

Aggregate (cost=3.63..3.64 rows=1 width=8) (actual time=0.026..0.026 rows=1 loops=110)

66. 1.728 2.750 ↓ 0.0 0 110

Nested Loop (cost=0.00..3.63 rows=1 width=4) (actual time=0.025..0.025 rows=0 loops=110)

  • Join Filter: (od.id_promo = eo.id_promo)
  • Rows Removed by Join Filter: 0
67. 0.990 0.990 ↓ 0.0 0 110

Seq Scan on eq_promo_prod od (cost=0.00..1.95 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=110)

  • Filter: (id_prod = ep.id_prod)
  • Rows Removed by Filter: 76
68. 0.032 0.032 ↑ 1.0 3 1

Seq Scan on eq_promo eo (cost=0.00..1.64 rows=3 width=4) (actual time=0.028..0.032 rows=3 loops=1)

  • Filter: (((LOCALTIMESTAMP)::date >= (dt_inicial)::date) AND ((LOCALTIMESTAMP)::date <= (dt_final)::date) AND ((LOCALTIMESTAMP)::time without time zone >= hr_inicial) AND ((LOCALTIMESTAMP)::time without time zone <= hr_final))
  • Rows Removed by Filter: 13
69. 0.880 133.760 ↑ 1.0 1 110

Limit (cost=0.00..503.23 rows=1 width=13) (actual time=1.216..1.216 rows=1 loops=110)

70. 132.880 132.880 ↑ 1.0 1 110

Seq Scan on eq_prod_ean pe (cost=0.00..503.23 rows=1 width=13) (actual time=1.208..1.208 rows=1 loops=110)

  • Filter: (id_prod = ep.id_prod)
  • Rows Removed by Filter: 13478