explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G7MZ

Settings
# exclusive inclusive rows x rows loops node
1. 16.956 2,065.858 ↑ 1.0 42 1

HashAggregate (cost=8,781.43..8,781.95 rows=42 width=50) (actual time=2,065.842..2,065.858 rows=42 loops=1)

  • Group Key: county
2. 8.406 2,048.902 ↓ 4.7 64,789 1

Bitmap Heap Scan on business (cost=1,468.07..8,643.90 rows=13,753 width=14) (actual time=2,040.577..2,048.902 rows=64,789 loops=1)

  • Recheck Cond: (cache.economy(business.*) @ ANY ('{266,462,551,383,521,477,325,182,104,011,478,465,261,439,022,181,619,268,274,282,132,422,512,201,203,272,110,264,309,351,013,172,471,429,293,466,141,139,143,052,553,222,241,381,324,291,303,843,234,452,281,799,842,237,061,254,469,562,107,284,152,205,162,292,321,120,841,432,821,091,133,106,108,552,206,202,750,464,352,221,024,109,072,252,016,639,301,251,279,474,232,014,302,245,370,236,204,089,273,231,323,259,433,631,161,421,472,263,101,353,102,023,131,211,390,099,192,235,151,267,559,310,244,012,289,463,952,233,062,612,015,611,243,142,105,283,256,561,331,322,473,813,242,212,239,255,081,467,412,253,171,692,275,360,071,021,620,329,476,051,563,304,191,960,103,382,970,494,702,271,265,461,262,511,257,791,479,332}'::ltxtquery[]))
  • Heap Blocks: exact=540
3. 2,040.496 2,040.496 ↓ 4.7 64,789 1

Bitmap Index Scan on "business % (location(*), economy(*))" (cost=0.00..1,464.63 rows=13,753 width=0) (actual time=2,040.496..2,040.496 rows=64,789 loops=1)

  • Index Cond: (cache.economy(business.*) @ ANY ('{266,462,551,383,521,477,325,182,104,011,478,465,261,439,022,181,619,268,274,282,132,422,512,201,203,272,110,264,309,351,013,172,471,429,293,466,141,139,143,052,553,222,241,381,324,291,303,843,234,452,281,799,842,237,061,254,469,562,107,284,152,205,162,292,321,120,841,432,821,091,133,106,108,552,206,202,750,464,352,221,024,109,072,252,016,639,301,251,279,474,232,014,302,245,370,236,204,089,273,231,323,259,433,631,161,421,472,263,101,353,102,023,131,211,390,099,192,235,151,267,559,310,244,012,289,463,952,233,062,612,015,611,243,142,105,283,256,561,331,322,473,813,242,212,239,255,081,467,412,253,171,692,275,360,071,021,620,329,476,051,563,304,191,960,103,382,970,494,702,271,265,461,262,511,257,791,479,332}'::ltxtquery[]))