explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KL4Y

Settings
# exclusive inclusive rows x rows loops node
1. 1,288.438 320,337.262 ↓ 1,573.0 1,573 1

Nested Loop (cost=14,503.85..71,129.53 rows=1 width=1,171) (actual time=740.642..320,337.262 rows=1,573 loops=1)

  • Join Filter: (((link.trml_id)::text = (terminal_1.id)::text) AND ((band.band_name)::text = (link_1.band_name)::text))
  • Rows Removed by Join Filter: 2940527
2. 6.344 317,730.549 ↓ 1,575.0 1,575 1

Nested Loop (cost=9,588.12..65,384.17 rows=1 width=1,182) (actual time=623.308..317,730.549 rows=1,575 loops=1)

3. 12.312 317,711.605 ↓ 1,575.0 1,575 1

Nested Loop (cost=9,587.84..65,383.84 rows=1 width=1,177) (actual time=623.285..317,711.605 rows=1,575 loops=1)

4. 9,023.305 317,674.093 ↓ 1,575.0 1,575 1

Nested Loop (cost=9,587.56..65,383.52 rows=1 width=1,236) (actual time=623.246..317,674.093 rows=1,575 loops=1)

  • Join Filter: ((fullpath.satellite_full_path_id)::text = (rel.satellite_full_path_id)::text)
  • Rows Removed by Join Filter: 49216587
5. 59.887 596.342 ↓ 16,639.0 16,639 1

Nested Loop (cost=3,383.23..56,942.51 rows=1 width=881) (actual time=523.216..596.342 rows=16,639 loops=1)

  • Join Filter: ((band.band_name)::text = (upband.band_type)::text)
  • Rows Removed by Join Filter: 49917
6. 0.022 0.071 ↑ 1.0 4 1

Merge Join (cost=2.60..2.76 rows=4 width=26) (actual time=0.044..0.071 rows=4 loops=1)

  • Merge Cond: ((upband.band_type)::text = (downband.band_type)::text)
7. 0.018 0.032 ↑ 1.0 4 1

Sort (cost=1.30..1.31 rows=4 width=13) (actual time=0.026..0.032 rows=4 loops=1)

  • Sort Key: upband.band_type
  • Sort Method: quicksort Memory: 25kB
8. 0.014 0.014 ↑ 1.0 4 1

Seq Scan on terminal_operational_range upband (cost=0.00..1.26 rows=4 width=13) (actual time=0.011..0.014 rows=4 loops=1)

  • Filter: (direction = '0'::numeric)
  • Rows Removed by Filter: 4
9. 0.011 0.017 ↑ 1.0 4 1

Sort (cost=1.30..1.31 rows=4 width=13) (actual time=0.015..0.017 rows=4 loops=1)

  • Sort Key: downband.band_type
  • Sort Method: quicksort Memory: 25kB
10. 0.006 0.006 ↑ 1.0 4 1

Seq Scan on terminal_operational_range downband (cost=0.00..1.26 rows=4 width=13) (actual time=0.004..0.006 rows=4 loops=1)

  • Filter: ('1'::numeric = direction)
  • Rows Removed by Filter: 4
11. 51.677 536.384 ↓ 16,639.0 16,639 4

Materialize (cost=3,380.63..56,939.61 rows=1 width=855) (actual time=77.427..134.096 rows=16,639 loops=4)

12. 25.836 484.707 ↓ 16,639.0 16,639 1

