explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MFEX

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=381.39..46,428.76 rows=1 width=1,040) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on leads (cost=381.24..46,165.56 rows=533 width=1,040) (actual rows= loops=)

  • Recheck Cond: (assignment_supply_entity_mapping_id = ANY ('{767,726,1117}'::integer[]))
  • Filter: ((((tags ->> 'is_abandoned'::text))::boolean IS NOT TRUE) AND (((tags ->> 'is_duplicate'::text))::boolean IS NOT TRUE) AND (((tags ->> 'is_archived'::text))::boolean IS NOT TRUE) AND (((tags ->> 'is_stale'::text))::boolean IS NOT TRUE) AND (((tags ->> 'agent_deactivated'::text))::boolean IS NOT TRUE))
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_leads_on_asem_id_and_patch_out_tag (cost=0.00..381.11 rows=17,042 width=0) (actual rows= loops=)

  • Index Cond: (assignment_supply_entity_mapping_id = ANY ('{767,726,1117}'::integer[]))
4. 0.000 0.000 ↓ 0.0

Index Scan using leads_statuses_pkey on leads_statuses (cost=0.15..0.48 rows=1 width=40) (actual rows= loops=)

  • Index Cond: (id = leads.status_id)
  • Filter: (((to_be_shown_on_app IS TRUE) OR ((name)::text = 'Linked'::text)) AND ((leads.id = ANY ('{95162,147885,147926,147927,252593,266962,304170,304177,304180,305132,344393,360542,360545,360549,360552,366406,366479,366569,514763,514765,514872,618693,621324,621354,621474,621475,621477,621675,639322,657228,657230,691813,691824,692029,700096,700105,710578,712002,721920,722379,743455,747247,752785,752951,752952,752954,752955,752956,752957,754068,758647,761624,763187,763569,777536,779217,779224,779511,779519,779523,788368,788375,788541,789160,796071,797456,797495,797499,797501,797502,797519,797561,797579,797630,799051,799071,799160,799181,799304,799364,799442,799474,800101,800161,800401,800418,800870,800872,800874,802576,803030,803064,803114,803122,803310,803525,803526,804531,804770,804884,809396,821340,821403,821413,821424,821432,821448,911838,918116,925845,926219,926249,942410,969005,1055496,1055498,1055506,1067129,1125891,1125895,1129511,1129512,1129517,1129923,1129962,1129970,1129996,1130032,1130081,1130088,1130549,1130650,1130652,1131202,1131226,1131250,1131614,1131687,1131697,1135639,1140973,1140979,1148747,1167344,1167596,1180208,1228286,1228290,1229787,1229880,1229883,1229946,1230345,1230426,1230429,1230466,1234298,1235640,1271090,1296644,1300264,1331634,1333197,1335020,1335063,1335518,1335575,1375717,1392315,1403997,1427766,1427772,1510979,1650400,1839916,1863045,1863046}'::bigint[])) OR ((name)::text = 'Fresh'::text)))