explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V4rc : Optimization for: plan #cM8C

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.005 424.933 ↓ 33.0 33 1

Limit (cost=7,716.81..7,716.82 rows=1 width=481) (actual time=424.924..424.933 rows=33 loops=1)

2. 0.076 424.928 ↓ 33.0 33 1

Sort (cost=7,716.81..7,716.82 rows=1 width=481) (actual time=424.923..424.928 rows=33 loops=1)

  • Sort Key: evs.creation_date DESC, evs.ev_id DESC
  • Sort Method: quicksort Memory: 42kB
3. 3.181 424.852 ↓ 33.0 33 1

Nested Loop Left Join (cost=1,034.11..7,716.80 rows=1 width=481) (actual time=106.667..424.852 rows=33 loops=1)

  • Join Filter: (mp.message_panel_id = evs.message_panel_id)
  • Rows Removed by Join Filter: 19041
4. 0.032 419.625 ↓ 33.0 33 1

Nested Loop Left Join (cost=1,034.11..7,676.29 rows=1 width=519) (actual time=106.445..419.625 rows=33 loops=1)

5. 0.038 419.395 ↓ 33.0 33 1

Nested Loop (cost=1,033.69..7,675.78 rows=1 width=395) (actual time=106.429..419.395 rows=33 loops=1)

6. 0.083 419.291 ↓ 33.0 33 1

Nested Loop (cost=1,033.26..7,675.32 rows=1 width=16) (actual time=106.422..419.291 rows=33 loops=1)

7. 0.000 409.380 ↓ 28.7 1,638 1

Nested Loop (cost=1,032.70..7,397.04 rows=57 width=24) (actual time=103.201..409.380 rows=1,638 loops=1)

8. 0.000 274.009 ↓ 35.4 55,545 1

Gather (cost=1,032.27..6,661.19 rows=1,568 width=16) (actual time=24.388..274.009 rows=55,545 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
9. 26.198 312.081 ↓ 30.1 27,772 2 / 2

Nested Loop (cost=32.27..5,504.39 rows=922 width=16) (actual time=20.922..312.081 rows=27,772 loops=2)

10. 140.022 147.021 ↓ 30.1 27,772 2 / 2

Parallel Bitmap Heap Scan on comm_flds cf_0 (cost=31.84..2,360.54 rows=922 width=16) (actual time=20.862..147.021 rows=27,772 loops=2)

  • Recheck Cond: (((name)::text = ANY ('{xappprop_group_name#en,xappextprop_group_name#en,xappprop_lang_group_name#en}'::text[])) AND ((lower("substring"((name)::text, 1, 9)) = 'xappprop_'::text) OR (lower("substring"((name)::text, 1, 12)) = 'xappextprop_'::text)))
  • Heap Blocks: exact=19634
11. 6.999 6.999 ↓ 35.4 55,545 1 / 2

Bitmap Index Scan on comm_flds_name_left_xappprop_pidx1 (cost=0.00..31.45 rows=1,568 width=0) (actual time=13.998..13.998 rows=55,545 loops=1)

  • Index Cond: ((name)::text = ANY ('{xappprop_group_name#en,xappextprop_group_name#en,xappprop_lang_group_name#en}'::text[]))
12. 138.863 138.863 ↑ 1.0 1 55,545 / 2

Index Scan using comm_pk on comm c_0 (cost=0.43..3.41 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=55,545)

  • Index Cond: (comm_id = cf_0.comm_id)
13. 166.635 166.635 ↓ 0.0 0 55,545

Index Scan using evs_pk on evs e (cost=0.42..0.47 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=55,545)

  • Index Cond: (ev_id = c_0.comm_ev_id)
  • Filter: (creation_date > (now() - '24:00:00'::interval))
  • Rows Removed by Filter: 1
14. 9.828 9.828 ↓ 0.0 0 1,638

Index Scan using idx_comm_values1 on comm_values cv_0 (cost=0.56..4.87 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=1,638)

  • Index Cond: (comm_fld_id = cf_0.comm_fld_id)
  • Filter: (lower((value)::text) ~~ '%search_devops%'::text)
  • Rows Removed by Filter: 1
15. 0.066 0.066 ↑ 1.0 1 33

Index Scan using evs_pk on evs (cost=0.42..0.46 rows=1 width=395) (actual time=0.002..0.002 rows=1 loops=33)

  • Index Cond: (ev_id = c_0.comm_ev_id)
  • Filter: (company_id = 1)
16. 0.198 0.198 ↑ 1.0 1 33

Index Scan using evs_email_message_ev_id_uc on evs_email_message msg (cost=0.42..0.51 rows=1 width=132) (actual time=0.006..0.006 rows=1 loops=33)

  • Index Cond: (ev_id = evs.ev_id)
17. 2.046 2.046 ↑ 1.1 578 33

Seq Scan on message_panel mp (cost=0.00..32.45 rows=645 width=61) (actual time=0.001..0.062 rows=578 loops=33)

Planning time : 16.332 ms
Execution time : 465.243 ms