Hash Join (cost=3,380.63..56,939.61 rows=1 width=855) (actual time=309.699..484.707 rows=16,639 loops=1)

  • Hash Cond: (((*SELECT* 1".carrier_id)::text = (carrier.end_end_connectivity_group_id)::text) AND (("*SELECT* 1".terminal_id)::text = (link.trml_id)::text) AND (("*SELECT* 1".eec_id)::text = (eec.end_end_cnct_id)::text)
13. 4.233 152.195 ↓ 11.8 16,599 1

Append (cost=46.95..53,584.86 rows=1,403 width=316) (actual time=3.007..152.195 rows=16,599 loops=1)

14. 0.023 33.937 ↓ 58.0 58 1

Subquery Scan on *SELECT* 1" (cost=46.95..5,668.35 rows=1 width=309) (actual time=3.006..33.937 rows=58 loops=1)

15. 0.095 33.914 ↓ 58.0 58 1

Nested Loop (cost=46.95..5,668.32 rows=1 width=341) (actual time=3.006..33.914 rows=58 loops=1)

  • Join Filter: (((scenario.sa_run_id)::text = (terminal_output.sa_run_id)::text) AND (scenario.epoch = terminal_output.epoch))
16. 12.206 33.529 ↑ 1.8 58 1

Hash Join (cost=46.40..5,286.34 rows=102 width=317) (actual time=2.979..33.529 rows=58 loops=1)

  • Hash Cond: (((carrier_output.sa_run_id)::text = (scenario.sa_run_id)::text) AND (carrier_output.epoch = scenario.epoch))
17. 21.309 21.309 ↑ 1.0 56,872 1

Seq Scan on sa_carrier_tx_trml_output carrier_output (cost=0.00..4,810.34 rows=56,872 width=270) (actual time=0.006..21.309 rows=56,872 loops=1)

  • Filter: (sat_orbital_pstn = '5'::numeric)
18. 0.006 0.014 ↑ 80.0 7 1

Hash (cost=26.80..26.80 rows=560 width=47) (actual time=0.014..0.014 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.008 0.008 ↑ 80.0 7 1

Seq Scan on op_sat_scenario_vw scenario (cost=0.00..26.80 rows=560 width=47) (actual time=0.005..0.008 rows=7 loops=1)

20. 0.290 0.290 ↑ 1.0 1 58

Index Scan using sa_tx_terminal_output_pk on sa_tx_terminal_output terminal_output (cost=0.56..3.71 rows=1 width=184) (actual time=0.005..0.005 rows=1 loops=58)

  • Index Cond: (((sa_run_id)::text = (carrier_output.sa_run_id)::text) AND (epoch = carrier_output.epoch) AND (sat_orbital_pstn = '5'::numeric) AND ((trml_id)::text = (carrier_output.trml_id)::text))
21. 5.447 114.025 ↓ 11.8 16,541 1

Subquery Scan on *SELECT* 2" (cost=1.94..47,916.51 rows=1,402 width=316) (actual time=0.264..114.025 rows=16,541 loops=1)

22. 7.029 108.578 ↓ 11.8 16,541 1

Nested Loop (cost=1.94..47,874.45 rows=1,402 width=348) (actual time=0.263..108.578 rows=16,541 loops=1)

23. 1.598 83.369 ↓ 9.1 1,515 1

Nested Loop (cost=1.52..47,703.65 rows=167 width=316) (actual time=0.247..83.369 rows=1,515 loops=1)

24. 1.804 77.226 ↓ 9.1 1,515 1

Nested Loop (cost=1.24..47,650.20 rows=167 width=248) (actual time=0.233..77.226 rows=1,515 loops=1)

  • Join Filter: (((scenario_1.sa_run_id)::text = (carrier_output_1.sa_run_id)::text) AND (scenario_1.epoch = carrier_output_1.epoch))
25. 0.533 1.164 ↑ 10.8 694 1

Nested Loop (cost=0.56..30,969.43 rows=7,485 width=231) (actual time=0.116..1.164 rows=694 loops=1)

26. 0.022 0.022 ↑ 80.0 7 1

Seq Scan on op_sat_scenario_vw scenario_1 (cost=0.00..26.80 rows=560 width=47) (actual time=0.018..0.022 rows=7 loops=1)

27. 0.609 0.609 ↓ 3.7 99 7

Index Scan using online_fk236_i on sa_tx_terminal_output terminal_output_1 (cost=0.56..54.44 rows=27 width=184) (actual time=0.025..0.087 rows=99 loops=7)

  • Index Cond: (((sa_run_id)::text = (scenario_1.sa_run_id)::text) AND (epoch = scenario_1.epoch) AND (sat_orbital_pstn = '5'::numeric))
28. 74.258 74.258 ↓ 2.0 2 694

Index Scan using sa_wgs_carrier_tx_trml_outp_pk on sa_wgs_carrier_tx_trml_output carrier_output_1 (cost=0.69..2.19 rows=1 width=209) (actual time=0.057..0.107 rows=2 loops=694)

  • Index Cond: (((sa_run_id)::text = (terminal_output_1.sa_run_id)::text) AND (epoch = terminal_output_1.epoch) AND (sat_orbital_pstn = '5'::numeric) AND ((trml_id)::text = (terminal_output_1.trml_id)::text))
29. 4.545 4.545 ↑ 1.0 1 1,515

Index Scan using end_end_connect_pk on end_end_connect eec_1 (cost=0.28..0.32 rows=1 width=68) (actual time=0.003..0.003 rows=1 loops=1,515)

  • Index Cond: ((end_end_cnct_id)::text = (carrier_output_1.end_end_cnct_id)::text)
30. 18.180 18.180 ↓ 1.2 11 1,515

Index Scan using online_fk345_i on sfp_eec_rel rel_1 (cost=0.41..0.75 rows=9 width=68) (actual time=0.004..0.012 rows=11 loops=1,515)

  • Index Cond: ((end_end_cnct_id)::text = (carrier_output_1.end_end_cnct_id)::text)
31. 72.543 306.676 ↓ 123.5 36,298 1

Hash (cost=3,321.92..3,321.92 rows=294 width=675) (actual time=306.676..306.676 rows=36,298 loops=1)

  • Buckets: 65536 (originally 1024) Batches: 1 (originally 1) Memory Usage: 26468kB
32. 17.646 234.133 ↓ 123.5 36,298 1

Nested Loop (cost=831.71..3,321.92 rows=294 width=675) (actual time=3.285..234.133 rows=36,298 loops=1)

33. 3.457 171.151 ↓ 77.1 3,778 1

Nested Loop (cost=831.30..3,255.77 rows=49 width=607) (actual time=3.261..171.151 rows=3,778 loops=1)

34. 3.076 156.360 ↓ 77.1 3,778 1

Hash Left Join (cost=831.02..3,239.28 rows=49 width=566) (actual time=3.248..156.360 rows=3,778 loops=1)

  • Hash Cond: ((termconfig.classification_code)::text = (classification.code)::text)
35. 5.961 153.274 ↓ 77.1 3,778 1

Nested Loop (cost=829.77..3,236.78 rows=49 width=562) (actual time=3.232..153.274 rows=3,778 loops=1)

36. 3.817 139.757 ↓ 77.1 3,778 1

Nested Loop (cost=829.49..3,221.37 rows=49 width=577) (actual time=3.222..139.757 rows=3,778 loops=1)

  • Join Filter: (((band.activity_id)::text = (locband.activity_id)::text) AND ((band.band_name)::text = (locband.band_name)::text))
  • Rows Removed by Join Filter: 2
37. 3.426 124.606 ↓ 40.6 3,778 1

Nested Loop (cost=829.21..3,185.93 rows=93 width=686) (actual time=3.211..124.606 rows=3,778 loops=1)

38. 4.081 109.846 ↓ 17.3 3,778 1

Nested Loop (cost=828.93..3,103.26 rows=218 width=633) (actual time=3.200..109.846 rows=3,778 loops=1)

39. 3.239 94.431 ↓ 7.4 3,778 1

Hash Left Join (cost=828.65..2,910.26 rows=510 width=544) (actual time=3.185..94.431 rows=3,778 loops=1)

  • Hash Cond: ((termconfig.caveat_id)::text = (caveat.id)::text)
40. 3.484 91.158 ↓ 7.4 3,778 1

Nested Loop (cost=825.21..2,890.47 rows=510 width=529) (actual time=3.144..91.158 rows=3,778 loops=1)

41. 4.122 76.340 ↓ 7.4 3,778 1

Nested Loop (cost=824.93..2,717.38 rows=513 width=485) (actual time=3.130..76.340 rows=3,778 loops=1)

42. 7.118 53.350 ↓ 5.1 4,717 1

Nested Loop (cost=824.51..2,112.49 rows=928 width=437) (actual time=3.118..53.350 rows=4,717 loops=1)

43. 3.822 34.904 ↓ 5.5 3,776 1

Nested Loop (cost=824.23..1,842.68 rows=682 width=266) (actual time=3.107..34.904 rows=3,776 loops=1)

44. 3.284 19.754 ↓ 5.5 3,776 1

Nested Loop (cost=823.95..1,545.70 rows=682 width=228) (actual time=3.095..19.754 rows=3,776 loops=1)

45. 2.862 7.318 ↓ 5.5 2,288 1

Hash Join (cost=823.66..1,315.58 rows=416 width=62) (actual time=3.082..7.318 rows=2,288 loops=1)

  • Hash Cond: ((carrier.activity_id)::text = (service.activity_id)::text)
46. 1.397 1.397 ↑ 1.0 4,805 1

Seq Scan on end_end_connectivity_group carrier (cost=0.00..335.15 rows=4,805 width=96) (actual time=0.009..1.397 rows=4,805 loops=1)

47. 0.470 3.059 ↑ 1.2 1,283 1

Hash (cost=773.42..773.42 rows=1,546 width=38) (actual time=3.059..3.059 rows=1,283 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 99kB
48. 2.312 2.589 ↑ 1.2 1,283 1

Bitmap Heap Scan on activity service (cost=43.63..773.42 rows=1,546 width=38) (actual time=0.356..2.589 rows=1,283 loops=1)

  • Recheck Cond: ('Service'::text = (activity_type)::text)
  • Filter: ((life_cycle_state_id)::text = 'Incorporated'::text)
  • Rows Removed by Filter: 1502
  • Heap Blocks: exact=607
49. 0.277 0.277 ↓ 1.0 2,804 1

Bitmap Index Scan on activity_activity_type_fk_i (cost=0.00..43.24 rows=2,794 width=0) (actual time=0.277..0.277 rows=2,804 loops=1)

  • Index Cond: ('Service'::text = (activity_type)::text)
50. 9.152 9.152 ↑ 1.0 2 2,288

Index Scan using online_fk61_i on end_end_connect eec (cost=0.28..0.49 rows=2 width=166) (actual time=0.003..0.004 rows=2 loops=2,288)

  • Index Cond: ((end_end_connectivity_group_id)::text = (carrier.end_end_connectivity_group_id)::text)
51. 11.328 11.328 ↑ 1.0 1 3,776

Index Scan using rf_link_pk on rf_link link (cost=0.29..0.44 rows=1 width=72) (actual time=0.003..0.003 rows=1 loops=3,776)

  • Index Cond: ((rf_link_id)::text = (eec.uplink)::text)
52. 11.328 11.328 ↑ 1.0 1 3,776

Index Scan using termband_terminal_fk_i on terminal_band band (cost=0.28..0.37 rows=1 width=171) (actual time=0.003..0.003 rows=1 loops=3,776)

  • Index Cond: ((terminal_id)::text = (link.trml_id)::text)
53. 18.868 18.868 ↑ 1.0 1 4,717

Index Scan using activity_pk on activity termconfig (cost=0.41..0.65 rows=1 width=48) (actual time=0.004..0.004 rows=1 loops=4,717)

  • Index Cond: ((activity_id)::text = (band.activity_id)::text)
  • Filter: ((life_cycle_state_id)::text = 'Incorporated'::text)
  • Rows Removed by Filter: 0
54. 11.334 11.334 ↑ 1.0 1 3,778

Index Scan using terminal_pk on terminal (cost=0.28..0.34 rows=1 width=44) (actual time=0.003..0.003 rows=1 loops=3,778)

  • Index Cond: ((id)::text = (link.trml_id)::text)
55. 0.017 0.034 ↑ 1.0 39 1

Hash (cost=2.17..2.17 rows=39 width=46) (actual time=0.034..0.034 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
56. 0.017 0.017 ↑ 1.0 39 1

Seq Scan on caveat (cost=0.00..2.17 rows=39 width=46) (actual time=0.009..0.017 rows=39 loops=1)

57. 11.334 11.334 ↑ 1.0 1 3,778

Index Scan using terminal_static_pk on terminal_static static (cost=0.28..0.38 rows=1 width=89) (actual time=0.003..0.003 rows=1 loops=3,778)

  • Index Cond: ((activity_id)::text = (band.activity_id)::text)
58. 11.334 11.334 ↑ 1.0 1 3,778

Index Scan using terminal_location_pk on terminal_location location (cost=0.28..0.38 rows=1 width=53) (actual time=0.003..0.003 rows=1 loops=3,778)

  • Index Cond: ((activity_id)::text = (band.activity_id)::text)
59. 11.334 11.334 ↑ 1.0 1 3,778

Index Scan using termlocband_termloc_fk_i on terminal_location_band locband (cost=0.28..0.35 rows=1 width=43) (actual time=0.003..0.003 rows=1 loops=3,778)

  • Index Cond: ((activity_id)::text = (termconfig.activity_id)::text)
60. 7.556 7.556 ↑ 1.0 1 3,778

Index Scan using terminal_type_pk on terminal_type (cost=0.27..0.31 rows=1 width=61) (actual time=0.002..0.002 rows=1 loops=3,778)

  • Index Cond: ((id)::text = (static.terminal_type_id)::text)
61. 0.004 0.010 ↑ 1.0 4 1

Hash (cost=1.12..1.12 rows=4 width=6) (actual time=0.010..0.010 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
62. 0.006 0.006 ↑ 1.0 4 1

Seq Scan on classification (cost=0.00..1.12 rows=4 width=6) (actual time=0.005..0.006 rows=4 loops=1)

63. 11.334 11.334 ↑ 1.0 1 3,778

Index Scan using terminal_ufb_pk on terminal_ufb ufb (cost=0.28..0.34 rows=1 width=41) (actual time=0.003..0.003 rows=1 loops=3,778)

  • Index Cond: ((terminal_id)::text = (link.trml_id)::text)
64. 45.336 45.336 ↓ 1.1 10 3,778

Index Scan using online_fk345_i on sfp_eec_rel rel (cost=0.41..1.08 rows=9 width=68) (actual time=0.004..0.012 rows=10 loops=3,778)

  • Index Cond: ((end_end_cnct_id)::text = (eec.end_end_cnct_id)::text)
65. 112,978.771 308,054.446 ↓ 1.0 2,958 16,639

Hash Join (cost=6,204.33..8,346.69 rows=2,902 width=423) (actual time=0.014..18.514 rows=2,958 loops=16,639)

  • Hash Cond: ((fullpath.satellite_config_id)::text = (incorporated.satellite_config_id)::text)
66. 195,019.273 195,075.636 ↑ 1.1 29,618 16,639

HashAggregate (cost=6,202.21..7,169.41 rows=32,240 width=638) (actual time=0.006..11.724 rows=29,618 loops=16,639)

  • Group Key: fullpath.satellite_full_path_id, fullpath.full_path_name, fullpath.satellite_config_id, (NULL::character varying), (0), fullpath.sat_uplink_path_id, path.switch_id, path.satellite_antenna_id
67. 7.048 56.363 ↑ 1.1 29,618 1

Append (cost=7.84..5,557.41 rows=32,240 width=638) (actual time=0.111..56.363 rows=29,618 loops=1)

68. 0.562 2.261 ↑ 1.0 126 1

Merge Join (cost=7.84..304.36 rows=126 width=249) (actual time=0.110..2.261 rows=126 loops=1)

  • Merge Cond: ((fullpath.sat_uplink_path_id)::text = (path.sat_path_id)::text)
69. 0.132 0.132 ↑ 1.0 126 1

Index Scan using online_fk319_i on satellite_full_path fullpath (cost=0.29..242.97 rows=126 width=135) (actual time=0.014..0.132 rows=126 loops=1)

  • Index Cond: (sat_uplink_path_id IS NOT NULL)
70. 1.567 1.567 ↑ 1.0 2,441 1

Index Scan using satellite_path_pk on satellite_path path (cost=0.28..295.99 rows=2,449 width=117) (actual time=0.013..1.567 rows=2,441 loops=1)

71. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=249) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
72. 23.306 47.052 ↑ 1.1 29,492 1

Hash Join (cost=1,229.76..4,285.91 rows=32,112 width=244) (actual time=13.660..47.052 rows=29,492 loops=1)

  • Hash Cond: ((fullpath_1.wgs_uplink_path_id)::text = (wgspath.wgs_actual_path_id)::text)
73. 10.146 10.146 ↑ 1.0 32,112 1

Seq Scan on satellite_full_path fullpath_1 (cost=0.00..1,974.14 rows=32,112 width=164) (actual time=0.012..10.146 rows=32,112 loops=1)

  • Filter: (sat_uplink_path_id IS NULL)
  • Rows Removed by Filter: 126
74. 4.169 13.600 ↑ 1.0 7,214 1

Hash (cost=995.30..995.30 rows=7,214 width=196) (actual time=13.600..13.600 rows=7,214 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 1527kB
75. 4.197 9.431 ↑ 1.0 7,214 1

Hash Join (cost=372.41..995.30 rows=7,214 width=196) (actual time=3.547..9.431 rows=7,214 loops=1)

  • Hash Cond: ((wgspath.sat_path_id)::text = (path_1.sat_path_id)::text)
76. 1.720 1.720 ↑ 1.0 7,214 1

Seq Scan on wgs_actual_path wgspath (cost=0.00..379.42 rows=7,214 width=73) (actual time=0.008..1.720 rows=7,214 loops=1)

77. 1.209 3.514 ↑ 1.0 2,449 1

Hash (cost=292.82..292.82 rows=2,449 width=162) (actual time=3.514..3.514 rows=2,449 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 433kB
78. 1.421 2.305 ↑ 1.0 2,449 1

Hash Join (cost=54.56..292.82 rows=2,449 width=162) (actual time=0.431..2.305 rows=2,449 loops=1)

  • Hash Cond: ((path_1.satellite_antenna_id)::text = (antenna_1.satellite_antenna_id)::text)
79. 0.467 0.467 ↑ 1.0 2,449 1

Seq Scan on satellite_path path_1 (cost=0.00..158.47 rows=2,449 width=156) (actual time=0.005..0.467 rows=2,449 loops=1)

80. 0.230 0.417 ↑ 1.0 649 1

Hash (cost=33.47..33.47 rows=649 width=45) (actual time=0.417..0.417 rows=649 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 58kB
81. 0.187 0.187 ↑ 1.0 649 1

Seq Scan on satellite_antenna antenna_1 (cost=0.00..33.47 rows=649 width=45) (actual time=0.009..0.187 rows=649 loops=1)

82. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=244) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
83. 0.016 0.039 ↑ 1.0 18 1

Hash (cost=1.54..1.54 rows=18 width=82) (actual time=0.039..0.039 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
84. 0.023 0.023 ↑ 1.0 18 1

Seq Scan on incorporated_mv incorporated (cost=0.00..1.54 rows=18 width=82) (actual time=0.018..0.023 rows=18 loops=1)

85. 25.200 25.200 ↑ 1.0 1 1,575

Index Scan using satellite_path_pk on satellite_path satpath (cost=0.28..0.32 rows=1 width=78) (actual time=0.016..0.016 rows=1 loops=1,575)

  • Index Cond: ((sat_path_id)::text = (fullpath.sat_uplink_path_id)::text)
86. 12.600 12.600 ↑ 1.0 1 1,575

Index Scan using satellite_antenna_pk on satellite_antenna antenna (cost=0.28..0.33 rows=1 width=44) (actual time=0.008..0.008 rows=1 loops=1,575)

  • Index Cond: ((satellite_antenna_id)::text = (satpath.satellite_antenna_id)::text)
87. 1,208.602 1,318.275 ↑ 4.7 1,868 1,575

HashAggregate (cost=4,915.73..5,177.39 rows=8,722 width=91) (actual time=0.075..0.837 rows=1,868 loops=1,575)

  • Group Key: satellite.satellite_designator, satellite.satellite_id, terminal_1.designator, terminal_1.id, link_1.band_name
88. 3.129 109.673 ↑ 1.2 7,552 1

Merge Join (cost=1.91..4,806.70 rows=8,722 width=91) (actual time=0.201..109.673 rows=7,552 loops=1)

  • Merge Cond: ((service_1.satellite_id)::text = (satellite.satellite_id)::text)
89. 7.164 106.516 ↑ 1.2 7,552 1

Nested Loop (cost=1.77..23,107.34 rows=8,722 width=85) (actual time=0.181..106.516 rows=7,552 loops=1)

90. 11.940 84.248 ↑ 1.2 7,552 1

Nested Loop (cost=1.48..20,164.58 rows=8,722 width=79) (actual time=0.158..84.248 rows=7,552 loops=1)

91. 4.366 45.876 ↑ 1.2 3,776 1

Nested Loop (cost=0.85..8,118.66 rows=4,361 width=107) (actual time=0.111..45.876 rows=3,776 loops=1)

92. 3.418 34.646 ↑ 1.2 2,288 1

Nested Loop (cost=0.57..6,647.72 rows=2,659 width=73) (actual time=0.091..34.646 rows=2,288 loops=1)

93. 11.520 11.520 ↑ 1.0 9,854 1

Index Scan using activity_satellite_fk_i on activity service_1 (cost=0.29..2,064.73 rows=9,885 width=77) (actual time=0.041..11.520 rows=9,854 loops=1)

  • Filter: ((life_cycle_state_id)::text = 'Incorporated'::text)
  • Rows Removed by Filter: 7955
94. 19.708 19.708 ↓ 0.0 0 9,854

Index Scan using eecg_activity_fk_i on end_end_connectivity_group carrier_1 (cost=0.28..0.40 rows=2 width=68) (actual time=0.002..0.002 rows=0 loops=9,854)

  • Index Cond: ((activity_id)::text = (service_1.activity_id)::text)
95. 6.864 6.864 ↑ 1.0 2 2,288

Index Scan using online_fk61_i on end_end_connect eec_2 (cost=0.28..0.49 rows=2 width=102) (actual time=0.003..0.003 rows=2 loops=2,288)

  • Index Cond: ((end_end_connectivity_group_id)::text = (carrier_1.end_end_connectivity_group_id)::text)
96. 7.552 26.432 ↑ 1.0 2 3,776

Bitmap Heap Scan on rf_link link_1 (cost=0.63..2.70 rows=2 width=74) (actual time=0.006..0.007 rows=2 loops=3,776)

  • Recheck Cond: (((eec_2.uplink)::text = (rf_link_id)::text) OR ((eec_2.downlink)::text = (rf_link_id)::text))
  • Heap Blocks: exact=4646
97. 3.776 18.880 ↓ 0.0 0 3,776

BitmapOr (cost=0.63..0.63 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=3,776)

98. 7.552 7.552 ↑ 1.0 1 3,776

Bitmap Index Scan on rf_link_pk (cost=0.00..0.32 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=3,776)

  • Index Cond: ((eec_2.uplink)::text = (rf_link_id)::text)
99. 7.552 7.552 ↑ 1.0 1 3,776

Bitmap Index Scan on rf_link_pk (cost=0.00..0.32 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=3,776)

  • Index Cond: ((eec_2.downlink)::text = (rf_link_id)::text)
100. 15.104 15.104 ↑ 1.0 1 7,552

Index Scan using terminal_pk on terminal terminal_1 (cost=0.28..0.34 rows=1 width=44) (actual time=0.002..0.002 rows=1 loops=7,552)

  • Index Cond: ((id)::text = (link_1.trml_id)::text)
101. 0.028 0.028 ↑ 1.1 35 1

Index Scan using satellite_pk on satellite (cost=0.14..7.43 rows=37 width=45) (actual time=0.012..0.028 rows=35 loops=1)