explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8lgJ : Optimization for: Optimization for: plan #cM8C; plan #V4rc

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 380.427 ↓ 72.0 72 1

Limit (cost=7,219.12..7,219.24 rows=1 width=481) (actual time=380.375..380.427 rows=72 loops=1)

2. 41.292 415.945 ↓ 72.0 72 1

Gather Merge (cost=7,219.12..7,219.24 rows=1 width=481) (actual time=380.373..415.945 rows=72 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 0.131 374.653 ↓ 36.0 36 2 / 2

Sort (cost=6,219.11..6,219.11 rows=1 width=481) (actual time=374.648..374.653 rows=36 loops=2)

  • Sort Key: evs.creation_date DESC, evs.ev_id DESC
  • Sort Method: quicksort Memory: 55kB
4. 0.054 374.522 ↓ 36.0 36 2 / 2

Nested Loop Left Join (cost=33.96..6,219.10 rows=1 width=481) (actual time=90.511..374.522 rows=36 loops=2)

5. 0.047 374.324 ↓ 36.0 36 2 / 2

Nested Loop Left Join (cost=33.69..6,218.80 rows=1 width=519) (actual time=90.473..374.324 rows=36 loops=2)

6. 0.560 373.953 ↓ 36.0 36 2 / 2

Nested Loop (cost=33.26..6,217.44 rows=1 width=395) (actual time=90.430..373.953 rows=36 loops=2)

7. 10.743 363.813 ↓ 20.3 1,198 2 / 2

Nested Loop (cost=32.70..5,929.40 rows=59 width=403) (actual time=88.778..363.813 rows=1,198 loops=2)

8. 23.068 241.930 ↓ 30.1 27,785 2 / 2

Nested Loop (cost=32.27..5,504.40 rows=922 width=16) (actual time=21.250..241.930 rows=27,785 loops=2)

9. 100.243 107.722 ↓ 30.1 27,785 2 / 2

Parallel Bitmap Heap Scan on comm_flds cf_0 (cost=31.84..2,360.54 rows=922 width=16) (actual time=21.180..107.722 rows=27,785 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=31529
10. 7.479 7.479 ↓ 35.4 55,570 1 / 2

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

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

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

  • Index Cond: (comm_id = cf_0.comm_id)
12. 111.140 111.140 ↓ 0.0 0 55,570 / 2

Index Scan using evs_pk on evs (cost=0.42..0.46 rows=1 width=395) (actual time=0.004..0.004 rows=0 loops=55,570)

  • Index Cond: (ev_id = c_0.comm_ev_id)
  • Filter: ((when_created > '2020-05-21 00:00:00-07'::timestamp with time zone) AND (company_id = 1))
  • Rows Removed by Filter: 1
13. 9.580 9.580 ↓ 0.0 0 2,395 / 2

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

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

Index Scan using evs_email_message_ev_id_uc on evs_email_message msg (cost=0.42..1.37 rows=1 width=132) (actual time=0.009..0.009 rows=1 loops=72)

  • Index Cond: (ev_id = evs.ev_id)
15. 0.144 0.144 ↑ 1.0 1 72 / 2

Index Scan using message_panel_pk on message_panel mp (cost=0.28..0.29 rows=1 width=61) (actual time=0.004..0.004 rows=1 loops=72)

  • Index Cond: (message_panel_id = evs.message_panel_id)
Planning time : 13.720 ms
Execution time : 416.243 ms