By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
6 rows affected
| m_requisition_id | ad_wf_activity_id | bpname | designation |
|---|---|---|---|
| 1014546 | 1014546 | Abul Kalam Azad | Asst. Manager |
| 1014546 | 1225097 | Md. Hasan Zahir | Plant Manager |
| 1014546 | 1229239 | Md. Hasan Zahir | Plant Manager |
| 1014546 | 1229240 | Sayela Alam | Sr. Manager |
| 1014546 | 1229241 | Md. Hasan Zahir | Plant Manager |
| 1014546 | 1229242 | Sayela Alam | Sr. Manager |
| m_requisition_id | max | bpname | designation |
|---|---|---|---|
| 1014546 | 1014546 | Abul Kalam Azad | Asst. Manager |
| 1014546 | 1229241 | Md. Hasan Zahir | Plant Manager |
| 1014546 | 1229242 | Sayela Alam | Sr. Manager |