explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I2xd

Settings
# exclusive inclusive rows x rows loops node
1. 0.102 1,172.834 ↑ 233.5 8 1

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

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

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

3. 161.564 292.351 ↓ 2.5 116,801 1

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

  • Hash Cond: (q0.project_id = p2.id)
4. 130.432 130.432 ↑ 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.033..130.432 rows=293,014 loops=1)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 271kB
6. 0.179 0.179 ↑ 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.011..0.179 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
Planning time : 0.684 ms