Denisio 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,

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

	-- 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,

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