Edi Santoso repodevs

Troubleshooting Guide: PostgreSQL CPU Spikes on account_move_line Deletions

This note explains why deleting from account_move_line spikes CPU and provides step-by-step instructions to fix it natively in PostgreSQL.

🛑 The Problem

When executing DELETE FROM account_move_line WHERE id IN ( ? ), PostgreSQL triggers internal system checks (RI_FKey_check_relation) for every table referencing account_move_line. If those referencing columns are not indexed, PostgreSQL performs a Sequential Full Table Scan across dozens of tables for every single ID deleted, melting your CPU.

🛠️ Step-by-Step Resolution

Kiro System Prompt used in .github/instructions/system-prompt.instructions.md

source: https://github.com/ghuntley/amazon-kiro.kiro-agent-source-code-analysis

Usage

Download file video_compressor.sh

Make it Executeable by chmod +x video_compressor.sh

Run the script ./video_compressor.sh source_video 15

15 is target new size in MB

Usage of `upgrade_addons.sh` script

Download it
Make it Executeable with chmod +x upgrade_addons.sh
Use it

./upgrade_addons.sh DATABASE ADDONS_A_TO_UGRADE,ADDONS_B_TO_UPGRADE

	import time
	import odoorpc
	import pandas


	def odoo_download_stock_move_to_excel():
	"""
	Download stock move data from Odoo and save it to an Excel file.
	"""
	# Odoo connection

	export GOROOT="$(go1.17 env GOROOT)"
	PATH_add "$(go1.17 env GOROOT)/bin"

	export GO111MODULE=on
	export GOFLAGS=-mod=vendor
	export CGO_ENABLED=0

	SELECT
	id, name
	FROM table_users
	WHERE 1=1
	[[ AND name = ANY(STRING_TO_ARRAY({{ user_name }}, ',')) ]]

	-- `user_name` is metabase variables, type: Text
	-- `','` is the delimeter
	-- usage: in variablse `user_name` -> `Sky,Blue,Green`
	-- it's will equal to `AND name IN ('Sky', 'Blue', 'Greem')

	#!/bin/bash

	# filter by name
	docker ps -a -f name=^/sentry

	# filter by name only container id
	docker ps -a -q -f name=^/sentry

	# filter by name then remove
	docker rm $(docker ps -a -q -f name=^/sentry)