explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RHAQG

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

Index Scan using demographics_2019_gen_geometry_1578581398166 on demographics_2019_gen demographics_2019_gen (cost=0..0 rows=0 width=0) (actual rows=155 loops=1)

  • Index Cond: ('0103000020E6100000010000002100000048B4F290F77154C0054A8009AC814140350085AA2A7254C0172D22B60B7E4140592783BECA7254C0D4F7719C8D7A4140D2308E8DD17354C00FF5740C54774140E3E15FED347554C0CBD72CAD7E74414029104D2FE77654C0E6FB1148297241406D5CD3A7D77854C00DCE24BB6A7041405D9FDB51F37A54C0AED8711B546F4140E4C78987257D54C060220710F06E4140CD85D9C9587F54C0040F416B426F4140809EE28F778154C0786612064870414032F56D166D8354C010BB8FDEF671414032A58328268554C0BDFEA2783E744140A5BBCAD9918654C07741717D087741400011F52BA28754C01ED5BA93397A4140254F07994C8854C0A4FE6569B27D41403066187D8A8854C04FB586E4508141409DD9255B598854C06EA3A370F1844140DFB2D2F9BA8754C0BF7BC25B70884140FF825156B58654C086DEFB35AB8B4140D93F4E6D528554C0E9DD0726828E414004565DDB9F8354C034F46A25D9904140042A2F58AE8154C0A368AE1799924140223D7311917F54C010B15EB1B09341408E49DAEB5C7D54C0057D5E25159441407BC2E8B1277B54C0D5516591C2934140C3B73339077954C078232425BC924140933B1F87107754C0E62869020C914140FA0D3DFE567554C0ED6991D7C28E4140E6BCFB9CEB7354C02B5A7B38F78B4140E6387A55DC7254C0C5B3DCBCC488414099F01A85337254C0287D35ED4A85414048B4F290F77154C0054A8009AC814140'::geography && geometry)
  • Filter: (((country)::text = 'USA'::text) AND (_st_distance('0103000020E6100000010000002100000048B4F290F77154C0054A8009AC814140350085AA2A7254C0172D22B60B7E4140592783BECA7254C0D4F7719C8D7A4140D2308E8DD17354C00FF5740C54774140E3E15FED347554C0CBD72CAD7E74414029104D2FE77654C0E6FB1148297241406D5CD3A7D77854C00DCE24BB6A7041405D9FDB51F37A54C0AED8711B546F4140E4C78987257D54C060220710F06E4140CD85D9C9587F54C0040F416B426F4140809EE28F778154C0786612064870414032F56D166D8354C010BB8FDEF671414032A58328268554C0BDFEA2783E744140A5BBCAD9918654C07741717D087741400011F52BA28754C01ED5BA93397A4140254F07994C8854C0A4FE6569B27D41403066187D8A8854C04FB586E4508141409DD9255B598854C06EA3A370F1844140DFB2D2F9BA8754C0BF7BC25B70884140FF825156B58654C086DEFB35AB8B4140D93F4E6D528554C0E9DD0726828E414004565DDB9F8354C034F46A25D9904140042A2F58AE8154C0A368AE1799924140223D7311917F54C010B15EB1B09341408E49DAEB5C7D54C0057D5E25159441407BC2E8B1277B54C0D5516591C2934140C3B73339077954C078232425BC924140933B1F87107754C0E62869020C914140FA0D3DFE567554C0ED6991D7C28E4140E6BCFB9CEB7354C02B5A7B38F78B4140E6387A55DC7254C0C5B3DCBCC488414099F01A85337254C0287D35ED4A85414048B4F290F77154C0054A8009AC814140'::geography, geometry, '0'::double precision, false) < '1e-05'::double precision))
Planning time : 0.848 ms
Execution time : 61.549 ms