user avatar
user avatar
user avatar
St.Antario
  • Member for 7 years, 8 months
  • Last seen more than a month ago
66 votes
2 answers
35k views

Understanding "bitmap heap scan" and "bitmap index scan"

9 votes
1 answer
4k views

Hash Join vs Hash Semi Join

6 votes
1 answer
1k views

Fastest query for distinct IDs in a many-to-many relationship

4 votes
1 answer
2k views

DISTINCT ON vs ROW_NUMBER() for getting a row with a maximum value of a group

3 votes
0 answers
71 views

Understanding row estimation for timestamp in postgresql

2 votes
1 answer
962 views

Understanding index fillfactor

1 vote
0 answers
466 views

How does PostgreSQL compute the cost for index scan?

1 vote
0 answers
49 views

Why does SemiJoin node receive so bad statistic even after runnning ANALYZE

1 vote
1 answer
72 views

Understanding rows count computation

1 vote
0 answers
36 views

ROW_NUMBER() window_agg rows estimation

0 votes
0 answers
603 views

How does the PostgreSQL query planner estimate the aggregated rows count?

0 votes
1 answer
27 views

How does the correlation statistic parameter affect the cost of index scan?