explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4jjN

Settings
# exclusive inclusive rows x rows loops node
1. 0.038 2.216 ↑ 4.0 2 1

Nested Loop (cost=0.17..804.28 rows=8 width=4) (actual time=0.327..2.216 rows=2 loops=1)

2. 0.278 0.278 ↓ 1.0 100 1

Index Scan using users_pkey on users (cost=0.09..407.11 rows=97 width=4) (actual time=0.013..0.278 rows=100 loops=1)

  • Index Cond: (id = ANY ('{11710,11711,11712,17680,36011,65310,65311,65313,65321,72610,72914,72915,73206,92899,94536,95401,95464,99140,99158,99166,132307,134828,134830,134836,134841,134854,140206,169639,169654,199284,200673,594668,596601,819791,955436,955476,1207348,1233931,1233932,1233933,1233935,1235631,1237876,1241603,1242068,1414625,1414626,1414627,1414628,1414629,1414630,1414631,1414632,1414633,1414634,1414635,1414636,1414637,1414638,1414639,1414640,1414641,1414642,1414643,1414644,1414645,1414646,1414647,1414648,1414649,1414650,1414651,1414652,1414653,1414654,1414655,1414656,1414657,1414658,1414659,1414660,1414661,1414662,1414663,1414664,1414665,1414666,1414667,1414668,1414669,1414670,1414671,1414672,1414673,1414674,1414675,1414676,1414677,1414678,1414679}'::integer[]))
  • Filter: (deleted_at IS NULL)
3. 1.900 1.900 ↓ 0.0 0 100

Index Scan using user_hubs_user_index on user_hubs (cost=0.09..4.09 rows=1 width=4) (actual time=0.017..0.019 rows=0 loops=100)

  • Index Cond: (user_id = users.id)
  • Filter: ((deleted_at IS NULL) AND (hub_id = 39) AND (user_type = 'alumni'::text))
  • Rows Removed by Filter: 26