explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WrN8

Settings
# exclusive inclusive rows x rows loops node
1. 0.265 11,089.039 ↑ 1.0 1 1

Limit (cost=103,944,424.90..103,944,424.91 rows=1 width=8) (actual time=11,088.776..11,089.039 rows=1 loops=1)

2. 0.824 11,088.774 ↑ 1.0 1 1

Aggregate (cost=103,944,424.90..103,944,424.91 rows=1 width=8) (actual time=11,088.774..11,088.774 rows=1 loops=1)

3. 1.160 11,087.950 ↑ 263.1 7,620 1

Subquery Scan on biz2 (cost=90,909,609.44..103,939,413.44 rows=2,004,585 width=0) (actual time=11,076.276..11,087.950 rows=7,620 loops=1)

  • Filter: (biz2.mm = 1)
  • Rows Removed by Filter: 26
4. 9.900 11,086.790 ↑ 52,434.9 7,646 1

WindowAgg (cost=90,909,609.44..98,927,950.36 rows=400,917,046 width=12,770) (actual time=11,076.260..11,086.790 rows=7,646 loops=1)

5. 5.080 11,076.890 ↑ 52,434.9 7,646 1

Sort (cost=90,909,609.44..91,911,902.06 rows=400,917,046 width=12) (actual time=11,076.152..11,076.890 rows=7,646 loops=1)

  • Sort Key: biz.id, biz4.id
  • Sort Method: quicksort Memory: 551kB
6. 65.106 11,071.810 ↑ 52,434.9 7,646 1

Hash Right Join (cost=26,182,589.32..29,705,906.36 rows=400,917,046 width=12) (actual time=11,043.636..11,071.810 rows=7,646 loops=1)

  • Hash Cond: ((b2.sub_type_id = oracle.text_tonumber(biz.child_type)) AND (b2.product_id = prod.id))
7. 1.084 1.084 ↑ 1.0 296 1

Seq Scan on biz_sub_type_cust b2 (cost=0.00..27.05 rows=296 width=11) (actual time=0.051..1.084 rows=296 loops=1)

  • Filter: (biz_type_id = '7'::numeric)
  • Rows Removed by Filter: 988
8. 2.483 11,005.620 ↑ 52,434.9 7,646 1

Hash (cost=17,819,709.63..17,819,709.63 rows=400,917,046 width=22) (actual time=11,005.620..11,005.620 rows=7,646 loops=1)

  • Buckets: 1048576 Batches: 512 Memory Usage: 8192kB
9. 6.805 11,003.137 ↑ 52,434.9 7,646 1

Merge Right Join (cost=10,696,357.60..17,819,709.63 rows=400,917,046 width=22) (actual time=10,991.308..11,003.137 rows=7,646 loops=1)

  • Merge Cond: ((oracle.to_char(ee.employeeid)) = (biz.create_man)::text)
10. 36.228 59.430 ↑ 1.1 43,658 1

Sort (cost=4,885.54..5,009.97 rows=49,769 width=7) (actual time=55.618..59.430 rows=43,658 loops=1)

  • Sort Key: (oracle.to_char(ee.employeeid))
  • Sort Method: quicksort Memory: 4059kB
11. 23.202 23.202 ↓ 1.0 49,773 1

Index Only Scan using employee_pkey on employee ee (cost=0.29..1,002.83 rows=49,769 width=7) (actual time=0.072..23.202 rows=49,773 loops=1)

  • Heap Fetches: 1926
12. 0.834 10,936.902 ↑ 5,594.1 7,646 1

Materialize (cost=10,691,472.06..10,905,333.05 rows=42,772,197 width=29) (actual time=10,935.570..10,936.902 rows=7,646 loops=1)

13. 3.747 10,936.068 ↑ 5,594.1 7,646 1

Sort (cost=10,691,472.06..10,798,402.55 rows=42,772,197 width=29) (actual time=10,935.567..10,936.068 rows=7,646 loops=1)

  • Sort Key: biz.create_man
  • Sort Method: quicksort Memory: 790kB
14. 1.888 10,932.321 ↑ 5,594.1 7,646 1

