192.168.1.112

sportsdb

public

Tables

baseball_offensive_stats

baseball_offensive_stats

Properties

Property	Value		Property	Value
OID	24887		Total size	256.0 KB
Owner	postgres		Table size	192.0 KB
Tablespace	pg_default		Indexes size	56.0 KB
Primary key(s)			Toast size	8.0 KB
Estimated rows	1528
Comment

Statistics

Property	Value		Property	Value
seq_scan	0		n_dead_tup	0
seq_tup_read	0		last_vacuum	-
idx_scan	0		last_autovacuum	-
idx_tup_fetch	0		last_analyze	-
n_tup_ins	0		last_autoanalyze	-
n_tup_upd	0		vacuum_count	0
n_tup_del	0		autovacuum_count	0
n_tup_hot_upd	0		analyze_count	0
n_live_tup	0		autoanalyze_count	0

Columns - 34

Name	Type	Length	Default value	Allow null	Unique	Comment
id	integer		nextval('baseball_offensive_stats_id_seq'::regclass)	false	true
average	numeric			true	false
runs_scored	integer			true	false
at_bats	integer			true	false
hits	integer			true	false
rbi	integer			true	false
total_bases	integer			true	false
slugging_percentage	numeric			true	false
bases_on_balls	integer			true	false
strikeouts	integer			true	false
left_on_base	integer			true	false
left_in_scoring_position	integer			true	false
singles	integer			true	false
doubles	integer			true	false
triples	integer			true	false
home_runs	integer			true	false
grand_slams	integer			true	false
at_bats_per_rbi	numeric			true	false
plate_appearances_per_rbi	numeric			true	false
at_bats_per_home_run	numeric			true	false
plate_appearances_per_home_run	numeric			true	false
sac_flies	integer			true	false
sac_bunts	integer			true	false
grounded_into_double_play	integer			true	false
moved_up	integer			true	false
on_base_percentage	numeric			true	false
stolen_bases	integer			true	false
stolen_bases_caught	integer			true	false
stolen_bases_average	numeric			true	false
hit_by_pitch	integer			true	false
defensive_interferance_reaches	integer			true	false
on_base_plus_slugging	numeric			true	false
plate_appearances	integer			true	false
hits_extra_base	integer			true	false

Indexes - 1

Name (scan, tup_read, tup_fetch)	Primary	Unique	Clustered	Size	Definition
baseball_offensive_stats_id_key (0, 0, 0)	false	true	false	56.0 KB	btree (id)

Unique constraints - 1

Name	Columns	Comment
baseball_offensive_stats_id_key	id