felix(at)crowfix(dot)com writes:
> Usage is to match data from the key and val tables to fetch the data
> value from the sid table.
What is the relation between key and val tables?
Will key.id and val.id be equal?
I have never quite/fully understand the outputs of analyze, but I wonder why
you have:
> -> Nested Loop (cost=0.00..4467.01 rows=1001 width=20) (actual time=0.205..28.304 rows=1000 loops=1)
Why 1000 rows?
Does any of your conditions in the select returns many records?