explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uxb6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 47,299.338 ↓ 0.0 0 1

Unique (cost=701,610.96..701,611.92 rows=192 width=8) (actual time=47,299.338..47,299.338 rows=0 loops=1)

2.          

CTE comm_fld_ids

3. 29.734 47,323.199 ↓ 0.0 0 1

Gather (cost=1,000.00..664,628.91 rows=2,527 width=8) (actual time=47,299.017..47,323.199 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 47,293.465 47,293.465 ↓ 0.0 0 5

Parallel Seq Scan on comm_values (cost=0.00..663,376.21 rows=632 width=8) (actual time=47,293.464..47,293.465 rows=0 loops=5)

  • Filter: (lower((value)::text) ~~ '%in356645%'::text)
  • Rows Removed by Filter: 4966149
5.          

CTE comm_ids

6. 0.001 47,299.028 ↓ 0.0 0 1

Nested Loop (cost=57.30..751.36 rows=10,878 width=8) (actual time=47,299.028..47,299.028 rows=0 loops=1)

7. 0.008 47,299.027 ↓ 0.0 0 1

HashAggregate (cost=56.86..58.86 rows=200 width=8) (actual time=47,299.026..47,299.027 rows=0 loops=1)

  • Group Key: comm_fld_ids.comm_fld_id
8. 47,299.019 47,299.019 ↓ 0.0 0 1

CTE Scan on comm_fld_ids (cost=0.00..50.54 rows=2,527 width=8) (actual time=47,299.019..47,299.019 rows=0 loops=1)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using comm_flds_pk on comm_flds (cost=0.44..3.46 rows=1 width=16) (never executed)

  • Index Cond: (comm_fld_id = comm_fld_ids.comm_fld_id)
  • Filter: ((name)::text = ANY ('{xappprop_incident_number#en,xappextprop_incident_number#enxappprop_lang_incident_number#en}'::text[]))
10.          

CTE event_ids

11. 0.001 47,299.035 ↓ 0.0 0 1

Nested Loop (cost=245.19..833.84 rows=1,547,885 width=8) (actual time=47,299.035..47,299.035 rows=0 loops=1)

12. 0.005 47,299.034 ↓ 0.0 0 1

HashAggregate (cost=244.75..246.75 rows=200 width=8) (actual time=47,299.034..47,299.034 rows=0 loops=1)

  • Group Key: comm_ids.comm_id
13. 47,299.029 47,299.029 ↓ 0.0 0 1

CTE Scan on comm_ids (cost=0.00..217.56 rows=10,878 width=8) (actual time=47,299.029..47,299.029 rows=0 loops=1)

14. 0.000 0.000 ↓ 0.0 0

Index Scan using comm_pk on comm (cost=0.43..3.43 rows=1 width=16) (never executed)

  • Index Cond: (comm_id = comm_ids.comm_id)
15. 0.032 47,299.338 ↓ 0.0 0 1

Sort (cost=35,396.85..35,397.33 rows=192 width=8) (actual time=47,299.338..47,299.338 rows=0 loops=1)

  • Sort Key: evs.ev_id
  • Sort Method: quicksort Memory: 25kB
16. 0.004 47,299.306 ↓ 0.0 0 1

Hash Join (cost=34,838.32..35,389.57 rows=192 width=8) (actual time=47,299.306..47,299.306 rows=0 loops=1)

  • Hash Cond: (evs.ev_id = event_ids.comm_ev_id)
17. 0.098 0.260 ↑ 385.0 1 1

Bitmap Heap Scan on evs (cost=6.41..554.51 rows=385 width=8) (actual time=0.260..0.260 rows=1 loops=1)

  • Recheck Cond: (company_id = '200505'::bigint)
  • Heap Blocks: exact=1
18. 0.162 0.162 ↓ 2.2 864 1

Bitmap Index Scan on evs_company_id_idx (cost=0.00..6.31 rows=385 width=0) (actual time=0.162..0.162 rows=864 loops=1)

  • Index Cond: (company_id = '200505'::bigint)
19. 0.001 47,299.042 ↓ 0.0 0 1

Hash (cost=34,829.41..34,829.41 rows=200 width=8) (actual time=47,299.041..47,299.042 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
20. 0.004 47,299.041 ↓ 0.0 0 1

HashAggregate (cost=34,827.41..34,829.41 rows=200 width=8) (actual time=47,299.041..47,299.041 rows=0 loops=1)

  • Group Key: event_ids.comm_ev_id
21. 47,299.037 47,299.037 ↓ 0.0 0 1

CTE Scan on event_ids (cost=0.00..30,957.70 rows=1,547,885 width=8) (actual time=47,299.037..47,299.037 rows=0 loops=1)