explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cM8C

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 1,340.714 ↓ 33.0 33 1

Limit (cost=7,719.34..7,719.34 rows=1 width=481) (actual time=1,340.706..1,340.714 rows=33 loops=1)

2. 0.190 1,340.707 ↓ 33.0 33 1

Sort (cost=7,719.34..7,719.34 rows=1 width=481) (actual time=1,340.702..1,340.707 rows=33 loops=1)

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

Nested Loop Left Join (cost=1,033.66..7,719.33 rows=1 width=481) (actual time=249.983..1,340.517 rows=33 loops=1)

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

Nested Loop Left Join (cost=1,033.66..7,678.81 rows=1 width=519) (actual time=249.512..1,333.176 rows=33 loops=1)

5. 0.180 1,332.551 ↓ 33.0 33 1

Nested Loop (cost=1,033.24..7,677.14 rows=1 width=395) (actual time=249.468..1,332.551 rows=33 loops=1)

6. 0.000 1,310.804 ↓ 29.1 1,659 1

Nested Loop (cost=1,032.67..7,398.87 rows=57 width=403) (actual time=244.065..1,310.804 rows=1,659 loops=1)

7. 0.000 1,054.121 ↓ 35.4 55,538 1

Gather (cost=1,032.25..6,659.57 rows=1,567 width=16) (actual time=25.115..1,054.121 rows=55,538 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
8. 6.137 1,160.138 ↓ 30.1 27,769 2 / 2

Nested Loop (cost=32.25..5,502.87 rows=922 width=16) (actual time=21.676..1,160.138 rows=27,769 loops=2)

9. 146.738 154.317 ↓ 30.1 27,769 2 / 2

Parallel Bitmap Heap Scan on comm_flds cf_0 (cost=31.82..2,359.03 rows=922 width=16) (actual time=21.607..154.317 rows=27,769 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=15986
10. 7.580 7.580 ↓ 35.4 55,538 1 / 2

Bitmap Index Scan on comm_flds_name_left_xappprop_pidx1 (cost=0.00..31.42 rows=1,567 width=0) (actual time=15.159..15.159 rows=55,538 loops=1)

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

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

  • Index Cond: (comm_id = cf_0.comm_id)
12. 277.690 277.690 ↓ 0.0 0 55,538

Index Scan using evs_pk on evs (cost=0.42..0.47 rows=1 width=395) (actual time=0.005..0.005 rows=0 loops=55,538)

  • Index Cond: (ev_id = c_0.comm_ev_id)
  • Filter: ((company_id = 1) AND (when_created > (now() - '24:00:00'::interval)))
  • Rows Removed by Filter: 1
13. 21.567 21.567 ↓ 0.0 0 1,659

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

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

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

  • Index Cond: (ev_id = evs.ev_id)
15. 2.904 2.904 ↑ 1.1 578 33

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

Planning time : 21.815 ms
Execution time : 1,374.988 ms