UTC: 2026-10-07T14:01:48Z
Hypothesis: composite index improves late-page reads, with additional write cost.
100000 rows, distribution 90/9/1%; three reads and 1000-row rollback writes per index.
Limits: 1 CPU, 512MiB; single local Docker instance; no concurrent writes or PITR.
Image: sha256:ef257d85f76e48da1c64832459b59fcaba1a4dac97bf5d7450c77753542eee94
2c8e791d08fca312f52a40e082b18dc82676e891df57c04fbca1334d5edcfa26  cmd/server/app.go
8fabb622999b681eb42452bfd349f71b53ad979e41f2ae57189d34c099bb3ee2  cmd/server/app_test.go
7290636ea31539d87bd97bb78cb28658409da966be8983e748ce1701f6f9f8f6  cmd/server/commands.go
b0a0c1689dfe2db5abc889af13d7adb00a1d4f3d260b5ebe6d5f529cb5983a0e  cmd/server/healthcheck.go
900039906536a81de51dc45af3904a7e44b4739d56690dd59f915d03d092c7e9  cmd/server/healthcheck_test.go
43ad9caf2260d8551b8b3e149681c5e66770e9901d72de41b81746cb0cac47ec  cmd/server/logger.go
c22d8cdf4ce31fde29945e967d3f025e280a7dc4d2022329d51be972d2a0f495  cmd/server/main.go
06b304d8f0cad20c206edbef8becab283c50c1722fd81c56a06f018dfe03bb7f  cmd/server/persistence.go
aaf096a8c0abb9e6860d5cd620a5b0580c130276374a09f21ac3a7790273385f  cmd/server/persistence_test.go
41ef40897886c0878cbfe52f6716bdcb8433fb7eaddcfff298e1d54c55db423d  internal/admission/distributed.go
a373c9539167a4b7c35d45334d35ffd4e9d124c1740c88c12094fededd9643b4  internal/admission/limiter.go
d52fb501e76ddb23c645c1aaa599e32da9d01e50064c9ca97ac0e320ffc7f0c8  internal/admission/limiter_test.go
8cb675a0bef8b1645071e4cb85b79a467620e99b375db5d8d3e16a54b4c5b5fa  internal/config/config.go
0181673dcc4db2557783941aa8c5b3f61bc0ca6b5196d87e69df000346c40391  internal/config/config_test.go
e784d7b934c4604065cd00bf4ff2b0c74741e759b1b7c81162adfc206d160153  internal/config/controller.go
027761b059b76898a84318ec1a8b43158d8bafd6e0b15b52efbe902b4d8c5ea3  internal/config/environment.go
3a69e20a00fa2ed816f344a990e9e0ef0077e1607d4207858b4b00e4ff5d1988  internal/config/logger.go
86cdf9e90b576f4484946bfd9605333fc52077f38d3a39c5d71ddca4cdeecda0  internal/config/memory.go
671f92c52c827989ce194f3928b02f707292022bb97d3c483410e97cf626b4af  internal/config/persistence.go
7377c7fc286e04292b7c82e4e286cadf409ce833079f794a501456024e73434a  internal/config/persistence_test.go
af72da25fea9811c13a50c8133e9e8b35e070c5295069c40c0ae89cdc0aff19a  internal/controller/fx.go
3107673b329dbe7934a29679024a18e3baada2cc99bee4d0ddbba0f9fd93edf9  internal/controller/http/fiber/auth.go
960cd6ea803ea4ef9b0231ce557fc5e792921aae343f33da6e8aca12495da39f  internal/controller/http/fiber/auth_test.go
9c092ba7bca191f25c3ba9c9a5d1ca844126bee740a4c0262b776e947263ac68  internal/controller/http/fiber/chats_test.go
be356cf26c228958d51f5bafa4305d7325e81ab01065575acbc9b2d7a6ddd4bd  internal/controller/http/fiber/configure.go
fd0d06ac838c8ceca1189303b98ce006ca1298381de49fe6d790d0f0f4007d3e  internal/controller/http/fiber/controller.go
151fb360bc3f7309678961b7739c5d905f3430bc4e63fb6c9b26495e12ab7227  internal/controller/http/fiber/controller_test.go
bb4216cb6c5813b66b51dc99a53f8cf09982789155305a099c321dd12fa8e2de  internal/controller/http/fiber/decode.go
6ee07f110bdb29d8d2191ab8889ba60474b33a5b225739875c8a57d8434be15d  internal/controller/http/fiber/dependencies.go
3351a019c43d0360ee0fd68afabb5200422d065ae7bd908b1c0a5c02a0c1ad41  internal/controller/http/fiber/error_codes.go
9d5da8d98ece2706e324cb2deca915e0811b6ad98f7aaac5805ca0f3cc0a1f9a  internal/controller/http/fiber/error_registry.go
d502e2a9f7fe3980c10c2760c31711794898c539d07b43b02497dc2cfb870358  internal/controller/http/fiber/errors.go
81e95e02b6e41929bf8e73f65e2d4921fc6471293815d590d38ad7d849106f3c  internal/controller/http/fiber/errors_test.go
49bb58b260f2df9473d8e0ae01b8c3c742e4266db00d64fe5e999730aba42a80  internal/controller/http/fiber/fixtures_auth_test.go
59e3f16adc94b7426c74e2f40b5ff18a9129c80fc619cb8144110bdeec095021  internal/controller/http/fiber/handlers.go
d32a9a01a8b391f4d986e14947a25a0504f4363335ea1524df05e0dd8e9e61bd  internal/controller/http/fiber/headers.go
6d18f3c4be98e70a7e61d82b014b6db9b3a5e594c9b5f50ecea88f89bd6917cd  internal/controller/http/fiber/health.go
f39cf7a0049a2ed39d6cc1fcc66b44656d9d6120914d0e973b032e12f3d0de08  internal/controller/http/fiber/lifecycle.go
496f50e5693456574614b8a47086a550018884adb37919ce82abf8c4e7e5254d  internal/controller/http/fiber/lifecycle_test.go
f63d4b0e2ee5f62c4d0d8c4b26a8734d68230af4577e3c6cb71a92525c3c8681  internal/controller/http/fiber/mapping.go
d848e00aff04d7a3339ca1847f47cad59fb7c05085f6cfb1965b27df516acdd6  internal/controller/http/fiber/messages_test.go
34fd687af80730601ba9276ef606fee76df84d14b4400a65ec5b804897673536  internal/controller/http/fiber/middleware.go
5259d44ea6c7d4e1776f5b66e00408d1450fdf859e2017bf14937d3020f3dcff  internal/controller/http/fiber/middleware_test.go
d806c2d026a8ff2fc54d60b62c062e80a3532e652fcfa5c3105684ba17cc9f67  internal/controller/http/fiber/public_errors.go
47089b63442f02d6e637a8dd785e323e97efb15fd82d2ffa303e7e10de4876cd  internal/controller/http/fiber/public_errors_test.go
826fe61b8d59465de7190c175b6abaa118f4a7deacdb1b9c628e25bb7f4feb3b  internal/controller/http/fiber/routes.go
0b3fad8fc87f561573bf4ee906a48a8fb317385ecc7600bdca3cc61992fa9253  internal/controller/http/fiber/users_test.go
24b6b06d6fab919cd2130697b44fd0d358265184dca0ca8362e0b4fcc2ae5a68  internal/controller/interface.go
a5bc7aac6d1764929fb11365c9f8b6a45ff65e47b3a317a7ccd9ec6dd1b2713a  internal/cursor/codec.go
a611b59197a205fd21fd94077577f2db7024266cd5ce8a5bfb18a85196bd357b  internal/cursor/codec_test.go
e205901cec2e66011ec764b70879b0eb0d28a78c4dea8913a9fb30c2d778fa8c  internal/hashring/ring.go
606cdf84342b97a63eedfb9cd37aa7c99a489eee54641d8645be930a9ce6be0d  internal/hashring/ring_test.go
e2ecd732848d10f4471567c9603aa7359fcb1af7b2708ead477f4949f7a2fa4a  internal/model/dto/models.go
896a694b0c217240343077d4287f4a6e447338c38571abbebcb3d16a519137fb  internal/model/dto/session.go
8c183b065bc3ab4cad20570eab79f334ca75a3309186fdf832fb1aa598894465  internal/model/http/models.go
fe2df6990331573bbf0202ebc81c58263a7c16a29b713eefa0f0e852e4ee4a76  internal/password/password.go
1ad8dcb7d055fcb8da56d10e1089b47fe1b9cbf848381ded1a4048f8fd41278a  internal/password/password_test.go
ede0474befff6773779dd448e9b42a98bd2edb12033b65366e5f65618ec4885e  internal/service/auth.go
1cc82be87998dc9b66216965dc3ac37aa6c210c1007fc46a2a0bd698e9cb6167  internal/service/authentication/service.go
c77137c6799dc1f9012387e45c21414ced2d7e0923b6f2750a09f61b76c6523a  internal/service/authentication/service_test.go
55baf7ba65292ae6a75b7a6af8d304886f35c7ad854b8d700251d6f32c964dbf  internal/service/cache.go
07244e89d9948087318df2dfecfb3a648c217bc313fb033748f5562e08ba8a95  internal/service/cursor.go
e19c47379f63a5ee7e24b9b0fded1eb326ea231392b4e27c324d205d4c620f7d  internal/service/errors.go
017b13007719a32a8eec26527848231381590e5632790bedec66a126776bad6e  internal/service/interface.go
fc191b98aaf0488cb60f258c3ce9788708818c7f299a10f80e91568adabd05e5  internal/service/production/access.go
af0659140715e467ab15388cc75aea8b2ff09b8edbbd5dc90aa6d3f5c24bf5bf  internal/service/production/cache_test.go
881f9269ad84ab5dc091fdec8ad6c36bebd2eaac0da0685b8d333216e0a2dd16  internal/service/production/chats.go
8eb5b603aeb7be2d5e5af859762610e26c8ad7c05fa222e04802950dd71f9c21  internal/service/production/chats_page_test.go
e7d4fa61a14f7cb4ba421ed5e83d794a85b42fac597e269807d564c830e2cbb8  internal/service/production/chats_test.go
fe5940f705df32902151d51f82c7f9f1df3e274e62413d9e1b54f2a512707d48  internal/service/production/creation.go
7495818188cc13028d9400dfa18005e9aa334ac048b7a84150dd2b6ddb28d796  internal/service/production/errors.go
007b27ba3005a3040283b35b7640523bc8ae04ada89b2731396b1559c3b20075  internal/service/production/fixture_test.go
1f5c9335bf4cf5b9f4137454e3ca22975e7c6c7118e4e60bb470851f8a7cd61e  internal/service/production/members.go
6bdd523dd8be7ce139a0a7f2c9ee16d8d2f03e4d15ed00e7a31658c23fb97c17  internal/service/production/messages.go
7b82f74aedb2f26079cce497778302246e9166c365508e37266a97078df5ca5c  internal/service/production/messages_page_test.go
6722838a6c117f76fb2710d664ec4ce9945479f18013af18437cf93814351d93  internal/service/production/messages_test.go
4306cd592bdcd2dd5c31eeadc0dc5e1a59b275ffa6de091032edf644171020c5  internal/service/production/pages.go
f0611bc8ad150fcac5505a6696bd293a144274431fb71b3e96f16a8229b85bcc  internal/service/production/pages_test.go
4cb0d47ef9cc020e608f93a8257b6d65136f6f74b86c3f591f19dad688fc7bf0  internal/service/production/pagination.go
1886cbbaa88de20d0e21bf6c1c35fde64164547fa86c1fb74860c93f59b5fc9b  internal/service/production/pagination_test.go
70fb90d812432e321c4fca1b1e2141cfad91453e294f4efda60c0898be686d7d  internal/service/production/service.go
b8ab1e6e92a365f38fb5ac660e311a00fea6a458c6c9cd9c8184dbaebb419f50  internal/service/production/service_test.go
50d873980bdc97a799c2e61a4b25c5bd222a32bd7baed28590510ef373ac0461  internal/service/production/users.go
04e0cb7a51877014ef23a8063ca435e3eb5e98fb78902ff166abc08139287315  internal/service/production/users_test.go
6aa0ff490fe8fca8b906b5073e0914a64369ddfc7d0648d895cc41cb69cdd2e0  internal/service/production/validation.go
ea599de0e0d2a0be7de7b0835307a4d1852db16a49bfad3636f7c30b85181fce  internal/store/interface.go
ac2aafe9f19706ff39b16a4ca1b1e142f6e52bef160ef591f9f2120d106ffd51  internal/store/memory/capacity.go
150851ac6a0d5da8835a9aaaa7c1156b075e5e3dd962698fb483b0afa8a2097f  internal/store/memory/chats.go
3036029e86462d8cf52aad993c4f9eff62a5cf0454e757b871abfd5b4902c9f5  internal/store/memory/chats_test.go
94f2a5ce429aa8280e1333760309fd1d02b314310cbdea495aef56a63ed145b1  internal/store/memory/messages.go
76f977bbabec7550093ca9d376efc9686345198cbee5e13ce31d38dcd425a469  internal/store/memory/messages_test.go
4aef07be1cb907cfa7a4a3d78060d8be57c9ff566c16e729dea9b0db68c7dfae  internal/store/memory/ordering.go
f463d530955bfe5793fb9a4ad93d6615a3ce923d1d4719b8c515f487c96997ca  internal/store/memory/store.go
b7f8237e22eac473ad47cd879238aed7ed16e08b28a6ff3029ddcc58072dfe0e  internal/store/memory/store_test.go
1652a23bc8fc29a6ef00851a19d4547b660f3bfcce9d458b7381db5b3f30778c  internal/store/memory/users.go
dc9a73504116b7e54d38a4e3b8c88ed1aa4c1144efdb9bb3ac671e0e1182d9a3  internal/store/memory/users_test.go
b9d69046cd919957434da02c635d259c8e36f27371270afedc312947eb5bb615  internal/store/postgres/chats.go
1ab5dd2f8d81697a57ee89e1969995e52bfccc0f3f25a5c480822e41313988f1  internal/store/postgres/messages.go
8b8bf6a255cc48cee4b3e4adc94c23cf6955ecf5dfba689bba973dfccbd1b1cb  internal/store/postgres/migrations/001_initial.sql
6f7f2e86822d806640888da990716279659fe90e5a74b3b0d5454a5155d0334b  internal/store/postgres/sessions.go
5f3e022a414103198a1ab8e62f337e67c22afd1afddda400884b79a5e51488a2  internal/store/postgres/store.go
538f1739eae4c276aa6b5df9aa8c4f4c3aca4a3043a71650256f257ffaaed029  internal/store/postgres/store_test.go
2721381975755efe2a4f14a8df3c1189d2dcc6c7933fc25292977014c26aa220  internal/store/postgres/users.go
ef9bfaf3bd684fded87c92a15b3e5c706a794caf04cc4ef711c4185e9c7fb12a  internal/strictjson/decode.go
ea6273526572b4bfcf681ef2659ea2c1ec74bfedeb5e9bdbd83ebfabe0647bf9  internal/strictjson/decode_test.go
4baa4e399be201189371d1ace6169e56958251386624af4996fac04e0ab5d1f7  internal/valkey/admission.go
693b866a740b6d5f765221be4c6489391821d4b58942cf0ff36030163dbae6a9  internal/valkey/cache.go
86acf0827e1d29993eda7ee62a8fa42b02d707330a94a70f5a3933911407e882  internal/valkey/client.go
b39e08ecc720e1d4fc81d342fa15192c0a0a82e849231161c1e0d2da2d8f625d  internal/valkey/client_test.go
5ea8c967f238b30a5f54ced22b0318832254ff99e5bcc4af145aee08d7f8c8da  scripts/research.sh
f47019141be4ac06d912cbd4281d94d181625a08637801627e897633bb20a124  student-tests/plans.sql
f7ca02dfce0db42f72594d794eda5821a9125e7a2b6966df731f32869a5f0b43  student-tests/research.sql
Timing is on.
PostgreSQL 17.6 on aarch64-unknown-linux-musl, compiled by gcc (Alpine 14.2.0) 14.2.0, 64-bit
Time: 0.459 ms
INSERT 0 1
Time: 0.790 ms
INSERT 0 3
Time: 1.172 ms
INSERT 0 3
Time: 0.978 ms
INSERT 0 100000
Time: 1729.487 ms (00:01.729)
DROP INDEX
Time: 1.273 ms
CREATE INDEX
Time: 13.915 ms
VARIANT: chat_only
ANALYZE
Time: 35.241 ms
[
  {
    "Plan": {
      "Node Type": "Limit",
      "Parallel Aware": false,
      "Async Capable": false,
      "Startup Cost": 3686.59,
      "Total Cost": 3686.72,
      "Plan Rows": 51,
      "Plan Width": 71,
      "Actual Startup Time": 4.354,
      "Actual Total Time": 4.358,
      "Actual Rows": 51,
      "Actual Loops": 1,
      "Shared Hit Blocks": 1235,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0,
      "Plans": [
        {
          "Node Type": "Sort",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Startup Cost": 3686.59,
          "Total Cost": 3720.43,
          "Plan Rows": 13536,
          "Plan Width": 71,
          "Actual Startup Time": 4.354,
          "Actual Total Time": 4.355,
          "Actual Rows": 51,
          "Actual Loops": 1,
          "Sort Key": ["created_at", "id"],
          "Sort Method": "top-N heapsort",
          "Sort Space Used": 31,
          "Sort Space Type": "Memory",
          "Shared Hit Blocks": 1235,
          "Shared Read Blocks": 0,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0,
          "Plans": [
            {
              "Node Type": "Seq Scan",
              "Parent Relationship": "Outer",
              "Parallel Aware": false,
              "Async Capable": false,
              "Relation Name": "messages",
              "Alias": "messages",
              "Startup Cost": 0.00,
              "Total Cost": 3235.00,
              "Plan Rows": 13536,
              "Plan Width": 71,
              "Actual Startup Time": 3.486,
              "Actual Total Time": 4.129,
              "Actual Rows": 5000,
              "Actual Loops": 1,
              "Filter": "((chat_id = 'c4ca4238-a0b9-2382-0dcc-509a6f75849b'::uuid) AND (ROW(created_at, id) > ROW(('2026-01-01 00:00:00+00'::timestamp with time zone + '00:00:00.085'::interval), 'dedbbd60-c592-c7ad-b64f-8ef8f0a025dc'::uuid)))",
              "Rows Removed by Filter": 95000,
              "Shared Hit Blocks": 1235,
              "Shared Read Blocks": 0,
              "Shared Dirtied Blocks": 0,
              "Shared Written Blocks": 0,
              "Local Hit Blocks": 0,
              "Local Read Blocks": 0,
              "Local Dirtied Blocks": 0,
              "Local Written Blocks": 0,
              "Temp Read Blocks": 0,
              "Temp Written Blocks": 0
            }
          ]
        }
      ]
    },
    "Planning": {
      "Shared Hit Blocks": 33,
      "Shared Read Blocks": 1,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0
    },
    "Planning Time": 0.132,
    "Triggers": [
    ],
    "Execution Time": 4.380
  }
]
BEGIN
[
  {
    "Plan": {
      "Node Type": "ModifyTable",
      "Operation": "Insert",
      "Parallel Aware": false,
      "Async Capable": false,
      "Relation Name": "messages",
      "Alias": "messages",
      "Startup Cost": 0.00,
      "Total Cost": 37.50,
      "Plan Rows": 0,
      "Plan Width": 0,
      "Actual Startup Time": 3.636,
      "Actual Total Time": 3.636,
      "Actual Rows": 0,
      "Actual Loops": 1,
      "Shared Hit Blocks": 6037,
      "Shared Read Blocks": 3,
      "Shared Dirtied Blocks": 22,
      "Shared Written Blocks": 19,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0,
      "Plans": [
        {
          "Node Type": "Function Scan",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Function Name": "generate_series",
          "Alias": "n",
          "Startup Cost": 0.00,
          "Total Cost": 37.50,
          "Plan Rows": 1000,
          "Plan Width": 88,
          "Actual Startup Time": 0.034,
          "Actual Total Time": 1.017,
          "Actual Rows": 1000,
          "Actual Loops": 1,
          "Shared Hit Blocks": 0,
          "Shared Read Blocks": 0,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0
        }
      ]
    },
    "Planning": {
      "Shared Hit Blocks": 0,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0
    },
    "Planning Time": 0.048,
    "Triggers": [
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16431",
        "Constraint Name": "messages_chat_id_fkey",
        "Relation": "messages",
        "Time": 5.081,
        "Calls": 1000
      },
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16436",
        "Constraint Name": "messages_sender_id_fkey",
        "Relation": "messages",
        "Time": 4.982,
        "Calls": 1000
      },
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16441",
        "Constraint Name": "messages_chat_id_sender_id_fkey",
        "Relation": "messages",
        "Time": 5.075,
        "Calls": 1000
      }
    ],
    "Execution Time": 18.904
  }
]
ROLLBACK
Time: 24.006 ms
[
  {
    "Plan": {
      "Node Type": "Limit",
      "Parallel Aware": false,
      "Async Capable": false,
      "Startup Cost": 3725.42,
      "Total Cost": 3725.55,
      "Plan Rows": 51,
      "Plan Width": 71,
      "Actual Startup Time": 4.327,
      "Actual Total Time": 4.331,
      "Actual Rows": 51,
      "Actual Loops": 1,
      "Shared Hit Blocks": 1248,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0,
      "Plans": [
        {
          "Node Type": "Sort",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Startup Cost": 3725.42,
          "Total Cost": 3759.62,
          "Plan Rows": 13679,
          "Plan Width": 71,
          "Actual Startup Time": 4.327,
          "Actual Total Time": 4.328,
          "Actual Rows": 51,
          "Actual Loops": 1,
          "Sort Key": ["created_at", "id"],
          "Sort Method": "top-N heapsort",
          "Sort Space Used": 31,
          "Sort Space Type": "Memory",
          "Shared Hit Blocks": 1248,
          "Shared Read Blocks": 0,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0,
          "Plans": [
            {
              "Node Type": "Seq Scan",
              "Parent Relationship": "Outer",
              "Parallel Aware": false,
              "Async Capable": false,
              "Relation Name": "messages",
              "Alias": "messages",
              "Startup Cost": 0.00,
              "Total Cost": 3269.06,
              "Plan Rows": 13679,
              "Plan Width": 71,
              "Actual Startup Time": 3.501,
              "Actual Total Time": 4.113,
              "Actual Rows": 5000,
              "Actual Loops": 1,
              "Filter": "((chat_id = 'c4ca4238-a0b9-2382-0dcc-509a6f75849b'::uuid) AND (ROW(created_at, id) > ROW(('2026-01-01 00:00:00+00'::timestamp with time zone + '00:00:00.085'::interval), 'dedbbd60-c592-c7ad-b64f-8ef8f0a025dc'::uuid)))",
              "Rows Removed by Filter": 95000,
              "Shared Hit Blocks": 1248,
              "Shared Read Blocks": 0,
              "Shared Dirtied Blocks": 0,
              "Shared Written Blocks": 0,
              "Local Hit Blocks": 0,
              "Local Read Blocks": 0,
              "Local Dirtied Blocks": 0,
              "Local Written Blocks": 0,
              "Temp Read Blocks": 0,
              "Temp Written Blocks": 0
            }
          ]
        }
      ]
    },
    "Planning": {
      "Shared Hit Blocks": 0,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0
    },
    "Planning Time": 0.080,
    "Triggers": [
    ],
    "Execution Time": 4.347
  }
]
BEGIN
[
  {
    "Plan": {
      "Node Type": "ModifyTable",
      "Operation": "Insert",
      "Parallel Aware": false,
      "Async Capable": false,
      "Relation Name": "messages",
      "Alias": "messages",
      "Startup Cost": 0.00,
      "Total Cost": 37.50,
      "Plan Rows": 0,
      "Plan Width": 0,
      "Actual Startup Time": 3.093,
      "Actual Total Time": 3.093,
      "Actual Rows": 0,
      "Actual Loops": 1,
      "Shared Hit Blocks": 7044,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 15,
      "Shared Written Blocks": 15,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0,
      "Plans": [
        {
          "Node Type": "Function Scan",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Function Name": "generate_series",
          "Alias": "n",
          "Startup Cost": 0.00,
          "Total Cost": 37.50,
          "Plan Rows": 1000,
          "Plan Width": 88,
          "Actual Startup Time": 0.041,
          "Actual Total Time": 0.944,
          "Actual Rows": 1000,
          "Actual Loops": 1,
          "Shared Hit Blocks": 0,
          "Shared Read Blocks": 0,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0
        }
      ]
    },
    "Planning": {
      "Shared Hit Blocks": 0,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0
    },
    "Planning Time": 0.035,
    "Triggers": [
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16431",
        "Constraint Name": "messages_chat_id_fkey",
        "Relation": "messages",
        "Time": 4.676,
        "Calls": 1000
      },
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16436",
        "Constraint Name": "messages_sender_id_fkey",
        "Relation": "messages",
        "Time": 4.557,
        "Calls": 1000
      },
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16441",
        "Constraint Name": "messages_chat_id_sender_id_fkey",
        "Relation": "messages",
        "Time": 4.767,
        "Calls": 1000
      }
    ],
    "Execution Time": 17.223
  }
]
ROLLBACK
Time: 21.961 ms
[
  {
    "Plan": {
      "Node Type": "Limit",
      "Parallel Aware": false,
      "Async Capable": false,
      "Startup Cost": 3767.18,
      "Total Cost": 3767.31,
      "Plan Rows": 51,
      "Plan Width": 71,
      "Actual Startup Time": 4.047,
      "Actual Total Time": 4.051,
      "Actual Rows": 51,
      "Actual Loops": 1,
      "Shared Hit Blocks": 1262,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0,
      "Plans": [
        {
          "Node Type": "Sort",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Startup Cost": 3767.18,
          "Total Cost": 3801.76,
          "Plan Rows": 13832,
          "Plan Width": 71,
          "Actual Startup Time": 4.047,
          "Actual Total Time": 4.049,
          "Actual Rows": 51,
          "Actual Loops": 1,
          "Sort Key": ["created_at", "id"],
          "Sort Method": "top-N heapsort",
          "Sort Space Used": 31,
          "Sort Space Type": "Memory",
          "Shared Hit Blocks": 1262,
          "Shared Read Blocks": 0,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0,
          "Plans": [
            {
              "Node Type": "Seq Scan",
              "Parent Relationship": "Outer",
              "Parallel Aware": false,
              "Async Capable": false,
              "Relation Name": "messages",
              "Alias": "messages",
              "Startup Cost": 0.00,
              "Total Cost": 3305.72,
              "Plan Rows": 13832,
              "Plan Width": 71,
              "Actual Startup Time": 3.225,
              "Actual Total Time": 3.843,
              "Actual Rows": 5000,
              "Actual Loops": 1,
              "Filter": "((chat_id = 'c4ca4238-a0b9-2382-0dcc-509a6f75849b'::uuid) AND (ROW(created_at, id) > ROW(('2026-01-01 00:00:00+00'::timestamp with time zone + '00:00:00.085'::interval), 'dedbbd60-c592-c7ad-b64f-8ef8f0a025dc'::uuid)))",
              "Rows Removed by Filter": 95000,
              "Shared Hit Blocks": 1262,
              "Shared Read Blocks": 0,
              "Shared Dirtied Blocks": 0,
              "Shared Written Blocks": 0,
              "Local Hit Blocks": 0,
              "Local Read Blocks": 0,
              "Local Dirtied Blocks": 0,
              "Local Written Blocks": 0,
              "Temp Read Blocks": 0,
              "Temp Written Blocks": 0
            }
          ]
        }
      ]
    },
    "Planning": {
      "Shared Hit Blocks": 0,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0
    },
    "Planning Time": 0.048,
    "Triggers": [
    ],
    "Execution Time": 4.062
  }
]
BEGIN
[
  {
    "Plan": {
      "Node Type": "ModifyTable",
      "Operation": "Insert",
      "Parallel Aware": false,
      "Async Capable": false,
      "Relation Name": "messages",
      "Alias": "messages",
      "Startup Cost": 0.00,
      "Total Cost": 37.50,
      "Plan Rows": 0,
      "Plan Width": 0,
      "Actual Startup Time": 2.858,
      "Actual Total Time": 2.859,
      "Actual Rows": 0,
      "Actual Loops": 1,
      "Shared Hit Blocks": 7056,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 14,
      "Shared Written Blocks": 14,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0,
      "Plans": [
        {
          "Node Type": "Function Scan",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Function Name": "generate_series",
          "Alias": "n",
          "Startup Cost": 0.00,
          "Total Cost": 37.50,
          "Plan Rows": 1000,
          "Plan Width": 88,
          "Actual Startup Time": 0.028,
          "Actual Total Time": 0.876,
          "Actual Rows": 1000,
          "Actual Loops": 1,
          "Shared Hit Blocks": 0,
          "Shared Read Blocks": 0,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0
        }
      ]
    },
    "Planning": {
      "Shared Hit Blocks": 0,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0
    },
    "Planning Time": 0.036,
    "Triggers": [
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16431",
        "Constraint Name": "messages_chat_id_fkey",
        "Relation": "messages",
        "Time": 4.890,
        "Calls": 1000
      },
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16436",
        "Constraint Name": "messages_sender_id_fkey",
        "Relation": "messages",
        "Time": 4.752,
        "Calls": 1000
      },
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16441",
        "Constraint Name": "messages_chat_id_sender_id_fkey",
        "Relation": "messages",
        "Time": 5.050,
        "Calls": 1000
      }
    ],
    "Execution Time": 17.684
  }
]
ROLLBACK
Time: 22.065 ms
Time: 0.119 ms
DROP INDEX
Time: 1.160 ms
CREATE INDEX
Time: 25.346 ms
VARIANT: history_keyset
ANALYZE
Time: 29.509 ms
[
  {
    "Plan": {
      "Node Type": "Limit",
      "Parallel Aware": false,
      "Async Capable": false,
      "Startup Cost": 0.42,
      "Total Cost": 11.77,
      "Plan Rows": 51,
      "Plan Width": 71,
      "Actual Startup Time": 0.019,
      "Actual Total Time": 0.024,
      "Actual Rows": 51,
      "Actual Loops": 1,
      "Shared Hit Blocks": 2,
      "Shared Read Blocks": 3,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0,
      "Plans": [
        {
          "Node Type": "Index Scan",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Scan Direction": "Forward",
          "Index Name": "candidate",
          "Relation Name": "messages",
          "Alias": "messages",
          "Startup Cost": 0.42,
          "Total Cost": 2986.47,
          "Plan Rows": 13418,
          "Plan Width": 71,
          "Actual Startup Time": 0.019,
          "Actual Total Time": 0.022,
          "Actual Rows": 51,
          "Actual Loops": 1,
          "Index Cond": "((chat_id = 'c4ca4238-a0b9-2382-0dcc-509a6f75849b'::uuid) AND (ROW(created_at, id) > ROW(('2026-01-01 00:00:00+00'::timestamp with time zone + '00:00:00.085'::interval), 'dedbbd60-c592-c7ad-b64f-8ef8f0a025dc'::uuid)))",
          "Rows Removed by Index Recheck": 0,
          "Shared Hit Blocks": 2,
          "Shared Read Blocks": 3,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0
        }
      ]
    },
    "Planning": {
      "Shared Hit Blocks": 28,
      "Shared Read Blocks": 1,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0
    },
    "Planning Time": 0.145,
    "Triggers": [
    ],
    "Execution Time": 0.034
  }
]
BEGIN
[
  {
    "Plan": {
      "Node Type": "ModifyTable",
      "Operation": "Insert",
      "Parallel Aware": false,
      "Async Capable": false,
      "Relation Name": "messages",
      "Alias": "messages",
      "Startup Cost": 0.00,
      "Total Cost": 37.50,
      "Plan Rows": 0,
      "Plan Width": 0,
      "Actual Startup Time": 3.555,
      "Actual Total Time": 3.555,
      "Actual Rows": 0,
      "Actual Loops": 1,
      "Shared Hit Blocks": 8094,
      "Shared Read Blocks": 3,
      "Shared Dirtied Blocks": 29,
      "Shared Written Blocks": 26,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0,
      "Plans": [
        {
          "Node Type": "Function Scan",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Function Name": "generate_series",
          "Alias": "n",
          "Startup Cost": 0.00,
          "Total Cost": 37.50,
          "Plan Rows": 1000,
          "Plan Width": 88,
          "Actual Startup Time": 0.032,
          "Actual Total Time": 0.919,
          "Actual Rows": 1000,
          "Actual Loops": 1,
          "Shared Hit Blocks": 0,
          "Shared Read Blocks": 0,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0
        }
      ]
    },
    "Planning": {
      "Shared Hit Blocks": 0,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0
    },
    "Planning Time": 0.028,
    "Triggers": [
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16431",
        "Constraint Name": "messages_chat_id_fkey",
        "Relation": "messages",
        "Time": 4.942,
        "Calls": 1000
      },
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16436",
        "Constraint Name": "messages_sender_id_fkey",
        "Relation": "messages",
        "Time": 4.895,
        "Calls": 1000
      },
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16441",
        "Constraint Name": "messages_chat_id_sender_id_fkey",
        "Relation": "messages",
        "Time": 5.082,
        "Calls": 1000
      }
    ],
    "Execution Time": 18.613
  }
]
ROLLBACK
Time: 19.066 ms
[
  {
    "Plan": {
      "Node Type": "Limit",
      "Parallel Aware": false,
      "Async Capable": false,
      "Startup Cost": 0.42,
      "Total Cost": 11.78,
      "Plan Rows": 51,
      "Plan Width": 71,
      "Actual Startup Time": 0.013,
      "Actual Total Time": 0.020,
      "Actual Rows": 51,
      "Actual Loops": 1,
      "Shared Hit Blocks": 5,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0,
      "Plans": [
        {
          "Node Type": "Index Scan",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Scan Direction": "Forward",
          "Index Name": "candidate",
          "Relation Name": "messages",
          "Alias": "messages",
          "Startup Cost": 0.42,
          "Total Cost": 3020.50,
          "Plan Rows": 13554,
          "Plan Width": 71,
          "Actual Startup Time": 0.013,
          "Actual Total Time": 0.017,
          "Actual Rows": 51,
          "Actual Loops": 1,
          "Index Cond": "((chat_id = 'c4ca4238-a0b9-2382-0dcc-509a6f75849b'::uuid) AND (ROW(created_at, id) > ROW(('2026-01-01 00:00:00+00'::timestamp with time zone + '00:00:00.085'::interval), 'dedbbd60-c592-c7ad-b64f-8ef8f0a025dc'::uuid)))",
          "Rows Removed by Index Recheck": 0,
          "Shared Hit Blocks": 5,
          "Shared Read Blocks": 0,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0
        }
      ]
    },
    "Planning": {
      "Shared Hit Blocks": 0,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0
    },
    "Planning Time": 0.054,
    "Triggers": [
    ],
    "Execution Time": 0.029
  }
]
BEGIN
[
  {
    "Plan": {
      "Node Type": "ModifyTable",
      "Operation": "Insert",
      "Parallel Aware": false,
      "Async Capable": false,
      "Relation Name": "messages",
      "Alias": "messages",
      "Startup Cost": 0.00,
      "Total Cost": 37.50,
      "Plan Rows": 0,
      "Plan Width": 0,
      "Actual Startup Time": 3.419,
      "Actual Total Time": 3.419,
      "Actual Rows": 0,
      "Actual Loops": 1,
      "Shared Hit Blocks": 8061,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 15,
      "Shared Written Blocks": 15,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0,
      "Plans": [
        {
          "Node Type": "Function Scan",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Function Name": "generate_series",
          "Alias": "n",
          "Startup Cost": 0.00,
          "Total Cost": 37.50,
          "Plan Rows": 1000,
          "Plan Width": 88,
          "Actual Startup Time": 0.032,
          "Actual Total Time": 0.918,
          "Actual Rows": 1000,
          "Actual Loops": 1,
          "Shared Hit Blocks": 0,
          "Shared Read Blocks": 0,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0
        }
      ]
    },
    "Planning": {
      "Shared Hit Blocks": 0,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0
    },
    "Planning Time": 0.022,
    "Triggers": [
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16431",
        "Constraint Name": "messages_chat_id_fkey",
        "Relation": "messages",
        "Time": 4.698,
        "Calls": 1000
      },
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16436",
        "Constraint Name": "messages_sender_id_fkey",
        "Relation": "messages",
        "Time": 4.610,
        "Calls": 1000
      },
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16441",
        "Constraint Name": "messages_chat_id_sender_id_fkey",
        "Relation": "messages",
        "Time": 4.897,
        "Calls": 1000
      }
    ],
    "Execution Time": 17.747
  }
]
ROLLBACK
Time: 18.036 ms
[
  {
    "Plan": {
      "Node Type": "Limit",
      "Parallel Aware": false,
      "Async Capable": false,
      "Startup Cost": 0.42,
      "Total Cost": 11.77,
      "Plan Rows": 51,
      "Plan Width": 71,
      "Actual Startup Time": 0.011,
      "Actual Total Time": 0.017,
      "Actual Rows": 51,
      "Actual Loops": 1,
      "Shared Hit Blocks": 5,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0,
      "Plans": [
        {
          "Node Type": "Index Scan",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Scan Direction": "Forward",
          "Index Name": "candidate",
          "Relation Name": "messages",
          "Alias": "messages",
          "Startup Cost": 0.42,
          "Total Cost": 3049.09,
          "Plan Rows": 13702,
          "Plan Width": 71,
          "Actual Startup Time": 0.010,
          "Actual Total Time": 0.014,
          "Actual Rows": 51,
          "Actual Loops": 1,
          "Index Cond": "((chat_id = 'c4ca4238-a0b9-2382-0dcc-509a6f75849b'::uuid) AND (ROW(created_at, id) > ROW(('2026-01-01 00:00:00+00'::timestamp with time zone + '00:00:00.085'::interval), 'dedbbd60-c592-c7ad-b64f-8ef8f0a025dc'::uuid)))",
          "Rows Removed by Index Recheck": 0,
          "Shared Hit Blocks": 5,
          "Shared Read Blocks": 0,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0
        }
      ]
    },
    "Planning": {
      "Shared Hit Blocks": 0,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0
    },
    "Planning Time": 0.035,
    "Triggers": [
    ],
    "Execution Time": 0.024
  }
]
BEGIN
[
  {
    "Plan": {
      "Node Type": "ModifyTable",
      "Operation": "Insert",
      "Parallel Aware": false,
      "Async Capable": false,
      "Relation Name": "messages",
      "Alias": "messages",
      "Startup Cost": 0.00,
      "Total Cost": 37.50,
      "Plan Rows": 0,
      "Plan Width": 0,
      "Actual Startup Time": 3.376,
      "Actual Total Time": 3.377,
      "Actual Rows": 0,
      "Actual Loops": 1,
      "Shared Hit Blocks": 8091,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 13,
      "Shared Written Blocks": 13,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0,
      "Plans": [
        {
          "Node Type": "Function Scan",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Function Name": "generate_series",
          "Alias": "n",
          "Startup Cost": 0.00,
          "Total Cost": 37.50,
          "Plan Rows": 1000,
          "Plan Width": 88,
          "Actual Startup Time": 0.032,
          "Actual Total Time": 0.926,
          "Actual Rows": 1000,
          "Actual Loops": 1,
          "Shared Hit Blocks": 0,
          "Shared Read Blocks": 0,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0
        }
      ]
    },
    "Planning": {
      "Shared Hit Blocks": 0,
      "Shared Read Blocks": 0,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0
    },
    "Planning Time": 0.021,
    "Triggers": [
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16431",
        "Constraint Name": "messages_chat_id_fkey",
        "Relation": "messages",
        "Time": 9.403,
        "Calls": 1000
      },
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16436",
        "Constraint Name": "messages_sender_id_fkey",
        "Relation": "messages",
        "Time": 4.799,
        "Calls": 1000
      },
      {
        "Trigger Name": "RI_ConstraintTrigger_c_16441",
        "Constraint Name": "messages_chat_id_sender_id_fkey",
        "Relation": "messages",
        "Time": 4.972,
        "Calls": 1000
      }
    ],
    "Execution Time": 22.682
  }
]
ROLLBACK
Time: 22.961 ms
Time: 0.139 ms

real	0m0.277s
user	0m0.020s
sys	0m0.047s

real	0m0.469s
user	0m0.019s
sys	0m0.027s
PASS: restore row count and checksum match
100000|452ef7ddb29fb8f662613e2f14934870
 15684027
                  id                  |       text       
--------------------------------------+------------------
 1017bfd4-6739-55ff-ee46-41ad3d481b1c | synthetic-50000
 14ee22ea-ba29-7944-c96a-fdbe5b16c65b | synthetic-100000
 c4ca4238-a0b9-2382-0dcc-509a6f75849b | synthetic-1
(3 rows)

