explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OAGl

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=79.12..79.19 rows=27 width=500) (actual rows= loops=)

  • Sort Key: ""createdAt"
2. 0.000 0.000 ↓ 0.0

Index Scan using message_tenantid_threadid_index on message (cost=0.29..78.48 rows=27 width=500) (actual rows= loops=)

  • Index Cond: (((""tenantId"")::text = 'TEN1ZGW4'::text) AND ((""threadId"")::text = 'THD105PFKP2H'::text))