HEX
Server: Apache
System: Linux pdx1-shared-a1-38 6.6.104-grsec-jammy+ #3 SMP Tue Sep 16 00:28:11 UTC 2025 x86_64
User: mmickelson (3396398)
PHP: 8.1.31
Disabled: NONE
Upload Files
File: //lib/python3/dist-packages/awscli/examples/lightsail/get-relational-database-metric-data.rst
**To get metric data for a relational database**

The following ``get-relational-database-metric-data`` example returns the count sum of the metric ``DatabaseConnections`` over the period of 24 hours (``86400`` seconds) between ``1570733176`` and ``1571597176`` for relational database ``Database1``.

We recommend that you use a unix time converter to identify the start and end times. ::

    aws lightsail get-relational-database-metric-data \
        --relational-database-name Database1 \
        --metric-name DatabaseConnections \
        --period 86400 \
        --start-time 1570733176 \
        --end-time 1571597176 \
        --unit Count \
        --statistics Sum

Output::

    {
        "metricName": "DatabaseConnections",
        "metricData": [
            {
                "sum": 1.0,
                "timestamp": 1571510760.0,
                "unit": "Count"
            },
            {
                "sum": 1.0,
                "timestamp": 1570733160.0,
                "unit": "Count"
            },
            {
                "sum": 1.0,
                "timestamp": 1570992360.0,
                "unit": "Count"
            },
            {
                "sum": 0.0,
                "timestamp": 1571251560.0,
                "unit": "Count"
            },
            {
                "sum": 721.0,
                "timestamp": 1570819560.0,
                "unit": "Count"
            },
            {
                "sum": 1.0,
                "timestamp": 1571078760.0,
                "unit": "Count"
            },
            {
                "sum": 2.0,
                "timestamp": 1571337960.0,
                "unit": "Count"
            },
            {
                "sum": 684.0,
                "timestamp": 1570905960.0,
                "unit": "Count"
            },
            {
                "sum": 0.0,
                "timestamp": 1571165160.0,
                "unit": "Count"
            },
            {
                "sum": 1.0,
                "timestamp": 1571424360.0,
                "unit": "Count"
            }
        ]
    }