demo@127.0.0.1:26257/movr> EXPLAIN (VERBOSE) SELECT COALESCE(vehicle_city, start_address, end_address) FROM rides;
                                        info
-------------------------------------------------------------------------------------
  distribution: full
  vectorized: true

  • render
  │ columns: ("coalesce")
  │ estimated row count: 500
  │ render coalesce: COALESCE(vehicle_city, start_address, end_address)
  │
  └── • scan
        columns: (vehicle_city, start_address, end_address)
        estimated row count: 500 (100% of the table; stats collected 2 minutes ago)
        table: rides@primary
        spans: FULL SCAN
(13 rows)

Time: 1ms total (execution 1ms / network 0ms)

demo@127.0.0.1:26257/movr> EXPLAIN (VEC, VERBOSE) SELECT COALESCE(vehicle_city, start_address, end_address) FROM rides;
                   info
-------------------------------------------
  │
  └ Node 1
    └ *colflow.BatchFlowCoordinator
      └ *colexec.Columnarizer
        └ *rowexec.noopProcessor
          └ *colexec.Materializer
            └ *colexecutils.CancelChecker
              └ *colfetcher.ColBatchScan
(8 rows)

Time: 1ms total (execution 1ms / network 0ms)