explain.depesz.com

PostgreSQL's explain analyze made readable

Result: os8f

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 106,701.911 ↑ 1.0 1 1

Aggregate (cost=55,497.37..55,497.38 rows=1 width=8) (actual time=106,701.911..106,701.911 rows=1 loops=1)

2. 70.995 106,701.907 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1,561.24..55,497.36 rows=1 width=8) (actual time=106,701.907..106,701.907 rows=0 loops=1)

3. 0.000 242.027 ↓ 78,865.0 78,865 1

Gather (cost=1,560.80..55,491.55 rows=1 width=16) (actual time=88.797..242.027 rows=78,865 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 143.295 6,368.187 ↓ 15,773.0 15,773 5

Nested Loop (cost=560.80..54,491.45 rows=1 width=16) (actual time=71.717..6,368.187 rows=15,773 loops=5)

5. 639.613 6,224.884 ↓ 11.7 15,773 5

Nested Loop (cost=560.38..53,254.97 rows=1,353 width=16) (actual time=71.514..6,224.884 rows=15,773 loops=5)

6. 5,544.957 5,585.232 ↓ 1.9 15,773 5

Parallel Bitmap Heap Scan on comm_flds data2_ (cost=559.95..39,982.92 rows=8,138 width=16) (actual time=48.633..5,585.232 rows=15,773 loops=5)

  • Recheck Cond: ((name)::text = ANY ('{xappprop_lang_integrationname#en,xappprop_integrationname#en,integrationname#en}'::text[]))
  • Heap Blocks: exact=1
7. 40.275 40.275 ↓ 2.6 84,032 1

Bitmap Index Scan on idx_comm_fld_name_only (cost=0.00..551.81 rows=32,551 width=0) (actual time=40.275..40.275 rows=84,032 loops=1)

  • Index Cond: ((name)::text = ANY ('{xappprop_lang_integrationname#en,xappprop_integrationname#en,integrationname#en}'::text[]))
8. 0.039 0.039 ↑ 1.0 1 78,865

Index Scan using comm_pk on comm runtimeeve1_ (cost=0.43..1.63 rows=1 width=16) (actual time=0.039..0.039 rows=1 loops=78,865)

  • Index Cond: (comm_id = data2_.comm_id)
  • Filter: ((comm_type)::text = 'EVENT'::text)
9. 0.008 0.008 ↑ 1.0 1 78,865

Index Scan using evs_pk on evs runtimeeve0_ (cost=0.42..0.91 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=78,865)

  • Index Cond: (ev_id = runtimeeve1_.comm_ev_id)
  • Filter: ((dmn_name IS NOT NULL) AND ((status)::text <> 'SUPPRESSED'::text) AND (company_id = '1'::bigint) AND (upper((sender)::text) ~~ '%XM-SUPPORT%'::text) AND ((status)::text = ANY ('{TERMINATED_WITH_ERR,PURGED,TERMINATED,SUSPENDED,SUPPRESSED,TERMINATED_EXT_FAILFILL,CREATE,ACTIVE,TERMINATED_PASSFILL,TERMINATED_BY_USER,TERMINATED_FAILFILL,TERMINATED_EXTERNAL,TERMINATED_EXT_PASSFILL}'::text[])))
10. 106,388.885 106,388.885 ↓ 0.0 0 78,865

Index Scan using idx_comm_values1 on comm_values values3_ (cost=0.44..3.13 rows=1 width=8) (actual time=1.349..1.349 rows=0 loops=78,865)

  • Index Cond: (comm_fld_id = data2_.comm_fld_id)
  • Filter: (lower((value)::text) ~~ '%pageout event%'::text)
  • Rows Removed by Filter: 1