explain (opt, verbose)
SELECT users.id, users.lat, users.lng
FROM users
WHERE st_dwithin(users.coordinates, st_makepoint(-2.25, 53.77)::geography, 20000)
ORDER BY users.id
LIMIT 10 OFFSET 0;
text
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
project
├── columns: id:1 lat:3 lng:4
├── cardinality: [0 - 10]
├── immutable
├── stats: [rows=10]
├── cost: 295653.566
├── key: (1)
├── fd: (1)-->(3,4)
├── ordering: +1
├── prune: (1,3,4)
├── interesting orderings: (+1)
└── limit
├── columns: id:1 lat:3 lng:4 coordinates:5
├── internal-ordering: +1
├── cardinality: [0 - 10]
├── immutable
├── stats: [rows=10]
├── cost: 295653.456
├── key: (1)
├── fd: (1)-->(3-5)
├── ordering: +1
├── interesting orderings: (+1)
├── select
│ ├── columns: id:1 lat:3 lng:4 coordinates:5
│ ├── immutable
│ ├── stats: [rows=136644.667]
│ ├── cost: 295653.346
│ ├── key: (1)
│ ├── fd: (1)-->(3-5)
│ ├── ordering: +1
│ ├── limit hint: 10.00
│ ├── prune: (1,3,4)
│ ├── interesting orderings: (+1)
│ ├── sort
│ │ ├── columns: id:1 lat:3 lng:4 coordinates:5
│ │ ├── stats: [rows=45548.2222]
│ │ ├── cost: 249649.621
│ │ ├── key: (1)
│ │ ├── fd: (1)-->(3-5)
│ │ ├── ordering: +1
│ │ ├── limit hint: 3.33
│ │ └── index-join users
│ │ ├── columns: id:1 lat:3 lng:4 coordinates:5
│ │ ├── stats: [rows=45548.2222]
│ │ ├── cost: 234641.374
│ │ ├── key: (1)
│ │ ├── fd: (1)-->(3-5)
│ │ └── inverted-filter
│ │ ├── columns: id:1
│ │ ├── inverted expression: /8
│ │ │ ├── tight: false
│ │ │ └── union spans
│ │ │ ├── ["B\xfdH@\x00\x00\x00\x00\x00\x00", "B\xfdH@\x00\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdHp\x00\x00\x00\x00\x00\x00", "B\xfdHp\x00\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdH{\x00\x00\x00\x00\x00\x00", "B\xfdH{\x00\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdH{\x00\x00\x00\x00\x00\x01", "B\xfdH{ \x00\x00\x00\x00\x00")
│ │ │ ├── ["B\xfdH{@\x00\x00\x00\x00\x00", "B\xfdH{@\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdH{`\x00\x00\x00\x00\x01", "B\xfdH{\x80\x00\x00\x00\x00\x00")
│ │ │ ├── ["B\xfdH{\x80\x00\x00\x00\x00\x01", "B\xfdH|\x00\x00\x00\x00\x00\x00")
│ │ │ ├── ["B\xfdH|\x00\x00\x00\x00\x00\x00", "B\xfdH|\x00\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdH|\x00\x00\x00\x00\x00\x01", "B\xfdH| \x00\x00\x00\x00\x00")
│ │ │ ├── ["B\xfdH|@\x00\x00\x00\x00\x00", "B\xfdH|@\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdH|`\x00\x00\x00\x00\x01", "B\xfdH|\x80\x00\x00\x00\x00\x00")
│ │ │ ├── ["B\xfdH|\x80\x00\x00\x00\x00\x01", "B\xfdH|\xa0\x00\x00\x00\x00\x00")
│ │ │ ├── ["B\xfdH|\xc0\x00\x00\x00\x00\x00", "B\xfdH|\xc0\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdH}\x00\x00\x00\x00\x00\x00", "B\xfdH}\x00\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdI\x00\x00\x00\x00\x00\x00\x00", "B\xfdI\x00\x00\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdL\x00\x00\x00\x00\x00\x00\x00", "B\xfdL\x00\x00\x00\x00\x00\x00\x00"]
│ │ │ └── ["B\xfdP\x00\x00\x00\x00\x00\x00\x00", "B\xfdP\x00\x00\x00\x00\x00\x00\x00"]
│ │ ├── stats: [rows=45548.2222]
│ │ ├── cost: 47893.6533
│ │ ├── key: (1)
│ │ └── scan users@users_coordinates_idx
│ │ ├── columns: id:1 coordinates_inverted_key:8
│ │ ├── inverted constraint: /8/1
│ │ │ └── spans
│ │ │ ├── ["B\xfdH@\x00\x00\x00\x00\x00\x00", "B\xfdH@\x00\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdHp\x00\x00\x00\x00\x00\x00", "B\xfdHp\x00\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdH{\x00\x00\x00\x00\x00\x00", "B\xfdH{\x00\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdH{\x00\x00\x00\x00\x00\x01", "B\xfdH{ \x00\x00\x00\x00\x00")
│ │ │ ├── ["B\xfdH{@\x00\x00\x00\x00\x00", "B\xfdH{@\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdH{`\x00\x00\x00\x00\x01", "B\xfdH{\x80\x00\x00\x00\x00\x00")
│ │ │ ├── ["B\xfdH{\x80\x00\x00\x00\x00\x01", "B\xfdH|\x00\x00\x00\x00\x00\x00")
│ │ │ ├── ["B\xfdH|\x00\x00\x00\x00\x00\x00", "B\xfdH|\x00\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdH|\x00\x00\x00\x00\x00\x01", "B\xfdH| \x00\x00\x00\x00\x00")
│ │ │ ├── ["B\xfdH|@\x00\x00\x00\x00\x00", "B\xfdH|@\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdH|`\x00\x00\x00\x00\x01", "B\xfdH|\x80\x00\x00\x00\x00\x00")
│ │ │ ├── ["B\xfdH|\x80\x00\x00\x00\x00\x01", "B\xfdH|\xa0\x00\x00\x00\x00\x00")
│ │ │ ├── ["B\xfdH|\xc0\x00\x00\x00\x00\x00", "B\xfdH|\xc0\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdH}\x00\x00\x00\x00\x00\x00", "B\xfdH}\x00\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdI\x00\x00\x00\x00\x00\x00\x00", "B\xfdI\x00\x00\x00\x00\x00\x00\x00"]
│ │ │ ├── ["B\xfdL\x00\x00\x00\x00\x00\x00\x00", "B\xfdL\x00\x00\x00\x00\x00\x00\x00"]
│ │ │ └── ["B\xfdP\x00\x00\x00\x00\x00\x00\x00", "B\xfdP\x00\x00\x00\x00\x00\x00\x00"]
│ │ ├── stats: [rows=45548.2222, distinct(1)=45548.2222, null(1)=0]
│ │ │ histogram(1)= 0 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 223.11 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444 227.67 4.4444
│ │ │ <--- '0016c774-fd6c-5303-b29e-69c0cebaec7a' -------- '01289f4c-4bec-523b-b604-ca15abee5988' -------- '024d0785-cac3-52b3-bc4c-e81b2348ec6e' -------- '03969c1f-4c53-586f-b9db-673e596f92b3' -------- '0559c175-c466-53f3-80c9-798bdfa65db8' -------- '06793ae8-d11f-576c-a286-768fd94dd1cd' -------- '07c500fd-aa74-545e-af61-9a78a7b98059' -------- '08e29f21-993e-50da-976d-2c55cb72aa0e' -------- '0a065ff9-e06f-5084-9707-ffae979e36aa' -------- '0b4096c8-3f2a-578f-8674-550429994a2e' -------- '0c704d03-265f-5a93-a63f-19ded9eec175' -------- '0dc6d997-6d04-5299-8501-f6b906faa21a' -------- '0f09a887-5f34-570a-aa87-367e4cace475' -------- '1073d57f-3b5f-5758-8c46-4b524ebe193e' -------- '11f2d500-2a1b-5cd3-af50-30dc4754101b' -------- '132f09b3-691e-5b6b-a527-93ee1c17f876' -------- '14c18729-61d2-5344-9dd9-dc8f8d5ae9d5' -------- '16140be1-e780-5d75-ac09-190d18d8494e' -------- '17415858-ebb9-517b-80ac-205728b9f317' -------- '18b1f418-bf12-5eb0-9c68-f668909838c8' -------- '1a0a5f71-2654-5d91-9f18-1978ab3c2529' -------- '1b20ac0e-feff-5d70-bf7d-204b80351361' -------- '1c556245-c305-573b-8aca-170d31927e85' -------- '1d760872-f1a6-5f6c-8cf9-269d9c2a6752' -------- '1e972c72-88d6-5ce9-9941-28a3fa06b2d3' -------- '2013cc1d-2814-5eb9-9051-bed64d53f513' -------- '2139e234-0a08-58ec-a430-266b157cdab8' -------- '225f36a5-effa-58e0-98ac-931fef4508ed' -------- '23a21188-4add-5858-af07-353765dd8510' -------- '24dfaa26-c21e-5417-86f4-9c791fa639ed' -------- '26569ffe-b4da-5261-b37c-7db071c53351' -------- '27a4f694-e068-5aa7-b582-dbe889810a1e' -------- '288d9e8b-40d1-5e73-99d2-56497805290f' -------- '29d77be3-21a0-5aa5-b616-28d917d82f9f' -------- '2b4c7ebb-837a-507d-a2d5-024ee522cd92' -------- '2c865a2a-6281-528f-bb0e-c1f163ea824d' -------- '2d83675b-d939-5bd2-9791-2150324d9d4f' -------- '2ede662e-a091-5d29-b1cb-4893e7723e91' -------- '306257db-96d4-5eb1-b2d6-f8a249ed329d' -------- '31775084-9713-5a91-afb9-e1427d7f4c91' -------- '328c42f2-a2cb-5e5f-bdd1-234364eaaeaa' -------- '33ba5e2e-4b0d-5886-9088-ae63ad220b2c' -------- '34c64f05-ba74-57cd-88b3-9313f13c068d' -------- '3646bc19-6065-5397-a1de-68aa8ba52acc' -------- '375bca50-26d2-5ea2-89de-225c11658ce8' -------- '388f4da5-66bc-50f9-80a6-1449c314b845' -------- '39e11845-a376-5d56-b44c-3629631f3e01' -------- '3ae49e8c-cb0c-5166-8302-141cbc082608' -------- '3c0f87c3-4386-518c-a306-4370e128da2b' -------- '3d66ccbc-d760-56f9-8215-7d2fc6cd9488' -------- '3f06ff0f-64de-535a-a20c-32019c2c12d2' -------- '400add8f-5bcb-5546-8325-679d71bb779d' -------- '417872e7-6d4f-5e29-8dad-ba62a1f97bab' -------- '42beb0fa-6a05-5172-8729-9c4b8bedf75e' -------- '44240f9c-80f7-5feb-8953-ef18b77f5b5c' -------- '45ca7de8-2e82-5039-84bd-501e9e3d4bb2' -------- '4748cc42-ae0d-5dc8-8761-46d504c16cbf' -------- '48de55ec-fbe9-5139-b30f-1add95b4ec47' -------- '4a4043e4-d2cb-5b07-9997-07d32b59877f' -------- '4b3e85e9-6be8-5155-9e6a-8b286e0b807c' -------- '4cbc492e-5bfe-5fb7-a124-937c2de5d2bc' -------- '4e3c1332-71f2-5ffe-83da-0ce5472b7429' -------- '4f6d4694-244d-5cba-84da-7cc2743bf22b' -------- '50a7c082-df3f-5c75-90fe-3fe1f7a65aa5' -------- '51aaec12-cd82-560c-a546-5d8ba69f623c' -------- '52d5bf0d-4586-5033-b3a0-0fcd7146ab16' -------- '53d4cbcf-5f5d-5266-b8b3-99aeb8f5bbdd' -------- '5574d200-0410-53ef-b770-90ec2bcb8912' -------- '56d3ab4a-1793-5a4b-9be3-2440d9c2fad8' -------- '5882f571-6aad-53d0-9617-9c8cd05041df' -------- '59b412ed-fe16-5dbf-8db1-1f6a502aa453' -------- '5ae78d36-a6ce-5b6e-a4cb-daf25ef1ff6d' -------- '5c51070b-7e39-5492-b13b-a424936586e0' -------- '5d661a6d-617c-54d9-aa59-ff6ba689790f' -------- '5e907e6c-520d-5cf2-9cbe-6d47a5ce5e9e' -------- '60181da3-964c-5c6b-b144-0a0d91632c70' -------- '61502a64-0f20-5edc-babc-295e723cb360' -------- '62d5c329-97f6-544f-941b-d72d36ed8f97' -------- '641e7b0d-7613-5a30-9c85-c9c22ec8a2f5' -------- '65c04001-1687-50fb-a67c-66be94673587' -------- '671e8469-0f74-5c1b-92d6-632ea7127657' -------- '686db44a-d9a9-5d11-a90b-fca5b4260e9f' -------- '699e8df5-fbcc-5e6b-94c0-8385ce67d077' -------- '6b193a0b-5540-520a-b75a-9abdfd01d30b' -------- '6c8bbf24-94db-5864-a5e4-feae44b16392' -------- '6dc18b30-ca62-5bc4-b554-8b24ff7ee1ab' -------- '6efec61f-4c83-5883-842b-3ce0bf769d8b' -------- '706c6987-1edd-5fd2-8ab9-835633a8b610' -------- '720d1a40-dbd9-52f3-9ec9-f27ae8c9f5e3' -------- '7311e794-59b0-5d7e-abfa-7940473cdfe8' -------- '73f5410a-6de7-553e-80e5-a593597a3df3' -------- '75435b9a-d19e-5dea-9604-9b41478c2a9f' -------- '76a5b6e6-ddd4-599e-b2dc-954c89cf073d' -------- '7856487a-af77-5d4a-b728-7b3af6a9b09e' -------- '79a30aa2-1089-5ad1-a3b6-ec9925db78c8' -------- '7ae9511c-748d-51bb-9811-58ee38f1f35f' -------- '7c2d6138-c8aa-5247-87b8-6a4e03843b68' -------- '7d6708fe-2430-5b6d-b92e-721caf5892cd' -------- '7ecbd737-f933-5fec-a59f-0a55b9cdc5c6' -------- '7ff9c69d-cdc2-5cf8-89fc-3435960d9f31' -------- '8174d64c-54be-5cdd-95c0-5aeefb5c7167' -------- '8286cc00-bf23-55a7-87fb-b1aa67a27488' -------- '83c16d41-7fc0-5c37-92f5-97eed5e9f838' -------- '84c82239-5a74-5a89-8edc-1a4a90bee8e7' -------- '861ad59d-0281-52f8-980b-fbfe18c50b7c' -------- '874ab865-da4c-5361-a2cc-555167dbd633' -------- '88a6141a-b0da-5277-b1d7-f4b1d8aa2c36' -------- '89a9eb4c-5f2b-5fcc-815d-5847153c1008' -------- '8b10dbd8-c16b-5a9b-a024-cdcf7a712984' -------- '8c32bf25-742a-502b-9c72-0044b191f8a3' -------- '8d538a25-8c47-5ad4-89ce-37adb120666b' -------- '8f1ec917-22fa-568f-9397-f362813350f3' -------- '9078dd45-b852-5753-9540-824485cf7e11' -------- '919d9c29-229c-592d-b670-ee8e18e73a26' -------- '92e8f2b1-c431-5b5b-bf6e-fbbf8dcae93a' -------- '93f1e078-65d1-5d12-9b3e-c2cc4950e6a7' -------- '95037795-c1c7-5f3b-bae9-5018c08036fe' -------- '95f64196-6cbc-5991-ae80-a2c3f94a9c69' -------- '971cd2e9-9a34-538a-8d99-f93d96ea0cd1' -------- '98595834-8f15-5351-9376-642ae1d8076c' -------- '995667eb-de10-5a78-a7ef-787ec83f41d5' -------- '9a7f509e-7fbe-5537-8c3e-f4159dca8119' -------- '9bd9c165-ce21-57ac-8cf5-6f3a36c02d51' -------- '9d8a807a-274b-5dab-9f15-e929bb83d497' -------- '9ef09750-9c2b-51f5-b61c-8005ab5bdc25' -------- 'a04dd9f6-7466-5ec9-a0f7-860e41028153' -------- 'a1786255-1185-548b-91c6-15c4752998ca' -------- 'a2b70519-4672-5fd3-8874-6681444c6301' -------- 'a3f10662-e03b-50b6-ae62-f44daeb3a411' -------- 'a55f93e9-2ed1-5339-9b2d-62c0ed0e45b0' -------- 'a6bbd21d-d78c-55ad-aefe-3a6b26bb0d95' -------- 'a82e8e13-7ddb-5224-832f-88c7e31b8858' -------- 'a9810df8-6ba9-52a2-9978-c1b658791e46' -------- 'aac51f78-8d5d-5d61-ab40-519ddcfbe006' -------- 'abf15e7f-8f58-50d2-82cb-5384aec2ce77' -------- 'ad522edb-8669-52ba-8637-f12ea7389ad9' -------- 'aea36bbd-0af4-5d23-bc1e-4b6ac49a9589' -------- 'afe1f961-2531-561c-900e-4dbf64771f86' -------- 'b149470b-7d6a-5b3b-b668-1e613bf53cb7' -------- 'b2420f01-7b90-519e-9525-b2443aee8890' -------- 'b3b4a350-b8fb-5f38-a5ea-bac72accb01b' -------- 'b4cfa98f-56fc-5a35-9649-218edec2e7fb' -------- 'b64415aa-c565-585e-ad0e-5fe5ed7fa751' -------- 'b7a98fde-6eff-5e80-97ce-967ed6488250' -------- 'b8d6478a-7bd8-5b28-89e5-295c328a43a1' -------- 'ba523325-f53f-560d-89f5-acc55d09cb28' -------- 'bbc7834a-e40c-55ee-895e-d4f445ca83a9' -------- 'bd2c77a8-7ba0-54f5-b37e-5bb554838d1f' -------- 'bebc9df2-a569-5e75-b73f-7229eb80fb3d' -------- 'bffd2a7c-b09c-559f-b48d-c7790a200233' -------- 'c117f664-9dc5-5ceb-ad65-20f9ab5bfded' -------- 'c26d3ea0-e2e9-55f6-864d-938acb06692e' -------- 'c373fd46-5139-5a46-b846-ff987228d2e0' -------- 'c4ced926-9e0b-5278-b5b3-9b2f1593515c' -------- 'c60050b8-139f-55ec-8a4b-9e32167c7381' -------- 'c75a616e-caa7-555a-91e3-cd947d63a2ae' -------- 'c922e8c2-84da-5c85-add4-657a67294771' -------- 'ca83c5e5-6500-5b8f-9410-5d1aa5170b75' -------- 'cb9b7b4a-ca4b-5b1a-8557-de87580b8536' -------- 'ccc674b8-45ba-50b2-8003-dabf024bdac9' -------- 'cdeb00f0-c409-5a0f-94a2-b8eeffe32946' -------- 'cf3f72ce-fc4b-559a-ba7b-ba860ee8daa5' -------- 'd097e68d-a559-5853-a7c5-b80864b94f68' -------- 'd1c6f35a-e95f-5667-9af7-d3dd42a067cb' -------- 'd317cf96-18fe-54a1-9e5e-cc244880ddd2' -------- 'd45763ed-ce7b-53b2-98c0-860cba573c53' -------- 'd5ad63b8-a07d-5e29-8c8a-f0b94351d0b2' -------- 'd6cfd13a-22ab-59ae-b28a-cb3db6def9e3' -------- 'd86c1f53-ef36-51f2-be24-cb34c380ebaa' -------- 'd978b91e-6f44-589d-835a-fcd825cb2016' -------- 'dac40579-4a06-5150-8884-ac751b40ab86' -------- 'dc00db72-0ff4-5833-b5c2-db9ac16e80bc' -------- 'dd1459f0-9a69-5534-8c87-1a7ae40f6222' -------- 'de34af8d-e0c9-524c-b67e-4a2573093631' -------- 'dfc4bd93-b24a-5a69-afed-d22cd66489ba' -------- 'e0c2b466-7311-5b73-8c73-250828067ec8' -------- 'e216d289-4687-5d67-abef-8756e0a421db' -------- 'e38667f3-6387-55bf-8263-9bb960abac35' -------- 'e4b397a4-4999-590a-b72f-5e807c55cb67' -------- 'e5e14708-1b51-5e14-8ce5-25dd459c2ae8' -------- 'e6f85292-9751-5514-a855-6bbd7f070fee' -------- 'e885181d-2c96-52d5-9fb8-dc6ee38c6842' -------- 'e9e506df-353f-5bea-92b1-f2cd738a2f6d' -------- 'eb21d200-c67f-5463-ad4f-d9efec878928' -------- 'eccd138f-d267-527f-8118-a1d2c9bd60fe' -------- 'ee40ee90-d27b-5ff1-bcb7-6ab9935c84ea' -------- 'ef1bb0aa-455e-5ab5-991d-83cd5e57dd71' -------- 'f0959ea0-b761-598a-abd3-8dd8923c2a98' -------- 'f214e2be-0e66-5587-99f3-4096fe63688c' -------- 'f39ec595-edf8-5758-9f04-f1fba43bac47' -------- 'f4ed96f3-8fad-5c82-8c89-ea6292d27115' -------- 'f674f655-9ad1-5a4c-96c2-7266371bdf39' -------- 'f7a1a312-ecb0-5248-9ced-264d28a0a2a1' -------- 'f8eea626-1062-59d9-9e57-2068d4283521' -------- 'fa500805-ff51-5f51-baa7-34ebd64708ae' -------- 'fb332e95-6eb6-57d5-a277-a2032ac5f3df' -------- 'fc589b51-eaf0-560a-bdd5-26608a714970' -------- 'fdac7638-abbf-5eae-af0f-2478f196b211' -------- 'febc4300-f9eb-5ca4-bed3-270217c25dbd' -------- 'ffff6522-5abd-5bc0-b329-b4b55b3b8839'
│ │ ├── cost: 47438.1611
│ │ ├── key: (1)
│ │ └── fd: (1)-->(8)
│ └── filters
│ └── st_dwithin(coordinates:5, '0101000020E610000000000000000002C0C3F5285C8FE24A40', 20000.0) [outer=(5), immutable]
└── 10
(102 rows)
Time: 19ms total (execution 11ms / network 9ms)
explain (opt, verbose)
SELECT users.id, users.lat, users.lng
FROM users
WHERE st_distancespheroid(users.coordinates::geometry, st_makepoint(-2.25, 53.77)) < 20000
ORDER BY users.id
LIMIT 10 OFFSET 0;
text
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
project
├── columns: id:1 lat:3 lng:4
├── cardinality: [0 - 10]
├── immutable
├── stats: [rows=10]
├── cost: 4169
├── key: (1)
├── fd: (1)-->(3,4)
├── ordering: +1
├── prune: (1,3,4)
├── interesting orderings: (+1)
└── limit
├── columns: id:1 lat:3 lng:4 coordinates:5
├── internal-ordering: +1
├── cardinality: [0 - 10]
├── immutable
├── stats: [rows=10]
├── cost: 4168.89
├── key: (1)
├── fd: (1)-->(3-5)
├── ordering: +1
├── interesting orderings: (+1)
├── select
│ ├── columns: id:1 lat:3 lng:4 coordinates:5
│ ├── immutable
│ ├── stats: [rows=136644.667]
│ ├── cost: 4168.78
│ ├── key: (1)
│ ├── fd: (1)-->(3-5)
│ ├── ordering: +1
│ ├── limit hint: 10.00
│ ├── prune: (1,3,4)
│ ├── interesting orderings: (+1)
│ ├── scan users
│ │ ├── columns: id:1 lat:3 lng:4 coordinates:5
│ │ ├── stats: [rows=409934, distinct(1)=409934, null(1)=0]
│ │ │ histogram(1)= 0 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2008 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40 2049 40
│ │ │ <--- '0016c774-fd6c-5303-b29e-69c0cebaec7a' ------ '01289f4c-4bec-523b-b604-ca15abee5988' ------ '024d0785-cac3-52b3-bc4c-e81b2348ec6e' ------ '03969c1f-4c53-586f-b9db-673e596f92b3' ------ '0559c175-c466-53f3-80c9-798bdfa65db8' ------ '06793ae8-d11f-576c-a286-768fd94dd1cd' ------ '07c500fd-aa74-545e-af61-9a78a7b98059' ------ '08e29f21-993e-50da-976d-2c55cb72aa0e' ------ '0a065ff9-e06f-5084-9707-ffae979e36aa' ------ '0b4096c8-3f2a-578f-8674-550429994a2e' ------ '0c704d03-265f-5a93-a63f-19ded9eec175' ------ '0dc6d997-6d04-5299-8501-f6b906faa21a' ------ '0f09a887-5f34-570a-aa87-367e4cace475' ------ '1073d57f-3b5f-5758-8c46-4b524ebe193e' ------ '11f2d500-2a1b-5cd3-af50-30dc4754101b' ------ '132f09b3-691e-5b6b-a527-93ee1c17f876' ------ '14c18729-61d2-5344-9dd9-dc8f8d5ae9d5' ------ '16140be1-e780-5d75-ac09-190d18d8494e' ------ '17415858-ebb9-517b-80ac-205728b9f317' ------ '18b1f418-bf12-5eb0-9c68-f668909838c8' ------ '1a0a5f71-2654-5d91-9f18-1978ab3c2529' ------ '1b20ac0e-feff-5d70-bf7d-204b80351361' ------ '1c556245-c305-573b-8aca-170d31927e85' ------ '1d760872-f1a6-5f6c-8cf9-269d9c2a6752' ------ '1e972c72-88d6-5ce9-9941-28a3fa06b2d3' ------ '2013cc1d-2814-5eb9-9051-bed64d53f513' ------ '2139e234-0a08-58ec-a430-266b157cdab8' ------ '225f36a5-effa-58e0-98ac-931fef4508ed' ------ '23a21188-4add-5858-af07-353765dd8510' ------ '24dfaa26-c21e-5417-86f4-9c791fa639ed' ------ '26569ffe-b4da-5261-b37c-7db071c53351' ------ '27a4f694-e068-5aa7-b582-dbe889810a1e' ------ '288d9e8b-40d1-5e73-99d2-56497805290f' ------ '29d77be3-21a0-5aa5-b616-28d917d82f9f' ------ '2b4c7ebb-837a-507d-a2d5-024ee522cd92' ------ '2c865a2a-6281-528f-bb0e-c1f163ea824d' ------ '2d83675b-d939-5bd2-9791-2150324d9d4f' ------ '2ede662e-a091-5d29-b1cb-4893e7723e91' ------ '306257db-96d4-5eb1-b2d6-f8a249ed329d' ------ '31775084-9713-5a91-afb9-e1427d7f4c91' ------ '328c42f2-a2cb-5e5f-bdd1-234364eaaeaa' ------ '33ba5e2e-4b0d-5886-9088-ae63ad220b2c' ------ '34c64f05-ba74-57cd-88b3-9313f13c068d' ------ '3646bc19-6065-5397-a1de-68aa8ba52acc' ------ '375bca50-26d2-5ea2-89de-225c11658ce8' ------ '388f4da5-66bc-50f9-80a6-1449c314b845' ------ '39e11845-a376-5d56-b44c-3629631f3e01' ------ '3ae49e8c-cb0c-5166-8302-141cbc082608' ------ '3c0f87c3-4386-518c-a306-4370e128da2b' ------ '3d66ccbc-d760-56f9-8215-7d2fc6cd9488' ------ '3f06ff0f-64de-535a-a20c-32019c2c12d2' ------ '400add8f-5bcb-5546-8325-679d71bb779d' ------ '417872e7-6d4f-5e29-8dad-ba62a1f97bab' ------ '42beb0fa-6a05-5172-8729-9c4b8bedf75e' ------ '44240f9c-80f7-5feb-8953-ef18b77f5b5c' ------ '45ca7de8-2e82-5039-84bd-501e9e3d4bb2' ------ '4748cc42-ae0d-5dc8-8761-46d504c16cbf' ------ '48de55ec-fbe9-5139-b30f-1add95b4ec47' ------ '4a4043e4-d2cb-5b07-9997-07d32b59877f' ------ '4b3e85e9-6be8-5155-9e6a-8b286e0b807c' ------ '4cbc492e-5bfe-5fb7-a124-937c2de5d2bc' ------ '4e3c1332-71f2-5ffe-83da-0ce5472b7429' ------ '4f6d4694-244d-5cba-84da-7cc2743bf22b' ------ '50a7c082-df3f-5c75-90fe-3fe1f7a65aa5' ------ '51aaec12-cd82-560c-a546-5d8ba69f623c' ------ '52d5bf0d-4586-5033-b3a0-0fcd7146ab16' ------ '53d4cbcf-5f5d-5266-b8b3-99aeb8f5bbdd' ------ '5574d200-0410-53ef-b770-90ec2bcb8912' ------ '56d3ab4a-1793-5a4b-9be3-2440d9c2fad8' ------ '5882f571-6aad-53d0-9617-9c8cd05041df' ------ '59b412ed-fe16-5dbf-8db1-1f6a502aa453' ------ '5ae78d36-a6ce-5b6e-a4cb-daf25ef1ff6d' ------ '5c51070b-7e39-5492-b13b-a424936586e0' ------ '5d661a6d-617c-54d9-aa59-ff6ba689790f' ------ '5e907e6c-520d-5cf2-9cbe-6d47a5ce5e9e' ------ '60181da3-964c-5c6b-b144-0a0d91632c70' ------ '61502a64-0f20-5edc-babc-295e723cb360' ------ '62d5c329-97f6-544f-941b-d72d36ed8f97' ------ '641e7b0d-7613-5a30-9c85-c9c22ec8a2f5' ------ '65c04001-1687-50fb-a67c-66be94673587' ------ '671e8469-0f74-5c1b-92d6-632ea7127657' ------ '686db44a-d9a9-5d11-a90b-fca5b4260e9f' ------ '699e8df5-fbcc-5e6b-94c0-8385ce67d077' ------ '6b193a0b-5540-520a-b75a-9abdfd01d30b' ------ '6c8bbf24-94db-5864-a5e4-feae44b16392' ------ '6dc18b30-ca62-5bc4-b554-8b24ff7ee1ab' ------ '6efec61f-4c83-5883-842b-3ce0bf769d8b' ------ '706c6987-1edd-5fd2-8ab9-835633a8b610' ------ '720d1a40-dbd9-52f3-9ec9-f27ae8c9f5e3' ------ '7311e794-59b0-5d7e-abfa-7940473cdfe8' ------ '73f5410a-6de7-553e-80e5-a593597a3df3' ------ '75435b9a-d19e-5dea-9604-9b41478c2a9f' ------ '76a5b6e6-ddd4-599e-b2dc-954c89cf073d' ------ '7856487a-af77-5d4a-b728-7b3af6a9b09e' ------ '79a30aa2-1089-5ad1-a3b6-ec9925db78c8' ------ '7ae9511c-748d-51bb-9811-58ee38f1f35f' ------ '7c2d6138-c8aa-5247-87b8-6a4e03843b68' ------ '7d6708fe-2430-5b6d-b92e-721caf5892cd' ------ '7ecbd737-f933-5fec-a59f-0a55b9cdc5c6' ------ '7ff9c69d-cdc2-5cf8-89fc-3435960d9f31' ------ '8174d64c-54be-5cdd-95c0-5aeefb5c7167' ------ '8286cc00-bf23-55a7-87fb-b1aa67a27488' ------ '83c16d41-7fc0-5c37-92f5-97eed5e9f838' ------ '84c82239-5a74-5a89-8edc-1a4a90bee8e7' ------ '861ad59d-0281-52f8-980b-fbfe18c50b7c' ------ '874ab865-da4c-5361-a2cc-555167dbd633' ------ '88a6141a-b0da-5277-b1d7-f4b1d8aa2c36' ------ '89a9eb4c-5f2b-5fcc-815d-5847153c1008' ------ '8b10dbd8-c16b-5a9b-a024-cdcf7a712984' ------ '8c32bf25-742a-502b-9c72-0044b191f8a3' ------ '8d538a25-8c47-5ad4-89ce-37adb120666b' ------ '8f1ec917-22fa-568f-9397-f362813350f3' ------ '9078dd45-b852-5753-9540-824485cf7e11' ------ '919d9c29-229c-592d-b670-ee8e18e73a26' ------ '92e8f2b1-c431-5b5b-bf6e-fbbf8dcae93a' ------ '93f1e078-65d1-5d12-9b3e-c2cc4950e6a7' ------ '95037795-c1c7-5f3b-bae9-5018c08036fe' ------ '95f64196-6cbc-5991-ae80-a2c3f94a9c69' ------ '971cd2e9-9a34-538a-8d99-f93d96ea0cd1' ------ '98595834-8f15-5351-9376-642ae1d8076c' ------ '995667eb-de10-5a78-a7ef-787ec83f41d5' ------ '9a7f509e-7fbe-5537-8c3e-f4159dca8119' ------ '9bd9c165-ce21-57ac-8cf5-6f3a36c02d51' ------ '9d8a807a-274b-5dab-9f15-e929bb83d497' ------ '9ef09750-9c2b-51f5-b61c-8005ab5bdc25' ------ 'a04dd9f6-7466-5ec9-a0f7-860e41028153' ------ 'a1786255-1185-548b-91c6-15c4752998ca' ------ 'a2b70519-4672-5fd3-8874-6681444c6301' ------ 'a3f10662-e03b-50b6-ae62-f44daeb3a411' ------ 'a55f93e9-2ed1-5339-9b2d-62c0ed0e45b0' ------ 'a6bbd21d-d78c-55ad-aefe-3a6b26bb0d95' ------ 'a82e8e13-7ddb-5224-832f-88c7e31b8858' ------ 'a9810df8-6ba9-52a2-9978-c1b658791e46' ------ 'aac51f78-8d5d-5d61-ab40-519ddcfbe006' ------ 'abf15e7f-8f58-50d2-82cb-5384aec2ce77' ------ 'ad522edb-8669-52ba-8637-f12ea7389ad9' ------ 'aea36bbd-0af4-5d23-bc1e-4b6ac49a9589' ------ 'afe1f961-2531-561c-900e-4dbf64771f86' ------ 'b149470b-7d6a-5b3b-b668-1e613bf53cb7' ------ 'b2420f01-7b90-519e-9525-b2443aee8890' ------ 'b3b4a350-b8fb-5f38-a5ea-bac72accb01b' ------ 'b4cfa98f-56fc-5a35-9649-218edec2e7fb' ------ 'b64415aa-c565-585e-ad0e-5fe5ed7fa751' ------ 'b7a98fde-6eff-5e80-97ce-967ed6488250' ------ 'b8d6478a-7bd8-5b28-89e5-295c328a43a1' ------ 'ba523325-f53f-560d-89f5-acc55d09cb28' ------ 'bbc7834a-e40c-55ee-895e-d4f445ca83a9' ------ 'bd2c77a8-7ba0-54f5-b37e-5bb554838d1f' ------ 'bebc9df2-a569-5e75-b73f-7229eb80fb3d' ------ 'bffd2a7c-b09c-559f-b48d-c7790a200233' ------ 'c117f664-9dc5-5ceb-ad65-20f9ab5bfded' ------ 'c26d3ea0-e2e9-55f6-864d-938acb06692e' ------ 'c373fd46-5139-5a46-b846-ff987228d2e0' ------ 'c4ced926-9e0b-5278-b5b3-9b2f1593515c' ------ 'c60050b8-139f-55ec-8a4b-9e32167c7381' ------ 'c75a616e-caa7-555a-91e3-cd947d63a2ae' ------ 'c922e8c2-84da-5c85-add4-657a67294771' ------ 'ca83c5e5-6500-5b8f-9410-5d1aa5170b75' ------ 'cb9b7b4a-ca4b-5b1a-8557-de87580b8536' ------ 'ccc674b8-45ba-50b2-8003-dabf024bdac9' ------ 'cdeb00f0-c409-5a0f-94a2-b8eeffe32946' ------ 'cf3f72ce-fc4b-559a-ba7b-ba860ee8daa5' ------ 'd097e68d-a559-5853-a7c5-b80864b94f68' ------ 'd1c6f35a-e95f-5667-9af7-d3dd42a067cb' ------ 'd317cf96-18fe-54a1-9e5e-cc244880ddd2' ------ 'd45763ed-ce7b-53b2-98c0-860cba573c53' ------ 'd5ad63b8-a07d-5e29-8c8a-f0b94351d0b2' ------ 'd6cfd13a-22ab-59ae-b28a-cb3db6def9e3' ------ 'd86c1f53-ef36-51f2-be24-cb34c380ebaa' ------ 'd978b91e-6f44-589d-835a-fcd825cb2016' ------ 'dac40579-4a06-5150-8884-ac751b40ab86' ------ 'dc00db72-0ff4-5833-b5c2-db9ac16e80bc' ------ 'dd1459f0-9a69-5534-8c87-1a7ae40f6222' ------ 'de34af8d-e0c9-524c-b67e-4a2573093631' ------ 'dfc4bd93-b24a-5a69-afed-d22cd66489ba' ------ 'e0c2b466-7311-5b73-8c73-250828067ec8' ------ 'e216d289-4687-5d67-abef-8756e0a421db' ------ 'e38667f3-6387-55bf-8263-9bb960abac35' ------ 'e4b397a4-4999-590a-b72f-5e807c55cb67' ------ 'e5e14708-1b51-5e14-8ce5-25dd459c2ae8' ------ 'e6f85292-9751-5514-a855-6bbd7f070fee' ------ 'e885181d-2c96-52d5-9fb8-dc6ee38c6842' ------ 'e9e506df-353f-5bea-92b1-f2cd738a2f6d' ------ 'eb21d200-c67f-5463-ad4f-d9efec878928' ------ 'eccd138f-d267-527f-8118-a1d2c9bd60fe' ------ 'ee40ee90-d27b-5ff1-bcb7-6ab9935c84ea' ------ 'ef1bb0aa-455e-5ab5-991d-83cd5e57dd71' ------ 'f0959ea0-b761-598a-abd3-8dd8923c2a98' ------ 'f214e2be-0e66-5587-99f3-4096fe63688c' ------ 'f39ec595-edf8-5758-9f04-f1fba43bac47' ------ 'f4ed96f3-8fad-5c82-8c89-ea6292d27115' ------ 'f674f655-9ad1-5a4c-96c2-7266371bdf39' ------ 'f7a1a312-ecb0-5248-9ced-264d28a0a2a1' ------ 'f8eea626-1062-59d9-9e57-2068d4283521' ------ 'fa500805-ff51-5f51-baa7-34ebd64708ae' ------ 'fb332e95-6eb6-57d5-a277-a2032ac5f3df' ------ 'fc589b51-eaf0-560a-bdd5-26608a714970' ------ 'fdac7638-abbf-5eae-af0f-2478f196b211' ------ 'febc4300-f9eb-5ca4-bed3-270217c25dbd' ------ 'ffff6522-5abd-5bc0-b329-b4b55b3b8839'
│ │ ├── cost: 69.42
│ │ ├── key: (1)
│ │ ├── fd: (1)-->(3-5)
│ │ ├── ordering: +1
│ │ ├── limit hint: 30.00
│ │ ├── prune: (1,3-5)
│ │ └── interesting orderings: (+1)
│ └── filters
│ └── st_distancespheroid(coordinates:5::GEOMETRY, '010100000000000000000002C0C3F5285C8FE24A40') < 20000.0 [outer=(5), immutable]
└── 10
(48 rows)
Time: 24ms total (execution 9ms / network 15ms)