Question : Below is my Query: select * from ( SELECT * from Player where Country_Name in (1,2) ) as […]
Tag: explain
Postgres Row Level Security policy optimizes poorly compared to inline version
Question : I have a query which looks like this: SELECT post.id, post.author_id, post.published_at, post.content FROM post WHERE post.group_id = […]
Understanding postgres reason for picking this query plan
Question : I ran a query: select * from orderline where orderid = 12345 and status > 0 that gave […]
postgres explain plan with giant gaps between operations
Question : I have a postgresql explain plan that seems to have large gaps between the join, sort & filter […]
Postgresql, very long joins
Question : I have two tables Places and Redemptions (details in gist) https://gist.github.com/kunashir/2648e6e4d8a97aa2d03859b8ee08a394 And the query takes a lot of […]
Why is “select join insert” so much faster than “loop insert”?
Question : MySQL docs state that the time required for inserts has these approximate proportions: Connecting: (3) Sending query to […]
Does limit impact affected rows or not?
Question : I have this table: CREATE TABLE IF NOT EXISTS `usergroups` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` […]
mysql query choosing an incorrect execution plan
Question : I have a primary with an dependant subquery as a where condition that is choosing a wrong execution […]
Non-deterministic performance of query on select, from 1s to 60s on table with 1 billion rows
Question : I’m trying to investigate why the performance of this query is so non-deterministic. It can take anywhere from […]
Why search by date field requires engine to touch all records?
Question : Why search by date field requires engine to touch all records? Is there any way to avoid it? […]