By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE t (geom geometry(point,2154));
CREATE TABLE
INSERT INTO t VALUES
('SRID=2154;POINT(197732.05324556993 7479316.68845789)'),
('SRID=2154;POINT(198868.11487880937 7479432.133272126)');
INSERT 0 2
SELECT
ST_AsGeoJSON(
ST_Union(
ST_Buffer(ST_Transform(geom,4326)::geography,500)::geometry))
FROM t;
| st_asgeojson |
|---|
| {"type":"MultiPolygon","coordinates":[[[[-4.63045667,54.169325563],[-4.630859179,54.168476993],[-4.631536075,54.1676908],[-4.632461332,54.166997192],[-4.633599391,54.16642282],[-4.634906518,54.165989751],[-4.63633249,54.165714623],[-4.637822524,54.165608005],[-4.639319374,54.165673994],[-4.640765538,54.165910054],[-4.642105455,54.166307116],[-4.643287644,54.166849925],[-4.644266679,54.167517628],[-4.645004933,54.168284569],[-4.645474028,54.16912128],[-4.64565592,54.169995611],[-4.645543602,54.170873963],[-4.645141372,54.171722579],[-4.644464672,54.172508847],[-4.643539496,54.173202546],[-4.642401393,54.173777011],[-4.641094102,54.174210162],[-4.639667872,54.174485349],[-4.638177525,54.174591991],[-4.636680353,54.174525991],[-4.63523391,54.174289884],[-4.633893798,54.173892747],[-4.632711528,54.173349847],[-4.631732537,54.172682051],[-4.630994446,54.171915027],[-4.630525611,54.171078258],[-4.630344032,54.170203902],[-4.63045667,54.169325563]]],[[[-4.613456602,54.171324498],[-4.613859478,54.170475983],[-4.61453673,54.169689883],[-4.615462319,54.168996404],[-4.61660067,54.168422191],[-4.617908041,54.167989305],[-4.619334199,54.167714377],[-4.620824352,54.167607969],[-4.622321252,54.167674168],[-4.623767393,54.167910432],[-4.625107216,54.168307684],[-4.626289244,54.168850662],[-4.627268055,54.169518504],[-4.628006034,54.170285551],[-4.62847481,54.171122331],[-4.628656354,54.171996689],[-4.628543671,54.172875027],[-4.628141074,54.173723589],[-4.627464017,54.174509764],[-4.62653851,54.175203334],[-4.625400114,54.175777641],[-4.624092579,54.176210609],[-4.622666162,54.176485595],[-4.621175696,54.176592028],[-4.619678475,54.176525816],[-4.618232055,54.176289505],[-4.616892036,54.175892179],[-4.615709928,54.17534911],[-4.61473116,54.174681174],[-4.613993346,54.173914045],[-4.613524828,54.173077208],[-4.613343598,54.172202824],[-4.613456602,54.171324498]]]]} |
SELECT 1