3 ms·
> Then I ran EXPLAIN for both of them and the query plan is THE same. *according to a LLM. Did you verify this?
by notachatbot123 2y ago
> Then I ran EXPLAIN for both of them and the query plan is THE same.
*according to a LLM. Did you verify this?
- sgarland 2y agoMy god, this is where we’re at? Asking an LLM to hallucinate a schema and the resultant EXPLAIN plans for given queries? Postgres is incredibly easy to spin up in a container to test things like this, and the mentioned schema (Postgres Air) is also freely available.
- deleted 2y ago[deleted]
- jgalt212 2y agoseriously. I'd never ask an LLM a question I had no idea what the answer was.
- 0cf8612b2e1e 2y agoGlad you pointed this out. I was assuming author ran an actual explain. Not that the LLM made a guess.
- santiagobasulto 2y agoGuys, I ran an EXPLAIN in a dockerized postgres server. You can see it in the screenshot I shared. Why did you assume I was just trusting the LLM? Jeez, Hn.
- notachatbot123 2y agoI mean the actual EXPLAINs. Were they actually exactly 100% the same?