Merge Right Join (cost=3,922,136.29..4,685,281.74 rows=42,772,197 width=29) (actual time=10,929.222..10,932.321 rows=7,646 loops=1)

  • Merge Cond: ((oracle.to_char(reqsource.para_value_id)) = (biz.biz_source)::text)
15. 3.160 4.959 ↑ 1.7 2,837 1

Sort (cost=382.21..393.98 rows=4,707 width=6) (actual time=4.572..4.959 rows=2,837 loops=1)

  • Sort Key: (oracle.to_char(reqsource.para_value_id))
  • Sort Method: quicksort Memory: 413kB
16. 1.799 1.799 ↓ 1.0 4,708 1

Seq Scan on sys_para_value reqsource (cost=0.00..95.07 rows=4,707 width=6) (actual time=0.021..1.799 rows=4,708 loops=1)

17. 1.103 10,925.474 ↑ 763.6 7,646 1

Materialize (cost=3,921,754.08..3,950,947.48 rows=5,838,681 width=34) (actual time=10,923.958..10,925.474 rows=7,646 loops=1)

18. 3.966 10,924.371 ↑ 763.6 7,646 1

Sort (cost=3,921,754.08..3,936,350.78 rows=5,838,681 width=34) (actual time=10,923.933..10,924.371 rows=7,646 loops=1)

  • Sort Key: biz.biz_source
  • Sort Method: quicksort Memory: 790kB
19. 2.191 10,920.405 ↑ 763.6 7,646 1

Hash Left Join (cost=2,449,809.53..3,174,337.75 rows=5,838,681 width=34) (actual time=6,058.218..10,920.405 rows=7,646 loops=1)

  • Hash Cond: (oracle.to_char(biz.trade_id) = oracle.to_char(st.trade_id))
20. 2.975 10,918.188 ↑ 763.6 7,646 1

Hash Left Join (cost=2,449,808.44..3,136,677.16 rows=5,838,681 width=39) (actual time=6,058.158..10,918.188 rows=7,646 loops=1)

  • Hash Cond: ((biz.province)::text = oracle.to_char(spv.prov_id))
21. 1,169.050 10,915.163 ↑ 763.6 7,646 1

Hash Right Join (cost=2,449,806.43..3,096,776.18 rows=5,838,681 width=42) (actual time=6,058.022..10,915.163 rows=7,646 loops=1)

  • Hash Cond: (re.endbusiness = biz.id)
22. 1,774.189 4,549.282 ↑ 1.0 3,814,432 1

Merge Left Join (cost=22.52..468,426.25 rows=3,818,621 width=12) (actual time=3.315..4,549.282 rows=3,814,432 loops=1)

  • Merge Cond: (re.startbusiness = biz4.id)
23. 1,198.928 1,198.928 ↑ 1.0 3,814,432 1

Index Scan using sys_reqrelation_start on reqmatrixlistrelation re (cost=0.43..100,356.74 rows=3,818,621 width=12) (actual time=0.116..1,198.928 rows=3,814,432 loops=1)

24. 1,576.165 1,576.165 ↑ 1.0 3,712,142 1

Index Only Scan using reqmatrixlist_pkey on reqmatrixlist biz4 (cost=0.43..311,009.55 rows=3,742,075 width=6) (actual time=0.093..1,576.165 rows=3,712,142 loops=1)

  • Heap Fetches: 3712247
25. 10.288 5,196.831 ↑ 750.9 7,620 1

Hash (cost=2,333,562.38..2,333,562.38 rows=5,721,642 width=36) (actual time=5,196.831..5,196.831 rows=7,620 loops=1)

  • Buckets: 1048576 Batches: 8 Memory Usage: 8248kB
26. 5.391 5,186.543 ↑ 750.9 7,620 1

Hash Left Join (cost=1,686,033.47..2,333,562.38 rows=5,721,642 width=36) (actual time=5,156.173..5,186.543 rows=7,620 loops=1)

  • Hash Cond: (biz.reqmatrix = mpt.mod_id)
27. 41.200 4,990.315 ↑ 750.9 7,620 1

Hash Right Join (cost=1,682,986.36..2,251,867.48 rows=5,721,642 width=43) (actual time=4,965.052..4,990.315 rows=7,620 loops=1)

  • Hash Cond: ((spd.para_value_id = oracle.text_tonumber(biz.urgent_degree)) AND (spd.product_id = prod.id))
