In case you have your own slow SQL query, you can optimize it automatically here.
For the query above, the following recommendations will be helpful as part of the SQL tuning process.
You'll find 3 sections below:
CREATE INDEX categories_article_idx_category_id_article_id ON "categories_articles" ("category_id","article_id");
CREATE INDEX comments_idx_is_visible_is_banned_posted_dat ON "comments" ("is_visible","is_banned","posted_date" desc);
CREATE INDEX comments_idx_posted_date ON "comments" ("posted_date" desc);
SELECT
*
FROM
comments co
JOIN
categories_articles ca
ON ca.article_id = co.article_id
WHERE
ca.category_id = 1
AND co.is_visible = TRUE
AND co.is_banned = FALSE
ORDER BY
co.posted_date DESC LIMIT 20