EXPLAIN full options

Expression index for LOWER()

Partial index for status filter

Correct index type rationale

No SELECT * in rewrites

ANALYZE after bulk migration

Increased statistics target

Monitoring query provided

Performance impact comment

Index on join column

No index without analysis

JSONB not JSON

GIN index created

jsonb_path_ops used

Generated column for status

Containment operator (@>) used

No BLOBs in database

No JSON type justification absent

Status field separate index

Index type comment/rationale

No huge arrays warning

No SELECT * in queries

pg_stat_statements query

Cache hit ratio check

Dead tuple monitoring

Replication lag query

XID wraparound check

Idle-in-transaction detection

REINDEX CONCURRENTLY

Per-table autovacuum tuning

No global autovacuum disable

UUID type for api_keys

UUID type comment

wal_level = replica

WAL archiving configured

Replication slot created

pg_basebackup -R flag

pg_basebackup -X stream

Slot name in pg_basebackup

primary_conninfo in standby config

pg_stat_replication lag query

Standby lag query

Lag alert threshold

Replication slot monitoring

pgvector extension enabled

HNSW index used

Cosine distance operator class

Cosine distance in search query

pg_trgm extension enabled

Trigram GIN index

Fuzzy similarity query

maintenance_work_mem before bulk import

ANALYZE after bulk import

random_page_cost for SSD

effective_io_concurrency for SSD

pgBouncer pool_mode = transaction

pgBouncer max_client_conn

pgBouncer default_pool_size

Parameterized customer lookup

Parameterized order update

Parameterized date range query

No SELECT * in safe_queries

CREATE INDEX CONCURRENTLY for all indexes

Partial index for pending transactions

EXPLAIN before index creation

EXPLAIN after index creation