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

-- Most heavy queries:
select type,
       event_time,
       initial_query_id,
       query_id,
       formatReadableSize(memory_usage) as memory,
       used_functions,
       used_aggregate_functions,
       current_database,
       result_rows,

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

Таблицы, которым пора делать vacuum

select schemaname,
       relname,
       quote_ident(schemaname) || '.' || quote_ident(relname)   as full_table_name,
       n_live_tup,
       n_dead_tup,