%20by%20%E2%80%9EZoish%E2%80%9D%2C%20licensed%20under%20%E2%80%9ECC0%201.0%E2%80%9D%20(https%3A%2F%2Fcreativecommons.org%2Fpublicdomain%2Fzero%2F1.0%2F)%3C%2Fdc%3Arights%3E%3C%2Frdf%3ADescription%3E%3C%2Frdf%3ARDF%3E%3C%2Fmetadata%3E%3Cmask%20id%3D%22viewboxMask%22%3E%3Crect%20width%3D%22560%22%20height%3D%22560%22%20rx%3D%22280%22%20ry%3D%22280%22%20x%3D%220%22%20y%3D%220%22%20fill%3D%22%23fff%22%20%2F%3E%3C%2Fmask%3E%3Cg%20mask%3D%22url(%23viewboxMask)%22%3E%3Crect%20fill%3D%22%23c0aede%22%20width%3D%22560%22%20height%3D%22560%22%20x%3D%220%22%20y%3D%220%22%20%2F%3E%3Cg%20transform%3D%22translate(136%20328)%22%3E%3Cpath%20d%3D%22M79.1%2076.2c7.7-15.2-6-20-13-28.8-12%2028.2-9.2%2055.9%206.1%2065%201.2-11.6-.3-23.8%207-36.2Z%22%20fill%3D%22%23fff%22%2F%3E%3Cpath%20fill-rule%3D%22evenodd%22%20clip-rule%3D%22evenodd%22%20d%3D%22M88.8%20107v-9.7c1-2%201.5-4.2%201.9-6.2.7-3.4%201.3-6.5%204.3-8.8%204.5-.1%208.3%201.9%2012.1%204%203.3%201.6%206.6%203.4%2010.3%203.8h1c3%20.5%206.3.9%207.8-3%201.6-4.1.2-7.7-3.8-9.5C103.6%2069%2091.2%2053.7%2078.9%2038c-8.4-10.9-20.8-8.3-28.4%203.9-11.2%2018-8.4%2037.6-5.8%2056l.1%201c2%2013.6%209.3%2027.7%2024.9%2033.3%2011.4%204%2018.4-.2%2019-12.2l.1-13ZM72.2%2053.5c6.5%205.8%2012.6%2011.3%207%2022.7-5.5%209.4-6%2018.7-6.4%2027.7a152%20152%200%200%201-.6%208.5c-15.3-9.1-18.2-36.8-6.1-65%201.8%202.2%204%204.2%206.1%206.1Z%22%20fill%3D%22%23000%22%2F%3E%3C%2Fg%3E%3Cg%20transform%3D%22translate(246%20125)%22%3E%3Cpath%20d%3D%22M82%2057.5c4.9-6%209.2-11.2%2013.8-16.2%202.5-2.8%206-4%209-1.2%203.5%203%201.3%205.8-.8%208.8C96%2060.4%2086%2070.1%2080.5%2083.4c-4%209.8-5.3%2019-2.3%2029.6%205.8%2019.9%2010.5%2040%2015.1%2060.2%203.3%2014.4-2.3%2023.8-16%2029-4%201.6-7.9%203.2-11.7%205-16.4%208-30.4%201.5-44.4-8.6%203.8-8%209.6-10.7%2018.5-5.7%208.7%205%2032.7.6%2039.6-6.8%204.5-5%201.4-9.7%200-14.4-5.8-19.7-14-38.7-15.6-59.8a68.6%2068.6%200%200%201%2018.4-54.4Z%22%20fill%3D%22%23000%22%2F%3E%3C%2Fg%3E%3Cg%20transform%3D%22translate(-45%20137)%22%3E%3Cpath%20d%3D%22M215.1%2076.6c5-12%209-29.4%2024.1-22.5%2020.7%209.4%2013.9%2030.7%209.7%2047.4-1.6%206.3-14.5%2015.9-18.3%2014.3-16.3-6.8-19.2-21.7-15.5-39.2ZM442%20113.4c-8.6%207.5-17%207.6-22.2-1.5-9-16-8.6-32.8%203.3-47.2%202.5-3%2013.8-3.6%2016.3-1%2014%2015%2014.6%2031.8%202.6%2049.7Z%22%20fill%3D%22%23000%22%2F%3E%3C%2Fg%3E%3Cg%20transform%3D%22translate(-45%20137)%22%3E%3C%2Fg%3E%3Cg%20transform%3D%22translate(119%20114)%22%3E%3Cpath%20d%3D%22M30.3%2032.1C58%2010%2089.8%2013.1%20121%2014.1c5.7%200%2012.2%201.3%2014.3%208.3%202.1%207.7-4.6%209.9-8.8%2013.8a44.7%2044.7%200%200%201-52.2%208.6%2037.9%2037.9%200%200%200-31.9%201.6c-2%201-3.8%201.9-5.8%202.6-6.3%202.5-14.3%206-18.6-.4-4.4-6.7%205.6-9%208.3-13.7.6-1%202-1.6%203.9-2.8ZM294.4%2023.8c7.7%204.3%2014.5%2010%2020%2017%202.5%203%205%206.3%203%2010.2-2.4%204.3-6.7%202.7-10.4%202.2-12.5-1.5-23.7-9.2-37-7.2-5%20.8-9.9.7-15%202.5-13%204.7-31-6.4-33-19.8-1-5.4%201-8.5%206.8-10%2022.2-5.7%2044-9%2065.6%205.1Z%22%20fill%3D%22%23000%22%2F%3E%3C%2Fg%3E%3C%2Fg%3E%3C%2Fsvg%3E)
Ravi Subramanian@ravi_s· Jun 23
EXPLAIN (ANALYZE, BUFFERS) is the most underused two words in backend engineering. Stop guessing why the query’s slow. The planner will literally tell you, with numbers, for free.
Loading
Log in to join the conversation.