Jelis
А можете привести какие нитбудь агригирующие запросы с експлайном? Думаю всем будет очнь интересно!
K sojaleniu, v silu specifiki zadach imenno aggregiruiushie zaprosy fakticheski ne ispolzuyutsia. Osnovnoi krug zaprosov -- raznogo roda prostranstvennye zaprosy na sfere:
Para primerov:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
explain analyze select * from sdssdr5.photoobjall where q3c_radial_query(ra,dec, 190 , 10 , 1 );
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on photoobjall (cost= 1499 . 69 .. 739361 . 67 rows= 50309 width= 1828 ) (actual time= 835 . 190 .. 8807 . 546 rows= 103161 loops= 1 )
Recheck Cond: (((q3c_ang2ipix(ra, "dec") >= 4338021972320452608 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4338092341064630272 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4339570084692361216 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339587676878405632 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4337916419204186112 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337934011390230528 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4337969195762319360 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337986787948363776 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4338004380134408192 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4338021972320452608 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4340344140878315520 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4340361733064359936 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4337828458273964032 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337846050460008448 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4337846050460008448 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337863642646052864 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4337863642646052864 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337881234832097280 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4337881234832097280 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337898827018141696 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4337951603576274944 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337969195762319360 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4339499715948183552 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339517308134227968 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4338796028506406912 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4338813620692451328 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4339587676878405632 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339605269064450048 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4339605269064450048 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339622861250494464 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4339622861250494464 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339640453436538880 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4337898827018141696 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337916419204186112 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4337934011390230528 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337951603576274944 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4337986787948363776 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4338004380134408192 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4339517308134227968 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339534900320272384 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4339552492506316800 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339570084692361216 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4338690475390140416 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4338708067576184832 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4338831212878495744 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4338848805064540160 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)))
Filter: (q3c_sindist(ra, "dec", 190 ::double precision, 10 ::double precision) < 7 .61524218043804e- 05 ::double precision)
-> BitmapOr (cost= 1499 . 69 .. 1499 . 69 rows= 150957 width= 0 ) (actual time= 269 . 646 .. 269 . 646 rows= 0 loops= 1 )
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 204 . 35 rows= 23224 width= 0 ) (actual time= 90 . 730 .. 90 . 730 rows= 25262 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4338021972320452608 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4338092341064630272 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 29 . 999 .. 29 . 999 rows= 5492 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4339570084692361216 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339587676878405632 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 19 . 891 .. 19 . 891 rows= 5800 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4337916419204186112 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337934011390230528 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 19 . 838 .. 19 . 838 rows= 5706 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4337969195762319360 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337986787948363776 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 3 . 294 .. 3 . 294 rows= 5713 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4338004380134408192 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4338021972320452608 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 015 .. 0 . 015 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 11 . 757 .. 11 . 757 rows= 6403 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4340344140878315520 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4340361733064359936 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 13 . 386 .. 13 . 386 rows= 4618 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4337828458273964032 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337846050460008448 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 1 . 867 .. 1 . 867 rows= 5134 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4337846050460008448 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337863642646052864 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 1 . 834 .. 1 . 834 rows= 5746 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4337863642646052864 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337881234832097280 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 20 . 814 .. 20 . 814 rows= 5468 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4337881234832097280 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337898827018141696 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 2 . 195 .. 2 . 195 rows= 5023 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4337951603576274944 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337969195762319360 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 10 . 065 .. 10 . 065 rows= 5300 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4339499715948183552 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339517308134227968 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 7 . 355 .. 7 . 355 rows= 5307 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4338796028506406912 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4338813620692451328 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 2 . 530 .. 2 . 530 rows= 6969 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4339587676878405632 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339605269064450048 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 4 . 354 .. 4 . 354 rows= 5302 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4339605269064450048 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339622861250494464 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 2 . 566 .. 2 . 566 rows= 7168 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4339622861250494464 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339640453436538880 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 2 . 780 .. 2 . 780 rows= 7300 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4337898827018141696 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337916419204186112 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 2 . 378 .. 2 . 378 rows= 7316 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4337934011390230528 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4337951603576274944 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 1 . 683 .. 1 . 683 rows= 5114 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4337986787948363776 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4338004380134408192 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 1 . 971 .. 1 . 971 rows= 5498 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4339517308134227968 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339534900320272384 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 7 . 819 .. 7 . 819 rows= 5392 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4339552492506316800 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4339570084692361216 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 7 . 749 .. 7 . 749 rows= 5677 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4338690475390140416 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4338708067576184832 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 51 . 84 rows= 5806 width= 0 ) (actual time= 2 . 145 .. 2 . 145 rows= 5909 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4338831212878495744 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4338848805064540160 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 017 .. 0 . 017 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on q3c_sdss (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
Total runtime: 8837 . 788 ms
( 205 rows)
Primer 2:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
explain analyze select * from (select * from ( select ra AS __match_ra, dec AS __match_dec, * from twomass.psc) as a where q3c_radial_query(__match_ra,__match_dec, 202 . 01458 , 33 . 55583 , 0 . 5 ) offset 0 ) as a left join sdssdr5.phototag as b on q3c_join(a.__match_ra,a.__match_dec,b.ra,b.dec, 1 .388888888888889E- 4 ) offset 0 ;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost= 1376628 . 93 .. 64353441614 . 27 rows= 96715727560 width= 826 ) (actual time= 1 . 515 .. 72 . 349 rows= 2368 loops= 1 )
-> Nested Loop Left Join (cost= 1376628 . 93 .. 64353441614 . 27 rows= 96715727560 width= 826 ) (actual time= 1 . 513 .. 71 . 546 rows= 2368 loops= 1 )
Join Filter: ((((q3c_ang2ipix("inner".ra, "inner"."dec") >= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 0 )) AND (q3c_ang2ipix("inner".ra, "inner"."dec") <= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 1 ))) OR ((q3c_ang2ipix("inner".ra, "inner"."dec") >= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 2 )) AND (q3c_ang2ipix("inner".ra, "inner"."dec") <= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 3 ))) OR ((q3c_ang2ipix("inner".ra, "inner"."dec") >= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 4 )) AND (q3c_ang2ipix("inner".ra, "inner"."dec") <= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 5 ))) OR ((q3c_ang2ipix("inner".ra, "inner"."dec") >= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 6 )) AND (q3c_ang2ipix("inner".ra, "inner"."dec") <= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 7 )))) AND (q3c_sindist("outer".ra, "outer"."dec", "inner".ra, "inner"."dec") < 1 .4690269086929e- 12 ::double precision))
-> Limit (cost= 243 . 08 .. 32685 . 46 rows= 2180 width= 290 ) (actual time= 1 . 381 .. 7 . 685 rows= 1127 loops= 1 )
-> Bitmap Heap Scan on psc (cost= 243 . 08 .. 32685 . 46 rows= 2180 width= 290 ) (actual time= 1 . 381 .. 7 . 294 rows= 1127 loops= 1 )
Recheck Cond: (((q3c_ang2ipix(ra, "dec") >= 4501576525975388160 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501594118161432576 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501805224393965568 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501822816580009984 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501611710347476992 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501629302533521408 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4502192252486942720 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502196650533453824 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501998738440454144 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502003136486965248 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4502003136486965248 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502007534533476352 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4502196650533453824 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502201048579964928 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4502201048579964928 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502205446626476032 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501572127928877056 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501576525975388160 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501778836114898944 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501783234161410048 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4502011932579987456 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502016330626498560 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501598516207943680 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501602914254454784 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501607312300965888 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501611710347476992 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501673282998632448 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501677681045143552 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501558933789343744 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501563331835854848 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501563331835854848 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501567729882365952 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501981146254409728 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501985544300920832 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501985544300920832 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501989942347431936 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501770040021876736 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501774438068387840 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501822816580009984 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501827214626521088 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4502033922812542976 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502038320859054080 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4502038320859054080 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502042718905565184 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4502209844672987136 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502214242719498240 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4502227436859031552 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502231834905542656 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501594118161432576 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501598516207943680 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4502205446626476032 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502209844672987136 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501567729882365952 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501572127928877056 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501994340393943040 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501998738440454144 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501774438068387840 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501778836114898944 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501783234161410048 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501787632207921152 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501796428300943360 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501800826347454464 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501831612673032192 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501836010719543296 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4502007534533476352 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502011932579987456 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4502218640766009344 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502223038812520448 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4502231834905542656 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502236232952053760 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501466574812610560 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501470972859121664 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501479768952143872 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501484166998654976 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501484166998654976 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501488565045166080 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 4501602914254454784 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501607312300965888 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)) OR ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint)))
Filter: (q3c_sindist(ra, "dec", 202 . 01458 ::double precision, 33 . 55583 ::double precision) < 1 .90384679143556e- 05 ::double precision)
-> BitmapOr (cost= 243 . 08 .. 243 . 08 rows= 6539 width= 0 ) (actual time= 1 . 219 .. 1 . 219 rows= 0 loops= 1 )
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 6 . 27 rows= 545 width= 0 ) (actual time= 0 . 087 .. 0 . 087 rows= 150 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501576525975388160 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501594118161432576 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 6 . 27 rows= 545 width= 0 ) (actual time= 0 . 037 .. 0 . 037 rows= 119 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501805224393965568 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501822816580009984 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 6 . 27 rows= 545 width= 0 ) (actual time= 0 . 040 .. 0 . 040 rows= 138 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501611710347476992 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501629302533521408 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 021 .. 0 . 021 rows= 39 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4502192252486942720 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502196650533453824 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 019 .. 0 . 019 rows= 27 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501998738440454144 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502003136486965248 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 016 .. 0 . 016 rows= 37 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4502003136486965248 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502007534533476352 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 016 .. 0 . 016 rows= 32 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4502196650533453824 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502201048579964928 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 017 .. 0 . 017 rows= 40 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4502201048579964928 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502205446626476032 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 013 .. 0 . 013 rows= 23 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501572127928877056 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501576525975388160 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 022 .. 0 . 022 rows= 50 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501778836114898944 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501783234161410048 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 016 .. 0 . 016 rows= 32 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4502011932579987456 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502016330626498560 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 015 .. 0 . 015 rows= 26 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501598516207943680 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501602914254454784 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 015 .. 0 . 015 rows= 31 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501607312300965888 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501611710347476992 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 015 .. 0 . 015 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 017 .. 0 . 017 rows= 29 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501673282998632448 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501677681045143552 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 014 .. 0 . 014 rows= 25 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501558933789343744 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501563331835854848 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 013 .. 0 . 013 rows= 24 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501563331835854848 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501567729882365952 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 017 .. 0 . 017 rows= 25 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501981146254409728 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501985544300920832 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 014 .. 0 . 014 rows= 27 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501985544300920832 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501989942347431936 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 014 .. 0 . 014 rows= 30 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501770040021876736 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501774438068387840 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 012 .. 0 . 012 rows= 20 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501822816580009984 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501827214626521088 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 021 .. 0 . 021 rows= 34 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4502033922812542976 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502038320859054080 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 017 .. 0 . 017 rows= 37 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4502038320859054080 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502042718905565184 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 017 .. 0 . 017 rows= 36 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4502209844672987136 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502214242719498240 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 017 .. 0 . 017 rows= 40 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4502227436859031552 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502231834905542656 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 014 .. 0 . 014 rows= 25 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501594118161432576 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501598516207943680 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 015 .. 0 . 015 rows= 32 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4502205446626476032 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502209844672987136 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 013 .. 0 . 013 rows= 28 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501567729882365952 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501572127928877056 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 015 .. 0 . 015 rows= 31 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501994340393943040 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501998738440454144 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 017 .. 0 . 017 rows= 37 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501774438068387840 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501778836114898944 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 016 .. 0 . 016 rows= 36 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501783234161410048 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501787632207921152 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 015 .. 0 . 015 rows= 31 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501796428300943360 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501800826347454464 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 015 .. 0 . 015 rows= 29 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501831612673032192 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501836010719543296 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 014 .. 0 . 014 rows= 34 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4502007534533476352 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502011932579987456 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 016 .. 0 . 016 rows= 36 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4502218640766009344 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502223038812520448 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 015 .. 0 . 015 rows= 31 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4502231834905542656 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4502236232952053760 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 016 .. 0 . 016 rows= 27 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501466574812610560 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501470972859121664 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 017 .. 0 . 017 rows= 37 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501479768952143872 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501484166998654976 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 017 .. 0 . 017 rows= 34 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501484166998654976 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501488565045166080 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 82 rows= 136 width= 0 ) (actual time= 0 . 016 .. 0 . 016 rows= 40 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 4501602914254454784 ::bigint) AND (q3c_ang2ipix(ra, "dec") < 4501607312300965888 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Index Scan on twomass_q3c_idx (cost= 0 . 00 .. 2 . 01 rows= 1 width= 0 ) (actual time= 0 . 008 .. 0 . 008 rows= 0 loops= 1 )
Index Cond: ((q3c_ang2ipix(ra, "dec") >= 1 ::bigint) AND (q3c_ang2ipix(ra, "dec") < - 1 ::bigint))
-> Bitmap Heap Scan on phototag b (cost= 1376385 . 84 .. 17711439 . 84 rows= 157446300 width= 288 ) (actual time= 0 . 034 .. 0 . 036 rows= 2 loops= 1127 )
Recheck Cond: (((q3c_ang2ipix(b.ra, b."dec") >= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 0 )) AND (q3c_ang2ipix(b.ra, b."dec") <= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 1 ))) OR ((q3c_ang2ipix(b.ra, b."dec") >= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 2 )) AND (q3c_ang2ipix(b.ra, b."dec") <= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 3 ))) OR ((q3c_ang2ipix(b.ra, b."dec") >= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 4 )) AND (q3c_ang2ipix(b.ra, b."dec") <= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 5 ))) OR ((q3c_ang2ipix(b.ra, b."dec") >= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 6 )) AND (q3c_ang2ipix(b.ra, b."dec") <= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 7 ))))
-> BitmapOr (cost= 1376385 . 84 .. 1376385 . 84 rows= 157446300 width= 0 ) (actual time= 0 . 032 .. 0 . 032 rows= 0 loops= 1127 )
-> Bitmap Index Scan on q3c_phototag_idx (cost= 0 . 00 .. 344096 . 46 rows= 39361575 width= 0 ) (actual time= 0 . 009 .. 0 . 009 rows= 1 loops= 1127 )
Index Cond: ((q3c_ang2ipix(b.ra, b."dec") >= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 0 )) AND (q3c_ang2ipix(b.ra, b."dec") <= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 1 )))
-> Bitmap Index Scan on q3c_phototag_idx (cost= 0 . 00 .. 344096 . 46 rows= 39361575 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 1 loops= 1127 )
Index Cond: ((q3c_ang2ipix(b.ra, b."dec") >= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 2 )) AND (q3c_ang2ipix(b.ra, b."dec") <= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 3 )))
-> Bitmap Index Scan on q3c_phototag_idx (cost= 0 . 00 .. 344096 . 46 rows= 39361575 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1127 )
Index Cond: ((q3c_ang2ipix(b.ra, b."dec") >= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 4 )) AND (q3c_ang2ipix(b.ra, b."dec") <= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 5 )))
-> Bitmap Index Scan on q3c_phototag_idx (cost= 0 . 00 .. 344096 . 46 rows= 39361575 width= 0 ) (actual time= 0 . 007 .. 0 . 007 rows= 0 loops= 1127 )
Index Cond: ((q3c_ang2ipix(b.ra, b."dec") >= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 6 )) AND (q3c_ang2ipix(b.ra, b."dec") <= q3c_nearby_it("outer".ra, "outer"."dec", 0 . 000138888888888889 ::double precision, 7 )))
Total runtime: 74 . 314 ms
( 220 rows)
V obshem nichego vpechiatliaushego... |
