1/17/2024 0 Comments Postgresql analyzeTwo queries have similar plans as shown in diagram below. Note that with constraint_exclusion off, both these Here we look at the graphical explain plan of the two below queries querying against the demo pagila database. For analyze, you will see time metrics in the tip. On a section of the graph, a little tip will pop up showing the stats for that part of the graph. In terms of the graphical display - the raw display doesn't look too different between the 2, but if you click This feature gives you the approximate explain plan and does not include time since its approximate.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |