EXPLAIN
See scripts
Query
select *
from routing
where from_member_id = 8
Output:
from_member_id | to_member_id | message_id
----------------+--------------+------------
8 | 1 | 240
8 | 2 | 122
8 | 3 | 201
8 | 3 | 239
8 | 4 | 201
8 | 4 | 239
8 | 5 | 201
8 | 6 | 201
8 | 6 | 239
8 | 8 | 239
8 | 9 | 240
8 | 11 | 240
8 | 12 | 122
8 | 12 | 145
8 | 13 | 122
8 | 15 | 122
8 | 17 | 122
8 | 18 | 201
8 | 19 | 240
8 | 20 | 240
(20 rows)
|