Finding codes¶

Every finding of lokadb check has a code. Codes are stable: a code is never renamed, so a baseline or a script that names a code keeps its meaning. Codes that are no longer produced are listed as retired.

There are 166 codes in this version. The codes appear in the text report next to each finding and in the JSON report (report format); how to read the findings and what to do about them is in check an application.

Codes in use¶

already_enabled
app_role_bypasses_rls
app_role_unknown
cdc_publication
child_composite_fk
child_has_tenant_column
child_without_fk
cloud_direct_access
cloud_direct_access_unknown
cloud_postgres_fdw
cloud_postgres_fdw_install
cloud_references
cloud_replication_slots
cloud_table_declared
cloud_wal_level
copy_from_cost
customer_app_database
customer_app_is_admin
customer_app_missing
customer_app_no_create_on_schema
customer_app_owner
customer_app_superuser
customer_app_unreachable
customer_collation_differs
customer_collation_missing
customer_collation_unavailable
customer_connected
customer_contents
customer_creates
customer_encoding
customer_extension_privilege
customer_extension_unavailable
customer_extension_version
customer_function_security_definer
customer_function_untrusted
customer_index_skipped
customer_object_missing
customer_previous_attempt
customer_privileges
customer_schema
customer_table_exists
customer_tables_unknown
customer_unreachable
customer_version
customer_version_older
ddl_rejected
ddl_replayed
ddl_then_write_transaction
dependent_refused
dependents_repointed
discovered
discovery_ambiguous
discovery_by_name
discovery_empty
discovery_link_tables
enable_prepare
enable_prepare_done
enable_prepare_stalled
exclude_not_tenant_scoped
feed_index
fk_multicolumn
fk_not_to_id
fk_to_cloud
fk_to_cloud_delete
fk_to_unique_column
grants_carried
id_missing
id_not_unique
id_null
id_type
id_unique_after
id_unique_not_checked
identity_always
key_declared
key_not_checked
key_not_unique
large_objects
latency_estimate
latency_expensive_transaction
latency_n_plus_one
latency_no_recording
logical_slots
materialized_view
matview_stores_moved_rows
mixed_write_transaction
move_leftovers
move_mode
name_conflict
no_pg_stat_statements
no_workload
org_dependencies
org_profile_fdw
orphan_rows
orphan_rows_sampled
parent_column_missing
parent_column_type
parent_not_in_spec
parent_polymorphic
parent_without_organization
parse_error
pg_stat_statements_hidden
pg_stat_statements_unreadable
profile_direct_all_organizations
profile_direct_fk_cloud
profile_direct_needs_mirror
profile_direct_refs
profile_direct_refused_form
profile_direct_share
profile_direct_tx_refused
profile_direct_unnamed_read
profile_direct_unnamed_write
profile_direct_unroutable
profile_estimate_only
profile_fdw
profile_fdw_after_cloud
profile_fdw_after_direct
profile_fdw_reason
profile_idle_session_timeout
profile_insert_cloud_id
profile_no_lokadb_queries
profile_org_not_moved
profile_two_connections
profile_unchanged
query_fanout_allowed
query_forbidden
query_refused
query_without_organization
recording_truncated
relation_declared
relation_not_checked
relation_unverified
replay_no_credentials
replay_targets_unreadable
replay_unreachable
rls_enabled
rls_policy
routing_invalid
routing_patch
routing_suggestion
spec_cycle
spec_duplicate
spec_no_organization
spec_parent_column
spec_tables_after_move
spec_two_organizations
table_missing
table_partitioned
table_rule
tenant_column_missing
tenant_column_type
tenant_kind_mixed
tenant_null
tenant_nullable
tenant_session_set
tenant_table_in_cloud
tenant_value_reserved
transactions_not_checked
triggers_carried
unique_not_tenant_scoped
unlinked_table
update_assigns_organization
upsert_rewritten
user_trigger
views_not_checked
workload_empty
workload_own_role_only

Retired codes¶

untested_feature