#	exclusive	inclusive	rows x	rows	loops	node
1.	0.083	2824.323	↓ 31.0	31	1	→ Sort (cost=54080.40..54080.41 rows=1 width=68) (actual time=2824.307..2824.323 rows=31 loops=1) Sort Key: po.datetime
2.	1.047	2824.240	↓ 31.0	31	1	→ Nested Loop Left Join (cost=45688.38..54080.39 rows=1 width=68) (actual time=1402.678..2824.240 rows=31 loops=1) Join Filter: (("inner".merch_id = "outer".merch_id) AND ("outer".prod_id = "inner".prod_id) AND ("inner".mydate = "outer".mydate))
3.	124.011	309.868	↓ 31.0	31	1	→ Hash Join (cost=16911.67..23972.60 rows=1 width=36) (actual time=204.167..309.868 rows=31 loops=1) Hash Cond: (("outer".merch_id = "inner".merch_id) AND ("outer".prod_id = "inner".prod_id) AND ("outer".datetime = "inner".date))
4.	128.364	128.364	↓ 1.0	174447	1	→ Seq Scan on t_price_order po (cost=0.00..4498.37 rows=170837 width=28) (actual time=0.005..128.364 rows=174447 loops=1)
5.	0.033	57.493	↑ 1.4	31	1	→ Hash (cost=16911.34..16911.34 rows=44 width=24) (actual time=57.493..57.493 rows=31 loops=1)
6.	0.034	57.460	↑ 1.4	31	1	→ Subquery Scan b (cost=16910.13..16911.34 rows=44 width=24) (actual time=57.400..57.460 rows=31 loops=1)
7.	17.216	57.426	↑ 1.4	31	1	→ HashAggregate (cost=16910.13..16910.90 rows=44 width=20) (actual time=57.398..57.426 rows=31 loops=1)
8.	26.490	40.210	↑ 9.7	16277	1	→ Nested Loop (cost=19.54..15330.13 rows=158000 width=20) (actual time=0.752..40.210 rows=16277 loops=1) Join Filter: ("outer".datetime <= (('2012-04-01'::date + "inner".n) + '18:00:00'::time without time zone))
9.	0.647	2.640	↓ 1.2	554	1	→ Nested Loop (cost=6.04..1491.63 rows=474 width=16) (actual time=0.729..2.640 rows=554 loops=1)
10.	0.004	0.449	↑ 1.0	1	1	→ Nested Loop (cost=0.00..47.80 rows=1 width=8) (actual time=0.414..0.449 rows=1 loops=1)
11.	0.017	0.017	↑ 1.0	1	1	→ Index Scan using t_merchant_pkey on t_merchant m (cost=0.00..5.89 rows=1 width=4) (actual time=0.016..0.017 rows=1 loops=1) Index Cond: (merch_id = 34)
12.	0.428	0.428	↑ 1.0	1	1	→ Seq Scan on tx_merch_prod mp (cost=0.00..41.89 rows=1 width=8) (actual time=0.395..0.428 rows=1 loops=1) Filter: ((prod_id = 1) AND (merch_id = 34))
13.	1.344	1.544	↓ 1.2	554	1	→ Bitmap Heap Scan on t_price_order po (cost=6.04..1439.09 rows=474 width=16) (actual time=0.311..1.544 rows=554 loops=1) Recheck Cond: (merch_id = 34) Filter: (prod_id = 1)
14.	0.200	0.200	↓ 1.6	938	1	→ Bitmap Index Scan on ix_merch_id (cost=0.00..6.04 rows=584 width=0) (actual time=0.200..0.200 rows=938 loops=1) Index Cond: (merch_id = 34)
15.	11.047	11.080	↑ 32.3	31	554	→ Materialize (cost=13.50..23.50 rows=1000 width=4) (actual time=0.001..0.020 rows=31 loops=554)
16.	0.033	0.033	↑ 32.3	31	1	→ Function Scan on generate_series x (cost=0.00..12.50 rows=1000 width=4) (actual time=0.014..0.033 rows=31 loops=1)
17.	668.143	2513.325	↓ 3.1	31	31	→ Merge Join (cost=28776.71..30107.61 rows=10 width=48) (actual time=80.856..81.075 rows=31 loops=31) Merge Cond: (("outer".prod_id = "inner".prod_id) AND ("outer".site_id = "inner".site_id) AND ("outer".datetime = "inner".date))
18.	1442.337	1702.520	↑ 3.9	34201	31	→ Sort (cost=19718.61..20049.78 rows=132467 width=48) (actual time=32.660..54.920 rows=34201 loops=31) Sort Key: pc.prod_id, pc.site_id, pc.datetime
19.	140.930	260.183	↑ 1.0	132452	1	→ Append (cost=1.02..3478.80 rows=132467 width=48) (actual time=0.383..260.183 rows=132452 loops=1)
20.	0.004	0.014	↓ 0.0	0	1	→ Bitmap Heap Scan on tx_prices pc (cost=1.02..7.50 rows=3 width=48) (actual time=0.014..0.014 rows=0 loops=1) Recheck Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
21.	0.010	0.010	↓ 0.0	0	1	→ Bitmap Index Scan on "cluster" (cost=0.00..1.02 rows=3 width=0) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
22.	0.002	0.006	↓ 0.0	0	1	→ Bitmap Heap Scan on tx_prices_yy09mm08 pc (cost=1.02..7.50 rows=3 width=48) (actual time=0.006..0.006 rows=0 loops=1) Recheck Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
23.	0.004	0.004	↓ 0.0	0	1	→ Bitmap Index Scan on tx_prices_yy09mm08_datetime (cost=0.00..1.02 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
24.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy09mm09_datetime on tx_prices_yy09mm09 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
25.	0.008	0.008	↓ 0.0	0	1	→ Index Scan using tx_prices_yy09mm10_datetime on tx_prices_yy09mm10 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.008..0.008 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
26.	0.008	0.008	↓ 0.0	0	1	→ Index Scan using tx_prices_yy09mm11_datetime on tx_prices_yy09mm11 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.008..0.008 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
27.	0.009	0.009	↓ 0.0	0	1	→ Index Scan using tx_prices_yy09mm12_datetime on tx_prices_yy09mm12 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.009..0.009 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
28.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm01_datetime on tx_prices_yy10mm01 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
29.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm02_datetime on tx_prices_yy10mm02 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
30.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm03_datetime on tx_prices_yy10mm03 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
31.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm04_datetime on tx_prices_yy10mm04 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
32.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm05_datetime on tx_prices_yy10mm05 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
33.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm06_datetime on tx_prices_yy10mm06 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
34.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm07_datetime on tx_prices_yy10mm07 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
35.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm08_datetime on tx_prices_yy10mm08 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
36.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm09_datetime on tx_prices_yy10mm09 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
37.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm10_datetime on tx_prices_yy10mm10 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
38.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm11_datetime on tx_prices_yy10mm11 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
39.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm12_datetime on tx_prices_yy10mm12 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
40.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm01_datetime on tx_prices_yy11mm01 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
41.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm02_datetime on tx_prices_yy11mm02 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
42.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm03_datetime on tx_prices_yy11mm03 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
43.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm04_datetime on tx_prices_yy11mm04 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
44.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm05_datetime on tx_prices_yy11mm05 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
45.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm06_datetime on tx_prices_yy11mm06 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
46.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm07_datetime on tx_prices_yy11mm07 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
47.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm08_datetime on tx_prices_yy11mm08 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
48.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm09_datetime on tx_prices_yy11mm09 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
49.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm10_datetime on tx_prices_yy11mm10 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
50.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm11_datetime on tx_prices_yy11mm11 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
51.	0.009	0.009	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm12_datetime on tx_prices_yy11mm12 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.009..0.009 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
52.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy12mm01_datetime on tx_prices_yy12mm01 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
53.	0.019	0.019	↓ 0.0	0	1	→ Index Scan using tx_prices_yy12mm02_datetime on tx_prices_yy12mm02 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.019..0.019 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
54.	0.009	0.009	↓ 0.0	0	1	→ Index Scan using yy12mm03 on tx_prices_yy12mm03 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.009..0.009 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
55.	118.882	118.882	↓ 1.0	132452	1	→ Seq Scan on tx_prices_yy12mm04 pc (cost=0.00..3359.78 rows=132426 width=27) (actual time=0.007..118.882 rows=132452 loops=1) Filter: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
56.	0.018	0.018	↓ 0.0	0	1	→ Index Scan using tx_prices_yy12mm05_datetime on tx_prices_yy12mm05 pc (cost=0.00..3.02 rows=1 width=27) (actual time=0.018..0.018 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
57.	0.002	0.008	↓ 0.0	0	1	→ Bitmap Heap Scan on tx_prices_yy12mm06 pc (cost=1.02..7.50 rows=3 width=48) (actual time=0.008..0.008 rows=0 loops=1) Recheck Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
58.	0.006	0.006	↓ 0.0	0	1	→ Bitmap Index Scan on cluster1206 (cost=0.00..1.02 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
59.	0.630	142.662	↑ 19.8	31	31	→ Sort (cost=9058.10..9059.63 rows=613 width=28) (actual time=4.584..4.602 rows=31 loops=31) Sort Key: b.prod_id, b.site_id, b.date
60.	0.037	142.032	↑ 19.8	31	1	→ Subquery Scan b (cost=9012.86..9029.72 rows=613 width=28) (actual time=141.972..142.032 rows=31 loops=1)
61.	2.084	141.995	↑ 19.8	31	1	→ HashAggregate (cost=9012.86..9023.59 rows=613 width=24) (actual time=141.968..141.995 rows=31 loops=1)
62.	4.337	139.911	↑ 22.5	2081	1	→ Nested Loop (cost=87.50..8426.91 rows=46876 width=24) (actual time=4.539..139.911 rows=2081 loops=1) Join Filter: ("outer".datetime <= (('2012-04-01'::date + "inner".n) + '18:00:00'::time without time zone))
63.	24.702	133.396	↑ 1.2	121	1	→ Hash Join (cost=74.00..4301.53 rows=141 width=20) (actual time=4.510..133.396 rows=121 loops=1) Hash Cond: ("outer".site_id = "inner".site_id)
64.	43.157	107.072	↑ 1.0	40821	1	→ Append (cost=2.28..3807.23 rows=42102 width=16) (actual time=0.398..107.072 rows=40821 loops=1)
65.	0.004	0.020	↓ 0.0	0	1	→ Bitmap Heap Scan on tx_prices pc (cost=2.28..6.11 rows=1 width=16) (actual time=0.020..0.020 rows=0 loops=1) Recheck Cond: ((prod_id = 1) AND (datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
66.	0.001	0.016	↓ 0.0	0	1	→ BitmapAnd (cost=2.28..2.28 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=1)
67.	0.015	0.015	↓ 0.0	0	1	→ Bitmap Index Scan on tx_prices_prod_id (cost=0.00..1.01 rows=3 width=0) (actual time=0.015..0.015 rows=0 loops=1) Index Cond: (prod_id = 1)
68.	0.000	0.000	↓ 0.0		0	→ Bitmap Index Scan on "cluster" (cost=0.00..1.02 rows=3 width=0) (actual time=.. rows= loops=0) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
69.	0.002	0.006	↓ 0.0	0	1	→ Bitmap Heap Scan on tx_prices_yy09mm08 pc (cost=2.28..6.11 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=1) Recheck Cond: ((prod_id = 1) AND (datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
70.	0.001	0.004	↓ 0.0	0	1	→ BitmapAnd (cost=2.28..2.28 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)
71.	0.003	0.003	↓ 0.0	0	1	→ Bitmap Index Scan on tx_prices_prod_id_0908 (cost=0.00..1.01 rows=3 width=0) (actual time=0.003..0.003 rows=0 loops=1) Index Cond: (prod_id = 1)
72.	0.000	0.000	↓ 0.0		0	→ Bitmap Index Scan on tx_prices_yy09mm08_datetime (cost=0.00..1.02 rows=3 width=0) (actual time=.. rows= loops=0) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
73.	0.013	0.013	↓ 0.0	0	1	→ Index Scan using tx_prices_yy09mm09_datetime on tx_prices_yy09mm09 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
74.	0.009	0.009	↓ 0.0	0	1	→ Index Scan using tx_prices_yy09mm10_datetime on tx_prices_yy09mm10 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
75.	0.009	0.009	↓ 0.0	0	1	→ Index Scan using tx_prices_yy09mm11_datetime on tx_prices_yy09mm11 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
76.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy09mm12_datetime on tx_prices_yy09mm12 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
77.	0.012	0.012	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm01_datetime on tx_prices_yy10mm01 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
78.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm02_datetime on tx_prices_yy10mm02 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
79.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm03_datetime on tx_prices_yy10mm03 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
80.	0.012	0.012	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm04_datetime on tx_prices_yy10mm04 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
81.	0.012	0.012	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm05_datetime on tx_prices_yy10mm05 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
82.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm06_datetime on tx_prices_yy10mm06 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
83.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm07_datetime on tx_prices_yy10mm07 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
84.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm08_datetime on tx_prices_yy10mm08 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
85.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm09_datetime on tx_prices_yy10mm09 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
86.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm10_datetime on tx_prices_yy10mm10 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
87.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm11_datetime on tx_prices_yy10mm11 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
88.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy10mm12_datetime on tx_prices_yy10mm12 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
89.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm01_datetime on tx_prices_yy11mm01 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
90.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm02_datetime on tx_prices_yy11mm02 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
91.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm03_datetime on tx_prices_yy11mm03 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
92.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm04_datetime on tx_prices_yy11mm04 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
93.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm05_datetime on tx_prices_yy11mm05 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
94.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm06_datetime on tx_prices_yy11mm06 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
95.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm07_datetime on tx_prices_yy11mm07 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
96.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm08_datetime on tx_prices_yy11mm08 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
97.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm09_datetime on tx_prices_yy11mm09 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
98.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm10_datetime on tx_prices_yy11mm10 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
99.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm11_datetime on tx_prices_yy11mm11 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
100.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy11mm12_datetime on tx_prices_yy11mm12 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
101.	0.010	0.010	↓ 0.0	0	1	→ Index Scan using tx_prices_yy12mm01_datetime on tx_prices_yy12mm01 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
102.	0.011	0.011	↓ 0.0	0	1	→ Index Scan using tx_prices_yy12mm02_datetime on tx_prices_yy12mm02 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
103.	0.009	0.009	↓ 0.0	0	1	→ Index Scan using yy12mm03 on tx_prices_yy12mm03 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
104.	63.532	63.532	↑ 1.0	40821	1	→ Seq Scan on tx_prices_yy12mm04 pc (cost=0.00..3690.91 rows=42067 width=16) (actual time=0.012..63.532 rows=40821 loops=1) Filter: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone) AND (prod_id = 1))
105.	0.017	0.017	↓ 0.0	0	1	→ Index Scan using tx_prices_yy12mm05_datetime on tx_prices_yy12mm05 pc (cost=0.00..3.02 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
106.	0.002	0.008	↓ 0.0	0	1	→ Bitmap Heap Scan on tx_prices_yy12mm06 pc (cost=1.02..7.51 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=1) Recheck Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone)) Filter: (prod_id = 1)
107.	0.006	0.006	↓ 0.0	0	1	→ Bitmap Index Scan on cluster1206 (cost=0.00..1.02 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1) Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))
108.	0.003	1.622	↑ 3.0	1	1	→ Hash (cost=71.71..71.71 rows=3 width=16) (actual time=1.622..1.622 rows=1 loops=1)
109.	0.530	1.619	↑ 3.0	1	1	→ Hash Join (cost=7.54..71.71 rows=3 width=16) (actual time=1.575..1.619 rows=1 loops=1) Hash Cond: ("outer".site_id = "inner".site_id)
110.	1.053	1.053	↓ 1.0	892	1	→ Seq Scan on t_site_products sp (cost=0.00..55.29 rows=886 width=8) (actual time=0.004..1.053 rows=892 loops=1) Filter: (prod_id = 1)
111.	0.008	0.036	↓ 1.7	5	1	→ Hash (cost=7.53..7.53 rows=3 width=8) (actual time=0.036..0.036 rows=5 loops=1)
112.	0.014	0.028	↓ 1.7	5	1	→ Bitmap Heap Scan on tx_merch_site ms (cost=2.01..7.53 rows=3 width=8) (actual time=0.022..0.028 rows=5 loops=1) Recheck Cond: (merch_id = 34)
113.	0.014	0.014	↓ 1.7	5	1	→ Bitmap Index Scan on tx_merch_comp_pkey (cost=0.00..2.01 rows=3 width=0) (actual time=0.014..0.014 rows=5 loops=1) Index Cond: (merch_id = 34)
114.	2.146	2.178	↑ 32.3	31	121	→ Materialize (cost=13.50..23.50 rows=1000 width=4) (actual time=0.001..0.018 rows=31 loops=121)
115.	0.032	0.032	↑ 32.3	31	1	→ Function Scan on generate_series x (cost=0.00..12.50 rows=1000 width=4) (actual time=0.016..0.032 rows=31 loops=1)

"Sort  (cost=54080.40..54080.41 rows=1 width=68) (actual time=2824.307..2824.323 rows=31 loops=1)"
"  Sort Key: po.datetime"
"  ->  Nested Loop Left Join  (cost=45688.38..54080.39 rows=1 width=68) (actual time=1402.678..2824.240 rows=31 loops=1)"
"        Join Filter: (("inner".merch_id = "outer".merch_id) AND ("outer".prod_id = "inner".prod_id) AND ("inner".mydate = "outer".mydate))"
"        ->  Hash Join  (cost=16911.67..23972.60 rows=1 width=36) (actual time=204.167..309.868 rows=31 loops=1)"
"              Hash Cond: (("outer".merch_id = "inner".merch_id) AND ("outer".prod_id = "inner".prod_id) AND ("outer".datetime = "inner".date))"
"              ->  Seq Scan on t_price_order po  (cost=0.00..4498.37 rows=170837 width=28) (actual time=0.005..128.364 rows=174447 loops=1)"
"              ->  Hash  (cost=16911.34..16911.34 rows=44 width=24) (actual time=57.493..57.493 rows=31 loops=1)"
"                    ->  Subquery Scan b  (cost=16910.13..16911.34 rows=44 width=24) (actual time=57.400..57.460 rows=31 loops=1)"
"                          ->  HashAggregate  (cost=16910.13..16910.90 rows=44 width=20) (actual time=57.398..57.426 rows=31 loops=1)"
"                                ->  Nested Loop  (cost=19.54..15330.13 rows=158000 width=20) (actual time=0.752..40.210 rows=16277 loops=1)"
"                                      Join Filter: ("outer".datetime <= (('2012-04-01'::date + "inner".n) + '18:00:00'::time without time zone))"
"                                      ->  Nested Loop  (cost=6.04..1491.63 rows=474 width=16) (actual time=0.729..2.640 rows=554 loops=1)"
"                                            ->  Nested Loop  (cost=0.00..47.80 rows=1 width=8) (actual time=0.414..0.449 rows=1 loops=1)"
"                                                  ->  Index Scan using t_merchant_pkey on t_merchant m  (cost=0.00..5.89 rows=1 width=4) (actual time=0.016..0.017 rows=1 loops=1)"
"                                                        Index Cond: (merch_id = 34)"
"                                                  ->  Seq Scan on tx_merch_prod mp  (cost=0.00..41.89 rows=1 width=8) (actual time=0.395..0.428 rows=1 loops=1)"
"                                                        Filter: ((prod_id = 1) AND (merch_id = 34))"
"                                            ->  Bitmap Heap Scan on t_price_order po  (cost=6.04..1439.09 rows=474 width=16) (actual time=0.311..1.544 rows=554 loops=1)"
"                                                  Recheck Cond: (merch_id = 34)"
"                                                  Filter: (prod_id = 1)"
"                                                  ->  Bitmap Index Scan on ix_merch_id  (cost=0.00..6.04 rows=584 width=0) (actual time=0.200..0.200 rows=938 loops=1)"
"                                                        Index Cond: (merch_id = 34)"
"                                      ->  Materialize  (cost=13.50..23.50 rows=1000 width=4) (actual time=0.001..0.020 rows=31 loops=554)"
"                                            ->  Function Scan on generate_series x  (cost=0.00..12.50 rows=1000 width=4) (actual time=0.014..0.033 rows=31 loops=1)"
"        ->  Merge Join  (cost=28776.71..30107.61 rows=10 width=48) (actual time=80.856..81.075 rows=31 loops=31)"
"              Merge Cond: (("outer".prod_id = "inner".prod_id) AND ("outer".site_id = "inner".site_id) AND ("outer".datetime = "inner".date))"
"              ->  Sort  (cost=19718.61..20049.78 rows=132467 width=48) (actual time=32.660..54.920 rows=34201 loops=31)"
"                    Sort Key: pc.prod_id, pc.site_id, pc.datetime"
"                    ->  Append  (cost=1.02..3478.80 rows=132467 width=48) (actual time=0.383..260.183 rows=132452 loops=1)"
"                          ->  Bitmap Heap Scan on tx_prices pc  (cost=1.02..7.50 rows=3 width=48) (actual time=0.014..0.014 rows=0 loops=1)"
"                                Recheck Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                ->  Bitmap Index Scan on "cluster"  (cost=0.00..1.02 rows=3 width=0) (actual time=0.010..0.010 rows=0 loops=1)"
"                                      Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Bitmap Heap Scan on tx_prices_yy09mm08 pc  (cost=1.02..7.50 rows=3 width=48) (actual time=0.006..0.006 rows=0 loops=1)"
"                                Recheck Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                ->  Bitmap Index Scan on tx_prices_yy09mm08_datetime  (cost=0.00..1.02 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
"                                      Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy09mm09_datetime on tx_prices_yy09mm09 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy09mm10_datetime on tx_prices_yy09mm10 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.008..0.008 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy09mm11_datetime on tx_prices_yy09mm11 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.008..0.008 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy09mm12_datetime on tx_prices_yy09mm12 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.009..0.009 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy10mm01_datetime on tx_prices_yy10mm01 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy10mm02_datetime on tx_prices_yy10mm02 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy10mm03_datetime on tx_prices_yy10mm03 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy10mm04_datetime on tx_prices_yy10mm04 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy10mm05_datetime on tx_prices_yy10mm05 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy10mm06_datetime on tx_prices_yy10mm06 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy10mm07_datetime on tx_prices_yy10mm07 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy10mm08_datetime on tx_prices_yy10mm08 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy10mm09_datetime on tx_prices_yy10mm09 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy10mm10_datetime on tx_prices_yy10mm10 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy10mm11_datetime on tx_prices_yy10mm11 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy10mm12_datetime on tx_prices_yy10mm12 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy11mm01_datetime on tx_prices_yy11mm01 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy11mm02_datetime on tx_prices_yy11mm02 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy11mm03_datetime on tx_prices_yy11mm03 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy11mm04_datetime on tx_prices_yy11mm04 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy11mm05_datetime on tx_prices_yy11mm05 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy11mm06_datetime on tx_prices_yy11mm06 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy11mm07_datetime on tx_prices_yy11mm07 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy11mm08_datetime on tx_prices_yy11mm08 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy11mm09_datetime on tx_prices_yy11mm09 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy11mm10_datetime on tx_prices_yy11mm10 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy11mm11_datetime on tx_prices_yy11mm11 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.011..0.011 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy11mm12_datetime on tx_prices_yy11mm12 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.009..0.009 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy12mm01_datetime on tx_prices_yy12mm01 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.010..0.010 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy12mm02_datetime on tx_prices_yy12mm02 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.019..0.019 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using yy12mm03 on tx_prices_yy12mm03 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.009..0.009 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Seq Scan on tx_prices_yy12mm04 pc  (cost=0.00..3359.78 rows=132426 width=27) (actual time=0.007..118.882 rows=132452 loops=1)"
"                                Filter: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Index Scan using tx_prices_yy12mm05_datetime on tx_prices_yy12mm05 pc  (cost=0.00..3.02 rows=1 width=27) (actual time=0.018..0.018 rows=0 loops=1)"
"                                Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                          ->  Bitmap Heap Scan on tx_prices_yy12mm06 pc  (cost=1.02..7.50 rows=3 width=48) (actual time=0.008..0.008 rows=0 loops=1)"
"                                Recheck Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                ->  Bitmap Index Scan on cluster1206  (cost=0.00..1.02 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)"
"                                      Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"              ->  Sort  (cost=9058.10..9059.63 rows=613 width=28) (actual time=4.584..4.602 rows=31 loops=31)"
"                    Sort Key: b.prod_id, b.site_id, b.date"
"                    ->  Subquery Scan b  (cost=9012.86..9029.72 rows=613 width=28) (actual time=141.972..142.032 rows=31 loops=1)"
"                          ->  HashAggregate  (cost=9012.86..9023.59 rows=613 width=24) (actual time=141.968..141.995 rows=31 loops=1)"
"                                ->  Nested Loop  (cost=87.50..8426.91 rows=46876 width=24) (actual time=4.539..139.911 rows=2081 loops=1)"
"                                      Join Filter: ("outer".datetime <= (('2012-04-01'::date + "inner".n) + '18:00:00'::time without time zone))"
"                                      ->  Hash Join  (cost=74.00..4301.53 rows=141 width=20) (actual time=4.510..133.396 rows=121 loops=1)"
"                                            Hash Cond: ("outer".site_id = "inner".site_id)"
"                                            ->  Append  (cost=2.28..3807.23 rows=42102 width=16) (actual time=0.398..107.072 rows=40821 loops=1)"
"                                                  ->  Bitmap Heap Scan on tx_prices pc  (cost=2.28..6.11 rows=1 width=16) (actual time=0.020..0.020 rows=0 loops=1)"
"                                                        Recheck Cond: ((prod_id = 1) AND (datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        ->  BitmapAnd  (cost=2.28..2.28 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=1)"
"                                                              ->  Bitmap Index Scan on tx_prices_prod_id  (cost=0.00..1.01 rows=3 width=0) (actual time=0.015..0.015 rows=0 loops=1)"
"                                                                    Index Cond: (prod_id = 1)"
"                                                              ->  Bitmap Index Scan on "cluster"  (cost=0.00..1.02 rows=3 width=0) (never executed)"
"                                                                    Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                  ->  Bitmap Heap Scan on tx_prices_yy09mm08 pc  (cost=2.28..6.11 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=1)"
"                                                        Recheck Cond: ((prod_id = 1) AND (datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        ->  BitmapAnd  (cost=2.28..2.28 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
"                                                              ->  Bitmap Index Scan on tx_prices_prod_id_0908  (cost=0.00..1.01 rows=3 width=0) (actual time=0.003..0.003 rows=0 loops=1)"
"                                                                    Index Cond: (prod_id = 1)"
"                                                              ->  Bitmap Index Scan on tx_prices_yy09mm08_datetime  (cost=0.00..1.02 rows=3 width=0) (never executed)"
"                                                                    Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                  ->  Index Scan using tx_prices_yy09mm09_datetime on tx_prices_yy09mm09 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy09mm10_datetime on tx_prices_yy09mm10 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy09mm11_datetime on tx_prices_yy09mm11 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy09mm12_datetime on tx_prices_yy09mm12 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy10mm01_datetime on tx_prices_yy10mm01 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy10mm02_datetime on tx_prices_yy10mm02 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy10mm03_datetime on tx_prices_yy10mm03 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy10mm04_datetime on tx_prices_yy10mm04 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy10mm05_datetime on tx_prices_yy10mm05 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy10mm06_datetime on tx_prices_yy10mm06 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy10mm07_datetime on tx_prices_yy10mm07 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy10mm08_datetime on tx_prices_yy10mm08 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy10mm09_datetime on tx_prices_yy10mm09 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy10mm10_datetime on tx_prices_yy10mm10 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy10mm11_datetime on tx_prices_yy10mm11 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy10mm12_datetime on tx_prices_yy10mm12 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy11mm01_datetime on tx_prices_yy11mm01 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy11mm02_datetime on tx_prices_yy11mm02 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy11mm03_datetime on tx_prices_yy11mm03 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy11mm04_datetime on tx_prices_yy11mm04 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy11mm05_datetime on tx_prices_yy11mm05 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy11mm06_datetime on tx_prices_yy11mm06 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy11mm07_datetime on tx_prices_yy11mm07 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy11mm08_datetime on tx_prices_yy11mm08 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy11mm09_datetime on tx_prices_yy11mm09 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy11mm10_datetime on tx_prices_yy11mm10 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy11mm11_datetime on tx_prices_yy11mm11 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy11mm12_datetime on tx_prices_yy11mm12 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy12mm01_datetime on tx_prices_yy12mm01 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using tx_prices_yy12mm02_datetime on tx_prices_yy12mm02 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Index Scan using yy12mm03 on tx_prices_yy12mm03 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Seq Scan on tx_prices_yy12mm04 pc  (cost=0.00..3690.91 rows=42067 width=16) (actual time=0.012..63.532 rows=40821 loops=1)"
"                                                        Filter: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone) AND (prod_id = 1))"
"                                                  ->  Index Scan using tx_prices_yy12mm05_datetime on tx_prices_yy12mm05 pc  (cost=0.00..3.02 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=1)"
"                                                        Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                  ->  Bitmap Heap Scan on tx_prices_yy12mm06 pc  (cost=1.02..7.51 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=1)"
"                                                        Recheck Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                                        Filter: (prod_id = 1)"
"                                                        ->  Bitmap Index Scan on cluster1206  (cost=0.00..1.02 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)"
"                                                              Index Cond: ((datetime <= '2012-05-01 00:00:00'::timestamp without time zone) AND (datetime >= '2012-04-01 00:00:00'::timestamp without time zone))"
"                                            ->  Hash  (cost=71.71..71.71 rows=3 width=16) (actual time=1.622..1.622 rows=1 loops=1)"
"                                                  ->  Hash Join  (cost=7.54..71.71 rows=3 width=16) (actual time=1.575..1.619 rows=1 loops=1)"
"                                                        Hash Cond: ("outer".site_id = "inner".site_id)"
"                                                        ->  Seq Scan on t_site_products sp  (cost=0.00..55.29 rows=886 width=8) (actual time=0.004..1.053 rows=892 loops=1)"
"                                                              Filter: (prod_id = 1)"
"                                                        ->  Hash  (cost=7.53..7.53 rows=3 width=8) (actual time=0.036..0.036 rows=5 loops=1)"
"                                                              ->  Bitmap Heap Scan on tx_merch_site ms  (cost=2.01..7.53 rows=3 width=8) (actual time=0.022..0.028 rows=5 loops=1)"
"                                                                    Recheck Cond: (merch_id = 34)"
"                                                                    ->  Bitmap Index Scan on tx_merch_comp_pkey  (cost=0.00..2.01 rows=3 width=0) (actual time=0.014..0.014 rows=5 loops=1)"
"                                                                          Index Cond: (merch_id = 34)"
"                                      ->  Materialize  (cost=13.50..23.50 rows=1000 width=4) (actual time=0.001..0.018 rows=31 loops=121)"
"                                            ->  Function Scan on generate_series x  (cost=0.00..12.50 rows=1000 width=4) (actual time=0.016..0.032 rows=31 loops=1)"
"Total runtime: 2828.743 ms"

Per node type stats

node type	count	sum of times	% of query
Append	2	184.087 ms	6.5 %
Bitmap Heap Scan	8	1.374 ms	0.0 %
Bitmap Index Scan	10	0.258 ms	0.0 %
BitmapAnd	2	0.002 ms	0.0 %
Function Scan	2	0.065 ms	0.0 %
Hash	3	0.044 ms	0.0 %
Hash Join	3	149.243 ms	5.3 %
HashAggregate	2	19.300 ms	0.7 %
Index Scan	65	0.709 ms	0.0 %
Materialize	2	13.193 ms	0.5 %
Merge Join	1	668.143 ms	23.7 %
Nested Loop	4	31.478 ms	1.1 %
Nested Loop Left Join	1	1.047 ms	0.0 %
Seq Scan	5	312.259 ms	11.1 %
Sort	3	1443.050 ms	51.1 %
Subquery Scan b	2	0.071 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
t_merchant	1	0.017 ms	0.0 %
Index Scan	1	0.017 ms	100.0 %
t_price_order	2	129.708 ms	4.6 %
Bitmap Heap Scan	1	1.344 ms	1.0 %
Seq Scan	1	128.364 ms	99.0 %
t_site_products	1	1.053 ms	0.0 %
Seq Scan	1	1.053 ms	100.0 %
tx_merch_prod	1	0.428 ms	0.0 %
Seq Scan	1	0.428 ms	100.0 %
tx_merch_site	1	0.014 ms	0.0 %
Bitmap Heap Scan	1	0.014 ms	100.0 %
tx_prices	2	0.008 ms	0.0 %
Bitmap Heap Scan	2	0.008 ms	100.0 %
tx_prices_yy09mm08	2	0.004 ms	0.0 %
Bitmap Heap Scan	2	0.004 ms	100.0 %
tx_prices_yy09mm09	2	0.024 ms	0.0 %
Index Scan	2	0.024 ms	100.0 %
tx_prices_yy09mm10	2	0.017 ms	0.0 %
Index Scan	2	0.017 ms	100.0 %
tx_prices_yy09mm11	2	0.017 ms	0.0 %
Index Scan	2	0.017 ms	100.0 %
tx_prices_yy09mm12	2	0.019 ms	0.0 %
Index Scan	2	0.019 ms	100.0 %
tx_prices_yy10mm01	2	0.023 ms	0.0 %
Index Scan	2	0.023 ms	100.0 %
tx_prices_yy10mm02	2	0.021 ms	0.0 %
Index Scan	2	0.021 ms	100.0 %
tx_prices_yy10mm03	2	0.020 ms	0.0 %
Index Scan	2	0.020 ms	100.0 %
tx_prices_yy10mm04	2	0.023 ms	0.0 %
Index Scan	2	0.023 ms	100.0 %
tx_prices_yy10mm05	2	0.023 ms	0.0 %
Index Scan	2	0.023 ms	100.0 %
tx_prices_yy10mm06	2	0.022 ms	0.0 %
Index Scan	2	0.022 ms	100.0 %
tx_prices_yy10mm07	2	0.022 ms	0.0 %
Index Scan	2	0.022 ms	100.0 %
tx_prices_yy10mm08	2	0.021 ms	0.0 %
Index Scan	2	0.021 ms	100.0 %
tx_prices_yy10mm09	2	0.020 ms	0.0 %
Index Scan	2	0.020 ms	100.0 %
tx_prices_yy10mm10	2	0.021 ms	0.0 %
Index Scan	2	0.021 ms	100.0 %
tx_prices_yy10mm11	2	0.022 ms	0.0 %
Index Scan	2	0.022 ms	100.0 %
tx_prices_yy10mm12	2	0.022 ms	0.0 %
Index Scan	2	0.022 ms	100.0 %
tx_prices_yy11mm01	2	0.021 ms	0.0 %
Index Scan	2	0.021 ms	100.0 %
tx_prices_yy11mm02	2	0.022 ms	0.0 %
Index Scan	2	0.022 ms	100.0 %
tx_prices_yy11mm03	2	0.022 ms	0.0 %
Index Scan	2	0.022 ms	100.0 %
tx_prices_yy11mm04	2	0.020 ms	0.0 %
Index Scan	2	0.020 ms	100.0 %
tx_prices_yy11mm05	2	0.020 ms	0.0 %
Index Scan	2	0.020 ms	100.0 %
tx_prices_yy11mm06	2	0.021 ms	0.0 %
Index Scan	2	0.021 ms	100.0 %
tx_prices_yy11mm07	2	0.021 ms	0.0 %
Index Scan	2	0.021 ms	100.0 %
tx_prices_yy11mm08	2	0.021 ms	0.0 %
Index Scan	2	0.021 ms	100.0 %
tx_prices_yy11mm09	2	0.021 ms	0.0 %
Index Scan	2	0.021 ms	100.0 %
tx_prices_yy11mm10	2	0.022 ms	0.0 %
Index Scan	2	0.022 ms	100.0 %
tx_prices_yy11mm11	2	0.022 ms	0.0 %
Index Scan	2	0.022 ms	100.0 %
tx_prices_yy11mm12	2	0.019 ms	0.0 %
Index Scan	2	0.019 ms	100.0 %
tx_prices_yy12mm01	2	0.020 ms	0.0 %
Index Scan	2	0.020 ms	100.0 %
tx_prices_yy12mm02	2	0.030 ms	0.0 %
Index Scan	2	0.030 ms	100.0 %
tx_prices_yy12mm03	2	0.018 ms	0.0 %
Index Scan	2	0.018 ms	100.0 %
tx_prices_yy12mm04	2	182.414 ms	6.5 %
Seq Scan	2	182.414 ms	100.0 %
tx_prices_yy12mm05	2	0.035 ms	0.0 %
Index Scan	2	0.035 ms	100.0 %
tx_prices_yy12mm06	2	0.004 ms	0.0 %
Bitmap Heap Scan	2	0.004 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 1hV

Colorize:

Columns visibility:

Per node type stats

Per table stats