[ { "Plan": { "Node Type": "Nested Loop", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 10004203783.77, "Total Cost": 1939632407738.00, "Plan Rows": 260, "Plan Width": 40, "Actual Startup Time": 635.868, "Actual Total Time": 68184.518, "Actual Rows": 1783, "Actual Loops": 1, "Inner Unique": false, "Shared Hit Blocks": 11511, "Shared Read Blocks": 12122, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Relation Name": "landolt", "Alias": "a", "Startup Cost": 10000000000.00, "Total Cost": 10000000016.26, "Plan Rows": 526, "Plan Width": 20, "Actual Startup Time": 3.854, "Actual Total Time": 14.944, "Actual Rows": 526, "Actual Loops": 1, "Shared Hit Blocks": 0, "Shared Read Blocks": 11, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Heap Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Relation Name": "allwise", "Alias": "b", "Startup Cost": 4203783.77, "Total Cost": 3668502676.26, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 85.328, "Actual Total Time": 129.421, "Actual Rows": 3, "Actual Loops": 526, "Recheck Cond": "(((q3c_ang2ipix((ra)::double precision, (de)::double precision) >= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 0)) AND (q3c_ang2ipix((ra)::double precision, (de)::double precision) <= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 1))) OR ((q3c_ang2ipix((ra)::double precision, (de)::double precision) >= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 2)) AND (q3c_ang2ipix((ra)::double precision, (de)::double precision) <= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 3))) OR ((q3c_ang2ipix((ra)::double precision, (de)::double precision) >= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 4)) AND (q3c_ang2ipix((ra)::double precision, (de)::double precision) <= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 5))) OR ((q3c_ang2ipix((ra)::double precision, (de)::double precision) >= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 6)) AND (q3c_ang2ipix((ra)::double precision, (de)::double precision) <= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 7))))", "Rows Removed by Index Recheck": 0, "Filter": "((q3c_sindist(a.ra, a.de, (ra)::double precision, (de)::double precision) < '5.288496861974292e-09'::double precision) AND ('0.008333333333333333'::double precision ==<<>>== ROW(a.ra, a.de, (ra)::double precision, (de)::double precision)::q3c_type))", "Rows Removed by Filter": 25, "Exact Heap Blocks": 15173, "Lossy Heap Blocks": 0, "Shared Hit Blocks": 11511, "Shared Read Blocks": 12111, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "BitmapOr", "Parent Relationship": "Outer", "Parallel Aware": false, "Startup Cost": 4203783.77, "Total Cost": 4203783.77, "Plan Rows": 332278926, "Plan Width": 0, "Actual Startup Time": 26.199, "Actual Total Time": 26.199, "Actual Rows": 0, "Actual Loops": 526, "Shared Hit Blocks": 7984, "Shared Read Blocks": 465, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "q3c_allwise_idx", "Startup Cost": 0.00, "Total Cost": 1050945.94, "Plan Rows": 83069732, "Plan Width": 0, "Actual Startup Time": 21.323, "Actual Total Time": 21.323, "Actual Rows": 10, "Actual Loops": 526, "Index Cond": "((q3c_ang2ipix((ra)::double precision, (de)::double precision) >= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 0)) AND (q3c_ang2ipix((ra)::double precision, (de)::double precision) <= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 1)))", "Shared Hit Blocks": 1752, "Shared Read Blocks": 363, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "q3c_allwise_idx", "Startup Cost": 0.00, "Total Cost": 1050945.94, "Plan Rows": 83069732, "Plan Width": 0, "Actual Startup Time": 3.608, "Actual Total Time": 3.608, "Actual Rows": 9, "Actual Loops": 526, "Index Cond": "((q3c_ang2ipix((ra)::double precision, (de)::double precision) >= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 2)) AND (q3c_ang2ipix((ra)::double precision, (de)::double precision) <= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 3)))", "Shared Hit Blocks": 2044, "Shared Read Blocks": 69, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "q3c_allwise_idx", "Startup Cost": 0.00, "Total Cost": 1050945.94, "Plan Rows": 83069732, "Plan Width": 0, "Actual Startup Time": 1.188, "Actual Total Time": 1.188, "Actual Rows": 5, "Actual Loops": 526, "Index Cond": "((q3c_ang2ipix((ra)::double precision, (de)::double precision) >= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 4)) AND (q3c_ang2ipix((ra)::double precision, (de)::double precision) <= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 5)))", "Shared Hit Blocks": 2091, "Shared Read Blocks": 22, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "q3c_allwise_idx", "Startup Cost": 0.00, "Total Cost": 1050945.94, "Plan Rows": 83069732, "Plan Width": 0, "Actual Startup Time": 0.061, "Actual Total Time": 0.061, "Actual Rows": 5, "Actual Loops": 526, "Index Cond": "((q3c_ang2ipix((ra)::double precision, (de)::double precision) >= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 6)) AND (q3c_ang2ipix((ra)::double precision, (de)::double precision) <= q3c_nearby_it(a.ra, a.de, '0.008333333333333333'::double precision, 7)))", "Shared Hit Blocks": 2097, "Shared Read Blocks": 11, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] } ] }, "Planning Time": 14523.104, "Triggers": [ ], "Execution Time": 69002.927 } ]