Failed to parse plan #748
Labels
Comments
|
Hello @AndriySysak What you pasted here is not the execution plan but the query. In case you don't know what an execution plan is, please read https://www.postgresql.org/docs/current/sql-explain.html Otherwise, in explain.dalibo.com or PEV2, please make sure you put the plan and the query in the adequate fields in the form. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
SELECT t0.serial
FROM (
SELECT DISTINCT s.serial
FROM serial_number_ranges AS s
) AS t
INNER JOIN (
SELECT t1.id, t1.range_high, t1.range_low, t1.serial
FROM (
SELECT s0.id, s0.range_high, s0.range_low, s0.serial
, ROW_NUMBER() OVER(PARTITION BY s0.serial ORDER BY s0.range_high - s0.range_low DESC) AS row
FROM serial_number_ranges AS s0
) AS t1
WHERE t1.row <= 2
) AS t0 ON t.serial = t0.serial
ORDER BY t0.range_high - t0.range_low DESC, t0.id
LIMIT 100
The text was updated successfully, but these errors were encountered: