Explain verbose terminolgies

Navin_C

Hi ,

I was curious to know what the explain verbose terminologies mean here.
Vertica documentation

Suppose I do a explain verbose and it shows value like these for every path.

+-SELECT LIMIT 10# [Cost: 365.000000, Rows: 10.000000 Disk(B): 0.000000 CPU(B): 0.000000 Memory(B): 0.000000 Netwrk(B): 0.000000 Parallelism: 1.000000] [OutRowSz (B): 274] (PATH ID: 0)
| Output Only: 10 tuples
| Execute on: Query Initiator
| Sort Key: (customer_dimension.customer_name)
| LDISTRIB_UNSEGMENTED
| +---> SORT [TOPK] [Cost: 365.000000, Rows: 544.000000 Disk(B): 0.000000 CPU(B): 1275443.584695 Memory(B): 149056.000000 Netwrk(B): 0.000000 Parallelism: 1.000000] [OutRowSz (B): 274] (PATH ID: 1)

What do these values mean
Disk(B)
CPU(B)
Memory(B)
Network(B)
Parallelism(B) (Can be threads used for that path)

I assume the value means the utilization of these resources, but what does the units (B) mean here.

emoreno

Bytes. E.g. OutRowSz is the width of one output tuple in bytes.
Hope this helps.
Eugenia

[Deleted User]

test