Re: Help to understand Actual Rows vs Plan Rows from the query planner output

Hi, > This is a broad topic, and I can only give you some hints. Yes when I am reading this https://www.postgresql.org/docs/10/static/using-explain.html I found the doc said like “...Plan-reading is an art that requires some exper

Re: Help to understand Actual Rows vs Plan Rows from the query planner output

Arup Rakshit wrote: > Thanks for the link. I read the documentation you linked, and part of it > I understood and rest went above my head. Probably I need to read it multiple > times to understand what is going on. I am learning how indexing works in > DBMS. > Mostly I understood Btree so far. I a

Re: Help to understand Actual Rows vs Plan Rows from the query planner output

Hello Thomas, Thanks for the link. I read the documentation you linked, and part of it I understood and rest went above my head. Probably I need to read it multiple times to understand what is going on. I am learning how indexing works in DBMS. Mostly I understood Btree so far. I am an applicat

Re: Help to understand Actual Rows vs Plan Rows from the query planner output

On 09/23/2018 10:21 PM, Arup Rakshit wrote: > Hello I have some questions related to the query plan output about the > planned and actual rows. In the following example: > > # explain (analyze true, costs true, format yaml) select * from users > where lower(city) = 'melanyfort' and lower(state)