QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Limit (cost=7.65..7.71 rows=25 width=60) (actual time=1.352..1.678 rows=25 loops=1) -> Sort (cost=7.65..7.84 rows=75 width=60) (actual time=1.344..1.428 rows=25 loops=1) Sort Key: number -> Append (cost=0.00..5.32 rows=75 width=60) (actual time=0.069..1.164 rows=25 loops=1) -> Subquery Scan "*SELECT* 1" (cost=0.00..1.72 rows=25 width=60) (actual time=0.063..0.877 rows=25 loops=1) -> Subquery Scan a (cost=0.00..1.47 rows=25 width=60) (actual time=0.052..0.651 rows=25 loops=1) -> Limit (cost=0.00..1.22 rows=25 width=60) (actual time=0.040..0.386 rows=25 loops=1) -> Index Scan Backward using mm_posrel_pkey on mm_posrel (cost=0.00..3675.54 rows=75595 width=60) (actual time=0.032..0.187 rows=25 loops=1) -> Subquery Scan "*SELECT* 2" (cost=0.00..1.80 rows=25 width=60) (actual time=0.031..0.031 rows=0 loops=1) -> Subquery Scan b (cost=0.00..1.55 rows=25 width=60) (actual time=0.023..0.023 rows=0 loops=1) -> Limit (cost=0.00..1.30 rows=25 width=60) (actual time=0.017..0.017 rows=0 loops=1) -> Index Scan Backward using mm_menu_item_pkey on mm_menu_item (cost=0.00..52.00 rows=1000 width=60) (actual time=0.009..0.009 rows=0 loops=1) -> Subquery Scan "*SELECT* 3" (cost=0.00..1.80 rows=25 width=60) (actual time=0.028..0.028 rows=0 loops=1) -> Subquery Scan c (cost=0.00..1.55 rows=25 width=60) (actual time=0.020..0.020 rows=0 loops=1) -> Limit (cost=0.00..1.30 rows=25 width=60) (actual time=0.013..0.013 rows=0 loops=1) -> Index Scan Backward using mm_cms_operation_pkey on mm_cms_operation (cost=0.00..52.00 rows=1000 width=60) (actual time=0.007..0.007 rows=0 loops=1) Total runtime: 2.077 ms (17 rows)