explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bw5m

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1.008 ↓ 3.0 3 1

Limit (cost=0.17..2.72 rows=1 width=175) (actual time=0.819..1.008 rows=3 loops=1)

  • Output: mm.member_guid, mm.legacy_user_id, mm.legacy_profile_id, mm.last_activity_utc, mm.date_of_birth, mm.gender, mm.home_country_id, mm.intent_type, mm.headline, mmpi.member_name, mmpi.home_city_name, mmpi.main_image_thumbnail_url, (((_st_distance('0101000020E610000048E17A14AEC75EC0A4703D0AD7A34840'::geography, mm.home_long_lat_geo, '0'::double precision, true) / '1000'::double precision))::integer), ((mm.profile_completed_utc <-> '2020-09-11 17:00:00'::timestamp without time zone))
  • Buffers: shared hit=88
2. 0.199 1.006 ↓ 3.0 3 1

Nested Loop (cost=0.17..2.72 rows=1 width=175) (actual time=0.818..1.006 rows=3 loops=1)

  • Output: mm.member_guid, mm.legacy_user_id, mm.legacy_profile_id, mm.last_activity_utc, mm.date_of_birth, mm.gender, mm.home_country_id, mm.intent_type, mm.headline, mmpi.member_name, mmpi.home_city_name, mmpi.main_image_thumbnail_url, ((_st_distance('0101000020E610000048E17A14AEC75EC0A4703D0AD7A34840'::geography, mm.home_long_lat_geo, '0'::double precision, true) / '1000'::double precision))::integer, (mm.profile_completed_utc <-> '2020-09-11 17:00:00'::timestamp without time zone)
  • Inner Unique: true
  • Buffers: shared hit=88
3. 0.759 0.759 ↓ 3.0 3 1

Index Scan using mm_hllg_dob_last_activity_profile_completed_gist on matching.matching_member mm (cost=0.06..1.35 rows=1 width=109) (actual time=0.618..0.759 rows=3 loops=1)

  • Output: mm.member_guid, mm.legacy_user_id, mm.legacy_profile_id, mm.last_activity_utc, mm.date_of_birth, mm.gender, mm.home_country_id, mm.intent_type, mm.headline, mm.home_long_lat_geo, mm.profile_completed_utc
  • Index Cond: ((mm.home_long_lat_geo && '0101000020E610000048E17A14AEC75EC0A4703D0AD7A34840'::geography) AND (mm.date_of_birth >= '1986-01-01'::date) AND (mm.date_of_birth <= '1992-01-01'::date))
  • Order By: (mm.profile_completed_utc <-> '2020-09-11 17:00:00'::timestamp without time zone)
  • Filter: ((mm.has_main_image IS TRUE) AND (mm.member_guid <> 'a009b356-a794-6dbe-d097-8e905321daa1'::uuid) AND (mm.gender = 1) AND (mm.seeking_gender = 0) AND ((mm.last_activity_utc)::date >= '2020-09-09'::date) AND ('0101000020E610000048E17A14AEC75EC0A4703D0AD7A34840'::geography && _st_expand(mm.home_long_lat_geo, '120000'::double precision)) AND _st_dwithin(mm.home_long_lat_geo, '0101000020E610000048E17A14AEC75EC0A4703D0AD7A34840'::geography, '120000'::double precision, false))
  • Rows Removed by Filter: 26
  • Buffers: shared hit=70
4. 0.048 0.048 ↑ 1.0 1 3

Index Scan using mmpi_mobile_long_lat_updated_date_idx on matching.matching_member_presentation_info mmpi (cost=0.11..1.32 rows=1 width=102) (actual time=0.016..0.016 rows=1 loops=3)

  • Output: mmpi.member_guid, mmpi.legacy_user_id, mmpi.legacy_profile_id, mmpi.home_longitude, mmpi.home_latitude, mmpi.inserted_tstamp, mmpi.last_edited, mmpi.date_of_birth, mmpi.gender, mmpi.seeking_gender, mmpi.member_ip, mmpi.member_name, mmpi.home_country_code, mmpi.home_state_code, mmpi.home_zipcode, mmpi.home_city_name, mmpi.main_image_thumbnail_url, mmpi.mobile_longitude, mmpi.mobile_latitude, mmpi.mobile_long_lat_updated_date
  • Index Cond: (mmpi.member_guid = mm.member_guid)
  • Filter: (mmpi.member_name IS NOT NULL)
  • Buffers: shared hit=15
Planning time : 1.361 ms
Execution time : 1.084 ms