explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kT2q

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 514.132 ↓ 100.0 100 1

Limit (cost=7,236.65..7,236.77 rows=1 width=481) (actual time=514.036..514.132 rows=100 loops=1)

2. 47.298 556.679 ↓ 100.0 100 1

Gather Merge (cost=7,236.65..7,236.77 rows=1 width=481) (actual time=514.035..556.679 rows=100 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 1.904 509.381 ↓ 110.0 110 2 / 2

Sort (cost=6,236.64..6,236.65 rows=1 width=481) (actual time=509.367..509.381 rows=110 loops=2)

  • Sort Key: evs.creation_date DESC, evs.ev_id DESC
  • Sort Method: quicksort Memory: 496kB
4. 1.281 507.477 ↓ 921.0 921 2 / 2

Nested Loop Left Join (cost=41.52..6,236.63 rows=1 width=481) (actual time=26.282..507.477 rows=921 loops=2)

5. 1.219 504.354 ↓ 921.0 921 2 / 2

Nested Loop Left Join (cost=41.25..6,236.34 rows=1 width=519) (actual time=26.236..504.354 rows=921 loops=2)

6. 0.765 494.846 ↓ 921.0 921 2 / 2

Nested Loop (cost=40.82..6,235.83 rows=1 width=395) (actual time=26.182..494.846 rows=921 loops=2)

7. 0.262 483.029 ↓ 921.0 921 2 / 2

Nested Loop (cost=40.40..6,235.37 rows=1 width=8) (actual time=26.137..483.029 rows=921 loops=2)

8. 7.507 471.715 ↓ 921.0 921 2 / 2

Nested Loop (cost=39.96..6,231.95 rows=1 width=8) (actual time=26.098..471.715 rows=921 loops=2)

9. 150.297 159.546 ↓ 34.0 27,696 2 / 2

Parallel Bitmap Heap Scan on comm_flds cf_0 (cost=39.40..2,108.20 rows=814 width=16) (actual time=24.942..159.546 rows=27,696 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=23684
10. 9.248 9.248 ↓ 43.8 60,622 1 / 2

Bitmap Index Scan on comm_flds_name_left_xappprop_pidx1 (cost=0.00..39.05 rows=1,383 width=0) (actual time=18.497..18.497 rows=60,622 loops=1)

  • Index Cond: ((name)::text = ANY ('{xappprop_group_name#en,xappextprop_group_name#en,xappprop_lang_group_name#en}'::text[]))
11. 304.661 304.661 ↓ 0.0 0 55,393 / 2

Index Scan using idx_comm_values1 on comm_values cv_0 (cost=0.56..5.06 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=55,393)

  • Index Cond: (comm_fld_id = cf_0.comm_fld_id)
  • Filter: (lower((value)::text) ~~ '%search_devops%'::text)
  • Rows Removed by Filter: 1
12. 11.052 11.052 ↑ 1.0 1 1,842 / 2

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

  • Index Cond: (comm_id = cf_0.comm_id)
13. 11.052 11.052 ↑ 1.0 1 1,842 / 2

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

  • Index Cond: (ev_id = c_0.comm_ev_id)
  • Filter: (company_id = 1)
14. 8.289 8.289 ↑ 1.0 1 1,842 / 2

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.009..0.009 rows=1 loops=1,842)

  • Index Cond: (ev_id = evs.ev_id)
15. 1.842 1.842 ↑ 1.0 1 1,842 / 2

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

  • Index Cond: (message_panel_id = evs.message_panel_id)
Planning time : 20.778 ms
Execution time : 557.157 ms