<Bartula Code/>
Blog
Missing foreign keys finder
Sometimes when you need to import big bunch of data you may need to consider setting a flag: SET session_replication_role = 'replica'; However, this import,
Postgre change ownership of whole database to the role/user (including tables, functions, and views)
If you need to transfer ownership of whole database (in postgress) you need to alter all tables, sequnces, views, and materialized views separately. Below is
Rider support MAUI .NET
If want to create .NET application with MAUI uusing Rider. you don’t need to install Visual Studio. All you need is run this commands dotnet
Check which process using socket
If you want to check which porcess accessing to the some url/port Use this: netstat -a -n -o | findstr "8080" Replace 8080 with port
The automatic indexer for Postgres
Using Ankane: Dexter you can find missing indexes in your database. You will need to install HypoPG – PostgreSQL extension for hypothetical indexes too. After
Usefull PostgreSQL commands
Source : https://gist.github.com/rgreenjr/3637525 — show running queries (pre 9.2) SELECT procpid, age(clock_timestamp(), query_start), usename, current_query FROM pg_stat_activity WHERE current_query != '<IDLE>' AND current_query NOT ILIKE