28. 2.132 2.132 ↑ 1.0 9,256 1

Seq Scan on sys_para_define spd (cost=0.00..183.60 rows=9,260 width=12) (actual time=0.032..2.132 rows=9,256 loops=1)

29. 6.204 4,946.983 ↑ 750.9 7,620 1

Hash (cost=1,546,873.73..1,546,873.73 rows=5,721,642 width=46) (actual time=4,946.983..4,946.983 rows=7,620 loops=1)

  • Buckets: 1048576 Batches: 8 Memory Usage: 8192kB
30. 58.847 4,940.779 ↑ 750.9 7,620 1

Hash Right Join (cost=1,345,126.57..1,546,873.73 rows=5,721,642 width=46) (actual time=4,888.635..4,940.779 rows=7,620 loops=1)

  • Hash Cond: ((bnc1.status_id = biz.bizstatus) AND (bnc1.product_id = prod.id))
31. 1.194 1.194 ↑ 1.0 3,774 1

Seq Scan on biz_node_cust bnc1 (cost=0.00..78.74 rows=3,774 width=11) (actual time=0.026..1.194 rows=3,774 loops=1)

32. 5.057 4,880.738 ↑ 750.9 7,620 1

Hash (cost=1,203,425.94..1,203,425.94 rows=5,721,642 width=51) (actual time=4,880.738..4,880.738 rows=7,620 loops=1)

  • Buckets: 1048576 Batches: 16 Memory Usage: 8200kB
33. 27.234 4,875.681 ↑ 750.9 7,620 1

Hash Right Join (cost=1,001,968.18..1,203,425.94 rows=5,721,642 width=51) (actual time=4,860.728..4,875.681 rows=7,620 loops=1)

  • Hash Cond: ((bnc2.node_id = biz.flownode) AND (bnc2.product_id = prod.id))
34. 0.820 0.820 ↑ 1.0 3,774 1

Seq Scan on biz_node_cust bnc2 (cost=0.00..78.74 rows=3,774 width=11) (actual time=0.037..0.820 rows=3,774 loops=1)

35. 4.242 4,847.627 ↑ 750.9 7,620 1

Hash (cost=860,267.55..860,267.55 rows=5,721,642 width=56) (actual time=4,847.627..4,847.627 rows=7,620 loops=1)

  • Buckets: 1048576 Batches: 16 Memory Usage: 8192kB
36. 4.371 4,843.385 ↑ 750.9 7,620 1

Merge Right Join (cost=759,965.42..860,267.55 rows=5,721,642 width=56) (actual time=4,837.182..4,843.385 rows=7,620 loops=1)

  • Merge Cond: ((oracle.to_char(tp.id)) = (biz.project_id)::text)
37. 13.688 21.060 ↑ 1.3 18,484 1

Sort (cost=2,118.83..2,176.63 rows=23,119 width=7) (actual time=19.432..21.060 rows=18,484 loops=1)

  • Sort Key: (oracle.to_char(tp.id))
  • Sort Method: quicksort Memory: 1960kB
38. 7.372 7.372 ↑ 1.0 23,119 1

Index Only Scan using taskplan_pkey on taskplan tp (cost=0.29..443.07 rows=23,119 width=7) (actual time=0.096..7.372 rows=23,119 loops=1)

  • Heap Fetches: 0
39. 9.395 4,817.954 ↑ 53.5 7,620 1

Sort (cost=757,846.59..758,866.60 rows=408,002 width=64) (actual time=4,817.534..4,817.954 rows=7,620 loops=1)

  • Sort Key: biz.project_id
  • Sort Method: quicksort Memory: 1264kB
40. 2.881 4,808.559 ↑ 53.5 7,620 1

Hash Left Join (cost=353,886.65..719,824.44 rows=408,002 width=64) (actual time=778.471..4,808.559 rows=7,620 loops=1)

  • Hash Cond: ((biz.make_depart)::text = oracle.to_char(spv_1.para_value_id))
41. 3.919 4,805.460 ↑ 53.5 7,620 1

Hash Left Join (cost=353,857.18..701,350.18 rows=408,002 width=73) (actual time=778.200..4,805.460 rows=7,620 loops=1)

  • Hash Cond: (modu.product = prod.id)
