explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qSU4 : Chad's flag change

Settings
# exclusive inclusive rows x rows loops node
1. 45.494 16,614.637 ↓ 62,505.0 62,505 1

Nested Loop Left Join (cost=1,344,603.77..1,621,964.65 rows=1 width=730) (actual time=13,094.894..16,614.637 rows=62,505 loops=1)

  • Join Filter: ((p.provider_id = ncn.provider_id) AND (p.provider_location_id = ncn.provider_location_id) AND (p.product_id = ncn.product_id))
2.          

CTE networks

3. 1,826.739 9,793.634 ↑ 1.1 62,505 1

GroupAggregate (cost=572,868.68..665,852.57 rows=65,713 width=445) (actual time=7,758.937..9,793.634 rows=62,505 loops=1)

  • Group Key: ock.strenuus_id, ock.strenuus_location_id, op.product_id, os.specialty_id, os.board_cert_id
4. 78.393 7,779.380 ↓ 1.4 93,418 1

Sort (cost=572,868.68..573,032.96 rows=65,713 width=311) (actual time=7,758.745..7,779.380 rows=93,418 loops=1)

  • Sort Key: ock.strenuus_id, ock.strenuus_location_id, op.product_id, os.specialty_id, os.board_cert_id
  • Sort Method: quicksort Memory: 17154kB
5. 22.479 7,700.987 ↓ 1.4 93,418 1

Hash Left Join (cost=561,507.33..567,610.36 rows=65,713 width=311) (actual time=7,585.969..7,700.987 rows=93,418 loops=1)

  • Hash Cond: (op.composite_key_id = ot_mga.composite_key_id)
  • Join Filter: (os.provider_type_id = 13)
6. 24.245 7,661.661 ↓ 1.4 93,418 1

Hash Left Join (cost=556,777.42..562,634.01 rows=65,713 width=287) (actual time=7,569.107..7,661.661 rows=93,418 loops=1)

  • Hash Cond: (op.composite_key_id = ot_hai.composite_key_id)
  • Join Filter: (os.provider_type_id = 3)
7. 45.877 7,620.461 ↓ 1.4 93,418 1

Hash Right Join (cost=552,047.51..557,657.66 rows=65,713 width=255) (actual time=7,552.139..7,620.461 rows=93,418 loops=1)

  • Hash Cond: (ot_anpt.composite_key_id = op.composite_key_id)
8. 22.921 22.921 ↑ 1.0 59,493 1

Seq Scan on output_tag_518191 ot_anpt (cost=0.00..4,729.90 rows=59,499 width=20) (actual time=0.009..22.921 rows=59,493 loops=1)

  • Filter: (data_element_id = 71)
  • Rows Removed by Filter: 185459
9. 30.204 7,551.663 ↓ 1.4 93,418 1

