Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
dekeract
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
3 ms
·
1.
▲
by
dekeract
11y ago
Since I know neither the schema nor the query you're running, I can only give you so much. You can look at costs to narrow in on a few spots. Lines 30-32 indicate that you are pulling a lot of data from buyclicks and transactions. This
2.
▲
by
dekeract
11y ago
Run an explain on that three page query, with analyze after some changes so you don't have to wait 12 hours. Put it into http://explain.depesz.com/ to see it in a prettier format, especially with analyze. Set up pgBadg