Watch our latest webinar: Fixing & Detecting Slow Postgres Queries with pganalyze Query Advisor.
Logo
  • Resources
  • Enterprise
  • Docs
  • Blog
  • Contact
  • Features
  • Pricing
  • Login
  • Free Trial
    • Overview
    • Installation Guide
    • pganalyze Collector
    • Query Performance
    • Workbooks
    • EXPLAIN Plans
      • Overview
      • The Basics of Postgres Query Planning
      • EXPLAIN Grid view
      • Comparing EXPLAIN plans
      • Insights
      • Scan nodes
        • Sequential Scan
        • Index Scan
        • Index-Only Scan
        • Bitmap Heap Scan
        • Bitmap Index Scan
        • CTE Scan
        • Custom Scan
        • Foreign Scan
        • Function Scan
        • Subquery Scan
        • Table Sample Scan
        • Tid Scan
        • Values Scan
        • Work Table Scan
      • Join nodes
      • Other nodes
    • Index Advisor
    • Indexing Engine
    • VACUUM Advisor
    • Schema Statistics
    • Log Insights
    • Connections
    • Alerts & Check-Up
    • Account Management
    • OpenTelemetry Integration
    • pganalyze Enterprise Server
    • pganalyze GraphQL API
    • Open-Source Components
❮ Documentation: EXPLAIN - Scan Nodes

EXPLAIN - Tid Scan

Description:

Similar to an Index Scan, but one that can only look up rows using the internal and unstable ctid identifier. You are unlikely to use this type of scan in your queries.


Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →
Logo
  • Contact
  • Plans & Pricing
  • Resources
  • Enterprise
  • Documentation
  • Customer Stories
  • Careers
  • Index Advisor
  • Security
  • Status
  • Compare pganalyze
  • Terms of Service
  • Privacy Policy
  • Newsletter
  • SOC 2 Type 2
  • Do Not Sell My Personal Information

Get in touch

Use the contact us form or email sales:
 sales@pganalyze.com

SOC 2 certification

pganalyze is SOC 2 Type 2 certified

pganalyze is SOC 2 Type 2 certified
© 2025 Duboce Labs, Inc.