felix@xxxxxxxxxxx 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?
