gistfile1.txt

cbq> EXPLAIN SELECT DISTINCT year FROM bucket-1 LIMIT 20
{
    "resultset": [
        {
            "input": {
                "input": {
                    "input": {
                        "as": "bucket-1",
                        "bucket": "bucket-1",
                        "ids": null,
                        "input": {
                            "as": "",
                            "bucket": "bucket-1",
                            "cover": false,
                            "index": "#alldocs",
                            "pool": "default",
                            "ranges": null,
                            "type": "scan"
                        },
                        "pool": "default",
                        "projection": null,
                        "type": "fetch"
                    },
                    "result": [
                        {
                            "as": "year",
                            "expr": {
                                "left": {
                                    "path": "bucket-1",
                                    "type": "property"
                                },
                                "right": {
                                    "path": "year",
                                    "type": "property"
                                },
                                "type": "dot_member"
                            },
                            "star": false
                        }
                    ],
                    "type": "projector"
                },
                "type": "eliminate-duplicates"
            },
            "type": "limit",
            "value": 20
        }
    ],
    "info": [
        {
            "caller": "http_response:160",
            "code": 100,
            "key": "total_rows",
            "message": "1"
        },
        {
            "caller": "http_response:162",
            "code": 101,
            "key": "total_elapsed_time",
            "message": "43.11233ms"
        }
    ]
}