Skip to content

Instantly share code, notes, and snippets.

@SrivastavaAnubhav
Created June 30, 2023 17:41
Show Gist options
  • Save SrivastavaAnubhav/739425564d8407bdf7664cba122df7a1 to your computer and use it in GitHub Desktop.
Save SrivastavaAnubhav/739425564d8407bdf7664cba122df7a1 to your computer and use it in GitHub Desktop.
TCMalloc 1 MB sampling perf scan workload
YAML_NAME(version) WORKLOAD BASELINE-(Baseline)↓ 1 MB SAMPLING↓ 1 MB SAMPLING/BASELINE↓
scanG10_seqscan_increasingTabletCount(v1.0) scanG10_noIndex_fullTable_seqScan_1M_rows_12tablets 186.79 189.94 1.02
scanG10_seqscan_increasingTabletCount(v1.0) scanG10_noIndex_fullTable_seqScan_1M_rows_3tablets 205.69 215.13 1.05
scanG10_seqscan_increasingTabletCount(v1.0) scanG10_noIndex_fullTable_seqScan_1M_rows_6tablets 185.28 188.21 1.02
scanG1_hash_pointlookup_primarykey_vs_index(v1.0) scanG1_indx_hash_point_lookup 0.35 0.33 0.94
scanG1_hash_pointlookup_primarykey_vs_index(v1.0) scanG1_pkey_hash_point_lookup 0.35 0.33 0.94
scanG2_pkey_rangeScan_increasingRows(v1.0) scanG2_pkey_rangescan_varying_rows_100Krows 87.28 97.78 1.12
scanG2_pkey_rangeScan_increasingRows(v1.0) scanG2_pkey_rangescan_varying_rows_1Mrows 861.9 990.19 1.15
scanG2_pkey_rangeScan_increasingRows(v1.0) scanG2_pkey_rangescan_varying_rows_1row 0.35 0.34 0.97
scanG2_pkey_rangeScan_increasingRows(v1.0) scanG2_pkey_rangescan_varying_rows_500Krows 422.23 486.23 1.15
scanG3_index_rangeScan_increasingRows(v1.0) scanG3_indx_rangescan_varying_rows_100Krows 59.42 65.06 1.09
scanG3_index_rangeScan_increasingRows(v1.0) scanG3_indx_rangescan_varying_rows_1Mrows 623.15 655.95 1.05
scanG3_index_rangeScan_increasingRows(v1.0) scanG3_indx_rangescan_varying_rows_1row 0.34 0.34 1
scanG3_index_rangeScan_increasingRows(v1.0) scanG3_indx_rangescan_varying_rows_500Krows 314.52 330.95 1.05
scanG4_pkey_rangeScan_INclause_increasingRows_(v1.0) scanG4_pkey_INclause_rangescan_increasing_rows_1000row 6 7.28 1.21
scanG4_pkey_rangeScan_INclause_increasingRows_(v1.0) scanG4_pkey_INclause_rangescan_increasing_rows_100row 1.28 1.39 1.09
scanG4_pkey_rangeScan_INclause_increasingRows_(v1.0) scanG4_pkey_INclause_rangescan_increasing_rows_10row 0.76 0.8 1.05
scanG4_pkey_rangeScan_INclause_increasingRows_(v1.0) scanG4_pkey_INclause_rangescan_increasing_rows_1row 0.34 0.34 1
scanG5_pkey_hash_pointLookup_increasingColumn(v1.0) scanG5_pkey_hash_pointLookup_table100column_fetch100column 0.43 0.43 1
scanG5_pkey_hash_pointLookup_increasingColumn(v1.0) scanG5_pkey_hash_pointLookup_table10column_fetch10column 0.35 0.34 0.97
scanG5_pkey_hash_pointLookup_increasingColumn(v1.0) scanG5_pkey_hash_pointLookup_table1column_fetch1column 0.34 0.33 0.97
scanG6_pkey_rangescan_halfTableScan_increasingColumn(v1.0) scanG6_pkey_rangescan_halfTable_table100column_fetch100column 3797.89 2837.14 0.75
scanG6_pkey_rangescan_halfTableScan_increasingColumn(v1.0) scanG6_pkey_rangescan_halfTable_table10column_fetch10column 609.53 652.65 1.07
scanG6_pkey_rangescan_halfTableScan_increasingColumn(v1.0) scanG6_pkey_rangescan_halfTable_table1column_fetch1column 378.26 439.57 1.16
scanG7_pkey_rangescan_fullTableScan_increasingColumn(v1.0) scanG7_pkey_rangescan_fullTable_table100column_fetch100column 7898.36 6160.36 0.78
scanG7_pkey_rangescan_fullTableScan_increasingColumn(v1.0) scanG7_pkey_rangescan_fullTable_table10column_fetch10column 1343.36 1327.69 0.99
scanG7_pkey_rangescan_fullTableScan_increasingColumn(v1.0) scanG7_pkey_rangescan_fullTable_table1column_fetch1column 770.89 895.45 1.16
scanG8_nonIndexed_rangescan_fullTableScan_increasingRow(v1.0) scanG8_noIndex_fullTable_seqScan_10M_rows 2739.77 2925.51 1.07
scanG8_nonIndexed_rangescan_fullTableScan_increasingRow(v1.0) scanG8_noIndex_fullTable_seqScan_1M_rows 203.16 211.74 1.04
scanG8_nonIndexed_rangescan_fullTableScan_increasingRow(v1.0) scanG8_noIndex_fullTable_seqScan_5M_rows 1311.64 1426.49 1.09
scanG9_count_nonIndexed_rangescan_fullTableScan_increasingRow(v1.0) scanG9_count_noIndex_fullTable_seqScan_10M_rows 2503.65 2614.03 1.04
scanG9_count_nonIndexed_rangescan_fullTableScan_increasingRow(v1.0) scanG9_count_noIndex_fullTable_seqScan_1M_rows 188.58 186.09 0.99
scanG9_count_nonIndexed_rangescan_fullTableScan_increasingRow(v1.0) scanG9_count_noIndex_fullTable_seqScan_5M_rows 1210.05 1312.03 1.08
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment