explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CVzf

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 979.919 ↑ 7.5 17 1

Unique (cost=263,128.34..263,128.98 rows=128 width=8) (actual time=979.914..979.919 rows=17 loops=1)

2. 0.160 979.913 ↑ 7.5 17 1

Sort (cost=263,128.34..263,128.66 rows=128 width=8) (actual time=979.911..979.913 rows=17 loops=1)

  • Sort Key: e.ev_id
  • Sort Method: quicksort Memory: 25kB
3. 0.078 979.753 ↑ 7.5 17 1

Nested Loop (cost=2.71..263,123.86 rows=128 width=8) (actual time=464.250..979.753 rows=17 loops=1)

4. 0.060 951.438 ↑ 7.6 17 1

Nested Loop (cost=2.28..263,053.08 rows=129 width=8) (actual time=445.237..951.438 rows=17 loops=1)

5. 0.335 949.576 ↑ 80.8 17 1

Nested Loop (cost=1.85..262,005.63 rows=1,373 width=8) (actual time=445.091..949.576 rows=17 loops=1)

6. 0.124 624.358 ↑ 1,852.1 67 1

Nested Loop (cost=1.28..186,543.69 rows=124,090 width=8) (actual time=420.863..624.358 rows=67 loops=1)

7. 0.026 382.386 ↑ 2.1 12 1

HashAggregate (cost=0.46..0.71 rows=25 width=32) (actual time=382.374..382.386 rows=12 loops=1)

  • Group Key: lower((retrieve_person_linked_recipients.target_name)::text)
8. 382.360 382.360 ↑ 1.4 18 1

Function Scan on retrieve_person_linked_recipients (cost=0.03..0.40 rows=25 width=32) (actual time=382.345..382.360 rows=18 loops=1)

  • Filter: (((recipient_cat)::text <> 'GROUP'::text) OR ((grp_association)::text <> 'supervisor'::text))
9. 241.848 241.848 ↑ 827.3 6 12

Index Scan using idx_comm_values0 on comm_values cv (cost=0.82..7,412.08 rows=4,964 width=125) (actual time=6.108..20.154 rows=6 loops=12)

  • Index Cond: (lower(""left""((value)::text, 200)) = lower((retrieve_person_linked_recipients.target_name)::text))
10. 324.883 324.883 ↓ 0.0 0 67

Index Scan using comm_flds_pk on comm_flds cf (cost=0.56..0.61 rows=1 width=16) (actual time=4.849..4.849 rows=0 loops=67)

  • Index Cond: (comm_fld_id = cv.comm_fld_id)
  • Filter: ((name)::text = 'recipients'::text)
  • Rows Removed by Filter: 1
11. 1.802 1.802 ↑ 1.0 1 17

Index Scan using comm_pk on comm c (cost=0.43..0.76 rows=1 width=16) (actual time=0.106..0.106 rows=1 loops=17)

  • Index Cond: (comm_id = cf.comm_id)
  • Filter: ((comm_type)::text = 'EVENT'::text)
12. 28.237 28.237 ↑ 1.0 1 17

Index Scan using evs_pk on evs e (cost=0.42..0.55 rows=1 width=8) (actual time=1.661..1.661 rows=1 loops=17)

  • Index Cond: (ev_id = c.comm_ev_id)
  • Filter: (company_id = 1)
Planning time : 6.757 ms
Execution time : 980.733 ms