Missing foreign keys finder
21 October 2023
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,
Menu
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,
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
Using Ankane: Dexter you can find missing indexes in your database. You will need to install HypoPG – PostgreSQL extension for hypothetical indexes too. After
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
Sometimes on import data to database, you have issue with not updated autoincement keys? Use this, to generate scripts for update all tables to their
BARTULACODE 2024