rerun over the same rows in another physical order this statement gives another answer, so its result depends on how the rows are stored and not only on the data
what it measured
{
"heuristic": true,
"rule": "R-SET",
"baseline_result_hash": "sha256:b30813a35899821e7385733844e35ce98546bfcf95f8ce1325e040107a2733d5",
"baseline_result": {
"columns": [
{
"name": "type",
"declared_type": "text"
}
],
"row_count": 461,
"truncated": false,
"rows_shown": 10,
"rows": [
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
]
],
"result_hash": "sha256:b30813a35899821e7385733844e35ce98546bfcf95f8ce1325e040107a2733d5"
},
"planner_statistics": {
"disp": {
"last_analyze": null,
"last_autoanalyze": "2026-09-08 05:19:17.037279+00",
"n_mod_since_analyze": 0
},
"district": {
"last_analyze": null,
"last_autoanalyze": "2026-09-08 05:19:24.361355+00",
"n_mod_since_analyze": 0
},
"account": {
"last_analyze": null,
"last_autoanalyze": "2026-09-08 05:19:16.907324+00",
"n_mod_since_analyze": 0
}
},
"shuffle": {
"seed": "1",
"row_limit": 300000,
"tables": [
"disp",
"district",
"account"
],
"tables_not_shuffled": [],
"tables_skipped_for_size": {
"laptimes": 400524,
"legalities": 427907,
"posthistory": 303155,
"trans": 1056320,
"yearmonth": 383282
},
"tables_not_reached_by_a_copy": {}
},
"shuffled_copies": {
"run": true,
"verdict": "equal",
"differs": false,
"result_hash": "sha256:b30813a35899821e7385733844e35ce98546bfcf95f8ce1325e040107a2733d5",
"result": {
"columns": [
{
"name": "type",
"declared_type": "text"
}
],
"row_count": 461,
"truncated": false,
"rows_shown": 10,
"rows": [
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
],
[
{
"type": "str",
"value": "DISPONENT"
}
]
],
"result_hash": "sha256:b30813a35899821e7385733844e35ce98546bfcf95f8ce1325e040107a2733d5"
}
},
"plan_variant": {
"run": false,
"reason": "the plan variant was not asked for"
}
}