explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Py6S

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 55.687 ↓ 100.0 100 1

Limit (cost=1,041.25..7,276.95 rows=1 width=481) (actual time=26.560..55.687 rows=100 loops=1)

2. 9.087 55.662 ↓ 100.0 100 1

Nested Loop Left Join (cost=1,041.25..7,276.95 rows=1 width=481) (actual time=26.556..55.662 rows=100 loops=1)

  • Join Filter: (mp.message_panel_id = evs.message_panel_id)
  • Rows Removed by Join Filter: 57700
3. 0.111 40.575 ↓ 100.0 100 1

Nested Loop Left Join (cost=1,041.25..7,236.44 rows=1 width=519) (actual time=26.170..40.575 rows=100 loops=1)

4. 0.173 39.764 ↓ 100.0 100 1

Nested Loop (cost=1,040.82..7,235.93 rows=1 width=395) (actual time=26.140..39.764 rows=100 loops=1)

5. 0.000 38.791 ↓ 100.0 100 1

Nested Loop (cost=1,040.40..7,235.47 rows=1 width=8) (actual time=26.080..38.791 rows=100 loops=1)

6. 0.000 42.463 ↓ 100.0 100 1

Gather (cost=1,039.96..7,232.05 rows=1 width=8) (actual time=26.030..42.463 rows=100 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
7. 0.646 42.620 ↓ 52.0 52 2 / 2

Nested Loop (cost=39.96..6,231.95 rows=1 width=8) (actual time=21.555..42.620 rows=52 loops=2)

8. 19.063 25.971 ↓ 1.5 1,231 2 / 2

Parallel Bitmap Heap Scan on comm_flds cf_0 (cost=39.40..2,108.20 rows=814 width=16) (actual time=20.167..25.971 rows=1,231 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=585
9. 6.908 6.908 ↓ 43.1 59,554 1 / 2

Bitmap Index Scan on comm_flds_name_left_xappprop_pidx1 (cost=0.00..39.05 rows=1,383 width=0) (actual time=13.816..13.816 rows=59,554 loops=1)

  • Index Cond: ((name)::text = ANY ('{xappprop_group_name#en,xappextprop_group_name#en,xappprop_lang_group_name#en}'::text[]))
10. 16.003 16.003 ↓ 0.0 0 2,462 / 2

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

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

Index Scan using comm_pk on comm c_0 (cost=0.43..3.41 rows=1 width=16) (actual time=0.010..0.010 rows=1 loops=100)

  • Index Cond: (comm_id = cf_0.comm_id)
12. 0.800 0.800 ↑ 1.0 1 100

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

  • Index Cond: (ev_id = c_0.comm_ev_id)
  • Filter: (company_id = 1)
13. 0.700 0.700 ↑ 1.0 1 100

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.007..0.007 rows=1 loops=100)

  • Index Cond: (ev_id = evs.ev_id)
14. 6.000 6.000 ↑ 1.1 578 100

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

Planning time : 96.679 ms
Execution time : 60.864 ms