Options

Explain verbose terminolgies

Navin_CNavin_C Vertica Customer

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.

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file