GS
а как побился?
SELECT id, order_id,
source,
original_status,
status_time,
created_at
FROM
tbl_order_delivery_status_history_item
WHERE
order_id = 298218039
ORDER BY
created_at ASC;
explain (analyze, verbose) на него показывает:
Sort (cost=4178.05..4189.08 rows=4413 width=67) (actual time=0.081..0.087 rows=31 loops=1)
Output: id, order_id, source, original_status, status_time, created_at
Sort Key: tbl_order_delivery_status_history_item.created_at
Sort Method: quicksort Memory: 30kB
Buffers: shared hit=36
-> Index Scan using tbl_order_delivery_status_his_order_id_source_original_stat_idx on public.tbl_order_delivery_status_history_item (cost=0.70..3910.89 rows=4413 width=67) (actual time=0.020..0.070 rows=31 loops=1)
Output: id, order_id, source, original_status, status_time, created_at
Index Cond: (tbl_order_delivery_status_history_item.order_id = 298218039)
Buffers: shared hit=36
