bitmap_heap_scan vs sequential scan

From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: bitmap_heap_scan vs sequential scan
Date: 2015-09-23 19:47:37
Message-ID: CADyzmyzx+7uW4RB0iYKwHn74iWf5bg=Z=Kk3uVejHkJ+M1ioWg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Good afternoon

I have what I think is a simple question. Does the seq_scan column in the
pg_stat_all_tables view include the number of bitmap_heap_scans in its
count or is it limited to sequential scans for a particular table?

Thank you,

--
*Mark Steben*
Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tirumalaraju, Ravikumar (GE Corporate, consultant) 2015-09-23 22:52:48 Need help...
Previous Message girish R G peetle 2015-09-22 16:46:54 Re: Need to calculate total size of a table along with BLOB data assosciated with it.