Home / postgres / postgres
AI Slop Code Risk Monitor

postgres/postgres

SlopCodeMonitor badge for postgres/postgres Adjusted legacy signal; badge bands: 25 / 50 / 75 (different from dashboard bands).

Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch

1.0 Low pattern signal View on GitHub

Open-Source Code Quality, Security and Technical Debt Review

This report summarizes scanner evidence for postgres/postgres, a C project with 22,649 GitHub stars. SynthScan examined 2,148,088 lines of code across 3891 source files, recording 1626 pattern matches distributed across 15 syntactic categories. The legacy adjusted pattern signal is 1.0 (Low pattern signal); it is not an authorship estimate.

Use the findings to ask whether maintainers can explain intent, verify dependencies, simplify unnecessary scaffolding, and focus review effort. Risk Payload v1 adds ownership, supply-chain, over-engineering, and review-effort vectors when available. These are prompts for human verification, not probabilities, security findings, or measured maintenance costs.

1.0
Adjusted Signal
1.0
Raw Pattern Score
100%
Time Factor
2026-10-31
Last Push
22.6K
Stars
C
Language
2.1M
Lines of Code
3.9K
Files
1.6K
Pattern Hits
2026-10-31
Scan Date
0.00
HC Hit Rate

Risk Review · Payload v1

Use each vector to guide manual verification of the underlying findings.

Payload schema: 1.0.0 · Engine: 2.0.0 · Scoring: heuristic-density-v1 · Scan date: 2026-10-31.

Cognitive Ownership Risk 4.0/100 · LOW

Can maintainers explain intent, assumptions, and trade-offs? 1483 finding(s).

Hallucinated Dependency & Supply Chain Risk 0.1/100 · LOW

Are imports declared and package/API names verified? 20 finding(s).

Agent Over-Engineering Ratio 0.9/100 · LOW

Are wrappers, guards, and repeated structures necessary? 125 finding(s).

PR Review Velocity Impact 4.9/100 · LOW

Which changes need focused human review? 1626 finding(s).

What These Metrics Mean

Adjusted Signal
Legacy pattern score normalized per 1,000 scanned lines and multiplied by the repository-level time factor. It is not an estimate of AI authorship.
Raw Pattern Score
Sum of severity- and context-weighted pattern findings before applying the time factor.
Time Factor
A coarse multiplier based on repository last-push metadata. It does not identify when individual code was written.
Pattern Hits
Count of configured pattern findings. Review each location and surrounding code before acting.
HC Hit Rate
High- and critical-severity findings per scanned file. Severity is a configured detector weight, not proof of a vulnerability or authorship.
Lines / Files
Scan coverage denominators used by the legacy normalized score.

Pattern-Signal History

This chart tracks the legacy adjusted pattern score across scan runs. Changes can reflect source changes, scan coverage, or detector/scoring versions; they do not measure AI adoption or prove that a team refactored code. Compare runs only when their scoring versions are compatible. The dashed line tracks the raw pattern-hit count.

Severity Breakdown

Groups findings by configured severity weight. Severity is not a confidence estimate, security rating, or proof that a package is missing. Verify imports against the project's manifests and inspect each finding in its local design context.

CRITICAL 0HIGH 1MEDIUM 265LOW 1360

Directory Score Breakdown

This horizontal bar chart shows where configured pattern scores accumulate across directories. Treat the bars as locations to inspect, not as evidence of authorship or code quality. Use the file-level findings to decide whether a directory needs a focused ownership, dependency, complexity, or review check.

Pattern Findings

The scanner identified 1626 distinct pattern matches across 15 syntactic categories. Each entry below represents a discrete location in the source code where the engine recorded a detector match to inspect in context. Expand any category row to inspect the individual file paths, line numbers, code snippets, and the lexical context (CODE, COMMENT, or STRING) in which each match was detected.

Reading the findings table: The Severity column indicates the configured finding weight (CRITICAL / HIGH / MEDIUM / LOW). The Context column identifies whether the match occurred inside executable code, an inline comment, or a string literal — legacy comment-context matches receive a ×1.5 score weight. The ⚡ bolt icon marks clustered matches: three or more patterns within a 10-line window, each receiving an additional ×1.5 density multiplier under the legacy scoring model.

