explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qz2c : Optimization for: plan #cM8C

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 403.594 ↓ 0.0 0 1

Limit (cost=6,685.47..6,685.59 rows=1 width=481) (actual time=403.594..403.594 rows=0 loops=1)

2. 40.111 437.949 ↓ 0.0 0 1

Gather Merge (cost=6,685.47..6,685.59 rows=1 width=481) (actual time=403.591..437.949 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 0.053 397.838 ↓ 0.0 0 2 / 2

Sort (cost=5,685.46..5,685.46 rows=1 width=481) (actual time=397.838..397.838 rows=0 loops=2)

  • Sort Key: evs.creation_date DESC, evs.ev_id DESC
  • Sort Method: quicksort Memory: 25kB
4. 0.001 397.785 ↓ 0.0 0 2 / 2

Nested Loop Left Join (cost=178.03..5,685.45 rows=1 width=481) (actual time=397.785..397.785 rows=0 loops=2)

5. 0.001 397.784 ↓ 0.0 0 2 / 2

Nested Loop Left Join (cost=177.76..5,685.14 rows=1 width=519) (actual time=397.784..397.784 rows=0 loops=2)

6. 0.410 397.783 ↓ 0.0 0 2 / 2

Nested Loop (cost=177.33..5,682.19 rows=1 width=395) (actual time=397.783..397.783 rows=0 loops=2)

7. 9.467 388.741 ↓ 166.0 664 2 / 2

Hash Join (cost=176.77..5,662.66 rows=4 width=403) (actual time=100.142..388.741 rows=664 loops=2)

  • Hash Cond: (c_0.comm_ev_id = evs.ev_id)
8. 2.376 363.189 ↓ 30.1 27,808 2 / 2

Nested Loop (cost=32.30..5,515.76 rows=924 width=16) (actual time=21.210..363.189 rows=27,808 loops=2)

9. 158.267 166.154 ↓ 30.1 27,808 2 / 2

Parallel Bitmap Heap Scan on comm_flds cf_0 (cost=31.86..2,365.02 rows=924 width=16) (actual time=21.135..166.154 rows=27,808 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=21730
10. 7.888 7.888 ↓ 35.4 55,617 1 / 2

Bitmap Index Scan on comm_flds_name_left_xappprop_pidx1 (cost=0.00..31.47 rows=1,571 width=0) (actual time=15.775..15.775 rows=55,617 loops=1)

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

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

  • Index Cond: (comm_id = cf_0.comm_id)
12. 2.316 16.085 ↑ 1.1 3,025 2 / 2

Hash (cost=102.83..102.83 rows=3,331 width=395) (actual time=16.085..16.085 rows=3,025 loops=2)

  • Buckets: 4096 Batches: 1 Memory Usage: 1074kB
13. 12.617 13.769 ↑ 1.1 3,025 2 / 2

Bitmap Heap Scan on evs (cost=81.76..102.83 rows=3,331 width=395) (actual time=1.326..13.769 rows=3,025 loops=2)

  • Recheck Cond: (((status)::text = ANY ('{CREATE,PURGED,SUSPENDED,ACTIVE}'::text[])) AND ((status)::text = 'ACTIVE'::text))
  • Filter: (company_id = 1)
  • Heap Blocks: exact=1329
14. 0.052 1.152 ↓ 0.0 0 2 / 2

BitmapAnd (cost=81.76..81.76 rows=14 width=0) (actual time=1.152..1.152 rows=0 loops=2)

15. 0.551 0.551 ↓ 1.2 3,974 2 / 2

Bitmap Index Scan on evs_status_ev_dmn_id_pidx (cost=0.00..33.44 rows=3,331 width=0) (actual time=0.551..0.551 rows=3,974 loops=2)

16. 0.549 0.549 ↓ 1.2 3,974 2 / 2

Bitmap Index Scan on idx_evs_status (cost=0.00..46.41 rows=3,331 width=0) (actual time=0.549..0.549 rows=3,974 loops=2)

  • Index Cond: ((status)::text = 'ACTIVE'::text)
17. 8.632 8.632 ↓ 0.0 0 1,328 / 2

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,328)

  • Index Cond: (comm_fld_id = cf_0.comm_fld_id)
  • Filter: (lower((value)::text) ~~ '%search_devops%'::text)
  • Rows Removed by Filter: 1
18. 0.000 0.000 ↓ 0.0 0 / 2

Index Scan using evs_email_message_ev_id_uc on evs_email_message msg (cost=0.42..2.95 rows=1 width=132) (never executed)

  • Index Cond: (ev_id = evs.ev_id)
19. 0.000 0.000 ↓ 0.0 0 / 2

Index Scan using message_panel_pk on message_panel mp (cost=0.28..0.31 rows=1 width=61) (never executed)

  • Index Cond: (message_panel_id = evs.message_panel_id)
Planning time : 16.205 ms
Execution time : 438.523 ms