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
    • Query Tuning
    • EXPLAIN Plans
      • Overview
      • The Basics of Postgres Query Planning
      • EXPLAIN Grid view
      • Comparing EXPLAIN plans
      • Insights
      • Scan nodes
      • Join nodes
      • Other nodes
        • Aggregate
        • Append
        • Bitmap And
        • Bitmap Or
        • Gather Merge
        • Gather
        • Group
        • Hash
        • Limit
        • Lock Rows
        • Materialize
        • Merge Append
        • Modify Table
        • Project Set
        • Recursive Union
        • Result
        • SetOp
        • Sort
        • Unique
        • Window Aggregate
    • 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 - Other Nodes

EXPLAIN - Unique

Description:

Like the UNIX command uniq, takes sorted input and eliminates adjacent duplicates. Useful for DISTINCT clauses if the input is already sorted (e.g., the query also includes an ORDER BY).


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

Email us anytime for questions:
 support@pganalyze.com

SOC 2 certification

pganalyze is SOC 2 Type 2 certified

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