QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- GroupAggregate (cost=879052459671.79..1008131430885.41 rows=3037152263850 width=36) (actual time=53254.277..53366.138 rows=205 loops=1) -> Sort (cost=879052459671.79..886645340331.41 rows=3037152263850 width=36) (actual time=53252.215..53271.619 rows=133116 loops=1) Sort Key: b.banner_id, b.client_body_id, (COALESCE(b.partner_body_id, a.partner_body_id)), b.space_id, b.campaign_id, a.evt_type_id Sort Method: quicksort Memory: 16544kB -> Nested Loop (cost=0.00..220465186.10 rows=3037152263850 width=36) (actual time=2.079..52841.371 rows=133116 loops=1) Join Filter: (a.request_id = b.request_id) -> Append (cost=0.00..6085.67 rows=140156 width=20) (actual time=0.115..147.640 rows=132577 loops=1) -> Index Scan using "XIF01request" on request a (cost=0.00..8.27 rows=1 width=20) (actual time=0.014..0.014 rows=0 loops=1) Index Cond: ((request_time >= '2012-05-28 09:00:00'::timestamp without time zone) AND (request_time < '2012-05-28 10:00:00'::timestamp without time zone)) -> Index Scan using "XIF01request_1222" on request_1222 a (cost=0.00..6077.40 rows=140155 width=20) (actual time=0.099..117.756 rows=132577 loops=1) Index Cond: ((request_time >= '2012-05-28 09:00:00'::timestamp without time zone) AND (request_time < '2012-05-28 10:00:00'::timestamp without time zone)) -> Append (cost=0.00..1569.44 rows=281 width=32) (actual time=0.217..0.365 rows=1 loops=132577) -> Seq Scan on request_data b (cost=0.00..11.30 rows=130 width=32) (actual time=0.000..0.000 rows=0 loops=132577) -> Index Scan using "IX_relationship64_request_d_c_1150" on request_d_c_1150 b (cost=0.00..9.56 rows=2 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1150" on request_d_n_1150 b (cost=0.00..17.58 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1151" on request_d_c_1151 b (cost=0.00..9.14 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1151" on request_d_n_1151 b (cost=0.00..17.41 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1152" on request_d_c_1152 b (cost=0.00..8.93 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1152" on request_d_n_1152 b (cost=0.00..18.71 rows=2 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1201" on request_d_c_1201 b (cost=0.00..8.56 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1201" on request_d_n_1201 b (cost=0.00..14.50 rows=2 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1202" on request_d_c_1202 b (cost=0.00..8.43 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1202" on request_d_n_1202 b (cost=0.00..12.59 rows=2 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1203" on request_d_c_1203 b (cost=0.00..8.36 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1203" on request_d_n_1203 b (cost=0.00..12.28 rows=2 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1204" on request_d_c_1204 b (cost=0.00..8.22 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1107" on request_d_c_1107 b (cost=0.00..8.84 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1204" on request_d_n_1204 b (cost=0.00..12.30 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1107" on request_d_n_1107 b (cost=0.00..16.65 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1205" on request_d_c_1205 b (cost=0.00..8.22 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1108" on request_d_c_1108 b (cost=0.00..8.66 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1108" on request_d_n_1108 b (cost=0.00..17.18 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1109" on request_d_c_1109 b (cost=0.00..8.79 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1109" on request_d_n_1109 b (cost=0.00..17.14 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1205" on request_d_n_1205 b (cost=0.00..12.30 rows=2 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1206" on request_d_c_1206 b (cost=0.00..8.23 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1206" on request_d_n_1206 b (cost=0.00..11.78 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1110" on request_d_c_1110 b (cost=0.00..8.87 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1110" on request_d_n_1110 b (cost=0.00..16.65 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1111" on request_d_c_1111 b (cost=0.00..8.83 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1111" on request_d_n_1111 b (cost=0.00..16.91 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1112" on request_d_c_1112 b (cost=0.00..8.86 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1112" on request_d_n_1112 b (cost=0.00..17.45 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1113" on request_d_c_1113 b (cost=0.00..8.96 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1113" on request_d_n_1113 b (cost=0.00..17.15 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1114" on request_d_c_1114 b (cost=0.00..9.33 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1114" on request_d_n_1114 b (cost=0.00..16.52 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1115" on request_d_c_1115 b (cost=0.00..9.72 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1115" on request_d_n_1115 b (cost=0.00..15.45 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1116" on request_d_c_1116 b (cost=0.00..9.74 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1116" on request_d_n_1116 b (cost=0.00..15.54 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1117" on request_d_c_1117 b (cost=0.00..9.67 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1117" on request_d_n_1117 b (cost=0.00..15.76 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1118" on request_d_c_1118 b (cost=0.00..10.16 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1118" on request_d_n_1118 b (cost=0.00..15.78 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1119" on request_d_c_1119 b (cost=0.00..10.31 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1119" on request_d_n_1119 b (cost=0.00..15.07 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1120" on request_d_c_1120 b (cost=0.00..10.21 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1120" on request_d_n_1120 b (cost=0.00..15.90 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1121" on request_d_c_1121 b (cost=0.00..9.74 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1121" on request_d_n_1121 b (cost=0.00..16.49 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1122" on request_d_c_1122 b (cost=0.00..9.15 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1122" on request_d_n_1122 b (cost=0.00..16.35 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1123" on request_d_c_1123 b (cost=0.00..9.21 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1123" on request_d_n_1123 b (cost=0.00..15.97 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1124" on request_d_c_1124 b (cost=0.00..9.37 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1124" on request_d_n_1124 b (cost=0.00..17.18 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1207" on request_d_c_1207 b (cost=0.00..8.23 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1207" on request_d_n_1207 b (cost=0.00..11.16 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1208" on request_d_c_1208 b (cost=0.00..8.21 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1208" on request_d_n_1208 b (cost=0.00..9.51 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1209" on request_d_c_1209 b (cost=0.00..8.21 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1209" on request_d_n_1209 b (cost=0.00..9.50 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1210" on request_d_c_1210 b (cost=0.00..5.27 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1210" on request_d_n_1210 b (cost=0.00..9.62 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1211" on request_d_c_1211 b (cost=0.00..4.27 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1211" on request_d_n_1211 b (cost=0.00..10.22 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1212" on request_d_c_1212 b (cost=0.00..2.27 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1212" on request_d_n_1212 b (cost=0.00..10.20 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1213" on request_d_c_1213 b (cost=0.00..5.87 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1213" on request_d_n_1213 b (cost=0.00..10.17 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1214" on request_d_c_1214 b (cost=0.00..5.87 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1214" on request_d_n_1214 b (cost=0.00..10.04 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1215" on request_d_c_1215 b (cost=0.00..5.87 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1215" on request_d_n_1215 b (cost=0.00..9.98 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1216" on request_d_c_1216 b (cost=0.00..5.87 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1216" on request_d_n_1216 b (cost=0.00..9.97 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1217" on request_d_c_1217 b (cost=0.00..5.87 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1217" on request_d_n_1217 b (cost=0.00..9.89 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1218" on request_d_c_1218 b (cost=0.00..3.87 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1218" on request_d_n_1218 b (cost=0.00..9.76 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1219" on request_d_c_1219 b (cost=0.00..3.87 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1219" on request_d_n_1219 b (cost=0.00..9.83 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1220" on request_d_c_1220 b (cost=0.00..5.87 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1220" on request_d_n_1220 b (cost=0.00..9.92 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1221" on request_d_c_1221 b (cost=0.00..3.87 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1221" on request_d_n_1221 b (cost=0.00..9.87 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1222" on request_d_c_1222 b (cost=0.00..3.87 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1222" on request_d_n_1222 b (cost=0.00..8.28 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1223" on request_d_c_1223 b (cost=0.00..3.87 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1223" on request_d_n_1223 b (cost=0.00..3.87 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1125" on request_d_c_1125 b (cost=0.00..8.85 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1125" on request_d_n_1125 b (cost=0.00..15.29 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1126" on request_d_c_1126 b (cost=0.00..8.55 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1126" on request_d_n_1126 b (cost=0.00..15.54 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1127" on request_d_c_1127 b (cost=0.00..8.83 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1127" on request_d_n_1127 b (cost=0.00..15.23 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1128" on request_d_c_1128 b (cost=0.00..8.91 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1128" on request_d_n_1128 b (cost=0.00..15.28 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1129" on request_d_c_1129 b (cost=0.00..8.71 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1129" on request_d_n_1129 b (cost=0.00..15.55 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1130" on request_d_c_1130 b (cost=0.00..8.52 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1130" on request_d_n_1130 b (cost=0.00..16.16 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1131" on request_d_c_1131 b (cost=0.00..8.63 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1131" on request_d_n_1131 b (cost=0.00..15.89 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1132" on request_d_c_1132 b (cost=0.00..8.60 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1132" on request_d_n_1132 b (cost=0.00..16.09 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1133" on request_d_c_1133 b (cost=0.00..8.53 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1133" on request_d_n_1133 b (cost=0.00..16.15 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1134" on request_d_c_1134 b (cost=0.00..8.68 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1134" on request_d_n_1134 b (cost=0.00..16.43 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1135" on request_d_c_1135 b (cost=0.00..8.97 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1135" on request_d_n_1135 b (cost=0.00..17.26 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1136" on request_d_c_1136 b (cost=0.00..9.18 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1136" on request_d_n_1136 b (cost=0.00..16.90 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1137" on request_d_c_1137 b (cost=0.00..9.65 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1137" on request_d_n_1137 b (cost=0.00..16.72 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1138" on request_d_c_1138 b (cost=0.00..9.54 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1138" on request_d_n_1138 b (cost=0.00..15.05 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1139" on request_d_c_1139 b (cost=0.00..9.43 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1139" on request_d_n_1139 b (cost=0.00..14.85 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1140" on request_d_c_1140 b (cost=0.00..9.71 rows=2 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1140" on request_d_n_1140 b (cost=0.00..16.59 rows=2 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1141" on request_d_c_1141 b (cost=0.00..9.16 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1141" on request_d_n_1141 b (cost=0.00..15.10 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1142" on request_d_c_1142 b (cost=0.00..9.43 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1142" on request_d_n_1142 b (cost=0.00..14.62 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1143" on request_d_c_1143 b (cost=0.00..9.19 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1143" on request_d_n_1143 b (cost=0.00..15.38 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1144" on request_d_c_1144 b (cost=0.00..9.09 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1144" on request_d_n_1144 b (cost=0.00..17.44 rows=2 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1145" on request_d_c_1145 b (cost=0.00..9.24 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1145" on request_d_n_1145 b (cost=0.00..17.75 rows=2 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1146" on request_d_c_1146 b (cost=0.00..9.15 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1146" on request_d_n_1146 b (cost=0.00..17.83 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1147" on request_d_c_1147 b (cost=0.00..9.25 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1147" on request_d_n_1147 b (cost=0.00..18.52 rows=2 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1148" on request_d_c_1148 b (cost=0.00..9.50 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1148" on request_d_n_1148 b (cost=0.00..18.26 rows=2 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_c_1149" on request_d_c_1149 b (cost=0.00..9.68 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) -> Index Scan using "IX_relationship64_request_d_n_1149" on request_d_n_1149 b (cost=0.00..17.87 rows=2 width=32) (actual time=0.003..0.003 rows=0 loops=132577) Index Cond: (b.request_id = a.request_id) Total runtime: 53375.294 ms (290 rows)