gistfile1.txt

cbq> EXPLAIN SELECT COUNT(*) FROM bucket-1 WHERE year = 1990
{
    "resultset": [
        {
            "input": {
                "aggregates": [
                    {
                        "distinct": false,
                        "name": "COUNT",
                        "operands": [
                            {
                                "expr": null,
                                "star": true
                            }
                        ],
                        "type": "function"
                    }
                ],
                "group": [],
                "input": {
                    "expr": {
                        "left": {
                            "left": {
                                "path": "bucket-1",
                                "type": "property"
                            },
                            "right": {
                                "path": "year",
                                "type": "property"
                            },
                            "type": "dot_member"
                        },
                        "right": {
                            "type": "literal_number",
                            "value": 1990
                        },
                        "type": "equals"
                    },
                    "input": {
                        "as": "bucket-1",
                        "bucket": "bucket-1",
                        "ids": null,
                        "input": {
                            "as": "",
                            "bucket": "bucket-1",
                            "cover": false,
                            "index": "by_year",
                            "pool": "default",
                            "ranges": [
                                {
                                    "high": [
                                        1990
                                    ],
                                    "inclusion": "both",
                                    "limit": 0,
                                    "low": [
                                        1990
                                    ]
                                }
                            ],
                            "type": "scan"
                        },
                        "pool": "default",
                        "projection": null,
                        "type": "fetch"
                    },
                    "type": "filter"
                },
                "type": "grouper"
            },
            "result": [
                {
                    "as": "$1",
                    "expr": {
                        "distinct": false,
                        "name": "COUNT",
                        "operands": [
                            {
                                "expr": null,
                                "star": true
                            }
                        ],
                        "type": "function"
                    },
                    "star": false
                }
            ],
            "type": "projector"
        }
    ],
    "info": [
        {
            "caller": "http_response:160",
            "code": 100,
            "key": "total_rows",
            "message": "1"
        },
        {
            "caller": "http_response:162",
            "code": 101,
            "key": "total_elapsed_time",
            "message": "43.604228ms"
        }
    ]
}