Suppose I make a query like - SELECT * FROM table_name WHERE condition
I want to know how much disk space this queryset has consumed.
Asked
Active
Viewed 94 times
0
-
Did you try `EXPLAIN SELECT * FROM table_name WHERE condition ` ? – Blusky Sep 08 '21 at 09:20
-
Yes I tried it but I do not get the space – programmer Sep 08 '21 at 09:31
-
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. – Community Sep 13 '21 at 13:24
1 Answers
2
You can use explain (analyze,buffers) SELECT * FROM table_name WHERE condition that will give you information on all the blocks that were used, the temp ones show the direct usage by the query. You can get a little more information on this question
NuLo
- 1,298
- 1
- 11
- 16