PHPMem v2.0.1

Version
1.6.45
Uptime
15 days 9 hours 57 minutes 1 second

Memory

Total
512MB
Used
24,01MB (4.69%)
Free
487,99MB

Keys

Current
27 650
Total (since start)
33 978
Evictions
0
Reclaimed
160
Expired Unfetched
0
Evicted Unfetched
0

Connections

Current
12 / 1 024 max
Total
170 888
Rejected
0
llm:54c95483a2f1fcb89b5149137ae9c16cd1bfd0f4447106c7abbb0dc6852941d4
TTL 6 days 20 hours 28 minutes 55 seconds Size 12,71KB Export
Edit
{
    "sentences": [
        {
            "sid": 1,
            "non_factual": "scaffold",
            "claims": []
        },
        {
            "sid": 2,
            "non_factual": null,
            "claims": [
                {
                    "quote": "the most useful one is **playing surface**",
                    "occurrence": 0,
                    "sids": [
                        2
                    ],
                    "kind": "interpretation",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 3,
            "non_factual": "heading",
            "claims": []
        },
        {
            "sid": 4,
            "non_factual": null,
            "claims": [
                {
                    "quote": "4 real values",
                    "occurrence": 0,
                    "sids": [
                        4
                    ],
                    "kind": "count",
                    "labels": [],
                    "measure": "Surface",
                    "aggregation": "count_distinct",
                    "value_literal": "4",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": "non-blank",
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "Surface"
                        ]
                    }
                },
                {
                    "quote": "28 rows",
                    "occurrence": 0,
                    "sids": [
                        4
                    ],
                    "kind": "count",
                    "labels": [],
                    "measure": null,
                    "aggregation": "count",
                    "value_literal": "28",
                    "unit": "rows",
                    "comparator": "eq",
                    "rank": null,
                    "filter": "blank Surface",
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "n_rows"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 5,
            "non_factual": "lead_in",
            "claims": []
        },
        {
            "sid": 6,
            "non_factual": null,
            "claims": [
                {
                    "quote": "117,571 rows",
                    "occurrence": 0,
                    "sids": [
                        6
                    ],
                    "kind": "count",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Hard",
                            "sid": 6
                        }
                    ],
                    "measure": null,
                    "aggregation": "count",
                    "value_literal": "117,571",
                    "unit": "rows",
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "n_rows"
                        ]
                    }
                },
                {
                    "quote": "107,650",
                    "occurrence": 0,
                    "sids": [
                        6
                    ],
                    "kind": "count",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Clay",
                            "sid": 6
                        }
                    ],
                    "measure": null,
                    "aggregation": "count",
                    "value_literal": "107,650",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "n_rows"
                        ]
                    }
                },
                {
                    "quote": "hold almost all records",
                    "occurrence": 0,
                    "sids": [
                        6
                    ],
                    "kind": "interpretation",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Hard",
                            "sid": 6
                        },
                        {
                            "column": "Surface",
                            "quote": "Clay",
                            "sid": 6
                        }
                    ],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 7,
            "non_factual": null,
            "claims": [
                {
                    "quote": "9,479",
                    "occurrence": 0,
                    "sids": [
                        7
                    ],
                    "kind": "count",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Grass",
                            "sid": 7
                        }
                    ],
                    "measure": null,
                    "aggregation": "count",
                    "value_literal": "9,479",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "n_rows"
                        ]
                    }
                },
                {
                    "quote": "2,477",
                    "occurrence": 0,
                    "sids": [
                        7
                    ],
                    "kind": "count",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Carpet",
                            "sid": 7
                        }
                    ],
                    "measure": null,
                    "aggregation": "count",
                    "value_literal": "2,477",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "n_rows"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 8,
            "non_factual": null,
            "claims": [
                {
                    "quote": "3.38",
                    "occurrence": 0,
                    "sids": [
                        8
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Clay",
                            "sid": 8
                        }
                    ],
                    "measure": "Aces",
                    "aggregation": "avg",
                    "value_literal": "3.38",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "avg_aces"
                        ]
                    }
                },
                {
                    "quote": "5.88",
                    "occurrence": 0,
                    "sids": [
                        8
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Hard",
                            "sid": 8
                        }
                    ],
                    "measure": "Aces",
                    "aggregation": "avg",
                    "value_literal": "5.88",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "avg_aces"
                        ]
                    }
                },
                {
                    "quote": "7.57",
                    "occurrence": 0,
                    "sids": [
                        8
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Grass",
                            "sid": 8
                        }
                    ],
                    "measure": "Aces",
                    "aggregation": "avg",
                    "value_literal": "7.57",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "avg_aces"
                        ]
                    }
                },
                {
                    "quote": "7.94",
                    "occurrence": 0,
                    "sids": [
                        8
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Carpet",
                            "sid": 8
                        }
                    ],
                    "measure": "Aces",
                    "aggregation": "avg",
                    "value_literal": "7.94",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "avg_aces"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 9,
            "non_factual": null,
            "claims": [
                {
                    "quote": "Fast surfaces are clearly serve-dominant, and clay is the odd one out.",
                    "occurrence": 0,
                    "sids": [
                        9
                    ],
                    "kind": "interpretation",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 10,
            "non_factual": null,
            "claims": [
                {
                    "quote": "2.81",
                    "occurrence": 0,
                    "sids": [
                        10
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "clay",
                            "sid": 10
                        }
                    ],
                    "measure": "DFs",
                    "aggregation": "avg",
                    "value_literal": "2.81",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "avg_double_faults"
                        ]
                    }
                },
                {
                    "quote": "3.17",
                    "occurrence": 0,
                    "sids": [
                        10
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "grass",
                            "sid": 10
                        }
                    ],
                    "measure": "DFs",
                    "aggregation": "avg",
                    "value_literal": "3.17",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "avg_double_faults"
                        ]
                    }
                },
                {
                    "quote": "much more uniform",
                    "occurrence": 0,
                    "sids": [
                        10
                    ],
                    "kind": "interpretation",
                    "labels": [],
                    "measure": "DFs",
                    "aggregation": "avg",
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "avg_double_faults"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 11,
            "non_factual": null,
            "claims": [
                {
                    "quote": "151",
                    "occurrence": 0,
                    "sids": [
                        11
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Grass",
                            "sid": 11
                        }
                    ],
                    "measure": "Rk",
                    "aggregation": "avg",
                    "value_literal": "151",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "avg_rank"
                        ]
                    }
                },
                {
                    "quote": "much lower",
                    "occurrence": 0,
                    "sids": [
                        11
                    ],
                    "kind": "comparison",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Grass",
                            "sid": 11
                        },
                        {
                            "column": "Surface",
                            "quote": "Clay",
                            "sid": 11
                        },
                        {
                            "column": "Surface",
                            "quote": "Hard",
                            "sid": 11
                        },
                        {
                            "column": "Surface",
                            "quote": "Carpet",
                            "sid": 11
                        }
                    ],
                    "measure": "Rk",
                    "aggregation": "avg",
                    "value_literal": null,
                    "unit": null,
                    "comparator": "lt",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "avg_rank"
                        ]
                    }
                },
                {
                    "quote": "361",
                    "occurrence": 0,
                    "sids": [
                        11
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Clay",
                            "sid": 11
                        }
                    ],
                    "measure": "Rk",
                    "aggregation": "avg",
                    "value_literal": "361",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "avg_rank"
                        ]
                    }
                },
                {
                    "quote": "311",
                    "occurrence": 0,
                    "sids": [
                        11
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Hard",
                            "sid": 11
                        }
                    ],
                    "measure": "Rk",
                    "aggregation": "avg",
                    "value_literal": "311",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "avg_rank"
                        ]
                    }
                },
                {
                    "quote": "517",
                    "occurrence": 0,
                    "sids": [
                        11
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Carpet",
                            "sid": 11
                        }
                    ],
                    "measure": "Rk",
                    "aggregation": "avg",
                    "value_literal": "517",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "avg_rank"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 12,
            "non_factual": null,
            "claims": [
                {
                    "quote": "Part of the surface effect is therefore a mix effect, because different calibre of player appears on each surface.",
                    "occurrence": 0,
                    "sids": [
                        12
                    ],
                    "kind": "interpretation",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 13,
            "non_factual": null,
            "claims": [
                {
                    "quote": "28 blank-surface rows",
                    "occurrence": 0,
                    "sids": [
                        13
                    ],
                    "kind": "count",
                    "labels": [],
                    "measure": null,
                    "aggregation": "count",
                    "value_literal": "28",
                    "unit": "rows",
                    "comparator": "eq",
                    "rank": null,
                    "filter": "blank Surface",
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "n_rows"
                        ]
                    }
                },
                {
                    "quote": "have no serve stats",
                    "occurrence": 0,
                    "sids": [
                        13
                    ],
                    "kind": "existence",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": "blank Surface",
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 14,
            "non_factual": "heading",
            "claims": []
        },
        {
            "sid": 15,
            "non_factual": "heading",
            "claims": []
        },
        {
            "sid": 16,
            "non_factual": null,
            "claims": [
                {
                    "quote": "~14 values",
                    "occurrence": 0,
                    "sids": [
                        16
                    ],
                    "kind": "count",
                    "labels": [],
                    "measure": "Rd",
                    "aggregation": "count_distinct",
                    "value_literal": "14",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E9",
                        "columns": [
                            "Rd"
                        ]
                    }
                },
                {
                    "quote": "shows form or depth across a tournament",
                    "occurrence": 0,
                    "sids": [
                        16
                    ],
                    "kind": "interpretation",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 17,
            "non_factual": null,
            "claims": [
                {
                    "quote": "~3,963 distinct values",
                    "occurrence": 0,
                    "sids": [
                        17
                    ],
                    "kind": "count",
                    "labels": [],
                    "measure": "Tournament",
                    "aggregation": "count_distinct",
                    "value_literal": "3,963",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E12",
                        "columns": [
                            "Tournament"
                        ]
                    }
                },
                {
                    "quote": "best used to group by tournament type or level rather than individually",
                    "occurrence": 0,
                    "sids": [
                        17
                    ],
                    "kind": "interpretation",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 18,
            "non_factual": null,
            "claims": [
                {
                    "quote": "the grain is one row per player per match",
                    "occurrence": 0,
                    "sids": [
                        18
                    ],
                    "kind": "structural",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 19,
            "non_factual": null,
            "claims": [
                {
                    "quote": "are player-level dimensions",
                    "occurrence": 0,
                    "sids": [
                        19
                    ],
                    "kind": "structural",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 20,
            "non_factual": "heading",
            "claims": []
        },
        {
            "sid": 21,
            "non_factual": null,
            "claims": [
                {
                    "quote": "ranging from 1 to about 2,250",
                    "occurrence": 0,
                    "sids": [
                        21
                    ],
                    "kind": "value",
                    "labels": [],
                    "measure": "Rk",
                    "aggregation": "max",
                    "value_literal": "2,250",
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E3",
                        "columns": [
                            "Rk__max"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 22,
            "non_factual": null,
            "claims": [
                {
                    "quote": "They can be banded into tiers such as top 10, top 100 and the rest.",
                    "occurrence": 0,
                    "sids": [
                        22
                    ],
                    "kind": "interpretation",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 23,
            "non_factual": null,
            "claims": [
                {
                    "quote": "This would let you compare serve and return profiles against stronger and weaker opponents.",
                    "occurrence": 0,
                    "sids": [
                        23
                    ],
                    "kind": "interpretation",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 24,
            "non_factual": "heading",
            "claims": []
        },
        {
            "sid": 25,
            "non_factual": null,
            "claims": [
                {
                    "quote": "`Date` spans 2013 to 2024 in the raw and return tables, and from 2006 in the serve table",
                    "occurrence": 0,
                    "sids": [
                        25
                    ],
                    "kind": "structural",
                    "labels": [],
                    "measure": "Date",
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 26,
            "non_factual": null,
            "claims": [
                {
                    "quote": "This allows year or era segmentation.",
                    "occurrence": 0,
                    "sids": [
                        26
                    ],
                    "kind": "interpretation",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 27,
            "non_factual": null,
            "claims": [
                {
                    "quote": "The three fact tables (raw, return, serve) share no detected join key",
                    "occurrence": 0,
                    "sids": [
                        27
                    ],
                    "kind": "structural",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 28,
            "non_factual": null,
            "claims": [
                {
                    "quote": "Hard and Clay hold roughly 95% of the rows",
                    "occurrence": 0,
                    "sids": [
                        28
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "Hard",
                            "sid": 28
                        },
                        {
                            "column": "Surface",
                            "quote": "Clay",
                            "sid": 28
                        }
                    ],
                    "measure": null,
                    "aggregation": "percent",
                    "value_literal": "95%",
                    "unit": "%",
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": "all rows",
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "n_rows"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 29,
            "non_factual": null,
            "claims": [
                {
                    "quote": "Comparisons involving grass and carpet rest on far fewer matches.",
                    "occurrence": 0,
                    "sids": [
                        29
                    ],
                    "kind": "interpretation",
                    "labels": [
                        {
                            "column": "Surface",
                            "quote": "grass",
                            "sid": 29
                        },
                        {
                            "column": "Surface",
                            "quote": "carpet",
                            "sid": 29
                        }
                    ],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E2",
                        "columns": [
                            "n_rows"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 30,
            "non_factual": null,
            "claims": [
                {
                    "quote": "use Surface as the primary segment, cross it with Round and with rank tiers, and keep tournament for drill-downs",
                    "occurrence": 0,
                    "sids": [
                        30
                    ],
                    "kind": "interpretation",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        }
    ]
}