Skip to content

Export from production triggered queries that resulted in failing health checks #3173

@jwalgran

Description

@jwalgran

At the time of a production export 529 queries of this shape were submitted in rapid succession.

SELECT
    "treemap_mapfeature"."id",
    "treemap_mapfeature"."udfs",
    "treemap_mapfeature"."instance_id",
    "treemap_mapfeature"."the_geom_webmercator",
    "treemap_mapfeature"."address_street",
    "treemap_mapfeature"."address_city",
    "treemap_mapfeature"."address_zip",
    "treemap_mapfeature"."readonly",
    "treemap_mapfeature"."updated_at",
    "treemap_mapfeature"."updated_by_id",
    "treemap_mapfeature"."feature_type",
    "treemap_mapfeature"."hide_at_zoom",
    "treemap_plot"."mapfeature_ptr_id",
    "treemap_plot"."width",
    "treemap_plot"."length",
    "treemap_plot"."owner_orig_id",
    (st_distance ("treemap_mapfeature"."the_geom_webmercator",
            st_transform (st_geomfromewkb (''::bytea),
                0))) AS "distance"
FROM
    "treemap_plot"
    INNER JOIN "treemap_mapfeature" ON ("treemap_plot"."mapfeature_ptr_id" = "treemap_mapfeature"."id")
    WHERE ("treemap_mapfeature"."instance_id" = 0
        AND st_distance ("treemap_mapfeature"."the_geom_webmercator", st_transform (st_geomfromewkb (''::bytea), 0))
        <= 0.0)
    ORDER BY
        "distance" ASC
    LIMIT 0;

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions