explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ze9l

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 4,210 1

Index Scan using demographics_2019_geometry_1578581398166 on demographics_2019 demographics_2019 (cost=0..0 rows=0 width=0) (actual rows=4,210 loops=1)

  • Index Cond: ('0103000020E61000000100000021000000DAACC7EA5D0C54C019C45275A68141405112E47FB40E54C0FA217822715D4140FB1644153F1554C0A0EC51D9AB3A4140D9F44275B41F54C05627E866A71A4140EF56AC1AA82D54C09736BA5697FE404015683C088F3E54C00F2B524687E740406638143BC55154C03ACCD0D051D64040BF8FFE8A936654C0ECFD544499CB4040B4EB5AD5357C54C0B095894AC2C74040F279E755E19154C08BE1F4A3F0CA4040CDEA2714CBA654C04812920906D54040D68EDC4D2EBA54C0CBBA093AA3E540408DA698C752CB54C038860A292BFC4040F80EFFEB92D954C0817FBF39C8174140636DB89F61E454C0C54E9D62733741402D27AEAA4FEB54C00046E110FD594140DA45A08D10EE54C0A9D3AD9B177E4140E667078E7EEC54C0EA4AEA0E63A241405F695BB39DE654C0DE56BF097AC54140F25C46649DDC54C0E8D26359FFE541408551904DD8CE54C06047CFDEAB02424069679345D2BD54C02168CD2F5C1A4240A0BC1CFA33AA54C0E51804481D2C42404F1C5E64C49454C09437098D373742406FA34F3A607E54C087DBDB69373B4240CA609ED4EF6754C041CD5FDFF2374240478FCA365C5254C028A51D998B2D42406C01A807843E54C01F59B0596D1C42406330F64A312D54C09FEA13DE48054240DBC99D90101F54C00AC8779D0BE9414093A3621AAA1454C0ECC5DA00D5C84140184FC5395D0E54C06F6CC8CBE9A54140DAACC7EA5D0C54C019C45275A6814140'::geography && geometry)
  • Filter: (_st_distance('0103000020E61000000100000021000000DAACC7EA5D0C54C019C45275A68141405112E47FB40E54C0FA217822715D4140FB1644153F1554C0A0EC51D9AB3A4140D9F44275B41F54C05627E866A71A4140EF56AC1AA82D54C09736BA5697FE404015683C088F3E54C00F2B524687E740406638143BC55154C03ACCD0D051D64040BF8FFE8A936654C0ECFD544499CB4040B4EB5AD5357C54C0B095894AC2C74040F279E755E19154C08BE1F4A3F0CA4040CDEA2714CBA654C04812920906D54040D68EDC4D2EBA54C0CBBA093AA3E540408DA698C752CB54C038860A292BFC4040F80EFFEB92D954C0817FBF39C8174140636DB89F61E454C0C54E9D62733741402D27AEAA4FEB54C00046E110FD594140DA45A08D10EE54C0A9D3AD9B177E4140E667078E7EEC54C0EA4AEA0E63A241405F695BB39DE654C0DE56BF097AC54140F25C46649DDC54C0E8D26359FFE541408551904DD8CE54C06047CFDEAB02424069679345D2BD54C02168CD2F5C1A4240A0BC1CFA33AA54C0E51804481D2C42404F1C5E64C49454C09437098D373742406FA34F3A607E54C087DBDB69373B4240CA609ED4EF6754C041CD5FDFF2374240478FCA365C5254C028A51D998B2D42406C01A807843E54C01F59B0596D1C42406330F64A312D54C09FEA13DE48054240DBC99D90101F54C00AC8779D0BE9414093A3621AAA1454C0ECC5DA00D5C84140184FC5395D0E54C06F6CC8CBE9A54140DAACC7EA5D0C54C019C45275A6814140'::geography, geometry, '0'::double precision, false) < '1e-05'::double precision)
Planning time : 1.553 ms
Execution time : 23,577.933 ms