42. 5.908 4,801.371 ↑ 53.5 7,620 1

Hash Left Join (cost=353,843.54..700,253.72 rows=408,002 width=72) (actual time=778.021..4,801.371 rows=7,620 loops=1)

  • Hash Cond: (biz.reqmatrix = modu.id)
43. 477.601 4,767.660 ↑ 53.5 7,620 1

Merge Right Join (cost=351,669.68..697,008.78 rows=408,002 width=66) (actual time=749.928..4,767.660 rows=7,620 loops=1)

  • Merge Cond: (biz.id = t.biz_id)
44. 2,668.378 4,256.362 ↑ 1.2 3,185,812 1

Merge Left Join (cost=890.60..330,754.47 rows=3,742,075 width=66) (actual time=8.061..4,256.362 rows=3,185,812 loops=1)

  • Merge Cond: (biz.id = (oracle.text_tonumber(bc.businessid)))
45. 1,577.724 1,577.724 ↑ 1.2 3,185,812 1

Index Scan using reqmatrixlist_pkey on reqmatrixlist biz (cost=0.43..311,009.55 rows=3,742,075 width=70) (actual time=0.022..1,577.724 rows=3,185,812 loops=1)

46. 5.838 10.260 ↑ 1.1 7,391 1

Sort (cost=890.17..910.79 rows=8,250 width=7) (actual time=8.014..10.260 rows=7,391 loops=1)

  • Sort Key: (oracle.text_tonumber(bc.businessid))
  • Sort Method: quicksort Memory: 771kB
47. 4.422 4.422 ↓ 1.0 8,251 1

Seq Scan on businesscomment bc (cost=0.00..353.50 rows=8,250 width=7) (actual time=0.022..4.422 rows=8,251 loops=1)

48. 5.379 33.697 ↑ 53.5 7,620 1

Sort (cost=350,779.08..351,799.09 rows=408,002 width=16) (actual time=31.593..33.697 rows=7,620 loops=1)

  • Sort Key: t.biz_id
  • Sort Method: quicksort Memory: 550kB
49. 0.931 28.318 ↑ 53.5 7,620 1

Append (cost=26,308.88..308,676.92 rows=408,002 width=16) (actual time=0.377..28.318 rows=7,620 loops=1)

50.          

CTE modus

51. 0.004 0.301 ↑ 2,500.8 22 1

Append (cost=0.29..834.47 rows=55,017 width=7) (actual time=0.036..0.301 rows=22 loops=1)

52. 0.036 0.036 ↑ 1.0 1 1

Index Only Scan using reqmatrix_pkey on reqmatrix rm_1 (cost=0.29..2.31 rows=1 width=7) (actual time=0.035..0.036 rows=1 loops=1)

  • Index Cond: (id = '21972978'::numeric)
  • Heap Fetches: 1
53. 0.044 0.261 ↑ 2,619.8 21 1

Connect By (cost=0.58..6.91 rows=55,016 width=7) (actual time=0.056..0.261 rows=21 loops=1)

  • Sort Key: level
54. 0.007 0.007 ↑ 1.0 1 1

Index Scan using reqmatrix_pkey on reqmatrix rm_2 (cost=0.29..2.31 rows=1 width=14) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (id = '21972978'::numeric)
55. 0.210 0.210 ↑ 10.0 1 21

Index Scan using sys_reqmatrix_reqmatrix_id on reqmatrix rm_2 (cost=0.29..4.60 rows=10 width=14) (actual time=0.007..0.010 rows=1 loops=21)

  • Index Cond: (PRIOR (rm_2.id) = parentid)
56.          

CTE modu_bizs

57. 1.327 20.446 ↑ 50.2 7,620 1

Nested Loop (cost=1,238.31..25,474.41 rows=382,274 width=6) (actual time=0.372..20.446 rows=7,620 loops=1)

58. 0.034 0.345 ↑ 9.5 21 1

HashAggregate (cost=1,237.88..1,239.88 rows=200 width=16) (actual time=0.335..0.345 rows=21 loops=1)

  • Group Key: modus_2.id
59. 0.311 0.311 ↑ 2,500.8 22 1

