explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IHkE

Settings
# exclusive inclusive rows x rows loops node
1. 1,002.613 23,785,226.452 ↓ 229.3 416,159 1

Group (cost=566,694,076.27..1,133,105,253.28 rows=1,815 width=149) (actual time=23,783,599.675..23,785,226.452 rows=416,159 loops=1)

  • Group Key: ei.att_value_5, depto.att_value_1, delito.att_value_2, hepo.att_value_1, acci.att_value_1, fisc.att_value_1, ei.att_value_num_2, ei.att_value_8, es.ent_sta_desc, (CASE WHEN (ei.att_value_num_8 = '1'::numeric) THEN 'SI'::text ELSE 'NO'::text EN (...)
2. 14,019.113 23,784,223.839 ↓ 229.3 416,216 1

Sort (cost=566,694,076.27..566,694,080.81 rows=1,815 width=149) (actual time=23,783,599.656..23,784,223.839 rows=416,216 loops=1)

  • Sort Key: ei.att_value_5, depto.att_value_1, delito.att_value_2, hepo.att_value_1, acci.att_value_1, fisc.att_value_1, ei.att_value_num_2, ei.att_value_8, es.ent_sta_desc, (CASE WHEN (ei.att_value_num_8 = '1'::numeric) THEN 'SI'::text ELSE 'NO'::te (...)
  • Sort Method: external merge Disk: 73536kB
3. 41,764.636 23,770,204.726 ↓ 229.3 416,216 1

Nested Loop Left Join (cost=161,675.79..566,693,978.02 rows=1,815 width=149) (actual time=46,246.326..23,770,204.726 rows=416,216 loops=1)

4. 3,033.658 4,445,985.242 ↓ 229.3 416,216 1

Nested Loop Left Join (cost=161,675.22..267,649.96 rows=1,815 width=165) (actual time=46,201.906..4,445,985.242 rows=416,216 loops=1)

5. 2,312.761 799,396.720 ↓ 229.3 416,216 1

Nested Loop Left Join (cost=161,674.79..249,366.04 rows=1,815 width=150) (actual time=46,181.190..799,396.720 rows=416,216 loops=1)

6. 2,467.661 796,251.527 ↓ 229.3 416,216 1

Nested Loop Left Join (cost=161,674.22..234,097.02 rows=1,815 width=154) (actual time=46,181.095..796,251.527 rows=416,216 loops=1)

7. 2,386.242 792,535.218 ↓ 229.3 416,216 1

Nested Loop Left Join (cost=161,673.65..218,828.00 rows=1,815 width=166) (actual time=46,181.021..792,535.218 rows=416,216 loops=1)

8. 3,250.497 516,695.064 ↓ 229.3 416,216 1

Nested Loop Left Join (cost=161,673.23..200,573.46 rows=1,815 width=151) (actual time=46,169.301..516,695.064 rows=416,216 loops=1)

9. 3,227.434 507,201.327 ↓ 229.3 416,216 1

Nested Loop Left Join (cost=161,672.66..185,304.44 rows=1,815 width=144) (actual time=46,169.137..507,201.327 rows=416,216 loops=1)

10. 2,865.432 499,395.517 ↓ 229.3 416,216 1

Nested Loop Left Join (cost=161,672.09..170,035.42 rows=1,815 width=141) (actual time=46,169.024..499,395.517 rows=416,216 loops=1)

11. 4,235.201 53,320.750 ↓ 229.3 416,159 1

Merge Left Join (cost=161,671.67..161,871.32 rows=1,815 width=126) (actual time=46,168.841..53,320.750 rows=416,159 loops=1)

  • Merge Cond: ((ei.env_id = depto.env_id) AND (secc.att_value_num_2 = ((depto.bus_ent_inst_name_num)::numeric)))
12. 10,025.833 48,279.760 ↓ 229.3 416,159 1

Sort (cost=98,273.99..98,278.53 rows=1,815 width=129) (actual time=46,154.056..48,279.760 rows=416,159 loops=1)

  • Sort Key: ei.env_id, secc.att_value_num_2
  • Sort Method: external sort Disk: 51712kB
13. 2,061.162 38,253.927 ↓ 229.3 416,159 1

Nested Loop Left Join (cost=1,474.81..98,175.75 rows=1,815 width=129) (actual time=29,210.711..38,253.927 rows=416,159 loops=1)

14. 1,193.888 33,279.652 ↓ 229.3 416,159 1

Hash Join (cost=1,474.24..82,906.73 rows=1,815 width=126) (actual time=29,210.610..33,279.652 rows=416,159 loops=1)

  • Hash Cond: ((ei.env_id = es.env_id) AND (ei.ent_sta_id = es.ent_sta_id_auto))
15. 3,023.937 32,085.545 ↓ 17.4 416,159 1

Bitmap Heap Scan on bus_ent_instance ei (cost=1,470.66..82,705.77 rows=23,897 width=91) (actual time=29,210.363..32,085.545 rows=416,159 loops=1)

  • Recheck Cond: (((bus_ent_inst_name_pre)::text = 'NC'::text) AND (att_value_num_5 = '1'::numeric) AND (reg_status = 0))
  • Filter: (bus_ent_inst_create_data < ('now'::cstring)::date)
  • Rows Removed by Filter: 657
  • Heap Blocks: exact=256118
16. 29,061.608 29,061.608 ↓ 17.5 418,153 1

Bitmap Index Scan on ix_bus_ent_instance_attn_namenum_05 (cost=0.00..1,464.69 rows=23,900 width=0) (actual time=29,061.608..29,061.608 rows=418,153 loops=1)

  • Index Cond: (((bus_ent_inst_name_pre)::text = 'NC'::text) AND (att_value_num_5 = '1'::numeric) AND (reg_status = 0))
17. 0.079 0.219 ↑ 1.0 63 1

Hash (cost=2.63..2.63 rows=63 width=47) (actual time=0.219..0.219 rows=63 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
18. 0.140 0.140 ↑ 1.0 63 1

Seq Scan on bus_ent_status es (cost=0.00..2.63 rows=63 width=47) (actual time=0.063..0.140 rows=63 loops=1)

19. 2,913.113 2,913.113 ↑ 1.0 1 416,159

Index Scan using uc_entity_inst_num on bus_ent_instance secc (cost=0.57..8.40 rows=1 width=14) (actual time=0.006..0.007 rows=1 loops=416,159)

  • Index Cond: ((ei.env_id = env_id) AND (bus_ent_id = 1112) AND ((ei.att_value_3)::integer = bus_ent_inst_name_num))
20. 791.147 805.789 ↓ 22.9 405,714 1

Sort (cost=63,397.68..63,441.88 rows=17,681 width=11) (actual time=14.734..805.789 rows=405,714 loops=1)

  • Sort Key: depto.env_id, ((depto.bus_ent_inst_name_num)::numeric)
  • Sort Method: quicksort Memory: 26kB
21. 0.095 14.642 ↑ 884.0 20 1

Bitmap Heap Scan on bus_ent_instance depto (cost=637.59..62,150.29 rows=17,681 width=11) (actual time=14.600..14.642 rows=20 loops=1)

  • Recheck Cond: (bus_ent_id = 1091)
  • Heap Blocks: exact=4
22. 14.547 14.547 ↑ 884.0 20 1

Bitmap Index Scan on ix_bus_ent_instance_01 (cost=0.00..633.17 rows=17,681 width=0) (actual time=14.547..14.547 rows=20 loops=1)

  • Index Cond: (bus_ent_id = 1091)
23. 443,209.335 443,209.335 ↓ 0.0 0 416,159

Index Only Scan using ix_bus_ent_inst_attribute_nc_trabajada on bus_ent_inst_attribute att_cc (cost=0.42..4.48 rows=2 width=23) (actual time=1.063..1.065 rows=0 loops=416,159)

  • Index Cond: ((bus_ent_inst_id = ei.bus_ent_inst_id_auto) AND (att_id = 4016) AND (env_id = ei.env_id))
  • Heap Fetches: 69589
24. 4,578.376 4,578.376 ↓ 0.0 0 416,216

Index Scan using uc_entity_inst_num on bus_ent_instance fisc (cost=0.57..8.40 rows=1 width=11) (actual time=0.010..0.011 rows=0 loops=416,216)

  • Index Cond: ((ei.env_id = env_id) AND (bus_ent_id = 1019) AND ((ei.att_value_9)::integer = bus_ent_inst_name_num))
25. 6,243.240 6,243.240 ↑ 1.0 1 416,216

Index Scan using uc_entity_inst_num on bus_ent_instance delito (cost=0.57..8.40 rows=1 width=19) (actual time=0.013..0.015 rows=1 loops=416,216)

  • Index Cond: ((ei.env_id = env_id) AND (bus_ent_id = 1296) AND ((ei.att_value_6)::integer = bus_ent_inst_name_num))
26. 273,453.912 273,453.912 ↓ 0.0 0 416,216

Index Scan using ix_prueba_reporte2 on bus_ent_inst_attribute att_hepo (cost=0.42..10.04 rows=2 width=23) (actual time=0.657..0.657 rows=0 loops=416,216)

  • Index Cond: ((ei.env_id = env_id) AND (ei.bus_ent_inst_id_auto = bus_ent_inst_id) AND (att_id = 1385))
27. 1,248.648 1,248.648 ↓ 0.0 0 416,216

Index Scan using uc_entity_inst_num on bus_ent_instance hepo (cost=0.57..8.40 rows=1 width=11) (actual time=0.003..0.003 rows=0 loops=416,216)

  • Index Cond: ((ei.env_id = env_id) AND (bus_ent_id = 1099) AND ((att_hepo.ent_inst_att_str_value)::integer = bus_ent_inst_name_num))
28. 832.432 832.432 ↓ 0.0 0 416,216

Index Scan using uc_entity_inst_num on bus_ent_instance acci (cost=0.57..8.40 rows=1 width=11) (actual time=0.002..0.002 rows=0 loops=416,216)

  • Index Cond: ((ei.env_id = env_id) AND (bus_ent_id = 1073) AND ((ei.att_value_7)::integer = bus_ent_inst_name_num))
29. 3,643,554.864 3,643,554.864 ↑ 2.0 1 416,216

Index Scan using ix_prueba_reporte1 on bus_ent_inst_attribute att_dir_hecho (cost=0.43..10.05 rows=2 width=23) (actual time=8.752..8.754 rows=1 loops=416,216)

  • Index Cond: ((ei.env_id = env_id) AND (ei.bus_ent_inst_id_auto = bus_ent_inst_id) AND (att_id = 2224))
30. 9,989.184 9,989.184 ↑ 1.0 1 416,216

Index Scan using uc_entity_inst_num on bus_ent_instance depto2 (cost=0.57..8.40 rows=1 width=11) (actual time=0.022..0.024 rows=1 loops=416,216)

  • Index Cond: ((ei.env_id = env_id) AND (bus_ent_id = 1091) AND ((att_dir_hecho.ent_inst_att_str_value)::integer = bus_ent_inst_name_num))
31.          

SubPlan (forNested Loop Left Join)

32. 7,083.526 5,074,505.472 ↑ 1.0 1 416,216

Nested Loop (cost=1.43..69.47 rows=1 width=3) (actual time=12.151..12.192 rows=1 loops=416,216)

33. 3,745.944 5,053,694.672 ↑ 4.0 1 416,216

Nested Loop (cost=0.86..35.41 rows=4 width=15) (actual time=12.105..12.142 rows=1 loops=416,216)

34. 9,156.752 9,156.752 ↑ 1.0 1 416,216

Index Scan using ix_attribute_03 on attribute att (cost=0.28..8.30 rows=1 width=4) (actual time=0.021..0.022 rows=1 loops=416,216)

  • Index Cond: ((att_name)::text = 'DIRECCION_JURISDICCION_STR'::text)
35. 5,040,791.976 5,040,791.976 ↑ 11.0 1 416,216

Index Scan using ix_bus_ent_inst_attr_01 on bus_ent_inst_attribute beia (cost=0.58..27.00 rows=11 width=19) (actual time=12.077..12.111 rows=1 loops=416,216)

  • Index Cond: ((ei.bus_ent_inst_id_auto = bus_ent_inst_id) AND (att_id = att.att_id_auto))
36. 13,727.274 13,727.274 ↑ 1.0 1 415,978

Index Scan using ix_bus_ent_instance_02 on bus_ent_instance juri (cost=0.57..8.51 rows=1 width=7) (actual time=0.032..0.033 rows=1 loops=415,978)

  • Index Cond: (((bus_ent_inst_name_pre)::text = 'JUR'::text) AND (bus_ent_inst_name_num = (beia.ent_inst_att_str_value)::integer))
37. 8,139.528 1,157,912.912 ↓ 0.0 0 416,216

Hash Join (cost=673.05..62,406.78 rows=2 width=3) (actual time=2.780..2.782 rows=0 loops=416,216)

  • Hash Cond: ((sug.bus_ent_inst_name_num)::numeric = beia_1.ent_inst_att_num_value)
38. 968.220 3,098.304 ↑ 5,893.7 3 96,822

Bitmap Heap Scan on bus_ent_instance sug (cost=637.59..62,150.29 rows=17,681 width=7) (actual time=0.029..0.032 rows=3 loops=96,822)

  • Recheck Cond: (bus_ent_id = 1300)
  • Heap Blocks: exact=96822
39. 2,130.084 2,130.084 ↑ 5,893.7 3 96,822

Bitmap Index Scan on ix_bus_ent_instance_01 (cost=0.00..633.17 rows=17,681 width=0) (actual time=0.022..0.022 rows=3 loops=96,822)

  • Index Cond: (bus_ent_id = 1300)
40. 2,497.296 1,146,675.080 ↓ 0.0 0 416,216

Hash (cost=35.41..35.41 rows=4 width=5) (actual time=2.755..2.755 rows=0 loops=416,216)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
41. 2,913.512 1,144,177.784 ↓ 0.0 0 416,216

Nested Loop (cost=0.86..35.41 rows=4 width=5) (actual time=2.746..2.749 rows=0 loops=416,216)

42. 8,740.536 8,740.536 ↑ 1.0 1 416,216

Index Scan using ix_attribute_03 on attribute att_1 (cost=0.28..8.30 rows=1 width=4) (actual time=0.020..0.021 rows=1 loops=416,216)

  • Index Cond: ((att_name)::text = 'NC_DPA_SUGERENCIA_DEPURACION_NUM'::text)
43. 1,132,523.736 1,132,523.736 ↓ 0.0 0 416,216

Index Scan using ix_bus_ent_inst_attr_01 on bus_ent_inst_attribute beia_1 (cost=0.58..27.00 rows=11 width=9) (actual time=2.720..2.721 rows=0 loops=416,216)

  • Index Cond: ((ei.bus_ent_inst_id_auto = bus_ent_inst_id) AND (att_id = att_1.att_id_auto))
44. 3,970.520 22,891.880 ↓ 0.0 0 416,216

Hash Join (cost=673.05..62,406.78 rows=2 width=3) (actual time=0.055..0.055 rows=0 loops=416,216)

  • Hash Cond: ((via.bus_ent_inst_name_num)::numeric = beia_2.ent_inst_att_num_value)
45. 95.820 191.640 ↑ 4,420.2 4 6,388

Bitmap Heap Scan on bus_ent_instance via (cost=637.59..62,150.29 rows=17,681 width=7) (actual time=0.023..0.030 rows=4 loops=6,388)

  • Recheck Cond: (bus_ent_id = 1301)
  • Heap Blocks: exact=12776
46. 95.820 95.820 ↑ 4,420.2 4 6,388

Bitmap Index Scan on ix_bus_ent_instance_01 (cost=0.00..633.17 rows=17,681 width=0) (actual time=0.015..0.015 rows=4 loops=6,388)

  • Index Cond: (bus_ent_id = 1301)
47. 1,248.648 18,729.720 ↓ 0.0 0 416,216

Hash (cost=35.41..35.41 rows=4 width=5) (actual time=0.045..0.045 rows=0 loops=416,216)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
48. 2,081.080 17,481.072 ↓ 0.0 0 416,216

Nested Loop (cost=0.86..35.41 rows=4 width=5) (actual time=0.042..0.042 rows=0 loops=416,216)

49. 6,243.240 6,243.240 ↑ 1.0 1 416,216

Index Scan using ix_attribute_03 on attribute att_2 (cost=0.28..8.30 rows=1 width=4) (actual time=0.014..0.015 rows=1 loops=416,216)

  • Index Cond: ((att_name)::text = 'NC_DPA_APLICAR_VIAS_ALTERNATIVAS_NUM'::text)
50. 9,156.752 9,156.752 ↓ 0.0 0 416,216

Index Scan using ix_bus_ent_inst_attr_01 on bus_ent_inst_attribute beia_2 (cost=0.58..27.00 rows=11 width=9) (actual time=0.022..0.022 rows=0 loops=416,216)

  • Index Cond: ((ei.bus_ent_inst_id_auto = bus_ent_inst_id) AND (att_id = att_2.att_id_auto))
51. 4,907.694 1,372,264.152 ↓ 0.0 0 416,216

Hash Join (cost=673.05..62,406.78 rows=2 width=3) (actual time=3.295..3.297 rows=0 loops=416,216)

  • Hash Cond: ((gra.bus_ent_inst_name_num)::numeric = beia_3.ent_inst_att_num_value)
52. 1,326.753 3,832.842 ↑ 5,893.7 3 147,417

Bitmap Heap Scan on bus_ent_instance gra (cost=637.59..62,150.29 rows=17,681 width=7) (actual time=0.023..0.026 rows=3 loops=147,417)

  • Recheck Cond: (bus_ent_id = 1008)
  • Heap Blocks: exact=147417
53. 2,506.089 2,506.089 ↑ 5,893.7 3 147,417

Bitmap Index Scan on ix_bus_ent_instance_01 (cost=0.00..633.17 rows=17,681 width=0) (actual time=0.017..0.017 rows=3 loops=147,417)

  • Index Cond: (bus_ent_id = 1008)
54. 2,081.080 1,363,523.616 ↓ 0.0 0 416,216

Hash (cost=35.41..35.41 rows=4 width=5) (actual time=3.276..3.276 rows=0 loops=416,216)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
55. 2,913.512 1,361,442.536 ↓ 0.0 0 416,216

Nested Loop (cost=0.86..35.41 rows=4 width=5) (actual time=3.269..3.271 rows=0 loops=416,216)

56. 6,243.240 6,243.240 ↑ 1.0 1 416,216

Index Scan using ix_attribute_03 on attribute att_3 (cost=0.28..8.30 rows=1 width=4) (actual time=0.014..0.015 rows=1 loops=416,216)

  • Index Cond: ((att_name)::text = 'NC_GRAVEDAD_DEL_HECHO_NUM'::text)
57. 1,352,285.784 1,352,285.784 ↓ 0.0 0 416,216

Index Scan using ix_bus_ent_inst_attr_01 on bus_ent_inst_attribute beia_3 (cost=0.58..27.00 rows=11 width=9) (actual time=3.249..3.249 rows=0 loops=416,216)

  • Index Cond: ((ei.bus_ent_inst_id_auto = bus_ent_inst_id) AND (att_id = att_3.att_id_auto))
58. 4,994.592 63,681.048 ↑ 1.0 1 416,216

Aggregate (cost=62,406.79..62,406.80 rows=1 width=3) (actual time=0.153..0.153 rows=1 loops=416,216)

59. 5,106.839 58,686.456 ↓ 0.0 0 416,216

Hash Join (cost=673.05..62,406.78 rows=2 width=3) (actual time=0.139..0.141 rows=0 loops=416,216)

  • Hash Cond: ((prio.bus_ent_inst_name_num)::numeric = beia_4.ent_inst_att_num_value)
60. 1,032.045 2,801.265 ↑ 5,893.7 3 147,435

Bitmap Heap Scan on bus_ent_instance prio (cost=637.59..62,150.29 rows=17,681 width=7) (actual time=0.016..0.019 rows=3 loops=147,435)

  • Recheck Cond: (bus_ent_id = 1034)
  • Heap Blocks: exact=147435
61. 1,769.220 1,769.220 ↑ 5,893.7 3 147,435

Bitmap Index Scan on ix_bus_ent_instance_01 (cost=0.00..633.17 rows=17,681 width=0) (actual time=0.012..0.012 rows=3 loops=147,435)

  • Index Cond: (bus_ent_id = 1034)
62. 2,081.080 50,778.352 ↓ 0.0 0 416,216

Hash (cost=35.41..35.41 rows=4 width=5) (actual time=0.122..0.122 rows=0 loops=416,216)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
63. 2,497.296 48,697.272 ↓ 0.0 0 416,216

Nested Loop (cost=0.86..35.41 rows=4 width=5) (actual time=0.116..0.117 rows=0 loops=416,216)

64. 7,075.672 7,075.672 ↑ 1.0 1 416,216

Index Scan using ix_attribute_03 on attribute att_4 (cost=0.28..8.30 rows=1 width=4) (actual time=0.016..0.017 rows=1 loops=416,216)

  • Index Cond: ((att_name)::text = 'NC_PRIORIDAD_PRIORIDAD_SUGERIDA_ENUM'::text)
65. 39,124.304 39,124.304 ↓ 0.0 0 416,216

Index Scan using ix_bus_ent_inst_attr_01 on bus_ent_inst_attribute beia_4 (cost=0.58..27.00 rows=11 width=9) (actual time=0.094..0.094 rows=0 loops=416,216)

  • Index Cond: ((ei.bus_ent_inst_id_auto = bus_ent_inst_id) AND (att_id = att_4.att_id_auto))
66. 4,023.094 330,475.504 ↓ 0.0 0 416,216

Hash Join (cost=673.05..62,296.27 rows=1 width=3) (actual time=0.793..0.794 rows=0 loops=416,216)

  • Hash Cond: (art.bus_ent_inst_name_num = (beia_5.ent_inst_att_str_value)::integer)
67. 353.272 971.498 ↑ 8,840.5 2 44,159

Bitmap Heap Scan on bus_ent_instance art (cost=637.59..62,150.29 rows=17,681 width=7) (actual time=0.020..0.022 rows=2 loops=44,159)

  • Recheck Cond: (bus_ent_id = 1009)
  • Heap Blocks: exact=44159
68. 618.226 618.226 ↑ 8,840.5 2 44,159

Bitmap Index Scan on ix_bus_ent_instance_01 (cost=0.00..633.17 rows=17,681 width=0) (actual time=0.014..0.014 rows=2 loops=44,159)

  • Index Cond: (bus_ent_id = 1009)
69. 2,081.080 325,480.912 ↓ 0.0 0 416,216

Hash (cost=35.41..35.41 rows=4 width=15) (actual time=0.782..0.782 rows=0 loops=416,216)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
70. 2,081.080 323,399.832 ↓ 0.0 0 416,216

Nested Loop (cost=0.86..35.41 rows=4 width=15) (actual time=0.777..0.777 rows=0 loops=416,216)

71. 6,659.456 6,659.456 ↑ 1.0 1 416,216

Index Scan using ix_attribute_03 on attribute att_5 (cost=0.28..8.30 rows=1 width=4) (actual time=0.015..0.016 rows=1 loops=416,216)

  • Index Cond: ((att_name)::text = 'NC_ART_PRE_ARCHIVO_STR'::text)
72. 314,659.296 314,659.296 ↓ 0.0 0 416,216

Index Scan using ix_bus_ent_inst_attr_01 on bus_ent_inst_attribute beia_5 (cost=0.58..27.00 rows=11 width=19) (actual time=0.756..0.756 rows=0 loops=416,216)

  • Index Cond: ((ei.bus_ent_inst_id_auto = bus_ent_inst_id) AND (att_id = att_5.att_id_auto))
73. 2,081.080 158,994.512 ↓ 0.0 0 416,216

Nested Loop (cost=0.86..35.41 rows=4 width=15) (actual time=0.382..0.382 rows=0 loops=416,216)

74. 6,659.456 6,659.456 ↑ 1.0 1 416,216

Index Scan using ix_attribute_03 on attribute att_6 (cost=0.28..8.30 rows=1 width=4) (actual time=0.015..0.016 rows=1 loops=416,216)

  • Index Cond: ((att_name)::text = 'CASO_ELIMINADO_ID_NUEVO'::text)
75. 150,253.976 150,253.976 ↓ 0.0 0 416,216

Index Scan using ix_bus_ent_inst_attr_01 on bus_ent_inst_attribute beia_6 (cost=0.58..27.00 rows=11 width=19) (actual time=0.361..0.361 rows=0 loops=416,216)

  • Index Cond: ((ei.bus_ent_inst_id_auto = bus_ent_inst_id) AND (att_id = att_6.att_id_auto))
76. 2,081.080 8,324.320 ↓ 0.0 0 416,216

Nested Loop (cost=0.86..35.41 rows=4 width=15) (actual time=0.020..0.020 rows=0 loops=416,216)

77. 4,162.160 4,162.160 ↑ 1.0 1 416,216

Index Scan using ix_attribute_03 on attribute att_7 (cost=0.28..8.30 rows=1 width=4) (actual time=0.010..0.010 rows=1 loops=416,216)

  • Index Cond: ((att_name)::text = 'CASO_ELIMINADO_ID_NUEVO'::text)
78. 2,081.080 2,081.080 ↓ 0.0 0 416,216

Index Scan using ix_bus_ent_inst_attr_01 on bus_ent_inst_attribute beia_7 (cost=0.58..27.00 rows=11 width=19) (actual time=0.005..0.005 rows=0 loops=416,216)

  • Index Cond: ((ei.bus_ent_inst_id_auto = bus_ent_inst_id) AND (att_id = att_7.att_id_auto))
79. 15,816.208 11,083,415.864 ↑ 1.0 1 416,216

Aggregate (cost=8.46..8.47 rows=1 width=8) (actual time=26.628..26.629 rows=1 loops=416,216)

80. 11,067,599.656 11,067,599.656 ↓ 11.0 11 416,216

Index Scan using ix_bus_ent_instance_log_reporte_nc_por_estados on bus_ent_instance_log beil (cost=0.43..8.46 rows=1 width=8) (actual time=3.264..26.591 rows=11 loops=416,216)

  • Index Cond: ((bus_ent_id = 1006) AND (bus_ent_inst_name_num = ei.bus_ent_inst_name_num) AND (reg_status = 0))
  • Filter: (env_id = 1001)