Re: [GENERAL] Question regarding the output of postgresql *explain* command

2017-05-28 Thread Arup Rakshit
Hi Tom, Thanks, I’ll read this page. > On May 28, 2017, at 8:36 PM, Tom Lane wrote: > > Arup Rakshit writes: >> I was reading to day how indexing works. And I was trying some query, for >> example below one. What the range basically means

Re: [GENERAL] Question regarding the output of postgresql *explain* command

2017-05-28 Thread Tom Lane
Arup Rakshit writes: > I was reading to day how indexing works. And I was trying some query, for > example below one. What the range basically means (cost=0.28..8.30 ? I don’t > understand this. https://www.postgresql.org/docs/current/static/using-explain.html

[GENERAL] Question regarding the output of postgresql *explain* command

2017-05-28 Thread Arup Rakshit
Hi, I was reading to day how indexing works. And I was trying some query, for example below one. What the range basically means (cost=0.28..8.30 ? I don’t understand this. ——— arup@ror ~/part-time-projects/entrylvl (add_index_to_job_sources)$ rails db psql (9.5.0) Type "help" for