explain.depesz.com

PostgreSQL's explain analyze made readable

Result: varW

Settings
# exclusive inclusive rows x rows loops node
1. 7.994 2,611.419 ↑ 1.0 1 1

Aggregate (cost=3,563.60..3,563.61 rows=1 width=8) (actual time=2,611.418..2,611.419 rows=1 loops=1)

2. 13.286 2,603.425 ↓ 7.7 64,789 1

Nested Loop (cost=1.05..3,542.52 rows=8,431 width=0) (actual time=1.513..2,603.425 rows=64,789 loops=1)

3. 0.902 0.951 ↓ 1.8 178 1

HashAggregate (cost=0.77..2.02 rows=100 width=32) (actual time=0.137..0.951 rows=178 loops=1)

  • Group Key: unnest('{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}'::web_economy.economy_code[])
4. 0.042 0.049 ↓ 1.8 178 1

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.023..0.049 rows=178 loops=1)

5. 0.007 0.007 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.006..0.007 rows=1 loops=1)

6. 2,589.188 2,589.188 ↓ 4.3 364 178

Index Scan using "business % (location(*), economy(*))" on business (cost=0.28..34.55 rows=84 width=47) (actual time=0.608..14.546 rows=364 loops=178)

  • Index Cond: (cache.economy(business.*) @ (((unnest('{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}'::web_economy.economy_code[])))::text)::ltxtquery)