Hi list,
This bug isn't causing me any immediate problems -- the plan works out
well regardless -- but PostgreSQL 8.4.7 is somehow overestimating the
number of rows coming from a nestloop join, when joining 2 large
partitioned tables. Maybe it's been fixed in more recent versions,
sadly it's an EOL Linux distro and I have no immediate plans to
upgrade.
It's estimating to join 135957 x 281 rows, but the product is somehow
2946151270877
In reality, it's joining 132577 x ~1 rows to get 133116 results
QUERY PLAN
GroupAggregate (cost=852067259163.57..977278688175.85
rows=2946151270877 width=36)
-> Sort (cost=852067259163.57..859432637340.77 rows=2946151270877 width=36)
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
-> Nested Loop (cost=0.00..213859871.55 rows=2946151270877 width=36)
Join Filter: (a.request_id = b.request_id)
-> Append (cost=0.00..5905.69 rows=135957 width=20)
-> Index Scan using "XIF01request" on request a
(cost=0.00..8.27 rows=1 width=20)
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..5897.42 rows=135956 width=20)
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)
-> Seq Scan on request_data b (cost=0.00..11.30
rows=130 width=32)
-> Index Scan using
"IX_relationship64_request_d_c_1150" on request_d_c_1150 b
(cost=0.00..9.56 rows=2 width=32)
Index Cond: (b.request_id = a.request_id)
*snip lots of partition index scans*
Query:
SELECT '2012-05-28T09:00:00', count(*),
uniq(sort(array_agg(visitor_id))), banner_id, client_body_id,
partner_body_id, space_id, campaign_id, evt_type_id FROM stats_request
WHERE stats_request.request_time >= '2012-05-28T09:00:00' AND
stats_request.request_time < (timestamp '2012-05-28T09:00:00' +
interval E'1 hour')::timestamp
GROUP BY banner_id, client_body_id, partner_body_id, space_id,
campaign_id, evt_type_id ORDER BY banner_id, client_body_id,
partner_body_id, space_id, campaign_id, evt_type_id;
Full EXPLAIN ANALYZE is attached.
Regards,
Marti
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)
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