CTE Scan on modus modus_2 (cost=0.00..1,100.34 rows=55,017 width=16) (actual time=0.038..0.311 rows=22 loops=1)

60. 18.774 18.774 ↓ 2.9 363 21

Index Scan using dmp_biz_idx_modu_biztype on reqmatrixlist biz_3 (cost=0.43..119.92 rows=125 width=13) (actual time=0.024..0.894 rows=363 loops=21)

  • Index Cond: ((biztype = '7'::numeric) AND (reqmatrix = modus_2.id))
61. 0.694 26.416 ↑ 51.3 7,620 1

Append (cost=0.00..166,015.23 rows=390,850 width=16) (actual time=0.375..26.416 rows=7,620 loops=1)

62. 23.094 23.094 ↑ 50.2 7,620 1

CTE Scan on modu_bizs t (cost=0.00..7,645.48 rows=382,274 width=16) (actual time=0.375..23.094 rows=7,620 loops=1)

63. 0.000 2.628 ↓ 0.0 0 1

Merge Anti Join (cost=154,315.09..156,329.74 rows=8,576 width=6) (actual time=2.628..2.628 rows=0 loops=1)

  • Merge Cond: (biz_1.id = t_1.biz_id)
64. 0.004 2.628 ↓ 0.0 0 1

Sort (cost=111,224.69..111,267.57 rows=17,152 width=12) (actual time=2.628..2.628 rows=0 loops=1)

  • Sort Key: bmr.biz_id
  • Sort Method: quicksort Memory: 25kB
65. 0.060 2.624 ↓ 0.0 0 1

Nested Loop (cost=1,238.73..110,018.38 rows=17,152 width=12) (actual time=2.624..2.624 rows=0 loops=1)

66. 0.043 0.572 ↑ 505.5 166 1

Nested Loop (cost=1,238.30..3,170.77 rows=83,915 width=6) (actual time=0.072..0.572 rows=166 loops=1)

67. 0.022 0.025 ↑ 9.5 21 1

HashAggregate (cost=1,237.88..1,239.88 rows=200 width=16) (actual time=0.018..0.025 rows=21 loops=1)

  • Group Key: modus.id
68. 0.003 0.003 ↑ 2,500.8 22 1

CTE Scan on modus (cost=0.00..1,100.34 rows=55,017 width=16) (actual time=0.000..0.003 rows=22 loops=1)

69. 0.504 0.504 ↑ 14.4 8 21

Index Scan using sys_bizmodulerelated_module on biz_module_related bmr (cost=0.42..8.50 rows=115 width=13) (actual time=0.007..0.024 rows=8 loops=21)

  • Index Cond: (module_related = modus.id)
70. 1.992 1.992 ↓ 0.0 0 166

Index Scan using reqmatrixlist_pkey on reqmatrixlist biz_1 (cost=0.43..1.27 rows=1 width=6) (actual time=0.012..0.012 rows=0 loops=166)

  • Index Cond: (id = bmr.biz_id)
  • Filter: (biztype = '7'::numeric)
  • Rows Removed by Filter: 1
71. 0.000 0.000 ↓ 0.0 0

Sort (cost=43,090.40..44,046.08 rows=382,274 width=16) (never executed)

  • Sort Key: t_1.biz_id
72. 0.000 0.000 ↓ 0.0 0

CTE Scan on modu_bizs t_1 (cost=0.00..7,645.48 rows=382,274 width=16) (never executed)

73. 0.113 0.971 ↓ 0.0 0 1

HashAggregate (cost=110,061.26..110,232.78 rows=17,152 width=6) (actual time=0.971..0.971 rows=0 loops=1)

  • Group Key: bmr_1.biz_id
74. 0.007 0.858 ↓ 0.0 0 1

Nested Loop (cost=1,238.73..110,018.38 rows=17,152 width=6) (actual time=0.858..0.858 rows=0 loops=1)

75. 0.039 0.187 ↑ 505.5 166 1

Nested Loop (cost=1,238.30..3,170.77 rows=83,915 width=6) (actual time=0.036..0.187 rows=166 loops=1)

76. 0.019 0.022 ↑ 9.5 21 1

HashAggregate (cost=1,237.88..1,239.88 rows=200 width=16) (actual time=0.015..0.022 rows=21 loops=1)

  • Group Key: modus_1.id
