explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iNYN

Settings
# exclusive inclusive rows x rows loops node
1. 0.758 27,118.985 ↑ 1.0 204 1

Nested Loop Left Join (cost=791.44..3,133.90 rows=212 width=106) (actual time=2.019..27,118.985 rows=204 loops=1)

2. 70.787 72.723 ↑ 1.0 204 1

Bitmap Heap Scan on location (cost=790.75..1,429.21 rows=204 width=37) (actual time=1.967..72.723 rows=204 loops=1)

  • Recheck Cond: (id = ANY ('{128495,132437,130757,116462,105070,112279,103003,129759,134757,102886,112681,116177,142226,132731,143030,123878,131690,131450,118496,103704,131367,116133,116511,153418,136930,100652,140997,124305,115617,124991,112020,155332,156987,151840,129568,116422,117295,122156,143494,110760,122169,123249,110544,143667,112824,130754,113597,143259,113782,112130,101121,145126,120196,148861,126114,120753,117120,148746,156009,120228,119359,115282,121873,120503,104850,154092,116550,114584,119930,126388,118069,111235,129882,145691,144258,130452,139889,142851,150160,156709,120643,158523,127004,101257,119681,119346,114443,108353,114040,139336,133427,124096,110962,148804,132752,211617,110380,129885,148658,101365,113270,105914,126148,143557,137826,153384,135894,146627,149356,114929,120108,113659,127234,154452,121004,118104,138983,131433,110807,119214,144809,124690,135130,149199,131830,116079,120813,115298,127372,153667,124799,119491,119344,103528,230779,126149,125085,134251,155216,131629,105957,135869,149335,110335,129952,130363,145463,135336,151856,120019,112184,134011,117262,127105,146491,129635,150453,114721,115189,116569,154412,142743,102743,156068,105114,126166,122964,125250,117657,142452,133000,117025,116850,125969,131782,156107,130171,126392,156799,132295,146920,133318,115593,120586,103161,131179,125870,157502,151029,144435,107662,158074,115951,128516,111078,155128,123764,132254,142647,114747,111828,128478,144718,138774}'::text[]))
  • Heap Blocks: exact=192
3. 1.936 1.936 ↑ 1.0 204 1

Bitmap Index Scan on location_pkey (cost=0.00..790.70 rows=204 width=0) (actual time=1.936..1.936 rows=204 loops=1)

  • Index Cond: (id = ANY ('{128495,132437,130757,116462,105070,112279,103003,129759,134757,102886,112681,116177,142226,132731,143030,123878,131690,131450,118496,103704,131367,116133,116511,153418,136930,100652,140997,124305,115617,124991,112020,155332,156987,151840,129568,116422,117295,122156,143494,110760,122169,123249,110544,143667,112824,130754,113597,143259,113782,112130,101121,145126,120196,148861,126114,120753,117120,148746,156009,120228,119359,115282,121873,120503,104850,154092,116550,114584,119930,126388,118069,111235,129882,145691,144258,130452,139889,142851,150160,156709,120643,158523,127004,101257,119681,119346,114443,108353,114040,139336,133427,124096,110962,148804,132752,211617,110380,129885,148658,101365,113270,105914,126148,143557,137826,153384,135894,146627,149356,114929,120108,113659,127234,154452,121004,118104,138983,131433,110807,119214,144809,124690,135130,149199,131830,116079,120813,115298,127372,153667,124799,119491,119344,103528,230779,126149,125085,134251,155216,131629,105957,135869,149335,110335,129952,130363,145463,135336,151856,120019,112184,134011,117262,127105,146491,129635,150453,114721,115189,116569,154412,142743,102743,156068,105114,126166,122964,125250,117657,142452,133000,117025,116850,125969,131782,156107,130171,126392,156799,132295,146920,133318,115593,120586,103161,131179,125870,157502,151029,144435,107662,158074,115951,128516,111078,155128,123764,132254,142647,114747,111828,128478,144718,138774}'::text[]))
4. 2.244 27,045.504 ↑ 1.0 1 204

Nested Loop Left Join (cost=0.69..8.35 rows=1 width=75) (actual time=131.081..132.576 rows=1 loops=204)

5. 26,994.708 26,994.708 ↑ 1.0 1 204

Index Scan using location_in_group_pkey on location_in_group x1 (cost=0.42..8.04 rows=1 width=47) (actual time=130.833..132.327 rows=1 loops=204)

  • Index Cond: (location_id = location.id)
6. 48.552 48.552 ↑ 1.0 1 204

Index Scan using location_group_pkey on location_group g (cost=0.28..0.29 rows=1 width=57) (actual time=0.237..0.238 rows=1 loops=204)

  • Index Cond: (x1.location_group_id = id)
Planning time : 1.251 ms
Execution time : 27,119.383 ms