DBalashov

using System.Runtime.CompilerServices;
using System.Runtime.InteropServices;
using System.Runtime.Intrinsics;
using System.Runtime.Intrinsics.X86;
using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Configs;
using BenchmarkDotNet.Jobs;
using BenchmarkDotNet.Running;

// | Method            | Categories | N     | Mean          | Error      | StdDev     | Median        | Ratio | RatioSD |

DBalashov

using System.Runtime.InteropServices;
using System.Runtime.Intrinsics;
using System.Runtime.Intrinsics.X86;
using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Configs;
using BenchmarkDotNet.Jobs;
using BenchmarkDotNet.Running;

// | Method             | Categories | N      | Mean          | Error      | StdDev     | Ratio |
// |------------------- |----------- |------- |--------------:|-----------:|-----------:|------:|

DBalashov

using System.Runtime.InteropServices;
using System.Runtime.Intrinsics;
using System.Runtime.Intrinsics.X86;
using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Configs;
using BenchmarkDotNet.Jobs;
using BenchmarkDotNet.Running;

// | Method           | Categories | N      | Mean          | Error        | StdDev     | Ratio |
// |----------------- |----------- |------- |--------------:|-------------:|-----------:|------:|

DBalashov

using System.Runtime.InteropServices;
using System.Runtime.Intrinsics;
using System.Runtime.Intrinsics.X86;
using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Configs;
using BenchmarkDotNet.Jobs;
using BenchmarkDotNet.Running;

#pragma warning disable CS8618

DBalashov

using System.Runtime.InteropServices;
using System.Runtime.Intrinsics;
using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Jobs;
using BenchmarkDotNet.Running;

#pragma warning disable CS8618

var summary = BenchmarkRunner.Run<MainTest>();

DBalashov

using System.Runtime.InteropServices;
using System.Runtime.Intrinsics;
using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Jobs;
using BenchmarkDotNet.Running;

#pragma warning disable CS8618

var summary = BenchmarkRunner.Run<MainTest>();

DBalashov

select table,
       formatReadableSize(sum(bytes)) as size,
       min(min_date)                  as min_date,
       max(max_date)                  as max_date
from system.parts
where active
group by table;

select table, formatReadableSize(size) as size, rows, days, formatReadableSize(avgDaySize) as avgDaySize
from (select table,

DBalashov

using System.Runtime.CompilerServices;
using System.Runtime.Intrinsics;
using System.Runtime.Intrinsics.X86;
using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Jobs;
using BenchmarkDotNet.Running;

#pragma warning disable CS8618

var summary = BenchmarkRunner.Run<MainTest>();

DBalashov

using System.Data.Common;
using System.Text;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Diagnostics;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Logging;

namespace PostgresExtensions;

/*

DBalashov

Другие интересные штуки тут: https://t.me/notes_of_programmer

Размер таблицы с детализацией

select l.metric
     , l.nr                                            as bytes
     , case when is_size then pg_size_pretty(nr) end   as bytes_pretty
     , case when is_size then nr / nullif(x.ct, 0) end as bytes_per_row
from (select min(tableoid)        as tbl     -- = 'public.tbl'::regclass::oid