Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select correlation from pg_stats where tablename = 'empCodeToPosition' and attname = 'positionId';
- CREATE EXTENSION IF NOT EXISTS pageinspect;
- SELECT bt.ctid as corr_heap_ctid, e."positionId", e."empCodeId" FROM bt_page_items('"empCodeToPosition_empCodeId_idx"', 21) as bt INNER JOIN "empCodeToPosition" e on e.ctid = bt.ctid LIMIT 100 OFFSET 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement