runs=1,2,3; rows measure=330, warmup=60; rows_match=0: 0
формат: медиана [p25–p75] (min–max), мс; буферы — медиана (min–max)

ping (SELECT 1), client_ms, n=30: 0.427 [0.342–0.504] (0.276–1.353)

variant | page | offset_rows | n | server_exec_ms | client_ms | planning_ms | shared_hit | shared_read | scan_node
offset | 1 | 0 | 30 | 0.037 [0.033–0.043] (0.027–0.081) | 0.486 [0.415–0.587] (0.346–1.915) | 0.026 [0.021–0.030] (0.017–0.044) | 23 (23–23) | 0 (0–0) | Index Scan Backward orders_created_at_id_idx
keyset | 1 | 0 | 30 | 0.042 [0.036–0.049] (0.026–0.087) | 0.448 [0.412–0.559] (0.368–1.986) | 0.028 [0.021–0.037] (0.016–0.061) | 23 (23–23) | 0 (0–0) | Index Scan Backward orders_created_at_id_idx
offset | 100 | 1980 | 30 | 0.660 [0.587–0.986] (0.370–2.036) | 1.031 [0.961–1.402] (0.728–3.565) | 0.027 [0.023–0.031] (0.015–0.090) | 2019 (2019–2019) | 0 (0–0) | Index Scan Backward orders_created_at_id_idx
keyset | 100 | 1980 | 30 | 0.034 [0.029–0.040] (0.025–0.052) | 0.518 [0.476–0.604] (0.396–1.901) | 0.061 [0.054–0.086] (0.045–0.122) | 23 (23–23) | 0 (0–0) | Index Scan Backward orders_created_at_id_idx
offset | 1000 | 19980 | 30 | 5.845 [5.414–7.148] (4.202–11.89) | 5.361 [4.990–6.814] (4.153–18.71) | 0.029 [0.023–0.030] (0.017–0.159) | 20157 (20157–20157) | 0 (0–0) | Index Scan Backward orders_created_at_id_idx
keyset | 1000 | 19980 | 30 | 0.038 [0.033–0.049] (0.028–0.072) | 0.530 [0.505–0.582] (0.426–1.095) | 0.060 [0.050–0.080] (0.028–0.116) | 23 (23–23) | 0 (0–0) | Index Scan Backward orders_created_at_id_idx
offset | 10000 | 199980 | 30 | 48.25 [42.78–71.58] (40.95–111.5) | 46.84 [43.20–58.75] (40.63–124.8) | 0.028 [0.021–0.030] (0.015–0.072) | 201535 (201535–201535) | 0 (0–0) | Index Scan Backward orders_created_at_id_idx
keyset | 10000 | 199980 | 30 | 0.044 [0.038–0.055] (0.032–0.280) | 0.506 [0.465–0.678] (0.376–2.405) | 0.059 [0.033–0.070] (0.026–0.293) | 23 (23–23) | 0 (0–0) | Index Scan Backward orders_created_at_id_idx
offset | 50000 | 999980 | 30 | 243.1 [215.5–281.4] (200.5–503.3) | 239.9 [211.9–307.9] (195.3–378.8) | 0.028 [0.023–0.031] (0.014–0.089) | 1007665 (1007665–1007665) | 0 (0–0) | Index Scan Backward orders_created_at_id_idx
keyset | 50000 | 999980 | 30 | 0.059 [0.040–0.066] (0.028–0.095) | 0.601 [0.537–0.681] (0.391–1.606) | 0.091 [0.085–0.096] (0.044–0.147) | 23 (23–23) | 0 (0–0) | Index Scan Backward orders_created_at_id_idx / Bitmap Heap Scan

медианы по прогонам (каждый прогон — свежий контейнер и свежая генерация), мс
variant | page | run 1 server | run 2 server | run 3 server | run 1 client | run 2 client | run 3 client | scan_node по прогонам
offset | 1 | 0.035 | 0.036 | 0.042 | 0.468 | 0.535 | 0.493 | Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx
keyset | 1 | 0.038 | 0.045 | 0.040 | 0.410 | 0.490 | 0.487 | Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx
offset | 100 | 0.596 | 0.838 | 0.834 | 0.965 | 1.305 | 1.269 | Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx
keyset | 100 | 0.029 | 0.036 | 0.037 | 0.488 | 0.566 | 0.512 | Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx
offset | 1000 | 5.624 | 6.697 | 6.133 | 4.910 | 6.812 | 5.926 | Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx
keyset | 1000 | 0.033 | 0.036 | 0.049 | 0.532 | 0.541 | 0.524 | Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx
offset | 10000 | 42.49 | 68.87 | 54.27 | 44.07 | 62.92 | 48.41 | Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx
keyset | 10000 | 0.043 | 0.051 | 0.041 | 0.495 | 0.641 | 0.491 | Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx
offset | 50000 | 222.4 | 272.7 | 245.1 | 219.1 | 243.2 | 257.0 | Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx / Index Scan Backward orders_created_at_id_idx
keyset | 50000 | 0.031 | 0.068 | 0.063 | 0.488 | 0.655 | 0.615 | Index Scan Backward orders_created_at_id_idx / Bitmap Heap Scan / Bitmap Heap Scan