Denisio DBalashov

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

Текущие выполняемые запросы

select pid, user, client_addr, query_start, backend_type, substr(query, 0, 256) as query
from pg_stat_activity
where query_start is not null
  and client_addr is not null;

	$extensions = @(".cs", ".vue", ".scss", ".ts")
	$exclude = @("\bin\", "\obj\", "\node_modules\", "\.nuxt\", "\.output\")
	$path = $args[0]

	$files = Get-ChildItem -Recurse -Include ($extensions \| % { '*' + $_ }) $path

	$statLength = @{}
	$statLOC = @{}

	$totalLOC = 0;

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

	namespace PostgresExtensions;

	/*

	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>();

	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,

	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>();