Awk snippet to count TCP sockets grouped by state

Depending on the release of awk it could be:

#!/usr/bin/gawk -f
{
        if ( ($NF) in stats )  {
                stats[$NF] = stats[$NF]+1;
        } else {
                stats[$NF]=1;
        }
}
END {
        for ( var in stats) {
                print var " = " stats[var];
        }
}

#!/usr/bin/gawk -f

{

if ( ($NF) in stats ) {

stats[$NF] = stats[$NF]+1;

} else {

stats[$NF]=1;

}

END {

for ( var in stats) {

print var " = " stats[var];

}

I saved the script as netstat_c.
I have to filter my netstat output to match only my tcp sockets prior to pipe the output to the script.

On linux:

$ netstat -a | grep ^tcp | netstat_c
LISTEN = 13
ESTABLISHED = 74
TIME_WAIT = 7

$ netstat -a | grep ^tcp | netstat_c

LISTEN = 13

ESTABLISHED = 74

TIME_WAIT = 7

This is great to check my webserver connections when I do stress tests.

Bio
Latest Posts

Ludovico

Principal Product Manager at Oracle

Ludovico is a member of the Oracle Database High Availability (HA), Scalability & Maximum Availability Architecture (MAA) Product Management team in Oracle. He focuses on Oracle Data Guard, Flashback technologies, and Cloud MAA.

Latest posts by Ludovico (see all)

New views in Oracle Data Guard 23c - January 3, 2024
New in Data Guard 21c and 23c: Automatic preparation of the primary - December 22, 2023
Does FLASHBACK QUERY work across incarnations or after a Data Guard failover? - December 13, 2023

DBA survival BLOG

Some DBA stuff and lots of Oracle Data Guard

Awk snippet to count TCP sockets grouped by state

Ludovico

Latest posts by Ludovico (see all)

Leave a Reply Cancel reply