Skip to content

Instantly share code, notes, and snippets.

@tamird

tamird/sql.stats

Created November 2, 2015 02:20
Show Gist options
  • Save tamird/4dcdc6713ce8fb590cb2 to your computer and use it in GitHub Desktop.
Save tamird/4dcdc6713ce8fb590cb2 to your computer and use it in GitHub Desktop.
Download ZIP
jemalloc stats in cockroachdb
Raw
sql.stats
___ Begin jemalloc statistics ___
Version: 0.0.0-0-g0000000000000000000000000000000000000000
Assertions disabled
Run-time option settings:
opt.abort: false
opt.lg_chunk: 21
opt.dss: "secondary"
opt.narenas: 16
opt.lg_dirty_mult: 3 (arenas.lg_dirty_mult: 3)
opt.stats_print: false
opt.junk: "false"
opt.quarantine: 0
opt.redzone: false
opt.zero: false
opt.tcache: true
opt.lg_tcache_max: 15
CPUs: 4
Arenas: 16
Pointer size: 8
Quantum size: 16
Page size: 4096
Min active:dirty page ratio per arena: 8:1
Maximum thread-cached size class: 32768
Chunk size: 2097152 (2^21)
Allocated: 289056, active: 339968, metadata: 516352, resident: 618496, mapped: 8388608
Current active ceiling: 6291456
Merged arenas stats:
assigned threads: 3
dss allocation precedence: N/A
min active:dirty page ratio: N/A
dirty pages: 83:0 active:dirty, 0 sweeps, 0 madvises, 0 purged
allocated nmalloc ndalloc nrequests
small: 153888 354 7 44
large: 135168 4 0 4
huge: 0 0 0 0
total: 289056 358 7 48
active: 339968
mapped: 6291456
metadata: mapped: 159744, allocated: 238720
bins: size ind allocated nmalloc ndalloc nrequests curregs curruns regs pgs util nfills nflushes newruns reruns
---
32 2 9376 300 7 0 293 3 128 1 0.763 3 0 3 0
---
128 8 1280 10 0 10 10 1 32 1 0.312 0 0 1 0
---
896 19 15232 17 0 17 17 1 32 7 0.531 0 0 1 0
---
4096 28 40960 10 0 0 10 10 1 1 1 1 0 10 0
5120 29 87040 17 0 17 17 5 4 5 0.850 0 0 5 0
---
large: size ind allocated nmalloc ndalloc nrequests curruns
---
28672 39 86016 3 0 3 3
---
49152 42 49152 1 0 1 1
---
huge: size ind allocated nmalloc ndalloc nrequests curhchunks
---
arenas[0]:
assigned threads: 1
dss allocation precedence: disabled
min active:dirty page ratio: 8:1
dirty pages: 81:0 active:dirty, 0 sweeps, 0 madvises, 0 purged
allocated nmalloc ndalloc nrequests
small: 147616 154 3 44
large: 135168 4 0 4
huge: 0 0 0 0
total: 282784 158 3 48
active: 331776
mapped: 2097152
metadata: mapped: 53248, allocated: 238720
bins: size ind allocated nmalloc ndalloc nrequests curregs curruns regs pgs util nfills nflushes newruns reruns
---
32 2 3104 100 3 0 97 1 128 1 0.757 1 0 1 0
---
128 8 1280 10 0 10 10 1 32 1 0.312 0 0 1 0
---
896 19 15232 17 0 17 17 1 32 7 0.531 0 0 1 0
---
4096 28 40960 10 0 0 10 10 1 1 1 1 0 10 0
5120 29 87040 17 0 17 17 5 4 5 0.850 0 0 5 0
---
large: size ind allocated nmalloc ndalloc nrequests curruns
---
28672 39 86016 3 0 3 3
---
49152 42 49152 1 0 1 1
---
huge: size ind allocated nmalloc ndalloc nrequests curhchunks
---
arenas[1]:
assigned threads: 1
dss allocation precedence: disabled
min active:dirty page ratio: 8:1
dirty pages: 1:0 active:dirty, 0 sweeps, 0 madvises, 0 purged
allocated nmalloc ndalloc nrequests
small: 3072 100 4 0
large: 0 0 0 0
huge: 0 0 0 0
total: 3072 100 4 0
active: 4096
mapped: 2097152
metadata: mapped: 53248, allocated: 0
bins: size ind allocated nmalloc ndalloc nrequests curregs curruns regs pgs util nfills nflushes newruns reruns
---
32 2 3072 100 4 0 96 1 128 1 0.750 1 0 1 0
---
large: size ind allocated nmalloc ndalloc nrequests curruns
---
huge: size ind allocated nmalloc ndalloc nrequests curhchunks
---
arenas[2]:
assigned threads: 1
dss allocation precedence: disabled
min active:dirty page ratio: 8:1
dirty pages: 1:0 active:dirty, 0 sweeps, 0 madvises, 0 purged
allocated nmalloc ndalloc nrequests
small: 3200 100 0 0
large: 0 0 0 0
huge: 0 0 0 0
total: 3200 100 0 0
active: 4096
mapped: 2097152
metadata: mapped: 53248, allocated: 0
bins: size ind allocated nmalloc ndalloc nrequests curregs curruns regs pgs util nfills nflushes newruns reruns
---
32 2 3200 100 0 0 100 1 128 1 0.781 1 0 1 0
---
large: size ind allocated nmalloc ndalloc nrequests curruns
---
huge: size ind allocated nmalloc ndalloc nrequests curhchunks
---
--- End jemalloc statistics ---
Raw
start.stats
___ Begin jemalloc statistics ___
Version: 0.0.0-0-g0000000000000000000000000000000000000000
Assertions disabled
Run-time option settings:
opt.abort: false
opt.lg_chunk: 21
opt.dss: "secondary"
opt.narenas: 16
opt.lg_dirty_mult: 3 (arenas.lg_dirty_mult: 3)
opt.stats_print: false
opt.junk: "false"
opt.quarantine: 0
opt.redzone: false
opt.zero: false
opt.tcache: true
opt.lg_tcache_max: 15
CPUs: 4
Arenas: 16
Pointer size: 8
Quantum size: 16
Page size: 4096
Min active:dirty page ratio per arena: 8:1
Maximum thread-cached size class: 32768
Chunk size: 2097152 (2^21)
Allocated: 1348640, active: 1757184, metadata: 1095168, resident: 2469888, mapped: 18874368
Current active ceiling: 16777216
Merged arenas stats:
assigned threads: 8
dss allocation precedence: N/A
min active:dirty page ratio: N/A
dirty pages: 429:0 active:dirty, 0 sweeps, 0 madvises, 0 purged
allocated nmalloc ndalloc nrequests
small: 1070112 7289 9 51
large: 278528 9 0 9
huge: 0 0 0 0
total: 1348640 7298 9 60
active: 1757184
mapped: 16777216
metadata: mapped: 425984, allocated: 382976
bins: size ind allocated nmalloc ndalloc nrequests curregs curruns regs pgs util nfills nflushes newruns reruns
---
16 1 11200 700 0 0 700 7 256 1 0.390 7 0 7 0
32 2 25312 800 9 0 791 8 128 1 0.772 8 0 8 0
48 3 33600 700 0 0 700 7 256 3 0.390 7 0 7 0
64 4 28672 448 0 0 448 7 64 1 1 7 0 7 0
80 5 56000 700 0 0 700 7 256 5 0.390 7 0 7 0
96 6 67200 700 0 0 700 7 128 3 0.781 7 0 7 0
112 7 44800 400 0 0 400 4 256 7 0.390 4 0 4 0
128 8 30848 241 0 17 241 8 32 1 0.941 7 0 8 0
160 9 112000 700 0 0 700 7 128 5 0.781 7 0 7 0
192 10 86016 448 0 0 448 7 64 3 1 7 0 7 0
224 11 156800 700 0 0 700 7 128 7 0.781 7 0 7 0
256 12 16384 64 0 0 64 4 16 1 1 4 0 4 0
320 13 143360 448 0 0 448 7 64 5 1 7 0 7 0
384 14 24576 64 0 0 64 2 32 3 1 2 0 2 0
448 15 28672 64 0 0 64 1 64 7 1 1 0 1 0
512 16 5120 10 0 0 10 2 8 1 0.625 1 0 2 0
640 17 20480 32 0 0 32 1 32 5 1 1 0 1 0
---
896 19 15232 17 0 17 17 1 32 7 0.531 0 0 1 0
---
1280 21 20480 16 0 0 16 1 16 5 1 1 0 1 0
1536 22 15360 10 0 0 10 2 8 3 0.625 1 0 2 0
---
4096 28 40960 10 0 0 10 10 1 1 1 1 0 10 0
5120 29 87040 17 0 17 17 5 4 5 0.850 0 0 5 0
---
large: size ind allocated nmalloc ndalloc nrequests curruns
---
28672 39 229376 8 0 8 8
---
49152 42 49152 1 0 1 1
---
huge: size ind allocated nmalloc ndalloc nrequests curhchunks
---
arenas[0]:
assigned threads: 1
dss allocation precedence: disabled
min active:dirty page ratio: 8:1
dirty pages: 155:0 active:dirty, 0 sweeps, 0 madvises, 0 purged
allocated nmalloc ndalloc nrequests
small: 251840 985 4 51
large: 278528 9 0 9
huge: 0 0 0 0
total: 530368 994 4 60
active: 634880
mapped: 2097152
metadata: mapped: 53248, allocated: 382976
bins: size ind allocated nmalloc ndalloc nrequests curregs curruns regs pgs util nfills nflushes newruns reruns
---
16 1 1600 100 0 0 100 1 256 1 0.390 1 0 1 0
32 2 3072 100 4 0 96 1 128 1 0.750 1 0 1 0
48 3 4800 100 0 0 100 1 256 3 0.390 1 0 1 0
64 4 4096 64 0 0 64 1 64 1 1 1 0 1 0
80 5 8000 100 0 0 100 1 256 5 0.390 1 0 1 0
96 6 9600 100 0 0 100 1 128 3 0.781 1 0 1 0
---
128 8 6272 49 0 17 49 2 32 1 0.765 1 0 2 0
160 9 16000 100 0 0 100 1 128 5 0.781 1 0 1 0
192 10 12288 64 0 0 64 1 64 3 1 1 0 1 0
224 11 22400 100 0 0 100 1 128 7 0.781 1 0 1 0
---
320 13 20480 64 0 0 64 1 64 5 1 1 0 1 0
---
896 19 15232 17 0 17 17 1 32 7 0.531 0 0 1 0
---
4096 28 40960 10 0 0 10 10 1 1 1 1 0 10 0
5120 29 87040 17 0 17 17 5 4 5 0.850 0 0 5 0
---
large: size ind allocated nmalloc ndalloc nrequests curruns
---
28672 39 229376 8 0 8 8
---
49152 42 49152 1 0 1 1
---
huge: size ind allocated nmalloc ndalloc nrequests curhchunks
---
arenas[1]:
assigned threads: 1
dss allocation precedence: disabled
min active:dirty page ratio: 8:1
dirty pages: 2:0 active:dirty, 0 sweeps, 0 madvises, 0 purged
allocated nmalloc ndalloc nrequests
small: 7232 164 2 0
large: 0 0 0 0
huge: 0 0 0 0
total: 7232 164 2 0
active: 8192
mapped: 2097152
metadata: mapped: 53248, allocated: 0
bins: size ind allocated nmalloc ndalloc nrequests curregs curruns regs pgs util nfills nflushes newruns reruns
---
32 2 3136 100 2 0 98 1 128 1 0.765 1 0 1 0
---
64 4 4096 64 0 0 64 1 64 1 1 1 0 1 0
---
large: size ind allocated nmalloc ndalloc nrequests curruns
---
huge: size ind allocated nmalloc ndalloc nrequests curhchunks
---
arenas[2]:
assigned threads: 1
dss allocation precedence: disabled
min active:dirty page ratio: 8:1
dirty pages: 51:0 active:dirty, 0 sweeps, 0 madvises, 0 purged
allocated nmalloc ndalloc nrequests
small: 154528 1104 3 0
large: 0 0 0 0
huge: 0 0 0 0
total: 154528 1104 3 0
active: 208896
mapped: 2097152
metadata: mapped: 53248, allocated: 0
bins: size ind allocated nmalloc ndalloc nrequests curregs curruns regs pgs util nfills nflushes newruns reruns
---
16 1 1600 100 0 0 100 1 256 1 0.390 1 0 1 0
32 2 3104 100 3 0 97 1 128 1 0.757 1 0 1 0
48 3 4800 100 0 0 100 1 256 3 0.390 1 0 1 0
64 4 4096 64 0 0 64 1 64 1 1 1 0 1 0
80 5 8000 100 0 0 100 1 256 5 0.390 1 0 1 0
96 6 9600 100 0 0 100 1 128 3 0.781 1 0 1 0
112 7 11200 100 0 0 100 1 256 7 0.390 1 0 1 0
128 8 4096 32 0 0 32 1 32 1 1 1 0 1 0
160 9 16000 100 0 0 100 1 128 5 0.781 1 0 1 0
192 10 12288 64 0 0 64 1 64 3 1 1 0 1 0
224 11 22400 100 0 0 100 1 128 7 0.781 1 0 1 0
256 12 4096 16 0 0 16 1 16 1 1 1 0 1 0
320 13 20480 64 0 0 64 1 64 5 1 1 0 1 0
384 14 12288 32 0 0 32 1 32 3 1 1 0 1 0
---
640 17 20480 32 0 0 32 1 32 5 1 1 0 1 0
---
large: size ind allocated nmalloc ndalloc nrequests curruns
---
huge: size ind allocated nmalloc ndalloc nrequests curhchunks
---
arenas[3]:
assigned threads: 1
dss allocation precedence: disabled
min active:dirty page ratio: 8:1
dirty pages: 50:0 active:dirty, 0 sweeps, 0 madvises, 0 purged
allocated nmalloc ndalloc nrequests
small: 150528 1104 0 0
large: 0 0 0 0
huge: 0 0 0 0
total: 150528 1104 0 0
active: 204800
mapped: 2097152
metadata: mapped: 53248, allocated: 0
bins: size ind allocated nmalloc ndalloc nrequests curregs curruns regs pgs util nfills nflushes newruns reruns
---
16 1 1600 100 0 0 100 1 256 1 0.390 1 0 1 0
32 2 3200 100 0 0 100 1 128 1 0.781 1 0 1 0
48 3 4800 100 0 0 100 1 256 3 0.390 1 0 1 0
64 4 4096 64 0 0 64 1 64 1 1 1 0 1 0
80 5 8000 100 0 0 100 1 256 5 0.390 1 0 1 0
96 6 9600 100 0 0 100 1 128 3 0.781 1 0 1 0
112 7 11200 100 0 0 100 1 256 7 0.390 1 0 1 0
128 8 4096 32 0 0 32 1 32 1 1 1 0 1 0
160 9 16000 100 0 0 100 1 128 5 0.781 1 0 1 0
192 10 12288 64 0 0 64 1 64 3 1 1 0 1 0
224 11 22400 100 0 0 100 1 128 7 0.781 1 0 1 0
256 12 4096 16 0 0 16 1 16 1 1 1 0 1 0
320 13 20480 64 0 0 64 1 64 5 1 1 0 1 0
---
448 15 28672 64 0 0 64 1 64 7 1 1 0 1 0
---
large: size ind allocated nmalloc ndalloc nrequests curruns
---
huge: size ind allocated nmalloc ndalloc nrequests curhchunks
---
arenas[4]:
assigned threads: 1
dss allocation precedence: disabled
min active:dirty page ratio: 8:1
dirty pages: 43:0 active:dirty, 0 sweeps, 0 madvises, 0 purged
allocated nmalloc ndalloc nrequests
small: 130112 902 0 0
large: 0 0 0 0
huge: 0 0 0 0
total: 130112 902 0 0
active: 176128
mapped: 2097152
metadata: mapped: 53248, allocated: 0
bins: size ind allocated nmalloc ndalloc nrequests curregs curruns regs pgs util nfills nflushes newruns reruns
---
16 1 1600 100 0 0 100 1 256 1 0.390 1 0 1 0
32 2 3200 100 0 0 100 1 128 1 0.781 1 0 1 0
48 3 4800 100 0 0 100 1 256 3 0.390 1 0 1 0
---
80 5 8000 100 0 0 100 1 256 5 0.390 1 0 1 0
96 6 9600 100 0 0 100 1 128 3 0.781 1 0 1 0
---
128 8 4096 32 0 0 32 1 32 1 1 1 0 1 0
160 9 16000 100 0 0 100 1 128 5 0.781 1 0 1 0
192 10 12288 64 0 0 64 1 64 3 1 1 0 1 0
224 11 22400 100 0 0 100 1 128 7 0.781 1 0 1 0
---
320 13 20480 64 0 0 64 1 64 5 1 1 0 1 0
384 14 12288 32 0 0 32 1 32 3 1 1 0 1 0
---
1536 22 15360 10 0 0 10 2 8 3 0.625 1 0 2 0
---
large: size ind allocated nmalloc ndalloc nrequests curruns
---
huge: size ind allocated nmalloc ndalloc nrequests curhchunks
---
arenas[5]:
assigned threads: 1
dss allocation precedence: disabled
min active:dirty page ratio: 8:1
dirty pages: 42:0 active:dirty, 0 sweeps, 0 madvises, 0 purged
allocated nmalloc ndalloc nrequests
small: 117760 1024 0 0
large: 0 0 0 0
huge: 0 0 0 0
total: 117760 1024 0 0
active: 172032
mapped: 2097152
metadata: mapped: 53248, allocated: 0
bins: size ind allocated nmalloc ndalloc nrequests curregs curruns regs pgs util nfills nflushes newruns reruns
---
16 1 1600 100 0 0 100 1 256 1 0.390 1 0 1 0
32 2 3200 100 0 0 100 1 128 1 0.781 1 0 1 0
48 3 4800 100 0 0 100 1 256 3 0.390 1 0 1 0
64 4 4096 64 0 0 64 1 64 1 1 1 0 1 0
80 5 8000 100 0 0 100 1 256 5 0.390 1 0 1 0
96 6 9600 100 0 0 100 1 128 3 0.781 1 0 1 0
112 7 11200 100 0 0 100 1 256 7 0.390 1 0 1 0
128 8 4096 32 0 0 32 1 32 1 1 1 0 1 0
160 9 16000 100 0 0 100 1 128 5 0.781 1 0 1 0
192 10 12288 64 0 0 64 1 64 3 1 1 0 1 0
224 11 22400 100 0 0 100 1 128 7 0.781 1 0 1 0
---
320 13 20480 64 0 0 64 1 64 5 1 1 0 1 0
---
large: size ind allocated nmalloc ndalloc nrequests curruns
---
huge: size ind allocated nmalloc ndalloc nrequests curhchunks
---
arenas[6]:
assigned threads: 1
dss allocation precedence: disabled
min active:dirty page ratio: 8:1
dirty pages: 45:0 active:dirty, 0 sweeps, 0 madvises, 0 purged
allocated nmalloc ndalloc nrequests
small: 126976 1050 0 0
large: 0 0 0 0
huge: 0 0 0 0
total: 126976 1050 0 0
active: 184320
mapped: 2097152
metadata: mapped: 53248, allocated: 0
bins: size ind allocated nmalloc ndalloc nrequests curregs curruns regs pgs util nfills nflushes newruns reruns
---
16 1 1600 100 0 0 100 1 256 1 0.390 1 0 1 0
32 2 3200 100 0 0 100 1 128 1 0.781 1 0 1 0
48 3 4800 100 0 0 100 1 256 3 0.390 1 0 1 0
64 4 4096 64 0 0 64 1 64 1 1 1 0 1 0
80 5 8000 100 0 0 100 1 256 5 0.390 1 0 1 0
96 6 9600 100 0 0 100 1 128 3 0.781 1 0 1 0
112 7 11200 100 0 0 100 1 256 7 0.390 1 0 1 0
128 8 4096 32 0 0 32 1 32 1 1 1 0 1 0
160 9 16000 100 0 0 100 1 128 5 0.781 1 0 1 0
192 10 12288 64 0 0 64 1 64 3 1 1 0 1 0
224 11 22400 100 0 0 100 1 128 7 0.781 1 0 1 0
256 12 4096 16 0 0 16 1 16 1 1 1 0 1 0
320 13 20480 64 0 0 64 1 64 5 1 1 0 1 0
---
512 16 5120 10 0 0 10 2 8 1 0.625 1 0 2 0
---
large: size ind allocated nmalloc ndalloc nrequests curruns
---
huge: size ind allocated nmalloc ndalloc nrequests curhchunks
---
arenas[7]:
assigned threads: 1
dss allocation precedence: disabled
min active:dirty page ratio: 8:1
dirty pages: 41:0 active:dirty, 0 sweeps, 0 madvises, 0 purged
allocated nmalloc ndalloc nrequests
small: 131136 956 0 0
large: 0 0 0 0
huge: 0 0 0 0
total: 131136 956 0 0
active: 167936
mapped: 2097152
metadata: mapped: 53248, allocated: 0
bins: size ind allocated nmalloc ndalloc nrequests curregs curruns regs pgs util nfills nflushes newruns reruns
---
16 1 1600 100 0 0 100 1 256 1 0.390 1 0 1 0
32 2 3200 100 0 0 100 1 128 1 0.781 1 0 1 0
48 3 4800 100 0 0 100 1 256 3 0.390 1 0 1 0
64 4 4096 64 0 0 64 1 64 1 1 1 0 1 0
80 5 8000 100 0 0 100 1 256 5 0.390 1 0 1 0
96 6 9600 100 0 0 100 1 128 3 0.781 1 0 1 0
---
128 8 4096 32 0 0 32 1 32 1 1 1 0 1 0
160 9 16000 100 0 0 100 1 128 5 0.781 1 0 1 0
192 10 12288 64 0 0 64 1 64 3 1 1 0 1 0
224 11 22400 100 0 0 100 1 128 7 0.781 1 0 1 0
256 12 4096 16 0 0 16 1 16 1 1 1 0 1 0
320 13 20480 64 0 0 64 1 64 5 1 1 0 1 0
---
1280 21 20480 16 0 0 16 1 16 5 1 1 0 1 0
---
large: size ind allocated nmalloc ndalloc nrequests curruns
---
huge: size ind allocated nmalloc ndalloc nrequests curhchunks
---
--- End jemalloc statistics ---
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment