You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
select SUM(st.calls) as call,
SUM(st.rows) as rows,
ROUND(SUM(st.wal_bytes)/1024/1024,2) as wal_MB,
count(DISTINCT(st.queryid)) AS statements_dist,
count(st.queryid) AS statements
FROM profile.sample_statements st
WHERE (st.sample_id >= 17173 and st.sample_id <=17178)
and st.server_id =2;
select SUM(ss.calls) as call,
SUM(ss.rows) as rows,
ROUND(SUM(ss.wal_bytes)/1024/1024, 2) as wal_MB,
sum(ss.statements) AS statements
FROM profile.sample_statements_total ss
WHERE (ss.sample_id >= 17173 and ss.sample_id <=17178)
and ss.server_id =2;
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
Hi!
select SUM(st.calls) as call,
SUM(st.rows) as rows,
ROUND(SUM(st.wal_bytes)/1024/1024,2) as wal_MB,
count(DISTINCT(st.queryid)) AS statements_dist,
count(st.queryid) AS statements
FROM profile.sample_statements st
WHERE (st.sample_id >= 17173 and st.sample_id <=17178)
and st.server_id =2;
"call" "rows" "wal_mb" "statements_dist" "statements"
3299164 5609738 3022.36 170 572
select SUM(ss.calls) as call,
SUM(ss.rows) as rows,
ROUND(SUM(ss.wal_bytes)/1024/1024, 2) as wal_MB,
sum(ss.statements) AS statements
FROM profile.sample_statements_total ss
WHERE (ss.sample_id >= 17173 and ss.sample_id <=17178)
and ss.server_id =2;
"call" "rows" "wal_mb" "statements"
3938772 7465065 3331.10 10705
select count(sl.*) as cnt, count(DISTINCT(sl.queryid_md5)) as cnt_dist from profile.stmt_list sl where sl.server_id =2;
"cnt" "cnt_dist"
1508 1508
Statements - total count of captured statements
Please explain how the value "statements" = 10705 FROM profile.sample_statements_total is calculated (where it comes from)?
Why are the values of "call" "rows" "wal_mb" calculated from sample_statements_total and sample_statements not equal?
All reactions