explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qckc

Settings
# exclusive inclusive rows x rows loops node
1. 920.670 4,356.420 ↑ 54.0 4,825 1

Hash Right Join (cost=16,946.71..456,592.35 rows=260,561 width=192) (actual time=2,592.418..4,356.420 rows=4,825 loops=1)

  • Hash Cond: (ag_nodo5__.id_nodo = ag_nodo5__ticket_accion.id_ticket)
2. 645.869 3,353.874 ↑ 1.0 5,997,809 1

Append (cost=0.00..405,656.88 rows=6,016,068 width=16) (actual time=0.018..3,353.874 rows=5,997,809 loops=1)

3. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on ag_nodo5__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=1)

4. 77.079 77.079 ↑ 1.0 192,073 1

Seq Scan on ag_nodo5__a_ficha_agenda (cost=0.00..6,960.71 rows=194,671 width=16) (actual time=0.011..77.079 rows=192,073 loops=1)

5. 0.642 0.642 ↑ 1.0 254 1

Seq Scan on ag_nodo5__sucursal (cost=0.00..9.54 rows=254 width=16) (actual time=0.016..0.642 rows=254 loops=1)

6. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on gd__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

7. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gdclon__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

8. 344.479 344.479 ↑ 1.0 796,453 1

Seq Scan on ag_nodo5__a_actividad (cost=0.00..49,497.53 rows=796,453 width=16) (actual time=0.012..344.479 rows=796,453 loops=1)

9. 26.914 26.914 ↑ 1.0 96,538 1

Seq Scan on ag_nodo5__empresa (cost=0.00..3,986.66 rows=96,666 width=16) (actual time=0.022..26.914 rows=96,538 loops=1)

10. 601.802 601.802 ↑ 1.0 801,158 1

Seq Scan on ag_nodo5__t_tarea (cost=0.00..104,764.10 rows=812,210 width=16) (actual time=0.017..601.802 rows=801,158 loops=1)

11. 516.614 516.614 ↓ 1.0 1,343,594 1

Seq Scan on ag_nodo5__a_aux_dia (cost=0.00..46,469.61 rows=1,343,561 width=16) (actual time=0.007..516.614 rows=1,343,594 loops=1)

12. 38.100 38.100 ↑ 1.0 102,233 1

Seq Scan on ag_nodo5__empresa_sucursal (cost=0.00..4,686.61 rows=102,261 width=16) (actual time=0.008..38.100 rows=102,233 loops=1)

13. 119.700 119.700 ↑ 1.0 273,500 1

Seq Scan on ag_nodo5__ticket (cost=0.00..34,865.37 rows=274,037 width=16) (actual time=0.017..119.700 rows=273,500 loops=1)

14. 110.161 110.161 ↑ 1.0 278,569 1

Seq Scan on ag_nodo5__ticket_ficha (cost=0.00..13,233.89 rows=278,789 width=16) (actual time=0.008..110.161 rows=278,569 loops=1)

15. 295.180 295.180 ↑ 1.0 680,257 1

Seq Scan on ag_nodo5__a_actividad_tema (cost=0.00..37,322.57 rows=680,257 width=16) (actual time=0.008..295.180 rows=680,257 loops=1)

16. 0.011 0.011 ↑ 1.0 14 1

Seq Scan on ag_nodo5__a_comentario (cost=0.00..1.14 rows=14 width=16) (actual time=0.008..0.011 rows=14 loops=1)

17. 3.252 3.252 ↑ 1.0 8,450 1

Seq Scan on ag_nodo5__a_compromiso (cost=0.00..429.50 rows=8,450 width=16) (actual time=0.011..3.252 rows=8,450 loops=1)

18. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on ag_nodo5__af_empresa_contacto (cost=0.00..11.70 rows=170 width=16) (actual time=0.003..0.003 rows=0 loops=1)

19. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on ag_nodo5__af_empresa_ficha_afiliacion (cost=0.00..11.70 rows=170 width=16) (actual time=0.002..0.002 rows=0 loops=1)

20. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on ag_nodo5__af_empresa_potencial (cost=0.00..11.70 rows=170 width=16) (actual time=0.002..0.002 rows=0 loops=1)

21. 16.713 16.713 ↓ 1.0 38,927 1

Seq Scan on ag_nodo5__contacto (cost=0.00..1,596.24 rows=38,924 width=16) (actual time=0.015..16.713 rows=38,927 loops=1)

22. 0.007 0.007 ↑ 1.0 3 1

Seq Scan on ag_nodo5__e_evento (cost=0.00..1.03 rows=3 width=16) (actual time=0.007..0.007 rows=3 loops=1)

23. 0.473 0.473 ↑ 1.0 1,301 1

Seq Scan on ag_nodo5__e_ficha_requerimiento (cost=0.00..62.01 rows=1,301 width=16) (actual time=0.011..0.473 rows=1,301 loops=1)

24. 0.004 0.004 ↑ 1.0 2 1

Seq Scan on ag_nodo5__e_proveedor (cost=0.00..1.02 rows=2 width=16) (actual time=0.004..0.004 rows=2 loops=1)

25. 0.653 0.653 ↑ 1.0 1,289 1

Seq Scan on ag_nodo5__e_requerimiento (cost=0.00..98.89 rows=1,289 width=16) (actual time=0.016..0.653 rows=1,289 loops=1)

26. 0.005 0.005 ↑ 1.0 2 1

Seq Scan on ag_nodo5__e_tipo_entrada (cost=0.00..1.02 rows=2 width=16) (actual time=0.005..0.005 rows=2 loops=1)

27. 23.722 23.722 ↑ 1.0 59,968 1

Seq Scan on ag_nodo5__empresa_contacto (cost=0.00..3,482.21 rows=60,121 width=16) (actual time=0.009..23.722 rows=59,968 loops=1)

28. 114.718 114.718 ↑ 1.0 252,824 1

Seq Scan on ag_nodo5__empresa_contacto_clon (cost=0.00..14,896.52 rows=252,952 width=16) (actual time=0.011..114.718 rows=252,824 loops=1)

29. 38.330 38.330 ↑ 1.0 86,897 1

Seq Scan on ag_nodo5__empresa_ficha (cost=0.00..4,536.14 rows=86,914 width=16) (actual time=0.013..38.330 rows=86,897 loops=1)

30. 3.783 3.783 ↑ 1.0 11,285 1

Seq Scan on ag_nodo5__empresa_holding (cost=0.00..440.85 rows=11,285 width=16) (actual time=0.011..3.783 rows=11,285 loops=1)

31. 0.008 0.008 ↑ 1.0 11 1

Seq Scan on ag_nodo5__empresa_segmentacion (cost=0.00..1.11 rows=11 width=16) (actual time=0.006..0.008 rows=11 loops=1)

32. 1.040 1.040 ↑ 1.0 2,946 1

Seq Scan on ag_nodo5__empresa_sindicato (cost=0.00..131.71 rows=2,971 width=16) (actual time=0.008..1.040 rows=2,946 loops=1)

33. 6.775 6.775 ↓ 1.0 18,914 1

Seq Scan on ag_nodo5__empresa_sindicato_clon (cost=0.00..876.08 rows=18,908 width=16) (actual time=0.012..6.775 rows=18,914 loops=1)

34. 1.960 1.960 ↑ 1.0 5,404 1

Seq Scan on ag_nodo5__empresa_sindicato_contacto (cost=0.00..261.26 rows=5,426 width=16) (actual time=0.010..1.960 rows=5,404 loops=1)

35. 13.791 13.791 ↑ 1.0 35,221 1

Seq Scan on ag_nodo5__empresa_sindicato_contacto_clon (cost=0.00..1,819.39 rows=35,239 width=16) (actual time=0.010..13.791 rows=35,221 loops=1)

36. 6.745 6.745 ↑ 1.0 21,671 1

Seq Scan on ag_nodo5__empresa_sucursal_trabajador (cost=0.00..835.71 rows=21,671 width=16) (actual time=0.007..6.745 rows=21,671 loops=1)

37. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on ag_nodo5__om_atencion (cost=0.00..11.40 rows=140 width=16) (actual time=0.007..0.008 rows=0 loops=1)

38. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on ag_nodo5__om_empresa (cost=0.00..10.60 rows=60 width=16) (actual time=0.002..0.002 rows=0 loops=1)

39. 0.016 0.016 ↑ 1.0 49 1

Seq Scan on ag_nodo5__om_oficina_movil (cost=0.00..2.49 rows=49 width=16) (actual time=0.006..0.016 rows=49 loops=1)

40. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on ag_nodo5__om_visita (cost=0.00..10.70 rows=70 width=16) (actual time=0.001..0.002 rows=0 loops=1)

41. 0.107 0.107 ↑ 1.0 403 1

Seq Scan on ag_nodo5__producto (cost=0.00..16.03 rows=403 width=16) (actual time=0.007..0.107 rows=403 loops=1)

42. 0.178 0.178 ↑ 1.0 658 1

Seq Scan on ag_nodo5__producto_accion (cost=0.00..26.58 rows=658 width=16) (actual time=0.005..0.178 rows=658 loops=1)

43. 0.019 0.019 ↑ 1.0 60 1

Seq Scan on ag_nodo5__producto_familia (cost=0.00..2.60 rows=60 width=16) (actual time=0.006..0.019 rows=60 loops=1)

44. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on ag_nodo5__t_aux (cost=0.00..1.01 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=1)

45. 14.369 14.369 ↑ 1.0 20,125 1

Seq Scan on ag_nodo5__t_ficha (cost=0.00..2,489.33 rows=20,133 width=16) (actual time=0.011..14.369 rows=20,125 loops=1)

46. 2.333 2.333 ↑ 1.0 7,016 1

Seq Scan on ag_nodo5__t_ficha_info (cost=0.00..279.16 rows=7,016 width=16) (actual time=0.007..2.333 rows=7,016 loops=1)

47. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on ag_nodo5__t_reporte (cost=0.00..11.40 rows=140 width=16) (actual time=0.002..0.002 rows=0 loops=1)

48. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on ag_nodo5__t_reporte_sup (cost=0.00..11.40 rows=140 width=16) (actual time=0.002..0.002 rows=0 loops=1)

49. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on ag_nodo5__t_reporte_zona (cost=0.00..11.50 rows=150 width=16) (actual time=0.006..0.006 rows=0 loops=1)

50. 0.006 0.006 ↑ 1.0 9 1

Seq Scan on ag_nodo5__t_tarea_concepto (cost=0.00..1.09 rows=9 width=16) (actual time=0.005..0.006 rows=9 loops=1)

51. 31.103 31.103 ↑ 1.0 94,694 1

Seq Scan on ag_nodo5__t_tarea_etapa (cost=0.00..3,849.94 rows=94,694 width=16) (actual time=0.009..31.103 rows=94,694 loops=1)

52. 2.032 2.032 ↑ 1.0 8,488 1

Seq Scan on ag_nodo5__t_tarea_info (cost=0.00..308.88 rows=8,488 width=16) (actual time=0.007..2.032 rows=8,488 loops=1)

53. 0.104 0.104 ↑ 1.0 339 1

Seq Scan on ag_nodo5__t_tarea_tipo (cost=0.00..14.39 rows=339 width=16) (actual time=0.014..0.104 rows=339 loops=1)

54. 0.018 0.018 ↑ 1.0 50 1

Seq Scan on ag_nodo5__t_tarea_tipo_etapa (cost=0.00..2.50 rows=50 width=16) (actual time=0.005..0.018 rows=50 loops=1)

55. 73.339 73.339 ↑ 1.0 253,589 1

Seq Scan on ag_nodo5__ticket_accion ag_nodo5__ticket_accion_1 (cost=0.00..11,823.24 rows=254,424 width=16) (actual time=0.017..73.339 rows=253,589 loops=1)

56. 6.435 6.435 ↑ 1.0 21,617 1

Seq Scan on ag_nodo5__ticket_beneficiario (cost=0.00..870.49 rows=21,649 width=16) (actual time=0.011..6.435 rows=21,617 loops=1)

57. 74.682 74.682 ↓ 1.0 165,647 1

Seq Scan on ag_nodo5__ticket_comentario (cost=0.00..9,185.04 rows=165,604 width=16) (actual time=0.016..74.682 rows=165,647 loops=1)

58. 14.884 14.884 ↑ 1.0 37,772 1

Seq Scan on ag_nodo5__ticket_contacto (cost=0.00..1,752.92 rows=37,792 width=16) (actual time=0.009..14.884 rows=37,772 loops=1)

59. 125.600 125.600 ↑ 1.0 277,534 1

Seq Scan on ag_nodo5__ticket_empresa (cost=0.00..13,418.13 rows=277,613 width=16) (actual time=0.011..125.600 rows=277,534 loops=1)

60. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on gd_calibracion__ (cost=0.00..10.50 rows=50 width=16) (actual time=0.003..0.003 rows=0 loops=1)

61. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on gd_comentario__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=1)

62. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_compromiso__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

63. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_detecnecesidad__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

64. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_evaluation_pg__ (cost=0.00..11.50 rows=150 width=16) (actual time=0.002..0.002 rows=0 loops=1)

65. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on gd_fichapivote__ (cost=0.00..11.50 rows=150 width=16) (actual time=0.004..0.004 rows=0 loops=1)

66. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_fichgc__ (cost=0.00..11.60 rows=160 width=16) (actual time=0.002..0.002 rows=0 loops=1)

67. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_fortaleza__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

68. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_objind__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.001..0.002 rows=0 loops=1)

69. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on gd_oportunidad__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

70. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_procesogestion__ (cost=0.00..11.40 rows=140 width=16) (actual time=0.002..0.002 rows=0 loops=1)

71. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_comentarioclon__ (cost=0.00..11.50 rows=150 width=16) (actual time=0.002..0.002 rows=0 loops=1)

72. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on gd_compromiso_accionclon__ (cost=0.00..10.50 rows=50 width=16) (actual time=0.004..0.004 rows=0 loops=1)

73. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_compromisoclon__ (cost=0.00..10.50 rows=50 width=16) (actual time=0.002..0.002 rows=0 loops=1)

74. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_compromisodesclon__ (cost=0.00..10.50 rows=50 width=16) (actual time=0.002..0.002 rows=0 loops=1)

75. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_compromisomejoraclon__ (cost=0.00..10.50 rows=50 width=16) (actual time=0.002..0.002 rows=0 loops=1)

76. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on gd_detecnecesidadclon__ (cost=0.00..10.50 rows=50 width=16) (actual time=0.003..0.003 rows=0 loops=1)

77. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_fortalezaclon__ (cost=0.00..10.50 rows=50 width=16) (actual time=0.002..0.002 rows=0 loops=1)

78. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_indicadorclon__ (cost=0.00..10.40 rows=40 width=16) (actual time=0.002..0.002 rows=0 loops=1)

79. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_objetivoclon__ (cost=0.00..10.30 rows=30 width=16) (actual time=0.002..0.002 rows=0 loops=1)

80. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on gd_oportunidadclon__ (cost=0.00..10.50 rows=50 width=16) (actual time=0.004..0.004 rows=0 loops=1)

81. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_compromiso_accion__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

82. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_compromisodes__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

83. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_compromisomejora__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

84. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on gd_indicador__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=1)

85. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_objetivo__ (cost=0.00..0.00 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

86. 0.807 81.876 ↑ 1.1 4,825 1

Hash (cost=16,882.76..16,882.76 rows=5,116 width=149) (actual time=81.876..81.876 rows=4,825 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 956kB
87. 18.320 81.069 ↑ 1.1 4,825 1

Gather (cost=5,490.81..16,882.76 rows=5,116 width=149) (actual time=52.108..81.069 rows=4,825 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
88. 0.838 62.749 ↑ 1.3 1,608 3 / 3

Hash Left Join (cost=4,490.81..15,371.16 rows=2,132 width=149) (actual time=36.359..62.749 rows=1,608 loops=3)

  • Hash Cond: (ag_nodo5__ticket_accion.id_ejecutivo_activacion = tbl2.id_user)
89. 2.805 60.251 ↑ 1.3 1,608 3 / 3

Parallel Hash Left Join (cost=4,299.40..15,174.15 rows=2,132 width=136) (actual time=34.613..60.251 rows=1,608 loops=3)

  • Hash Cond: (ag_nodo5__ticket_accion.id_empresa = tbl1.id_nodo)
90. 23.595 23.595 ↑ 1.3 1,608 3 / 3

Parallel Seq Scan on ag_nodo5__ticket_accion (cost=0.00..10,869.15 rows=2,132 width=111) (actual time=0.134..23.595 rows=1,608 loops=3)

  • Filter: ((id_responsable = 6,787) AND (nodo_status = '3'::bpchar))
  • Rows Removed by Filter: 82,921
91. 20.454 33.851 ↑ 1.8 32,179 3 / 3

Parallel Hash (cost=3,588.62..3,588.62 rows=56,862 width=41) (actual time=33.850..33.851 rows=32,179 loops=3)

  • Buckets: 131,072 Batches: 1 Memory Usage: 8,288kB
92. 13.397 13.397 ↑ 1.8 32,179 3 / 3

Parallel Seq Scan on ag_nodo5__empresa tbl1 (cost=0.00..3,588.62 rows=56,862 width=41) (actual time=0.008..13.397 rows=32,179 loops=3)

93. 0.804 1.660 ↑ 1.0 2,196 3 / 3

Hash (cost=163.96..163.96 rows=2,196 width=25) (actual time=1.660..1.660 rows=2,196 loops=3)

  • Buckets: 4,096 Batches: 1 Memory Usage: 161kB
94. 0.856 0.856 ↑ 1.0 2,196 3 / 3

Seq Scan on ag_users tbl2 (cost=0.00..163.96 rows=2,196 width=25) (actual time=0.015..0.856 rows=2,196 loops=3)

Planning time : 20.879 ms
Execution time : 4,359.190 ms