Hash (cost=551,226.18..551,226.18 rows=65,706 width=243) (actual time=7,551.663..7,551.663 rows=93,418 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 12728kB
10. 36.483 7,521.459 ↓ 1.4 93,418 1

Hash Right Join (cost=545,517.60..551,226.18 rows=65,706 width=243) (actual time=7,459.930..7,521.459 rows=93,418 loops=1)

  • Hash Cond: (ot_han.composite_key_id = op.composite_key_id)
11. 17.585 127.382 ↓ 1.0 57,069 1

Hash Left Join (cost=7,004.34..11,881.72 rows=56,184 width=47) (actual time=101.887..127.382 rows=57,069 loops=1)

  • Hash Cond: (ot_han.data_value = ohad.hospital_affil_id)
12. 19.801 19.801 ↓ 1.0 57,069 1

Seq Scan on output_tag_518191 ot_han (cost=0.00..4,729.90 rows=56,184 width=20) (actual time=10.934..19.801 rows=57,069 loops=1)

  • Filter: (data_element_id = 1)
  • Rows Removed by Filter: 187883
13. 50.609 89.996 ↑ 1.0 218,415 1

Hash (cost=4,274.15..4,274.15 rows=218,415 width=45) (actual time=89.996..89.996 rows=218,415 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 18747kB
14. 39.387 39.387 ↑ 1.0 218,415 1

Seq Scan on output_hospital_affil_domain ohad (cost=0.00..4,274.15 rows=218,415 width=45) (actual time=0.009..39.387 rows=218,415 loops=1)

15. 20.937 7,357.594 ↑ 1.0 65,691 1

Hash (cost=537,691.94..537,691.94 rows=65,706 width=204) (actual time=7,357.594..7,357.594 rows=65,691 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 7956kB
16. 14.217 7,336.657 ↑ 1.0 65,691 1

Merge Left Join (cost=536,409.04..537,691.94 rows=65,706 width=204) (actual time=7,240.949..7,336.657 rows=65,691 loops=1)

  • Merge Cond: (op.composite_key_id = ot_ps.composite_key_id)
17. 18.079 7,307.938 ↑ 1.0 65,691 1

Merge Left Join (cost=531,679.13..532,797.75 rows=65,706 width=192) (actual time=7,226.445..7,307.938 rows=65,691 loops=1)

  • Merge Cond: (op.composite_key_id = ot_enrid.composite_key_id)
18. 13.004 7,270.949 ↑ 1.0 65,691 1

Merge Left Join (cost=526,428.72..527,250.12 rows=65,706 width=180) (actual time=7,208.545..7,270.949 rows=65,691 loops=1)

  • Merge Cond: (op.composite_key_id = ot_tlbl.composite_key_id)
19. 13.195 7,243.318 ↑ 1.0 65,691 1

Merge Left Join (cost=521,698.81..522,355.92 rows=65,706 width=168) (actual time=7,193.916..7,243.318 rows=65,691 loops=1)

  • Merge Cond: (op.composite_key_id = ot_tlvl.composite_key_id)
20. 13.358 7,215.108 ↑ 1.0 65,691 1

Merge Left Join (cost=516,968.90..517,461.73 rows=65,706 width=156) (actual time=7,178.899..7,215.108 rows=65,691 loops=1)

  • Merge Cond: (op.composite_key_id = ot_anp.composite_key_id)
21. 16.208 7,185.681 ↑ 1.0 65,691 1

Merge Left Join (cost=512,238.99..512,567.54 rows=65,706 width=144) (actual time=7,162.828..7,185.681 rows=65,691 loops=1)

  • Merge Cond: (op.composite_key_id = ot_gnpi.composite_key_id)
22. 30.926 7,153.292 ↑ 1.0 65,691 1

Sort (cost=507,509.08..507,673.35 rows=65,706 width=132) (actual time=7,146.643..7,153.292 rows=65,691 loops=1)

  • Sort Key: op.composite_key_id
  • Sort Method: quicksort Memory: 12319kB
23. 3,702.701 7,122.366 ↑ 1.0 65,691 1

Hash Join (cost=20,881.07..502,251.37 rows=65,706 width=132) (actual time=210.636..7,122.366 rows=65,691 loops=1)

  • Hash Cond: (ock.id = op.composite_key_id)
24. 3,211.015 3,211.015 ↑ 1.0 25,095,354 1

Seq Scan on output_composite_key ock (cost=0.00..386,605.36 rows=25,095,436 width=12) (actual time=0.012..3,211.015 rows=25,095,354 loops=1)

25. 19.489 208.650 ↑ 1.0 65,691 1

Hash (cost=20,059.74..20,059.74 rows=65,706 width=132) (actual time=208.650..208.650 rows=65,691 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 8066kB
26. 14.359 189.161 ↑ 1.0 65,691 1

Hash Left Join (cost=13,950.54..20,059.74 rows=65,706 width=132) (actual time=109.785..189.161 rows=65,691 loops=1)

  • Hash Cond: (op.composite_key_id = ot_nm.composite_key_id)
27. 14.872 158.558 ↑ 1.0 65,691 1

Hash Left Join (cost=9,220.63..15,083.42 rows=65,706 width=120) (actual time=93.529..158.558 rows=65,691 loops=1)

  • Hash Cond: (op.composite_key_id = ot_fl.composite_key_id)
28. 28.091 120.156 ↑ 1.0 65,691 1

Hash Right Join (cost=4,490.71..10,107.10 rows=65,706 width=108) (actual time=69.984..120.156 rows=65,691 loops=1)

  • Hash Cond: (ot_gn.composite_key_id = op.composite_key_id)
29. 22.316 22.316 ↑ 1.0 61,121 1

Seq Scan on output_tag_518191 ot_gn (cost=0.00..4,729.90 rows=61,181 width=52) (actual time=0.011..22.316 rows=61,121 loops=1)

  • Filter: (data_element_id = 2)
  • Rows Removed by Filter: 183831
30. 14.639 69.749 ↑ 1.0 63,893 1

Hash (cost=3,692.05..3,692.05 rows=63,893 width=64) (actual time=69.749..69.749 rows=63,893 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 4924kB
31. 23.857 55.110 ↑ 1.0 63,893 1

Hash Join (cost=1,776.59..3,692.05 rows=63,893 width=64) (actual time=22.321..55.110 rows=63,893 loops=1)

  • Hash Cond: (os.composite_key_id = op.composite_key_id)
32. 9.163 9.163 ↑ 1.0 63,893 1

Seq Scan on output_specialty_518191 os (cost=0.00..1,036.93 rows=63,893 width=20) (actual time=0.011..9.163 rows=63,893 loops=1)

33. 10.839 22.090 ↑ 1.0 59,493 1

Hash (cost=1,032.93..1,032.93 rows=59,493 width=44) (actual time=22.089..22.090 rows=59,493 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3301kB
34. 11.251 11.251 ↑ 1.0 59,493 1

Seq Scan on output_product_518191 op (cost=0.00..1,032.93 rows=59,493 width=44) (actual time=0.010..11.251 rows=59,493 loops=1)

35. 0.000 23.530 ↓ 0.0 0 1

Hash (cost=4,729.90..4,729.90 rows=1 width=20) (actual time=23.530..23.530 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
36. 23.530 23.530 ↓ 0.0 0 1

Seq Scan on output_tag_518191 ot_fl (cost=0.00..4,729.90 rows=1 width=20) (actual time=23.530..23.530 rows=0 loops=1)

  • Filter: (data_element_id = 117)
  • Rows Removed by Filter: 244952
37. 0.001 16.244 ↓ 0.0 0 1

Hash (cost=4,729.90..4,729.90 rows=1 width=20) (actual time=16.243..16.244 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
38. 16.243 16.243 ↓ 0.0 0 1

Seq Scan on output_tag_518191 ot_nm (cost=0.00..4,729.90 rows=1 width=20) (actual time=16.243..16.243 rows=0 loops=1)

  • Filter: (data_element_id = 176)
  • Rows Removed by Filter: 244952
39. 0.010 16.181 ↓ 0.0 0 1

Sort (cost=4,729.91..4,729.91 rows=1 width=20) (actual time=16.181..16.181 rows=0 loops=1)

  • Sort Key: ot_gnpi.composite_key_id
  • Sort Method: quicksort Memory: 25kB
40. 16.171 16.171 ↓ 0.0 0 1

Seq Scan on output_tag_518191 ot_gnpi (cost=0.00..4,729.90 rows=1 width=20) (actual time=16.171..16.171 rows=0 loops=1)

  • Filter: (data_element_id = 83)
  • Rows Removed by Filter: 244952
41. 0.005 16.069 ↓ 0.0 0 1

Sort (cost=4,729.91..4,729.91 rows=1 width=20) (actual time=16.069..16.069 rows=0 loops=1)

  • Sort Key: ot_anp.composite_key_id
  • Sort Method: quicksort Memory: 25kB
42. 16.064 16.064 ↓ 0.0 0 1

Seq Scan on output_tag_518191 ot_anp (cost=0.00..4,729.90 rows=1 width=20) (actual time=16.064..16.064 rows=0 loops=1)

  • Filter: (data_element_id = 111)
  • Rows Removed by Filter: 244952
43. 0.004 15.015 ↓ 0.0 0 1

Sort (cost=4,729.91..4,729.91 rows=1 width=20) (actual time=15.015..15.015 rows=0 loops=1)

  • Sort Key: ot_tlvl.composite_key_id
  • Sort Method: quicksort Memory: 25kB
44. 15.011 15.011 ↓ 0.0 0 1

Seq Scan on output_tag_518191 ot_tlvl (cost=0.00..4,729.90 rows=1 width=20) (actual time=15.011..15.011 rows=0 loops=1)

  • Filter: (data_element_id = 137)
  • Rows Removed by Filter: 244952
45. 0.013 14.627 ↓ 0.0 0 1

Sort (cost=4,729.91..4,729.91 rows=1 width=20) (actual time=14.627..14.627 rows=0 loops=1)

  • Sort Key: ot_tlbl.composite_key_id
  • Sort Method: quicksort Memory: 25kB
46. 14.614 14.614 ↓ 0.0 0 1

Seq Scan on output_tag_518191 ot_tlbl (cost=0.00..4,729.90 rows=1 width=20) (actual time=14.614..14.614 rows=0 loops=1)

  • Filter: (data_element_id = 150)
  • Rows Removed by Filter: 244952
47. 3.555 18.910 ↓ 1.1 8,736 1

Sort (cost=5,250.40..5,270.47 rows=8,026 width=20) (actual time=17.895..18.910 rows=8,736 loops=1)

  • Sort Key: ot_enrid.composite_key_id
  • Sort Method: quicksort Memory: 1032kB
48. 15.355 15.355 ↓ 1.0 8,292 1

Seq Scan on output_tag_518191 ot_enrid (cost=0.00..4,729.90 rows=8,026 width=20) (actual time=14.039..15.355 rows=8,292 loops=1)

  • Filter: (data_element_id = 96)
  • Rows Removed by Filter: 236660
49. 0.003 14.502 ↓ 0.0 0 1

Sort (cost=4,729.91..4,729.91 rows=1 width=20) (actual time=14.502..14.502 rows=0 loops=1)

  • Sort Key: ot_ps.composite_key_id
  • Sort Method: quicksort Memory: 25kB
50. 14.499 14.499 ↓ 0.0 0 1

Seq Scan on output_tag_518191 ot_ps (cost=0.00..4,729.90 rows=1 width=20) (actual time=14.499..14.499 rows=0 loops=1)

  • Filter: (data_element_id = 10)
  • Rows Removed by Filter: 244952
51. 0.001 16.955 ↓ 0.0 0 1

Hash (cost=4,729.90..4,729.90 rows=1 width=40) (actual time=16.955..16.955 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
52. 16.954 16.954 ↓ 0.0 0 1

Seq Scan on output_tag_518191 ot_hai (cost=0.00..4,729.90 rows=1 width=40) (actual time=16.954..16.954 rows=0 loops=1)

  • Filter: ((data_value_2 IS NOT NULL) AND (data_element_id = 1))
  • Rows Removed by Filter: 244952
53. 0.001 16.847 ↓ 0.0 0 1

Hash (cost=4,729.90..4,729.90 rows=1 width=40) (actual time=16.847..16.847 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
54. 16.846 16.846 ↓ 0.0 0 1

Seq Scan on output_tag_518191 ot_mga (cost=0.00..4,729.90 rows=1 width=40) (actual time=16.846..16.846 rows=0 loops=1)

  • Filter: ((data_value_2 IS NOT NULL) AND (data_element_id = 1))
  • Rows Removed by Filter: 244952
55.          

SubPlan (for GroupAggregate)

56. 125.010 187.515 ↑ 1.0 1 62,505

Aggregate (cost=1.25..1.26 rows=1 width=32) (actual time=0.002..0.003 rows=1 loops=62,505)

57. 62.505 62.505 ↓ 0.0 0 62,505

Function Scan on unnest x (cost=0.00..1.00 rows=100 width=32) (actual time=0.001..0.001 rows=0 loops=62,505)

58.          

CTE network_pmg_client_networks

59. 0.001 10.791 ↓ 0.0 0 1

GroupAggregate (cost=415,483.07..474,523.07 rows=6,571 width=120) (actual time=10.791..10.791 rows=0 loops=1)

  • Group Key: networks.product_id, networks.provider_id, networks.provider_location_id, cnn.project_mapping_generation_id
60. 0.004 10.790 ↓ 0.0 0 1

Sort (cost=415,483.07..418,946.35 rows=1,385,311 width=36) (actual time=10.790..10.790 rows=0 loops=1)

  • Sort Key: networks.product_id, networks.provider_id, networks.provider_location_id, cnn.project_mapping_generation_id
  • Sort Method: quicksort Memory: 25kB
61. 0.001 10.786 ↓ 0.0 0 1

Hash Left Join (cost=6,790.96..274,169.03 rows=1,385,311 width=36) (actual time=10.786..10.786 rows=0 loops=1)

  • Hash Cond: ((cnn.project_mapping_generation_id = cn_sf.project_mapping_generation_id) AND ((cnn.client_network_id)::text = (cn_sf.client_network_id)::text))
  • Join Filter: (cn_sf.suppress_flags OR (networks.flags = '{ZELIS_PREM_SORT}'::text[]) OR ((array_remove(networks.flags, 'ZELIS_PREM_SORT'::text) <> '{}'::text[]) AND (cn_sf.include_only_flags <> '{}'::text[]) AND (NOT (networks.flags && cn_sf.include_only_flags))))
62. 0.001 10.785 ↓ 0.0 0 1

Hash Left Join (cost=6,747.66..266,824.09 rows=1,385,311 width=60) (actual time=10.785..10.785 rows=0 loops=1)

  • Hash Cond: ((cnn.project_mapping_generation_id = cn_sort.project_mapping_generation_id) AND ((cnn.client_network_id)::text = (cn_sort.client_network_id)::text))
  • Join Filter: (((cn_sort.include_only_flags = '{}'::text[]) OR ((cn_sort.include_only_flags <> '{}'::text[]) AND (networks.flags && cn_sort.include_only_flags))) AND ('ZELIS_PREM_SORT'::text = ANY (networks.flags)))
63. 0.002 10.784 ↓ 0.0 0 1

Merge Join (cost=6,708.46..259,511.78 rows=1,385,311 width=52) (actual time=10.784..10.784 rows=0 loops=1)

  • Merge Cond: (cnn.network_id = networks.product_id)
  • Join Filter: ((networks.service_areas = '{NULL}'::text[]) OR (cnn.service_area IS NULL) OR (cnn.service_area = ANY (networks.service_areas)))
64. 0.020 0.020 ↑ 58,003.0 1 1

Index Scan using client_network_networks_network_id_idx on client_networks_networks cnn (cost=0.29..2,605.76 rows=58,003 width=19) (actual time=0.020..0.020 rows=1 loops=1)

65. 0.003 10.762 ↓ 0.0 0 1

Sort (cost=6,708.17..6,871.63 rows=65,384 width=76) (actual time=10.762..10.762 rows=0 loops=1)

  • Sort Key: networks.product_id
  • Sort Method: quicksort Memory: 25kB
66. 10.759 10.759 ↓ 0.0 0 1

CTE Scan on networks (cost=0.00..1,478.54 rows=65,384 width=76) (actual time=10.759..10.759 rows=0 loops=1)

  • Filter: (flags <> '{}'::text[])
  • Rows Removed by Filter: 62505
67. 0.000 0.000 ↓ 0.0 0

Hash (cost=35.18..35.18 rows=268 width=145) (never executed)

68. 0.000 0.000 ↓ 0.0 0

Seq Scan on client_networks cn_sort (cost=0.00..35.18 rows=268 width=145) (never executed)

  • Filter: ((NOT suppress_flags) AND ((include_only_flags = '{}'::text[]) OR (include_only_flags <> '{}'::text[])))
69. 0.000 0.000 ↓ 0.0 0

Hash (cost=31.12..31.12 rows=812 width=146) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Seq Scan on client_networks cn_sf (cost=0.00..31.12 rows=812 width=146) (never executed)

71.          

CTE network_client_networks

72. 0.002 10.802 ↓ 0.0 0 1

GroupAggregate (cost=713.19..909.02 rows=657 width=140) (actual time=10.802..10.802 rows=0 loops=1)

  • Group Key: n_1.product_id, n_1.provider_id, n_1.provider_location_id
73. 0.001 10.800 ↓ 0.0 0 1

Merge Left Join (cost=713.19..779.24 rows=6,571 width=112) (actual time=10.800..10.800 rows=0 loops=1)

  • Merge Cond: ((n_1.product_id = n2.product_id) AND (n_1.provider_id = n2.provider_id) AND (n_1.provider_location_id = n2.provider_location_id))
74. 0.007 10.799 ↓ 0.0 0 1

Sort (cost=548.08..564.51 rows=6,571 width=108) (actual time=10.799..10.799 rows=0 loops=1)

  • Sort Key: n_1.product_id, n_1.provider_id, n_1.provider_location_id
  • Sort Method: quicksort Memory: 25kB
75. 10.792 10.792 ↓ 0.0 0 1

CTE Scan on network_pmg_client_networks n_1 (cost=0.00..131.42 rows=6,571 width=108) (actual time=10.791..10.792 rows=0 loops=1)

76. 0.000 0.000 ↓ 0.0 0

Sort (cost=165.11..165.19 rows=33 width=16) (never executed)

  • Sort Key: n2.product_id, n2.provider_id, n2.provider_location_id
77. 0.000 0.000 ↓ 0.0 0

CTE Scan on network_pmg_client_networks n2 (cost=0.00..164.28 rows=33 width=16) (never executed)

  • Filter: (array_length(suppress_flags_pmg_client_network_ids, 1) = all_pmg_client_network_ids_count)
78. 37.774 16,569.143 ↓ 62,505.0 62,505 1

Nested Loop (cost=203,319.11..480,655.36 rows=1 width=570) (actual time=13,084.088..16,569.143 rows=62,505 loops=1)

79. 31.953 16,343.854 ↓ 62,505.0 62,505 1

Nested Loop (cost=203,318.68..480,654.89 rows=1 width=528) (actual time=13,084.063..16,343.854 rows=62,505 loops=1)

80. 2,176.639 16,124.386 ↓ 62,505.0 62,505 1

Hash Right Join (cost=203,318.25..480,654.44 rows=1 width=484) (actual time=13,084.035..16,124.386 rows=62,505 loops=1)

  • Hash Cond: ((pl.strenuus_id = p.provider_id) AND (pl.strenuus_location_id = p.provider_location_id))
81. 1,468.067 1,468.067 ↑ 1.0 11,403,214 1

Seq Scan on tmp_location_core_tags pl (cost=0.00..191,803.10 rows=11,404,410 width=28) (actual time=0.015..1,468.067 rows=11,403,214 loops=1)

82. 39.476 12,479.680 ↓ 62,505.0 62,505 1

Hash (cost=203,318.24..203,318.24 rows=1 width=464) (actual time=12,479.680..12,479.680 rows=62,505 loops=1)

  • Buckets: 65536 (originally 1024) Batches: 1 (originally 1) Memory Usage: 22249kB
83. 124.275 12,440.204 ↓ 62,505.0 62,505 1

Nested Loop (cost=138,712.11..203,318.24 rows=1 width=464) (actual time=9,433.257..12,440.204 rows=62,505 loops=1)

  • Join Filter: ((p.provider_id = oc.strenuus_id) AND (p.provider_location_id = oc.strenuus_location_id))
  • Rows Removed by Join Filter: 593277
84. 51.214 11,565.869 ↑ 1.1 62,505 1

Hash Join (cost=138,711.67..140,198.43 rows=65,713 width=460) (actual time=9,433.217..11,565.869 rows=62,505 loops=1)

  • Hash Cond: (p.provider_id = pr.strenuus_id)
85. 9,849.160 9,849.160 ↑ 1.1 62,505 1

CTE Scan on networks p (cost=0.00..1,314.26 rows=65,713 width=445) (actual time=7,758.940..9,849.160 rows=62,505 loops=1)

86. 906.911 1,665.495 ↓ 1.0 4,004,631 1

Hash (cost=88,683.52..88,683.52 rows=4,002,252 width=15) (actual time=1,665.495..1,665.495 rows=4,004,631 loops=1)

  • Buckets: 4194304 Batches: 1 Memory Usage: 202342kB
87. 758.584 758.584 ↓ 1.0 4,004,631 1

Seq Scan on tmp_providers pr (cost=0.00..88,683.52 rows=4,002,252 width=15) (actual time=0.015..758.584 rows=4,004,631 loops=1)

88. 750.060 750.060 ↑ 1.2 10 62,505

Index Scan using output_core_strenuus_id_idx on output_core oc (cost=0.43..0.78 rows=12 width=16) (actual time=0.004..0.012 rows=10 loops=62,505)

  • Index Cond: (strenuus_id = pr.strenuus_id)
89. 187.515 187.515 ↑ 1.0 1 62,505

Index Scan using tmp_output_address_pkey on tmp_output_address a (cost=0.43..0.45 rows=1 width=52) (actual time=0.003..0.003 rows=1 loops=62,505)

  • Index Cond: (address_id = oc.address_id)
90. 187.515 187.515 ↑ 1.0 1 62,505

Index Scan using tmp_output_name_pkey on tmp_output_name n (cost=0.43..0.46 rows=1 width=50) (actual time=0.003..0.003 rows=1 loops=62,505)

  • Index Cond: (name_id = oc.name_id)
91. 0.000 0.000 ↓ 0.0 0 62,505

CTE Scan on network_client_networks ncn (cost=0.00..13.14 rows=657 width=140) (actual time=0.000..0.000 rows=0 loops=62,505)

Planning time : 8.466 ms
Execution time : 16,626.907 ms