explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EuSb

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

Aggregate (cost=55,494.01..55,494.02 rows=1 width=8) (actual time=1,701.932..1,701.933 rows=1 loops=1)

2. 33.957 1,701.929 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1,561.24..55,494.00 rows=1 width=8) (actual time=1,701.928..1,701.929 rows=0 loops=1)

3. 0.000 79.052 ↓ 79,446.0 79,446 1

Gather (cost=1,560.80..55,488.19 rows=1 width=16) (actual time=36.947..79.052 rows=79,446 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 224.331 533.436 ↓ 15,889.0 15,889 5

Nested Loop (cost=560.80..54,488.09 rows=1 width=16) (actual time=36.642..533.436 rows=15,889 loops=5)

5. 83.195 309.091 ↓ 11.7 15,889 5

Nested Loop (cost=560.38..53,254.97 rows=1,353 width=16) (actual time=31.084..309.091 rows=15,889 loops=5)

6. 196.274 225.891 ↓ 2.0 15,889 5

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

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

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

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

Index Scan using comm_pk on comm runtimeeve1_ (cost=0.43..1.63 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=79,446)

  • Index Cond: (comm_id = data2_.comm_id)
  • Filter: ((comm_type)::text = 'EVENT'::text)
9. 0.014 0.014 ↑ 1.0 1 79,446

Index Scan using evs_pk on evs runtimeeve0_ (cost=0.42..0.91 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=79,446)

  • 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
10. 1,588.920 1,588.920 ↓ 0.0 0 79,446

Index Scan using idx_comm_values1 on comm_values values3_ (cost=0.44..3.13 rows=1 width=8) (actual time=0.020..0.020 rows=0 loops=79,446)

  • Index Cond: (comm_fld_id = data2_.comm_fld_id)
  • Filter: (lower((value)::text) ~~ '%pageout event%'::text)
  • Rows Removed by Filter: 1
Planning time : 5.880 ms
Execution time : 1,704.241 ms