Over-Commented Block1244 hits · 1158 pts
SeverityFileLineSnippetContext
LOWcontrib/postgres_fdw/deparse.c41#include "catalog/pg_collation.h"COMMENT
LOWcontrib/postgres_fdw/postgres_fdw.c21#include "commands/defrem.h"COMMENT
LOWcontrib/postgres_fdw/postgres_fdw.c41#include "optimizer/restrictinfo.h"COMMENT
LOWcontrib/postgres_fdw/connection.c21#include "catalog/pg_user_mapping.h"COMMENT
LOWcontrib/pg_prewarm/autoprewarm.c21 * IDENTIFICATIONCOMMENT
LOWcontrib/pg_prewarm/autoprewarm.c41#include "storage/latch.h"COMMENT
LOWcontrib/pageinspect/btreefuncs.c21 * THE AUTHOR SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOTCOMMENT
LOWcontrib/pageinspect/heapfuncs.c21 * contrib/pageinspect/heapfuncs.cCOMMENT
LOWcontrib/file_fdw/file_fdw.c21#include "access/table.h"COMMENT
LOWcontrib/uuid-ossp/uuid-ossp.c21#include "utils/uuid.h"COMMENT
LOWcontrib/uuid-ossp/uuid-ossp.c41#endifCOMMENT
LOWcontrib/pg_trgm/trgm_op.c1/*COMMENT
LOWcontrib/pg_trgm/trgm_op.c221 if (GetDefaultCharSignedness())COMMENT
LOWcontrib/pg_trgm/trgm.h21 * the operator classes, because we can't handle case-insensitive wildcardCOMMENT
LOWcontrib/pg_trgm/trgm.h81#define CLRBIT(x,i) GETBYTE(x,i) &= ~( 0x01 << ( (i) % BITBYTE ) )COMMENT
LOWcontrib/unaccent/generate_unaccent_rules.py1#!/usr/bin/pythonCOMMENT
LOWcontrib/unaccent/generate_unaccent_rules.py21# command line argument -- will be parsed and used.COMMENT
LOWcontrib/unaccent/generate_unaccent_rules.py181 # And finish the processing of each individual rule.COMMENT
LOWcontrib/cube/cubedata.h41#define SET_POINT_BIT(cube) ( (cube)->header |= POINT_BIT )COMMENT
LOWcontrib/dblink/dblink.c41#include "catalog/namespace.h"COMMENT
LOWcontrib/intarray/_int.h61/* bigint defines */COMMENT
LOWcontrib/pgrowlocks/pgrowlocks.c21 * IS" BASIS, AND THE AUTHOR HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE,COMMENT
LOWcontrib/btree_gin/btree_gin.c1/*COMMENT
LOWcontrib/ltree/ltree.h161#define COMPUTESIZE(size,lenofoperand) ( HDRSIZEQT + (size) * sizeof(ITEM) + (lenofoperand) )COMMENT
LOWcontrib/ltree/ltree.h221#define PG_GETARG_LTREE_P_COPY(n) DatumGetLtreePCopy(PG_GETARG_DATUM(n))COMMENT
LOWcontrib/ltree/ltree.h281#define LTG_NODE(x) ( (ltree*)( ((char*)(x))+LTG_HDRSIZE ) )COMMENT
LOWcontrib/pg_stat_statements/pg_stat_statements.c41 *COMMENT
LOWcontrib/pg_stat_statements/pg_stat_statements.c61#include "pgstat.h"COMMENT
LOWcontrib/pg_stat_statements/pg_stat_statements.c1581pg_stat_statements_reset(PG_FUNCTION_ARGS)COMMENT
LOWcontrib/pg_buffercache/pg_buffercache_pages.c21COMMENT
LOWcontrib/amcheck/verify_heapam.c21#include "access/visibilitymap.h"COMMENT
LOWcontrib/amcheck/verify_nbtree.c21 *COMMENT
LOWcontrib/hstore/hstore_io.c1/*COMMENT
LOWcontrib/pgcrypto/px.h41#define PX_MAX_SALT_LEN 128COMMENT
LOWcontrib/pgcrypto/px.h61#define PXE_BAD_SALT_ROUNDS -15COMMENT
LOWcontrib/pgcrypto/px.h201#define px_md_block_size(md) (md)->block_size(md)COMMENT
LOWcontrib/pgcrypto/scripts/pgp_session_data.py1#!/usr/bin/pythonCOMMENT
LOWcontrib/pg_plan_advice/pgpa_planner.c21#include "pgpa_output.h"COMMENT
LOWcontrib/pgstattuple/pgstatindex.c21 * THE AUTHOR SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOTCOMMENT
LOWcontrib/pgstattuple/pgstattuple.c21 * IS" BASIS, AND THE AUTHOR HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE,COMMENT
LOWcontrib/fuzzystrmatch/dmetaphone.c101#include "utils/builtins.h"COMMENT
LOWcontrib/fuzzystrmatch/daitch_mokotoff_header.pl121 print $OUTPUT "};\n";COMMENT
LOWcontrib/sepgsql/sepgsql.h41#define SEPG_CLASS_BLK_FILE 5COMMENT
LOWcontrib/sepgsql/sepgsql.h61#define SEPG_PROCESS__SETCURRENT (1<<2)COMMENT
LOWcontrib/sepgsql/sepgsql.h81#define SEPG_DIR__REPARENT (1<<10)COMMENT
LOWcontrib/sepgsql/sepgsql.h101#define SEPG_BLK_FILE__UNLINK (SEPG_FILE__UNLINK)COMMENT
LOWcontrib/sepgsql/sepgsql.h121#define SEPG_DB_DATABASE__SETATTR (1<<3)COMMENT
LOWcontrib/sepgsql/sepgsql.h141#define SEPG_DB_TABLE__RELABELFROM (SEPG_DB_DATABASE__RELABELFROM)COMMENT
LOWcontrib/sepgsql/sepgsql.h161#define SEPG_DB_PROCEDURE__DROP (SEPG_DB_DATABASE__DROP)COMMENT
LOWcontrib/sepgsql/sepgsql.h181#define SEPG_DB_TUPLE__RELABELTO (SEPG_DB_DATABASE__RELABELTO)COMMENT
LOWcontrib/sepgsql/sepgsql.h201#define SEPG_DB_LANGUAGE__SETATTR (SEPG_DB_DATABASE__SETATTR)COMMENT
LOWcontrib/sepgsql/label.c21#include "catalog/pg_attribute.h"COMMENT
LOW.github/workflows/pg-ci.yml1# GitHub Actions CI configuration for PostgreSQLCOMMENT
LOW.github/workflows/pg-ci.yml261 timeout-minutes: 15COMMENT
LOW.github/workflows/pg-ci.yml381 key: ${{ steps.ccache-restore-branch.outputs.cache-primary-key }}COMMENT
LOW.github/workflows/pg-ci.yml761 # Use MacPorts, even though Homebrew is installed. The installationCOMMENT
LOW.github/workflows/pg-ci.yml901 # then `robocopy` it into per-test data directories. Robocopy with theCOMMENT
LOW.github/workflows/pg-ci.yml921 # postgres' plpython3u loads python3.dll (the stable-ABI forwarder)COMMENT
LOWsrc/pl/plpgsql/src/pl_exec.c21#include "access/htup_details.h"COMMENT
LOWsrc/pl/plpgsql/src/pl_comp.c21#include "catalog/namespace.h"COMMENT
1184 more matches not shown…
Self-Referential Comments141 hits · 434 pts
SeverityFileLineSnippetContext
MEDIUMcontrib/pg_visibility/t/001_concurrent_transaction.pl36# Create a sample table and run vacuumCOMMENT
MEDIUMcontrib/pg_visibility/t/002_corrupt_vm.pl21# Create a sample table with at least 10 pages and then run VACUUM. 10 isCOMMENT
MEDIUMcontrib/amcheck/t/004_verify_nbtree_unique.pl18# Create a custom operator class and an index which uses it.COMMENT
MEDIUMcontrib/amcheck/t/005_pitr.pl16# Create a table with each of 6 PK values spanning 1/4 of a block. Delete theCOMMENT
MEDIUMcontrib/amcheck/t/001_verify_heapam.pl115# Create a test sequence of the given name.COMMENT
MEDIUMsrc/test/ssl/t/SSL/Server.pm15 # Create a new clusterCOMMENT
MEDIUMsrc/test/ldap/t/003_ldap_connection_param_lookup.pl74# Create the set of service files used in the tests.COMMENT
MEDIUMsrc/test/recovery/t/042_low_level_backup.pl51# Create a table that will be used to verify that recovery started at theCOMMENT
MEDIUMsrc/test/recovery/t/040_standby_failover_slots_sync.pl37# Create a subscriber node, wait for sync to completeCOMMENT
MEDIUMsrc/test/recovery/t/040_standby_failover_slots_sync.pl50# Create a subscription that enables failover.COMMENT
MEDIUMsrc/test/recovery/t/040_standby_failover_slots_sync.pl137# Create a standbyCOMMENT
MEDIUMsrc/test/recovery/t/040_standby_failover_slots_sync.pl377# Create a cascading standbyCOMMENT
MEDIUMsrc/test/recovery/t/040_standby_failover_slots_sync.pl410# Create a failover slot and advance the restart_lsn to a position where aCOMMENT
MEDIUMsrc/test/recovery/t/040_standby_failover_slots_sync.pl766# Create a logical 'test_decoding' replication slot with failover enabledCOMMENT
MEDIUMsrc/test/recovery/t/033_replay_tsp_drops.pl121# Create a database in the tablespace and a table in default tablespaceCOMMENT
MEDIUMsrc/test/recovery/t/008_fsm_truncation.pl24# Create a primary node and its standby, initializing both with some dataCOMMENT
MEDIUMsrc/test/recovery/t/035_standby_logical_decoding.pl47# Create the required logical slots on standby.COMMENT
MEDIUM⚡src/test/recovery/t/035_standby_logical_decoding.pl503# Create a table on the primaryCOMMENT
MEDIUM⚡src/test/recovery/t/035_standby_logical_decoding.pl507# Create a table (same structure) on the subscriber nodeCOMMENT
MEDIUM⚡src/test/recovery/t/035_standby_logical_decoding.pl511# Create a publication on the primaryCOMMENT
MEDIUMsrc/test/recovery/t/035_standby_logical_decoding.pl558# Create the injection_points extensionCOMMENT
MEDIUMsrc/test/recovery/t/035_standby_logical_decoding.pl917# Create a slot on a database that would not be dropped. This slot should notCOMMENT
MEDIUMsrc/test/recovery/t/035_standby_logical_decoding.pl956# Create a physical replication slot on the standby.COMMENT
MEDIUMsrc/test/recovery/t/035_standby_logical_decoding.pl1073# Create a logical slot on the cascading standby for this test.COMMENT
MEDIUMsrc/test/recovery/t/046_checkpoint_logical_slot.pl36# Create the two slots we'll need.COMMENT
MEDIUMsrc/test/recovery/t/046_checkpoint_logical_slot.pl159# Create a standbyCOMMENT
MEDIUMsrc/test/recovery/t/014_unlogged_reinit.pl21# Create an unlogged table and an unlogged sequence to test that forksCOMMENT
MEDIUMsrc/test/recovery/t/014_unlogged_reinit.pl43# Create an unlogged table in a tablespace.COMMENT
MEDIUMsrc/test/recovery/t/019_replslot_limit.pl39# Create a standby linking to it using the replication slotCOMMENT
MEDIUMsrc/test/recovery/t/019_replslot_limit.pl443# Create a standby linking to the primary using the replication slotCOMMENT
MEDIUMsrc/test/recovery/t/049_wait_for_lsn.pl101# Create a streaming standby with a 1 second delay from the backupCOMMENT
MEDIUMsrc/test/recovery/t/049_wait_for_lsn.pl875# Create an archive-only standby: has_restoring but NOT has_streaming.COMMENT
MEDIUMsrc/test/recovery/t/054_unlogged_sequence_promotion.pl24# Create the unlogged sequence after the standby has started, so its init forkCOMMENT
MEDIUMsrc/test/recovery/t/017_shm.pl44# Create a shmem segment that will conflict with gnat's first choiceCOMMENT
MEDIUMsrc/test/recovery/t/047_checkpoint_physical_slot.pl37# Create a physical replication slot.COMMENT
MEDIUMsrc/test/recovery/t/051_effective_wal_level.pl45# Create a physical slot and verify that it doesn't affect effective_wal_level.COMMENT
MEDIUMsrc/test/recovery/t/051_effective_wal_level.pl54# Create a temporary logical slot but exit without releasing it explicitly.COMMENT
MEDIUMsrc/test/recovery/t/051_effective_wal_level.pl111# Create a new logical slot and check that effective_wal_level must be increasedCOMMENT
MEDIUMsrc/test/recovery/t/051_effective_wal_level.pl208# Creating a logical slot on standby should succeed as the primary enablesCOMMENT
MEDIUMsrc/test/perl/PostgreSQL/Test/Cluster.pm16 # Create a data directory with initdbCOMMENT
MEDIUMsrc/test/perl/PostgreSQL/Test/BackgroundPsql.pm16 # Create a data directory with initdbCOMMENT
MEDIUMsrc/test/subscription/t/017_stream_ddl.pl6# This file is mainly to test the DDL/DML interaction of the publisher side,COMMENT
MEDIUMsrc/test/subscription/t/037_except.pl104# Create a logical replication slot to help with later tests.COMMENT
MEDIUMsrc/test/subscription/t/033_run_as_table_owner.pl232# Create a new subscription "admin_sub" owned by regress_admin2. It'sCOMMENT
MEDIUMsrc/test/subscription/t/036_sequences.pl86# Create a new sequence 'regress_s2', and update existing sequence 'regress_s1'COMMENT
MEDIUMsrc/test/subscription/t/036_sequences.pl134# Create a new sequence 'regress_s3', and update the existing sequenceCOMMENT
MEDIUMsrc/test/subscription/t/036_sequences.pl302# Create a new sequence 'regress_s4' whose START value is not the same in theCOMMENT
MEDIUMsrc/test/subscription/t/019_stream_subxact_ddl_abort.pl7# This file is mainly to test the DDL/DML interaction of the publisher side,COMMENT
MEDIUMsrc/test/subscription/t/029_on_error.pl107# Create a pub/sub to set up logical replication. This tests that theCOMMENT
MEDIUMsrc/test/subscription/t/030_origin.pl46# Create the same table on node_BCOMMENT
MEDIUMsrc/test/subscription/t/100_bugs.pl181# Create the tables in all nodes.COMMENT
MEDIUMsrc/test/subscription/t/100_bugs.pl186# Create a cascaded replication setup like:COMMENT
MEDIUMsrc/test/subscription/t/100_bugs.pl550# Create an AFTER INSERT trigger on the table that raises and subsequentlyCOMMENT
MEDIUMsrc/test/subscription/t/100_bugs.pl638# Create a publication with the zero-division row filter. It always throws anCOMMENT
MEDIUM⚡src/test/subscription/t/035_conflicts.pl14# Create a publisher nodeCOMMENT
MEDIUM⚡src/test/subscription/t/035_conflicts.pl19# Create a subscriber nodeCOMMENT
MEDIUM⚡src/test/subscription/t/035_conflicts.pl24# Create a table on publisherCOMMENT
MEDIUMsrc/test/subscription/t/035_conflicts.pl47# Create the subscriptionCOMMENT
MEDIUMsrc/test/subscription/t/035_conflicts.pl171# Create the same table on node_BCOMMENT
MEDIUMsrc/test/subscription/t/035_conflicts.pl386# Create the table and publish it from node B only, so that local changes onCOMMENT
81 more matches not shown…
Decorative Section Separators116 hits · 368 pts
SeverityFileLineSnippetContext
MEDIUMsrc/tools/gen_keywordlist.pl1#----------------------------------------------------------------------COMMENT
MEDIUMsrc/tools/gen_keywordlist.pl29#----------------------------------------------------------------------COMMENT
MEDIUMsrc/tools/PerfectHash.pm1#----------------------------------------------------------------------COMMENT
MEDIUMsrc/tools/PerfectHash.pm28#----------------------------------------------------------------------COMMENT
MEDIUMsrc/tools/msvc_gendef.pl33 # ------------------------------------------------------------------------COMMENT
MEDIUMsrc/tools/mark_pgdllimport.pl3#----------------------------------------------------------------------COMMENT
MEDIUMsrc/tools/mark_pgdllimport.pl23#----------------------------------------------------------------------COMMENT
MEDIUMsrc/test/recovery/t/044_invalidate_inactive_slots.pl40# ========================================================================COMMENT
MEDIUMsrc/test/recovery/t/044_invalidate_inactive_slots.pl105# =============================================================================COMMENT
MEDIUMsrc/test/recovery/t/019_replslot_limit.pl430# =============================================================================COMMENT
MEDIUMsrc/test/recovery/t/019_replslot_limit.pl493# =============================================================================COMMENT
MEDIUMsrc/test/recovery/t/019_replslot_limit.pl495# =============================================================================COMMENT
MEDIUMsrc/test/recovery/t/019_replslot_limit.pl553# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/037_except.pl73# ============================================COMMENT
MEDIUMsrc/test/subscription/t/037_except.pl75# ============================================COMMENT
MEDIUMsrc/test/subscription/t/037_except.pl205# ============================================COMMENT
MEDIUMsrc/test/subscription/t/037_except.pl207# ============================================COMMENT
MEDIUMsrc/test/subscription/t/037_except.pl230# ============================================COMMENT
MEDIUMsrc/test/subscription/t/037_except.pl232# ============================================COMMENT
MEDIUMsrc/test/subscription/t/028_row_filter.pl23# ====================================================================COMMENT
MEDIUMsrc/test/subscription/t/028_row_filter.pl77# ====================================================================COMMENT
MEDIUMsrc/test/subscription/t/028_row_filter.pl79# ====================================================================COMMENT
MEDIUMsrc/test/subscription/t/028_row_filter.pl179# ====================================================================COMMENT
MEDIUMsrc/test/subscription/t/028_row_filter.pl181# ======================================================COMMENT
MEDIUMsrc/test/subscription/t/028_row_filter.pl800# ======================================================COMMENT
MEDIUMsrc/test/subscription/t/014_binary.pl43# ------------------------------------------------------COMMENT
MEDIUMsrc/test/subscription/t/014_binary.pl45# ------------------------------------------------------COMMENT
MEDIUMsrc/test/subscription/t/014_binary.pl84# ----------------------------------COMMENT
MEDIUMsrc/test/subscription/t/014_binary.pl86# ----------------------------------COMMENT
MEDIUMsrc/test/subscription/t/014_binary.pl135# ------------------------------------------------------------------------------COMMENT
MEDIUMsrc/test/subscription/t/014_binary.pl137# ------------------------------------------------------------------------------COMMENT
MEDIUM⚡src/test/subscription/t/014_binary.pl180# ---------------------------------------------------------------COMMENT
MEDIUM⚡src/test/subscription/t/014_binary.pl182# ---------------------------------------------------------------COMMENT
MEDIUMsrc/test/subscription/t/014_binary.pl243# -----------------------------------------------------COMMENT
MEDIUMsrc/test/subscription/t/014_binary.pl245# -----------------------------------------------------COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl24# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl90# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl92# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl178# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl180# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl264# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl266# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl345# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl347# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl408# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl410# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl479# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl481# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl538# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl540# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl607# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl609# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/032_subscribe_use_index.pl734# =============================================================================COMMENT
MEDIUMsrc/test/subscription/t/011_generated.pl104# =============================================================================COMMENT
MEDIUM⚡src/test/subscription/t/011_generated.pl121# =============================================================================COMMENT
MEDIUM⚡src/test/subscription/t/011_generated.pl125# --------------------------------------------------COMMENT
MEDIUM⚡src/test/subscription/t/011_generated.pl129# --------------------------------------------------COMMENT
MEDIUM⚡src/test/subscription/t/011_generated.pl220# =============================================================================COMMENT
MEDIUM⚡src/test/subscription/t/011_generated.pl230# =============================================================================COMMENT
MEDIUM⚡src/test/subscription/t/011_generated.pl232# --------------------------------------------------COMMENT
56 more matches not shown…
Redundant / Tautological Comments43 hits · 64 pts
SeverityFileLineSnippetContext
LOWcontrib/unaccent/generate_unaccent_rules.py117 # Check if the base letter of this letter has marks.COMMENT
LOWcontrib/sepgsql/t/001_sepgsql.pl228# Check if the truncate permission exists in the loaded policy, and if so,COMMENT
LOWsrc/test/recovery/t/041_checkpoint_at_promote.pl38# Check if the extension injection_points is available, as it may beCOMMENT
LOWsrc/test/recovery/t/001_stream_rep.pl616# Check if the previous segment gets correctly recycled after theCOMMENT
LOWsrc/test/recovery/t/040_standby_failover_slots_sync.pl248# Check if the synced slot is invalidatedCOMMENT
LOWsrc/test/recovery/t/040_standby_failover_slots_sync.pl889# Set two_phase to true and enable the subscriptionCOMMENT
LOWsrc/test/recovery/t/044_invalidate_inactive_slots.pl58# Check if the 'injection_points' extension is available, as it may beCOMMENT
LOWsrc/test/recovery/t/016_min_consistency.pl49# Set shared_buffers to a very low value to enforce discard and flushCOMMENT
LOWsrc/test/recovery/t/035_standby_logical_decoding.pl127# Check if all the slots on standby are dropped. These include the 'activeslot'COMMENT
LOWsrc/test/recovery/t/035_standby_logical_decoding.pl305# Check if the extension injection_points is available, as it may beCOMMENT
LOWsrc/test/recovery/t/035_standby_logical_decoding.pl632# Set hot_standby_feedback to onCOMMENT
LOWsrc/test/recovery/t/050_redo_segment_missing.pl24# Check if the extension injection_points is available, as it may beCOMMENT
LOWsrc/test/recovery/t/046_checkpoint_logical_slot.pl26# Check if the extension injection_points is available, as it may beCOMMENT
LOWsrc/test/recovery/t/048_vacuum_horizon_floor.pl108# Set primary_conninfo to something invalid on the replica and reload theCOMMENT
LOWsrc/test/recovery/t/047_checkpoint_physical_slot.pl27# Check if the extension injection_points is available, as it may beCOMMENT
LOWsrc/test/recovery/t/047_checkpoint_physical_slot.pl124# Check if the required wal segment exists.COMMENT
LOWsrc/test/recovery/t/051_effective_wal_level.pl331# Set wal_level to 'replica' and restart the primary. Since one logical slotCOMMENT
LOWsrc/test/perl/PostgreSQL/Test/Cluster.pm1723 # Add node to list of nodesCOMMENT
LOWsrc/test/perl/PostgreSQL/Test/Utils.pm162 # Check if this environment is MSYS2.COMMENT
LOWsrc/test/subscription/t/023_twophase_stream.pl463# Set max_prepared_transactions to correct value to resume the replicationCOMMENT
LOWsrc/test/subscription/t/021_twophase.pl83# Set max_prepared_transactions to correct value to resume the replicationCOMMENT
LOWsrc/test/subscription/t/021_twophase.pl489# Set two_phase to "true" and failover to "true" before the COMMIT PREPARED.COMMENT
LOWsrc/test/subscription/t/035_conflicts.pl743# Set max_retention_duration to a minimal value to initiate retention stop.COMMENT
LOWsrc/test/subscription/t/035_conflicts.pl770# Set max_retention_duration to 0COMMENT
LOW…t/modules/test_autovacuum/t/001_parallel_autovacuum.pl59# Check if the extension injection_points is available, as it may beCOMMENT
LOW…/test/modules/xid_wraparound/t/001_emergency_vacuum.pl105# Check if these tables are vacuumed.COMMENT
LOW…/test/modules/xid_wraparound/t/001_emergency_vacuum.pl119# Check if vacuum failsafe was triggered for each table.COMMENT
LOWsrc/test/modules/test_misc/t/007_catcache_inval.pl24# Check if the extension injection_points is available, as it may beCOMMENT
LOWsrc/test/modules/test_misc/t/006_signal_autovacuum.pl29# Check if the extension injection_points is available, as it may beCOMMENT
LOW…t/modules/test_misc/t/010_index_concurrently_upsert.pl28# Check if the extension injection_points is availableCOMMENT
LOWsrc/test/modules/test_misc/t/003_check_guc.pl62 # Check if this line matches a GUC parameter:COMMENT
LOWsrc/test/modules/test_misc/t/005_timeouts.pl28# Check if the extension injection_points is available, as it may beCOMMENT
LOWsrc/test/modules/test_misc/t/011_lock_stats.pl81# Check if the extension injection_points is availableCOMMENT
LOWsrc/test/modules/worker_spi/t/002_worker_terminate.pl77# Check if the extension injection_points is available, as it may beCOMMENT
LOWsrc/test/authentication/t/003_peer.pl82# Check if peer authentication is supported on this platform.COMMENT
LOWsrc/test/authentication/t/007_pre_auth.pl28# Check if the extension injection_points is available, as it may beCOMMENT
LOWsrc/bin/pg_rewind/t/RewindTest.pm132 # Set wal_keep_size to prevent WAL segment recycling after enforcedCOMMENT
LOWsrc/bin/pg_basebackup/t/040_pg_createsubscriber.pl384# Check if node S is still a standbyCOMMENT
LOWsrc/bin/pg_amcheck/t/004_verify_heapam.pl679 # Set xmin to xmax of tuple at offset 30.COMMENT
LOWsrc/bin/pg_upgrade/t/005_char_signedness.pl42# Check if the value is successfully updated.COMMENT
LOWsrc/bin/pg_upgrade/t/005_char_signedness.pl88# Check if the default char signedness of the new cluster inheritedCOMMENT
LOWsrc/bin/pg_upgrade/t/002_pg_upgrade.pl649# Check if there are any logs coming from pg_upgrade, that would only beCOMMENT
LOWsrc/interfaces/libpq/t/005_negotiate_encryption.pl152# Check if the extension injection_points is available, as it may beCOMMENT
Slop Phrases20 hits · 32 pts
SeverityFileLineSnippetContext
LOWcontrib/postgres_fdw/deparse.c1065 * expanded later, but don't forget to add deparse support below.COMMENT
LOWsrc/tools/version_stamp.pl103print "Don't forget to run autoconf $aconfver before committing.\n";CODE
MEDIUMsrc/test/regress/regress.c902 * enough for demonstration purposes.COMMENT
LOWsrc/test/recovery/t/006_logical_decoding.pl163# make sure you can't drop a slot while activeCOMMENT
LOWsrc/bin/pg_dump/pg_backup_archiver.c2142 * a sign byte. If you change this, don't forget to change the fileCOMMENT
LOWsrc/include/mb/pg_wchar.h61 * WARNING: If you add some encoding don't forget to updateCOMMENT
MEDIUMsrc/include/lib/ilist.h46 * Here's a simple example demonstrating how this can be used. Let's assumeCOMMENT
LOWsrc/backend/access/transam/xlog.c6036 * If you change them, don't forget to update the list.COMMENT
LOWsrc/backend/access/brin/brin_minmax_multi.c634 /* don't forget to include the null terminator ;-) */COMMENT
LOWsrc/backend/access/common/reloptions.c52 * (vi) don't forget to document the optionCOMMENT
LOWsrc/backend/access/heap/heapam.c2213 * If heaptup is a private copy, release it. Don't forget to copy t_selfCOMMENT
LOWsrc/backend/access/heap/heapam.c4350 * If heaptup is a private copy, release it. Don't forget to copy t_selfCOMMENT
LOWsrc/backend/nodes/bitmapset.c1556 * Note: don't forget to specify bitmap_match as the match function!COMMENT
LOWsrc/backend/catalog/system_views.sql10 * executable either --- but by default they will be. So don't forget toCOMMENT
LOWsrc/backend/utils/adt/expandedrecord.c1464 * But don't forget to mark header as dummy.COMMENT
LOWsrc/backend/utils/adt/selfuncs.c1068 /* Don't forget to account for nulls. */COMMENT
LOWsrc/backend/utils/adt/acl.c820 * you make a change here, don't forget to update the GRANT man page,COMMENT
LOWsrc/backend/utils/hash/dynahash.c1572 /* don't forget to terminate the rebuilt hash chains... */COMMENT
LOWsrc/backend/regex/regc_nfa.c2927 /* Don't forget to free sclone's donemap when done with it */COMMENT
LOWsrc/backend/storage/lmgr/lock.c2100 /* don't forget to clear waitMask bit if appropriate */COMMENT
AI Slop Vocabulary16 hits · 32 pts
SeverityFileLineSnippetContext
MEDIUMcontrib/amcheck/t/005_pitr.pl35# VACUUM to delete the aforementioned leaf page. Force an XLogFlush() byCOMMENT
LOWsrc/pl/tcl/sql/pltcl_setup.sql194 # If not a Postgres error, just return the basic error messageCOMMENT
LOWsrc/tools/PerfectHash.pm76 # It's not worth passing this around as a parameter; just use a global.COMMENT
LOWsrc/test/kerberos/t/001_auth.pl16# just add whatever other tests are needed to here.COMMENT
MEDIUMsrc/test/ssl/t/SSL/Server.pm74# mode and this way they will find a port to run on in a more robust way.COMMENT
MEDIUMsrc/test/recovery/t/053_standby_login_event_trigger.pl15# To keep the test robust the event trigger is set up in a dedicatedCOMMENT
LOWsrc/test/recovery/t/015_promotion_pages.pl55# Now just use a dummy table and run some operations to move minRecoveryPointCOMMENT
MEDIUMsrc/test/perl/PostgreSQL/Test/Cluster.pm1915 # so callers can harness this port for the widest range of purposes.COMMENT
LOWsrc/test/perl/PostgreSQL/Test/Cluster.pm2267 # because of a timeout and the caller requested to handle that, just returnCOMMENT
LOWsrc/test/perl/PostgreSQL/Test/Cluster.pm3429 # Before release 12 walreceiver just set the application name toCOMMENT
MEDIUMsrc/test/perl/PostgreSQL/Test/Cluster.pm3521 # harness won't accept a skip; otherwise, it won't acceptCOMMENT
LOWsrc/test/modules/test_pg_dump/t/001_base.pl27# test_key indicates that a given run should simply use the sameCOMMENT
LOWsrc/bin/pg_dump/t/002_pg_dump.pl20# test_key indicates that a given run should simply use the sameCOMMENT
LOWsrc/backend/catalog/Catalog.pm340 # parse. We can't just use a regex because of values inCOMMENT
LOWsrc/backend/catalog/genbki.pl323 # special SQL names for types etc; we just use the names in the sourceCOMMENT
LOWsrc/interfaces/ecpg/preproc/parse.pl507 # Not a nonterminal declaration, so just add it to $line.COMMENT
Fake / Example Data19 hits · 27 pts
SeverityFileLineSnippetContext
LOWsrc/test/regress/sql/tsearch.sql559'Lorem ipsum urna. Nullam nullam ullamcorper urna.',CODE
LOWsrc/test/regress/sql/tsearch.sql564'Lorem ipsum urna. Nullam nullam ullamcorper urna.',CODE
LOWsrc/test/regress/sql/tsearch.sql640'Lorem ipsum urna. Nullam nullam ullamcorper urna.',CODE
LOWsrc/test/modules/oauth_validator/t/001_server.pl601 "ALTER SYSTEM SET oauth_validator.authn_id TO 'test\@example.org'");CODE
LOWsrc/test/modules/oauth_validator/t/001_server.pl679# Allow "user@example.com" to log in under the test role.COMMENT
LOWsrc/test/modules/test_shmem/test_shmem.c34 char dummy_data[FLEXIBLE_ARRAY_MEMBER];CODE
LOWsrc/bin/psql/t/001_basic.pl363 "\\copy copy_default from $copy_default_sql_file with (format 'csv', default 'placeholder');CODE
LOW⚡src/include/utils/elog.h282 * "ereturn(context, dummy_value, ...);" is exactly the same asCOMMENT
LOW⚡src/include/utils/elog.h283 * "errsave(context, ...); return dummy_value;". This saves a bitCOMMENT
LOW⚡src/include/utils/elog.h285 * actions to take after reporting a soft error. "dummy_value"COMMENT
LOW⚡src/include/utils/elog.h288#define ereturn_domain(context, dummy_value, domain, ...) \COMMENT
LOW⚡src/include/utils/elog.h291 return dummy_value; \CODE
LOW⚡src/include/utils/elog.h294#define ereturn(context, dummy_value, ...) \COMMENT
LOW⚡src/include/utils/elog.h295 ereturn_domain(context, dummy_value, TEXTDOMAIN, __VA_ARGS__)CODE
LOWsrc/backend/optimizer/plan/planmain.c264 * Examine any "placeholder" expressions generated during subquery pullup.COMMENT
LOW…erfaces/ecpg/test/expected/preproc-pointer_to_struct.c163 strcpy(custs1[0].name.arr, "John Doe");CODE
LOW…erfaces/ecpg/test/expected/preproc-pointer_to_struct.c167 strcpy(acme.customers[1].name.arr, "Jane Doe");CODE
LOW…nterfaces/ecpg/test/expected/preproc-array_of_struct.c158 strcpy(custs1[0].name.arr, "John Doe");CODE
LOW…nterfaces/ecpg/test/expected/preproc-array_of_struct.c162 strcpy(acme.customers[1].name.arr, "Jane Doe");CODE
Verbosity Indicators11 hits · 16 pts
SeverityFileLineSnippetContext
LOWcontrib/amcheck/verify_heapam.c1783 * We go further, because we need to check if the toast datum is corrupt.COMMENT
LOWsrc/bin/pg_amcheck/t/004_verify_heapam.pl145# The purpose of this function is to write a tuple back to disk with someCOMMENT
LOWsrc/bin/pg_dump/t/006_pg_dump_compress.pl599 # if just one match, we need to check if it's realCOMMENT
LOWsrc/bin/pg_dump/t/002_pg_dump.pl5336 # if just one match, we need to check if it's realCOMMENT
LOWsrc/backend/optimizer/util/clauses.c4950 * Note that we need to check if the relation actually has anyCOMMENT
LOWsrc/backend/utils/mb/mbutils.c73 * This variable stores the conversion function to convert from UTF-8COMMENT
LOWsrc/backend/storage/ipc/shm_mq.c872 * The purpose of this function is to make sure that the processCOMMENT
LOWsrc/backend/executor/execMain.c156 * If the transaction is read-only, we need to check if any writes areCOMMENT
LOWsrc/backend/replication/slot.c2284 * We need to check if the slot is invalidated here sinceCOMMENT
LOWsrc/backend/replication/pgoutput/pgoutput.c2311 * across all publications. So we need to check if the alreadyCOMMENT
LOWsrc/backend/partitioning/partdesc.c447 * The purpose of this function is to ensure that we get the sameCOMMENT
Synthetic Comment Markers1 hit · 8 pts
SeverityFileLineSnippetContext
HIGHsrc/tools/ci/ci_macports_packages.sh75# If setting all the required packages as requested fails, we needCOMMENT
Excessive Try-Catch Wrapping7 hits · 7 pts
SeverityFileLineSnippetContext
LOWsrc/pl/plpython/sql/plpython_import.sql27except Exception as ex:CODE
LOWsrc/pl/plpython/sql/plpython_ereport.sql124except Exception as e:CODE
LOWsrc/pl/plpython/sql/plpython_ereport.sql132except Exception as e:CODE
LOWsrc/pl/plpython/sql/plpython_spi.sql34except Exception as ex:CODE
LOWsrc/pl/plpython/sql/plpython_spi.sql48except Exception as ex:CODE
LOWsrc/pl/plpython/sql/plpython_spi.sql63except Exception as ex:CODE
LOWsrc/pl/plpython/sql/plpython_transaction.sql170except Exception as e:CODE
Deep Nesting3 hits · 3 pts
SeverityFileLineSnippetContext
LOWcontrib/unaccent/generate_unaccent_rules.py160CODE
LOWcontrib/unaccent/generate_unaccent_rules.py228CODE
LOWsrc/tools/generate_editorconfig.py22CODE
Modern AI Meta-Vocabulary1 hit · 3 pts
SeverityFileLineSnippetContext
MEDIUMsrc/tools/pg_bsd_indent/t/001_pg_bsd_indent.pl3# The test cases come from FreeBSD upstream, but this test scaffolding is ours.COMMENT
Hyper-Verbose Identifiers2 hits · 2 pts
SeverityFileLineSnippetContext
LOWcontrib/unaccent/generate_unaccent_rules.py160def parse_cldr_latin_ascii_transliterator(latinAsciiFilePath):CODE
LOWcontrib/pgcrypto/scripts/pgp_session_data.py287def build_literal_data_packet(data: bytes) -> bytes:CODE
Example Usage Blocks1 hit · 2 pts
SeverityFileLineSnippetContext
LOWsrc/backend/port/aix/mkldexport.sh8# Usage:COMMENT
Unused Imports1 hit · 1 pts
SeverityFileLineSnippetContext
LOWcontrib/pgcrypto/scripts/pgp_session_data.py25CODE