77. 0.003 0.003 ↑ 2,500.8 22 1

CTE Scan on modus modus_1 (cost=0.00..1,100.34 rows=55,017 width=16) (actual time=0.001..0.003 rows=22 loops=1)

78. 0.126 0.126 ↑ 14.4 8 21

Index Scan using sys_bizmodulerelated_module on biz_module_related bmr_1 (cost=0.42..8.50 rows=115 width=13) (actual time=0.003..0.006 rows=8 loops=21)

  • Index Cond: (module_related = modus_1.id)
79. 0.664 0.664 ↓ 0.0 0 166

Index Scan using reqmatrixlist_pkey on reqmatrixlist biz_2 (cost=0.43..1.27 rows=1 width=6) (actual time=0.004..0.004 rows=0 loops=166)

  • Index Cond: (id = bmr_1.biz_id)
  • Filter: (biztype = '7'::numeric)
  • Rows Removed by Filter: 1
80. 12.783 27.803 ↑ 1.0 53,460 1

Hash (cost=1,486.16..1,486.16 rows=55,016 width=13) (actual time=27.802..27.803 rows=53,460 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2911kB
81. 15.020 15.020 ↑ 1.0 53,460 1

Seq Scan on reqmatrix modu (cost=0.00..1,486.16 rows=55,016 width=13) (actual time=0.021..15.020 rows=53,460 loops=1)

82. 0.084 0.170 ↑ 1.0 384 1

Hash (cost=8.84..8.84 rows=384 width=7) (actual time=0.170..0.170 rows=384 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
83. 0.086 0.086 ↑ 1.0 384 1

Seq Scan on product prod (cost=0.00..8.84 rows=384 width=7) (actual time=0.013..0.086 rows=384 loops=1)

84. 0.058 0.218 ↓ 1.0 169 1

Hash (cost=27.37..27.37 rows=167 width=6) (actual time=0.218..0.218 rows=169 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
85. 0.160 0.160 ↓ 1.0 169 1

Index Scan using sys_sysparavalue_paraid on sys_para_value spv_1 (cost=0.28..27.37 rows=167 width=6) (actual time=0.050..0.160 rows=169 loops=1)

  • Index Cond: (para_id = ANY ('{69,51,118,217,275,321}'::numeric[]))
86. 14.998 190.837 ↑ 1.0 53,341 1

Hash (cost=2,359.42..2,359.42 rows=55,016 width=7) (actual time=190.837..190.837 rows=53,341 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2547kB
87. 8.951 175.839 ↑ 1.0 53,341 1

Subquery Scan on mpt (cost=0.58..2,359.42 rows=55,016 width=7) (actual time=0.696..175.839 rows=53,341 loops=1)

88. 59.736 166.888 ↑ 1.0 53,341 1

Connect By (cost=0.58..1,809.26 rows=55,016 width=39) (actual time=0.685..166.888 rows=53,341 loops=1)

  • Sort Key: level
89. 0.470 0.470 ↑ 1.0 373 1

Index Scan using sys_reqmatrix_reqmatrix_id on reqmatrix rm (cost=0.29..88.24 rows=374 width=14) (actual time=0.066..0.470 rows=373 loops=1)

  • Index Cond: (parentid IS NULL)
90. 106.682 106.682 ↑ 10.0 1 53,341

Index Scan using sys_reqmatrix_reqmatrix_id on reqmatrix rm (cost=0.29..4.60 rows=10 width=14) (actual time=0.002..0.002 rows=1 loops=53,341)

  • Index Cond: (PRIOR (rm.id) = parentid)
91. 0.023 0.050 ↑ 1.0 45 1

Hash (cost=1.45..1.45 rows=45 width=5) (actual time=0.050..0.050 rows=45 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
92. 0.027 0.027 ↑ 1.0 45 1

Seq Scan on sys_province spv (cost=0.00..1.45 rows=45 width=5) (actual time=0.022..0.027 rows=45 loops=1)

93. 0.012 0.026 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=5) (actual time=0.026..0.026 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
94. 0.014 0.014 ↑ 1.0 4 1

Seq Scan on sys_trade st (cost=0.00..1.04 rows=4 width=5) (actual time=0.013..0.014 rows=4 loops=1)