Pivot Query in Postgresql select * from crosstab ( $$ SELECT anonymous_id, message_id , timestamp, key, value FROM pixels WHERE tenant_id = 2 AND pixels.timestamp >= '2019-10-19 10:41:03.254968' AND pixels.timestamp < '2019-10-20 10:41:03.254968' AND message_id = ANY(SELECT message_id FROM pixels WHERE tenant_id = 2 AND pixels.timestamp >= '2019-10-19 10:41:03.254968' AND pixels.timestamp < '2019-10-20 10:41:03.254968' AND key = 'event' AND value = 'init_banuba_success' ) AND (key = ANY(array['context.timezone','context.device.model','