explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QMLC

Settings
# exclusive inclusive rows x rows loops node
1. 0.075 1,172.190 ↑ 233.5 8 1

Sort (cost=75,121.73..75,126.40 rows=1,868 width=3,861) (actual time=1,172.188..1,172.190 rows=8 loops=1)

  • Sort Key: e1.first_name, e1.last_name
  • Sort Method: quicksort Memory: 38kB
2. 63.241 1,172.115 ↑ 233.5 8 1

Nested Loop (cost=101.71..71,915.73 rows=1,868 width=3,861) (actual time=144.915..1,172.115 rows=8 loops=1)

3. 162.799 291.267 ↓ 2.5 116,801 1

Hash Join (cost=101.29..14,556.93 rows=46,573 width=2,874) (actual time=0.539..291.267 rows=116,801 loops=1)

  • Hash Cond: (q0.project_id = p2.id)
4. 127.996 127.996 ↑ 1.0 293,014 1

Seq Scan on qualifications q0 (cost=0.00..13,684.02 rows=293,112 width=2,132) (actual time=0.038..127.996 rows=293,014 loops=1)

  • Filter: (type = 'prospect'::prospect_type)
  • Rows Removed by Filter: 21071
5. 0.206 0.472 ↑ 1.0 235 1

Hash (cost=98.35..98.35 rows=235 width=742) (actual time=0.472..0.472 rows=235 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 271kB
6. 0.266 0.266 ↑ 1.0 235 1

Index Scan using projects_live_index on projects p2 (cost=0.28..98.35 rows=235 width=742) (actual time=0.023..0.266 rows=235 loops=1)

  • Index Cond: (live = true)
  • Filter: live
7. 817.607 817.607 ↓ 0.0 0 116,801

Index Scan using expert_profiles_pkey on expert_profiles e1 (cost=0.42..1.23 rows=1 width=987) (actual time=0.007..0.007 rows=0 loops=116,801)

  • Index Cond: (id = q0.profile_id)
  • Filter: ((email ~~* '%500%'::text) OR (f_unaccent(((btrim(first_name) || ' '::text) || btrim(last_name))) ~~* '%500%'::text) OR (regexp_replace((phone)::text, '[^0-9+]+'::text, ''::text, 'g'::text) ~~* '%500%'::text))
  • Rows Removed by Filter: 1