, case when num_rows > table_rows then lpad(to_char(num_rows::float/table_rows,'xfmB9990D9'),6)Įlse lpad(to_char(100*num_rows/table_rows,'fmB999 %'),6) end coverage
,round(100*max_scratch::float/table_scratch) as pct_scratch
Postgres=> select end_time-start_time duration,round(num_rows/extract(epoch from end_time-start_time)) riops
0 kommentar(er)
