explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BHZD : geometryCol_geographyidx

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 155 1

Bitmap Heap Scan on demographics_2019_geom demographics_2019_geom (cost=0..0 rows=0 width=0) (actual rows=155 loops=1)

  • Filter: (('0101000020E61000001AC05B20417D54C0E10B93A982814140'::geography && _st_expand((geometry)::geography, '16093'::double precision)) AND _st_dwithin('0101000020E61000001AC05B20417D54C0E10B93A982814140'::geography, (geometry)::geography, '16093'::double precision, false) AND (st_area(geography(st_transform(st_intersection(st_transform('0103000020E6100000010000002100000048B4F290F77154C0054A8009AC814140350085AA2A7254C0172D22B60B7E4140592783BECA7254C0D4F7719C8D7A4140D2308E8DD17354C00FF5740C54774140E3E15FED347554C0CBD72CAD7E74414029104D2FE77654C0E6FB1148297241406D5CD3A7D77854C00DCE24BB6A7041405D9FDB51F37A54C0AED8711B546F4140E4C78987257D54C060220710F06E4140CD85D9C9587F54C0040F416B426F4140809EE28F778154C0786612064870414032F56D166D8354C010BB8FDEF671414032A58328268554C0BDFEA2783E744140A5BBCAD9918654C07741717D087741400011F52BA28754C01ED5BA93397A4140254F07994C8854C0A4FE6569B27D41403066187D8A8854C04FB586E4508141409DD9255B598854C06EA3A370F1844140DFB2D2F9BA8754C0BF7BC25B70884140FF825156B58654C086DEFB35AB8B4140D93F4E6D528554C0E9DD0726828E414004565DDB9F8354C034F46A25D9904140042A2F58AE8154C0A368AE1799924140223D7311917F54C010B15EB1B09341408E49DAEB5C7D54C0057D5E25159441407BC2E8B1277B54C0D5516591C2934140C3B73339077954C078232425BC924140933B1F87107754C0E62869020C914140FA0D3DFE567554C0ED6991D7C28E4140E6BCFB9CEB7354C02B5A7B38F78B4140E6387A55DC7254C0C5B3DCBCC488414099F01A85337254C0287D35ED4A85414048B4F290F77154C0054A8009AC814140'::geometry, _st_bestsrid('0103000020E6100000010000002100000048B4F290F77154C0054A8009AC814140350085AA2A7254C0172D22B60B7E4140592783BECA7254C0D4F7719C8D7A4140D2308E8DD17354C00FF5740C54774140E3E15FED347554C0CBD72CAD7E74414029104D2FE77654C0E6FB1148297241406D5CD3A7D77854C00DCE24BB6A7041405D9FDB51F37A54C0AED8711B546F4140E4C78987257D54C060220710F06E4140CD85D9C9587F54C0040F416B426F4140809EE28F778154C0786612064870414032F56D166D8354C010BB8FDEF671414032A58328268554C0BDFEA2783E744140A5BBCAD9918654C07741717D087741400011F52BA28754C01ED5BA93397A4140254F07994C8854C0A4FE6569B27D41403066187D8A8854C04FB586E4508141409DD9255B598854C06EA3A370F1844140DFB2D2F9BA8754C0BF7BC25B70884140FF825156B58654C086DEFB35AB8B4140D93F4E6D528554C0E9DD0726828E414004565DDB9F8354C034F46A25D9904140042A2F58AE8154C0A368AE1799924140223D7311917F54C010B15EB1B09341408E49DAEB5C7D54C0057D5E25159441407BC2E8B1277B54C0D5516591C2934140C3B73339077954C078232425BC924140933B1F87107754C0E62869020C914140FA0D3DFE567554C0ED6991D7C28E4140E6BCFB9CEB7354C02B5A7B38F78B4140E6387A55DC7254C0C5B3DCBCC488414099F01A85337254C0287D35ED4A85414048B4F290F77154C0054A8009AC814140'::geography, (geometry)::geography)), st_transform(geometry((geometry)::geography), _st_bestsrid('0103000020E6100000010000002100000048B4F290F77154C0054A8009AC814140350085AA2A7254C0172D22B60B7E4140592783BECA7254C0D4F7719C8D7A4140D2308E8DD17354C00FF5740C54774140E3E15FED347554C0CBD72CAD7E74414029104D2FE77654C0E6FB1148297241406D5CD3A7D77854C00DCE24BB6A7041405D9FDB51F37A54C0AED8711B546F4140E4C78987257D54C060220710F06E4140CD85D9C9587F54C0040F416B426F4140809EE28F778154C0786612064870414032F56D166D8354C010BB8FDEF671414032A58328268554C0BDFEA2783E744140A5BBCAD9918654C07741717D087741400011F52BA28754C01ED5BA93397A4140254F07994C8854C0A4FE6569B27D41403066187D8A8854C04FB586E4508141409DD9255B598854C06EA3A370F1844140DFB2D2F9BA8754C0BF7BC25B70884140FF825156B58654C086DEFB35AB8B4140D93F4E6D528554C0E9DD0726828E414004565DDB9F8354C034F46A25D9904140042A2F58AE8154C0A368AE1799924140223D7311917F54C010B15EB1B09341408E49DAEB5C7D54C0057D5E25159441407BC2E8B1277B54C0D5516591C2934140C3B73339077954C078232425BC924140933B1F87107754C0E62869020C914140FA0D3DFE567554C0ED6991D7C28E4140E6BCFB9CEB7354C02B5A7B38F78B4140E6387A55DC7254C0C5B3DCBCC488414099F01A85337254C0287D35ED4A85414048B4F290F77154C0054A8009AC814140'::geography, (geometry)::geography))), 4326)), false) > '0.01'::double precision))
  • Heap Blocks: exact=178
2. 0.000 0.000 ↓ 0.0 178 1

Bitmap Index Scan on demographics_2019_geom_idxen_geographyidx (cost=0..0 rows=0 width=0) (actual rows=178 loops=1)

  • Index Cond: ((geometry)::geography && '0101000020E61000001AC05B20417D54C0E10B93A982814140'::geography)
Planning time : 0.696 ms
Execution time : 52.809 ms