add remove split language chart show hidden hide
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT 10
id
1
2
3
4
5
6
7
8
9
10
SELECT 10
QUERY PLAN
WindowAgg (cost=368.69..445.19 rows=2550 width=20) (actual time=0.129..0.132 rows=10 loops=1)
  -> WindowAgg (cost=368.69..413.32 rows=2550 width=12) (actual time=0.114..0.121 rows=10 loops=1)
        -> Sort (cost=368.69..375.07 rows=2550 width=8) (actual time=0.112..0.114 rows=10 loops=1)
              Sort Key: id
              Sort Method: quicksort Memory: 25kB
              -> WindowAgg (cost=179.78..224.41 rows=2550 width=8) (actual time=0.047..0.054 rows=10 loops=1)
                    -> Sort (cost=179.78..186.16 rows=2550 width=4) (actual time=0.032..0.033 rows=10 loops=1)
                          Sort Key: id DESC
                          Sort Method: quicksort Memory: 25kB
                          -> Seq Scan on q (cost=0.00..35.50 rows=2550 width=4) (actual time=0.010..0.011 rows=10 loops=1)
Planning Time: 0.275 ms
Execution Time: 0.568 ms
EXPLAIN