explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X53E : Optimization for: plan #kT2q

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 166,813.177 ↓ 2.1 100 1

Limit (cost=643,467.67..643,473.42 rows=48 width=481) (actual time=166,813.076..166,813.177 rows=100 loops=1)

2. 171.455 166,971.971 ↓ 2.1 100 1

Gather Merge (cost=643,467.67..643,473.42 rows=48 width=481) (actual time=166,813.071..166,971.971 rows=100 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 3.038 166,800.516 ↓ 10.6 127 5 / 5

Sort (cost=642,467.62..642,467.65 rows=12 width=481) (actual time=166,800.505..166,800.516 rows=127 loops=5)

  • Sort Key: evs.creation_date DESC, evs.ev_id DESC
  • Sort Method: quicksort Memory: 464kB
4. 2.527 166,797.478 ↓ 60.7 728 5 / 5

Nested Loop Left Join (cost=5,622.62..642,467.40 rows=12 width=481) (actual time=3,420.188..166,797.478 rows=728 loops=5)

5. 1.992 166,790.581 ↓ 60.7 728 5 / 5

Nested Loop Left Join (cost=5,622.34..642,463.86 rows=12 width=519) (actual time=3,420.132..166,790.581 rows=728 loops=5)

6. 2.372 166,781.305 ↓ 60.7 728 5 / 5

Nested Loop (cost=5,621.92..642,457.79 rows=12 width=395) (actual time=3,420.072..166,781.305 rows=728 loops=5)

7. 1.899 166,768.007 ↓ 60.7 728 5 / 5

Nested Loop (cost=5,621.49..642,452.22 rows=12 width=8) (actual time=3,419.995..166,768.007 rows=728 loops=5)

8. 747.481 166,751.540 ↓ 60.7 728 5 / 5

Nested Loop (cost=5,621.06..642,441.19 rows=12 width=8) (actual time=3,419.932..166,751.540 rows=728 loops=5)

9. 55,958.812 56,458.071 ↓ 17.5 1,738,825 5 / 5

Parallel Bitmap Heap Scan on comm_flds cf_0 (cost=5,620.50..309,632.91 rows=99,116 width=16) (actual time=2,569.694..56,458.071 rows=1,738,825 loops=5)

  • Recheck Cond: ((lower("substring"((name)::text, 1, 9)) = 'xappprop_'::text) OR (lower("substring"((name)::text, 1, 12)) = 'xappextprop_'::text))
  • Heap Blocks: exact=44964
10. 499.259 499.259 ↓ 21.9 8,694,126 1 / 5

Bitmap Index Scan on comm_flds_name_left_xappprop_pidx1 (cost=0.00..5,521.38 rows=396,464 width=0) (actual time=2,496.294..2,496.294 rows=8,694,126 loops=1)

11. 109,545.988 109,545.988 ↓ 0.0 0 8,694,126 / 5

Index Scan using idx_comm_values1 on comm_values cv_0 (cost=0.56..3.35 rows=1 width=8) (actual time=0.063..0.063 rows=0 loops=8,694,126)

  • Index Cond: (comm_fld_id = cf_0.comm_fld_id)
  • Filter: (lower((value)::text) ~~ '%search_devops%'::text)
  • Rows Removed by Filter: 1
12. 14.568 14.568 ↑ 1.0 1 3,642 / 5

Index Scan using comm_pk on comm c_0 (cost=0.43..0.92 rows=1 width=16) (actual time=0.020..0.020 rows=1 loops=3,642)

  • Index Cond: (comm_id = cf_0.comm_id)
13. 10.926 10.926 ↑ 1.0 1 3,642 / 5

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

  • Index Cond: (ev_id = c_0.comm_ev_id)
  • Filter: (company_id = 1)
14. 7.284 7.284 ↑ 1.0 1 3,642 / 5

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.010..0.010 rows=1 loops=3,642)

  • Index Cond: (ev_id = evs.ev_id)
15. 4.370 4.370 ↑ 1.0 1 3,642 / 5

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

  • Index Cond: (message_panel_id = evs.message_panel_id)
Planning time : 26.216 ms
Execution time : 166,972.924 ms