AI Slop Code Risk Monitor

paradedb/paradedb

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

One Postgres for your application data, full-text search, vector retrieval, and aggregations. Home of the pg_search extension.

3.4 Low pattern signal View on GitHub

Open-Source Code Quality, Security and Technical Debt Review

This report summarizes scanner evidence for paradedb/paradedb, a Rust project with 9,467 GitHub stars. SynthScan examined 350,662 lines of code across 1397 source files, recording 1051 pattern matches distributed across 16 syntactic categories. The legacy adjusted pattern signal is 3.4 (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.

3.4
Adjusted Signal
3.4
Raw Pattern Score
100%
Time Factor
2026-10-31
Last Push
9.5K
Stars
Rust
Language
350.7K
Lines of Code
1.4K
Files
1.1K
Pattern Hits
2026-10-31
Scan Date
0.01
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 13.1/100 · LOW

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

Hallucinated Dependency & Supply Chain Risk 1.3/100 · LOW

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

Agent Over-Engineering Ratio 2.1/100 · LOW

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

PR Review Velocity Impact 15.4/100 · LOW

Which changes need focused human review? 1051 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 3HIGH 8MEDIUM 26LOW 1014

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 1051 distinct pattern matches across 16 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 Block855 hits · 855 pts
SeverityFileLineSnippetContext
LOWtokenizers/src/edge_ngram.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtokenizers/src/cjk.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtokenizers/src/code.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtokenizers/src/icu.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtokenizers/src/lib.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtokenizers/src/token_length.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtokenizers/src/ngram.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtokenizers/src/lindera.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtokenizers/src/manager.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtokenizers/src/manager.rs341// The "type" field will not be present on the deserialized value.COMMENT
LOWtokenizers/src/manager.rs1601 /// uses the new tokenizer which strips whitespace.COMMENT
LOWtokenizers/src/token_trim.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtokenizers/src/chinese_convert.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtokenizers/src/unicode_words.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWdocker/generate-dockerfiles.sh1#!/usr/bin/env bashCOMMENT
LOWdocker/manifests/antithesis-paradedb.yaml1# This manifest is intended exclusively for use on the Antithesis platform.COMMENT
LOWschemabot/tests/cli.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWschemabot/src/schema.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWschemabot/src/sql.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWschemabot/src/migration.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWschemabot/src/main.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/antithesis/anytime_recovery_liveness.sh1#!/bin/bashCOMMENT
LOWtests/antithesis/singleton_driver_property-tests.sh1#!/bin/bashCOMMENT
LOWtests/tests/mpp_error_masking.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/copy.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/bm25_search.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/mlt.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/serializable.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/sorting.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/basescan_cancel.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/cleanup.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/domain_type.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/mpp_joinscan_concurrent.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/vacuum.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/key.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/joins.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/hybrid.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/term.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/ltree.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/mutation.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/heap_filter_system_columns.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/index_config.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/pg_dump.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/typmod_terminate.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/fast_fields.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/range.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/index_permissions.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/citus_compatibility.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/citus_compatibility.rs21use sqlx::PgConnection;COMMENT
LOWtests/tests/index_access_locks.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/index_sorting.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/index_sorting.rs561// These tests verify that the sorted index path works correctly with parallelCOMMENT
LOWtests/tests/index_sorting.rs881 }COMMENT
LOWtests/tests/icu.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/heap.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/columnar.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/schema_grants.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/ivm.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/iam.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
LOWtests/tests/query.rs1// Copyright (c) 2023-2026 ParadeDB, Inc.COMMENT
795 more matches not shown…
Decorative Section Separators17 hits · 64 pts
SeverityFileLineSnippetContext
MEDIUM⚡.github/scripts/release.py1040# ==============================================================================COMMENT
MEDIUM⚡.github/scripts/release.py1042# ==============================================================================COMMENT
MEDIUM.github/scripts/release.py54# ==============================================================================COMMENT
MEDIUM.github/scripts/release.py56# ==============================================================================COMMENT
MEDIUM.github/scripts/release.py309# ==============================================================================COMMENT
MEDIUM.github/scripts/release.py311# ==============================================================================COMMENT
MEDIUM.github/scripts/release.py798# ==============================================================================COMMENT
MEDIUM.github/scripts/release.py800# ==============================================================================COMMENT
MEDIUM.github/scripts/release.py928# ==============================================================================COMMENT
MEDIUM.github/scripts/release.py930# ==============================================================================COMMENT
MEDIUM⚡pg_search/src/postgres/customscan/joinscan/mod.rs104//! ┌─────────────────┐ ┌──────────────────┐ ┌─────────────────────┐COMMENT
MEDIUM⚡pg_search/src/postgres/customscan/joinscan/mod.rs109//! └─────────────────┘ └──────────────────┘ └─────────────────────┘COMMENT
MEDIUM⚡pg_search/src/postgres/customscan/joinscan/mod.rs112//! ┌─────────────────────┐COMMENT
MEDIUM⚡pg_search/src/postgres/customscan/joinscan/mod.rs115//! └─────────────────────┘COMMENT
MEDIUM⚡pg_search/src/query/builder.rs52//! output ──────────────────> (query, None)COMMENT
MEDIUM⚡pg_search/src/query/builder.rs56//! output ──┬── clone ──────> (cloned_query, Some(output))COMMENT
MEDIUM⚡pg_search/src/query/builder.rs57//! └── keep ───────> Must keep output for children closure.COMMENT
Fake / Example Data57 hits · 58 pts
SeverityFileLineSnippetContext
LOWtests/tests/partitioned_build_concurrent_writes.rs55 SELECT (i * 7919) % 500, 'lorem ipsum ' || i || ' ' || repeat('padding here ', 8)CODE
LOWtests/tests/concurrent_build_writes.rs52 SELECT 'lorem ipsum ' || i || ' ' || repeat('padding here ', 8)CODE
LOWtests/tests/documentation.rs127 "John Doe".into()CODE
LOWtests/tests/documentation.rs2058 assert_eq!(rows[0], (1, 1, 3, 99.99, "John Doe".into()));CODE
LOWtests/tests/search_config.rs65 "('John Doe', 'New Book Release', 'Exciting new book released by renowned author.'),CODE
LOW…ests/pg_regress/common/snippet_json_advanced_setup.sql36(3, '{"content": "test Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut laboCODE
LOW…ests/pg_regress/common/snippet_json_advanced_setup.sql36(3, '{"content": "test Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut laboCODE
LOW…sts/pg_regress/common/snippet_position_basic_setup.sql15('test Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut labore et dolore magCODE
LOW…sts/pg_regress/common/snippet_position_basic_setup.sql15('test Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut labore et dolore magCODE
LOW…/pg_regress/common/snippet_position_advanced_setup.sql42(4, 3, 'test Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut labore et doloCODE
LOW…/pg_regress/common/snippet_position_advanced_setup.sql42(4, 3, 'test Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut labore et doloCODE
LOW…h/tests/pg_regress/common/snippet_json_basic_setup.sql24('test Lorem ipsum dolor sit amet...test',CODE
LOW…h/tests/pg_regress/common/snippet_json_basic_setup.sql24('test Lorem ipsum dolor sit amet...test',CODE
LOW…tests/pg_regress/common/parallel_build_small_setup.sql11SELECT 'lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore maCODE
LOW…tests/pg_regress/common/parallel_build_small_setup.sql11SELECT 'lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore maCODE
LOW…_search/tests/pg_regress/sql/score_join_predicates.sql41(4, 3, 'test Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut labore et doloCODE
LOW…_search/tests/pg_regress/sql/score_join_predicates.sql41(4, 3, 'test Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut labore et doloCODE
LOWpg_search/tests/pg_regress/sql/aggregate_join_alias.sql30 (1, 'Acme Corp', 'acme.com'),CODE
LOWpg_search/tests/pg_regress/sql/deprecated_score.sql41(4, 3, 'test Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut labore et doloCODE
LOWpg_search/tests/pg_regress/sql/deprecated_score.sql41(4, 3, 'test Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut labore et doloCODE
LOWpg_search/tests/pg_regress/sql/lateral-join.sql56 ('John Doe', 'Tech writer specializing in databases', 'database'),CODE
LOWpg_search/tests/pg_regress/sql/composite_advanced.sql28 'field1_' || i || ' lorem ipsum dolor sit amet consectetur adipiscing elit sed do eiusmod tempor incididunt ut laborCODE
LOWpg_search/tests/pg_regress/sql/composite_advanced.sql28 'field1_' || i || ' lorem ipsum dolor sit amet consectetur adipiscing elit sed do eiusmod tempor incididunt ut laborCODE
LOW…earch/tests/pg_regress/sql/aggregate_join_coverage.sql30 ('Laptop order bulk', 'Acme Corp', 10, 9999),CODE
LOW…earch/tests/pg_regress/sql/aggregate_join_coverage.sql31 ('Laptop order single', 'Acme Corp', 1, 999),CODE
LOWpg_search/tests/pg_regress/sql/deprecated_snippet.sql13('test Lorem ipsum dolor sit amet...test');CODE
LOWpg_search/tests/pg_regress/sql/deprecated_snippet.sql13('test Lorem ipsum dolor sit amet...test');CODE
LOWpg_search/tests/pg_regress/sql/snippet_limit_offset.sql13('test Lorem ipsum dolor sit amet...test');CODE
LOWpg_search/tests/pg_regress/sql/snippet_limit_offset.sql13('test Lorem ipsum dolor sit amet...test');CODE
LOWpg_search/tests/pg_regress/sql/join_key_types.sql424(12345678901234567890, 'John Doe', 'Checking'),CODE
LOWpg_search/tests/pg_regress/sql/issue_4643.sql21SELECT i, CASE WHEN i % 2 = 0 THEN 'John Smith' ELSE 'Jane Doe' END, i % 2CODE
LOWpg_search/tests/pg_regress/sql/issue_3474.sql13('test Lorem ipsum dolor sit amet...test');CODE
LOWpg_search/tests/pg_regress/sql/issue_3474.sql13('test Lorem ipsum dolor sit amet...test');CODE
LOWpg_search/tests/pg_regress/sql/join_outer_pathkey.sql27INSERT INTO companies_op VALUES (1, 'Acme Corp'), (2, 'Globex Inc'), (3, 'Initech');CODE
LOWpg_search/tests/pg_regress/sql/issue_4532.sql36 (1, 1, 'Acme Corp'),CODE
LOWpg_search/src/bootstrap/test_table.rs779 (1, 3, 99.99, "John Doe"),CODE
LOWpg_search/src/bootstrap/test_table.rs782 (2, 6, 501.87, "John Doe"),CODE
LOWpg_search/src/scan/segmented_topk_exec.rs1502 SELECT 'lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor ' ||CODE
LOWpg_search/src/scan/segmented_topk_exec.rs1502 SELECT 'lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor ' ||CODE
LOWpg_search/src/postgres/build.rs587 SELECT 'Lorem Ipsum ' || i FROM generate_series(1, 500) i;CODE
LOWpg_search/src/postgres/build_parallel.rs1695 SELECT 'lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore CODE
LOWpg_search/src/postgres/build_parallel.rs1695 SELECT 'lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore CODE
LOWpg_search/src/postgres/build_parallel.rs2165 SELECT (i * 7919) % 100, 'lorem ipsum ' || i || ' ' || repeat('padding word here ', 50)CODE
LOWpg_search/src/postgres/build_parallel.rs2340 SELECT (i * 7919) % 7, 'lorem ipsum ' || i || ' ' || repeat('padding word here ', 50)CODE
LOWpg_search/src/postgres/build_parallel.rs2398 SELECT (i * 7919) % 100, 'lorem ipsum ' || i || ' ' || repeat('padding word here ', 50)CODE
LOWpg_search/src/postgres/build_partitioning.rs607 SELECT i % 50, repeat('lorem ipsum dolor sit amet ', 20) FROM generate_series(1, 40000) i;CODE
LOWpg_search/src/postgres/build_partitioning.rs607 SELECT i % 50, repeat('lorem ipsum dolor sit amet ', 20) FROM generate_series(1, 40000) i;CODE
LOW…_search/src/postgres/customscan/joinscan/scan_state.rs1011 // Skip any "placeholder" expressions that don't need to be considered nowCOMMENT
LOW…src/postgres/customscan/datafusion/expr_translators.rs677 Some(col("placeholder"))CODE
LOW…earch/src/postgres/customscan/datafusion/translator.rs255 return Some(col("placeholder"));CODE
LOW…earch/src/postgres/customscan/datafusion/translator.rs264 return Some(col("placeholder"));CODE
LOWpg_search/src/index/writer/index.rs851 document.add_text(text_field, "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempoCODE
LOWpg_search/src/index/writer/index.rs851 document.add_text(text_field, "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempoCODE
LOWpg_search/src/index/stats/tests.rs189 'lorem ipsum ' || i || ' ' || repeat('padding word here ', 50)CODE
LOWpg_search/src/index/stats/tests.rs360 SELECT (i * 7919) % 100, 'lorem ipsum ' || i || ' ' || repeat('padding word here ', 50)CODE
LOWpg_search/src/index/stats/tests.rs426 SELECT (i * 7919) % 100, 'lorem ipsum ' || i || ' ' || repeat('padding word here ', 50)CODE
LOWpg_search/src/index/stats/tests.rs444 SELECT 42, 'lorem ipsum ' || i || ' ' || repeat('padding word here ', 50)CODE
Hyper-Verbose Identifiers54 hits · 46 pts
SeverityFileLineSnippetContext
LOWdocs/override.js218 function rememberFrameworkTabFromKeyboard(event) {CODE
LOWbenchmarks/cohere/test_prepare_k6.py58 def test_exports_exact_selected_settings_and_buffers_without_changing_inputs(self):CODE
LOWbenchmarks/cohere/test_prepare_k6.py77 def test_refuses_below_target_point_even_when_pdbench_labels_it_selected(self):CODE
LOWbenchmarks/cohere/test_prepare_k6.py87 def test_refuses_mixed_sessions_and_incomplete_query_sets(self):CODE
LOWbenchmarks/cohere/test_prepare_k6.py98 def test_refuses_partial_query_set_or_loose_recall_tolerance(self):CODE
LOWbenchmarks/cohere/test_prepare_k6.py112 def test_plan_guard_requires_index_scan_and_filter_pushdown(self):CODE
LOWbenchmarks/cohere/test_compare_search.py49 def test_pairs_by_query_and_labels_commits_without_modifying_sources(self, run):CODE
LOWbenchmarks/cohere/test_compare_search.py71 def test_missing_and_incompatible_baselines_skip_only_affected_queries(self, run):CODE
LOWbenchmarks/cohere/test_compare_search.py85 def test_missing_current_sweep_or_duplicate_query_is_an_error(self):CODE
LOWbenchmarks/cohere/test_compare_search.py96 def test_pdbench_failure_is_reported(self, run):CODE
LOW.github/scripts/extract_code_snippets.py216def write_standalone_snippets(outputs, outside, coverage):CODE
LOW.github/scripts/test_release.py17 def test_newer_tag_does_not_change_checkout_upgrade_chain(self):CODE
LOW.github/scripts/test_release.py42 def test_unreleased_sql_target_is_not_an_upgrade_starting_release(self):CODE
LOW.github/scripts/test_release.py53 def test_synthetic_upgrade_extends_untagged_migration_tip(self):CODE
LOW.github/scripts/test_release.py89 def test_release_uses_newest_tag_before_migration_sync(self):CODE
LOW.github/scripts/test_release.py101 def test_explicit_predecessor_still_takes_priority(self):CODE
LOW.github/scripts/test_release.py108 def test_tags_remain_a_fallback_without_sql_targets(self):CODE
LOW.github/scripts/test_release.py124 def test_latest_promotion_archives_older_pages_in_both_layouts(self):CODE
LOW.github/scripts/test_release.py151 def test_maintenance_registration_preserves_latest(self):CODE
LOW.github/scripts/test_release.py165 def test_assembly_promotes_latest_and_archives_previous(self):CODE
LOW.github/scripts/test_release.py186 def test_missing_latest_page_does_not_archive_existing_latest(self):CODE
LOW⚡.github/scripts/release.py1045def extract_statements_and_objects(content):CODE
LOW.github/scripts/release.py88def latest_released_sql_version(sql_dir):CODE
LOW.github/scripts/release.py94def handle_latest_sql_version_command(args, repo_root):CODE
LOW.github/scripts/release.py161def _build_fragment_dependency_graph(fragments):CODE
LOW.github/scripts/release.py190def topological_sort_fragments(fragments):CODE
LOW.github/scripts/release.py371def collect_changelog_fragments(unreleased_dir, headers_map):CODE
LOW.github/scripts/release.py399def _normalize_changelog_item(item):CODE
LOW.github/scripts/release.py513def _insert_into_version_group(changelog_pages, target_group, target_page):CODE
LOW.github/scripts/release.py526def _insert_into_older_groups(older_pages, target_group, target_page):CODE
LOW.github/scripts/release.py539def _promote_new_active_group(changelog_pages, older_pages, target_group, target_page):CODE
LOW.github/scripts/release.py591def _insert_into_legacy_anchors(versions, target_page):CODE
LOW.github/scripts/release.py610def insert_changelog_into_pages(docs_data, target_page):CODE
LOW.github/scripts/release.py618def update_navigation_version(docs_data, new_version):CODE
LOW.github/scripts/release.py665def update_docs_version_examples(repo_root, clean_ver):CODE
LOW.github/scripts/release.py691def update_installation_version(repo_root, clean_ver):CODE
LOW.github/scripts/release.py710def update_kubernetes_version(repo_root, clean_ver):CODE
LOW.github/scripts/release.py727def update_digitalocean_version(repo_root, clean_ver):CODE
LOW.github/scripts/release.py743def update_changelog_indexing(repo_root, version, is_latest):CODE
LOW.github/scripts/release.py844def get_rendered_changelog_body(repo_root, clean_ver):CODE
LOW.github/scripts/release.py1007def handle_set_version_command(args, repo_root):CODE
LOW.github/scripts/release.py1020def handle_approval_body_command(args, repo_root):CODE
LOW.github/scripts/release.py1089def catalog_unreleased_objects(unreleased_dir, before_pr=None):CODE
LOW.github/scripts/release.py1119def get_changed_fragment_files(repo_root, base_sha):CODE
LOW.github/scripts/release.py1172def _check_single_main_fragment(fpath, unreleased_dir):CODE
LOW.github/scripts/release.py1238def lint_main_branch_fragments(repo_root, base_sha):CODE
LOW.github/scripts/release.py1258def _check_branch_fragment_dependencies(repo_root, unreleased_sql_dir, base_ref):CODE
LOW.github/scripts/release.py1290def _check_branch_fragment_identity(repo_root, all_fragments):CODE
LOW.github/scripts/release.py1354def lint_release_branch_fragments(repo_root, base_ref):CODE
LOW.github/scripts/release.py1454def handle_lint_fragments_command(args, repo_root):CODE
LOW⚡.github/scripts/test_generate_release_notes.py25 def test_backport_credits_source_and_preserves_links(self):CODE
LOW⚡.github/scripts/test_generate_release_notes.py30 def test_manual_pr_keeps_author(self):CODE
LOW⚡.github/scripts/test_generate_release_notes.py33 def test_unlabelled_reference_is_not_followed(self):CODE
LOW⚡.github/scripts/test_generate_release_notes.py41 def test_missing_reference_fails(self):CODE
Structural Annotation Overuse19 hits · 30 pts
SeverityFileLineSnippetContext
LOWtests/tests/replication.rs511 // Step 1: Create and start the primary Postgres instanceCOMMENT
LOWtests/tests/replication.rs527 // Step 2: Create the standby using pg_basebackupCOMMENT
LOWbenchmarks/DATASET_PREPARATION.md15## Step 1: Load Source Data into S3COMMENT
LOWbenchmarks/DATASET_PREPARATION.md40## Step 2: Create a ConfigCOMMENT
LOWbenchmarks/DATASET_PREPARATION.md75## Step 3: Sample the Source DataCOMMENT
LOWbenchmarks/DATASET_PREPARATION.md110## Step 4: Convert Sampled Data to CSVCOMMENT
LOWbenchmarks/DATASET_PREPARATION.md150## Step 5: Load the HeapCOMMENT
LOWbenchmarks/DATASET_PREPARATION.md165## Step 6: Snapshot or Restore the HeapCOMMENT
LOWbenchmarks/DATASET_PREPARATION.md208## Step 7: Run BenchmarksCOMMENT
LOWpg_search/tests/pg_regress/README.md16### Step 1: Create the SQL TestCOMMENT
LOWpg_search/tests/pg_regress/README.md38### Step 2: Generate the Expected OutputCOMMENT
LOWpg_search/tests/pg_regress/README.md49### Step 3: Verify the Expected OutputCOMMENT
LOW⚡pg_search/src/postgres/composite.rs214 // Step 1: Get fields (this validates type is composite, not RECORD, not domain)COMMENT
LOW⚡pg_search/src/postgres/composite.rs217 // Step 2: Check for nested compositesCOMMENT
LOW…c/postgres/customscan/aggregatescan/datafusion_exec.rs134 // Step 1: Build the join DataFrame from the RelNode treeCOMMENT
LOW…c/postgres/customscan/aggregatescan/datafusion_exec.rs159 // Step 2: Build GROUP BY expressionsCOMMENT
LOW…c/postgres/customscan/aggregatescan/datafusion_exec.rs214 // Step 3: Build aggregate expressions. `pdb.agg()` entries contribute noCOMMENT
LOW…c/postgres/customscan/aggregatescan/datafusion_exec.rs359 // Step 4: Apply aggregate, then HAVING (post-aggregate)COMMENT
LOW…c/postgres/customscan/aggregatescan/datafusion_exec.rs407 // Step 5: Apply TopK and/or Stage 2 window aggregates (`OVER ()`).COMMENT
Hallucination Indicators3 hits · 30 pts
SeverityFileLineSnippetContext
CRITICAL…ostgres/customscan/joinscan/range_partitioning_rule.rs466 let l_rows = edge.left.prov.scan_info.estimate.as_planner_estimate();CODE
CRITICAL…ostgres/customscan/joinscan/range_partitioning_rule.rs467 let r_rows = edge.right.prov.scan_info.estimate.as_planner_estimate();CODE
CRITICALpg_search/src/postgres/customscan/joinscan/mod.rs1707 let snapshot = state.csstate.ss.ps.state.as_ref().unwrap().es_snapshot;CODE
Cross-File Repetition6 hits · 30 pts
SeverityFileLineSnippetContext
HIGHstressgres/suites/bulk-update-merge-pressure.toml0select pg_relation_size('idxtest') / current_setting('block_size')::int as block_count, ( select count(*)::bigint from pSTRING
HIGHstressgres/suites/single-node-planner-paths.toml0select pg_relation_size('idxtest') / current_setting('block_size')::int as block_count, ( select count(*)::bigint from pSTRING
HIGHstressgres/suites/background-merge.toml0select pg_relation_size('idxtest') / current_setting('block_size')::int as block_count, ( select count(*)::bigint from pSTRING
HIGHstressgres/suites/single-node-planner-paths.toml0set max_parallel_workers = 0; set paradedb.enable_custom_scan = off; set paradedb.enable_aggregate_custom_scan = off; seSTRING
HIGH…essgres/suites/logical-replication-fsm-merge-race.toml0set max_parallel_workers = 0; set paradedb.enable_custom_scan = off; set paradedb.enable_aggregate_custom_scan = off; seSTRING
HIGH…essgres/suites/logical-replication-mixed-workload.toml0set max_parallel_workers = 0; set paradedb.enable_custom_scan = off; set paradedb.enable_aggregate_custom_scan = off; seSTRING
AI Slop Vocabulary6 hits · 18 pts
SeverityFileLineSnippetContext
MEDIUMtests/tests/mpp_cancel.rs112// inside the join before signalling. A few attempts make the test robust against host timing; onCOMMENT
MEDIUM.github/scripts/smoke_test_code_snippets.sh107# Make the external-index fixtures available to every ORM harness.COMMENT
MEDIUMpg_search/src/scan/pre_filter.rs74//! `PreFilter`s do not execute custom matching logic. Instead, they leverage native DataFusionCOMMENT
MEDIUMpg_search/src/scan/late_materialization.rs101/// plan tree to find its exact root column at the `TableScan` level, allowing robust exact matching.COMMENT
MEDIUMpg_search/src/postgres/customscan/opexpr.rs391/// exists in the pg_type catalog. This is more robust than maintaining aCOMMENT
MEDIUMpg_search/src/postgres/storage/fsm.rs555/// swapped until the entry is finished moving. Essentially, tags have an affinity for their key/valueCOMMENT
Verbosity Indicators9 hits · 15 pts
SeverityFileLineSnippetContext
LOWtests/tests/replication.rs511 // Step 1: Create and start the primary Postgres instanceCOMMENT
LOWtests/tests/replication.rs527 // Step 2: Create the standby using pg_basebackupCOMMENT
LOW⚡pg_search/src/postgres/composite.rs214 // Step 1: Get fields (this validates type is composite, not RECORD, not domain)COMMENT
LOW⚡pg_search/src/postgres/composite.rs217 // Step 2: Check for nested compositesCOMMENT
LOW…c/postgres/customscan/aggregatescan/datafusion_exec.rs134 // Step 1: Build the join DataFrame from the RelNode treeCOMMENT
LOW…c/postgres/customscan/aggregatescan/datafusion_exec.rs159 // Step 2: Build GROUP BY expressionsCOMMENT
LOW…c/postgres/customscan/aggregatescan/datafusion_exec.rs214 // Step 3: Build aggregate expressions. `pdb.agg()` entries contribute noCOMMENT
LOW…c/postgres/customscan/aggregatescan/datafusion_exec.rs359 // Step 4: Apply aggregate, then HAVING (post-aggregate)COMMENT
LOW…c/postgres/customscan/aggregatescan/datafusion_exec.rs407 // Step 5: Apply TopK and/or Stage 2 window aggregates (`OVER ()`).COMMENT
Self-Referential Comments3 hits · 9 pts
SeverityFileLineSnippetContext
MEDIUMdocker/bootstrap.sh5# This file is NOT executed when running in CloudNativePG as it circumvents the normalCOMMENT
MEDIUMscripts/pg_search_common.sh78# Create a new database for testingCOMMENT
MEDIUM.github/scripts/squash-gh-pages.sh101# Create an orphan root commit (zero parent commits) pointing directly to the treeCOMMENT
Deep Nesting14 hits · 9 pts
SeverityFileLineSnippetContext
LOWbenchmarks/cohere/prepare_k6.py13CODE
LOW.github/scripts/test_release.py53CODE
LOW.github/scripts/release.py22CODE
LOW.github/scripts/release.py107CODE
LOW.github/scripts/release.py161CODE
LOW.github/scripts/release.py405CODE
LOW.github/scripts/release.py501CODE
LOW.github/scripts/release.py591CODE
LOW.github/scripts/release.py1045CODE
LOW.github/scripts/release.py1089CODE
LOW.github/scripts/release.py1119CODE
LOW.github/scripts/release.py1258CODE
LOW.github/scripts/compact-benchmark-history.py13CODE
LOW.github/scripts/compact-benchmark-history.py52CODE
Cross-Language Confusion1 hit · 5 pts
SeverityFileLineSnippetContext
HIGH.github/scripts/extract_code_snippets.py105 f'docsIndexes.push({{ table: "{table}", 'CODE
Empty Error Handlers1 hit · 5 pts
SeverityFileLineSnippetContext
HIGH.github/scripts/release.py1166except subprocess.SubprocessError:CODE
Example Usage Blocks3 hits · 4 pts
SeverityFileLineSnippetContext
LOWscripts/pg_search_run.sh9# Usage:COMMENT
LOWscripts/pg_search_test.sh9# Usage:COMMENT
LOW.github/scripts/squash-gh-pages.sh9# Usage:COMMENT
Unused Imports2 hits · 2 pts
SeverityFileLineSnippetContext
LOW.github/scripts/django_snippet_harness.py5CODE
LOW.github/scripts/sqlalchemy_snippet_harness.py5CODE
Modern Structural Boilerplate1 hit · 1 pts
SeverityFileLineSnippetContext
LOW.github/scripts/sqlalchemy_snippet_harness.py107__all__ = [CODE