explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bm6w : Optimization for: notif sla; plan #FfwJ

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 3,007.939 ↓ 0.0 0 1

Finalize GroupAggregate (cost=67,933.96..68,391.57 rows=3,693 width=143) (actual time=3,007.939..3,007.939 rows=0 loops=1)

  • Group Key: a."SYS_ID_TR_INCIDENT_SLA", b."SYS_ID_TR_NOTIFICATION", b."SYS_ID_R_CONDITION
2. 19.826 3,013.767 ↓ 0.0 0 1

Gather Merge (cost=67,933.96..68,323.86 rows=3,078 width=143) (actual time=3,007.936..3,013.767 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.003 2,993.941 ↓ 0.0 0 3 / 3

Partial GroupAggregate (cost=66,933.93..66,968.56 rows=1,539 width=143) (actual time=2,993.941..2,993.941 rows=0 loops=3)

  • Group Key: a."SYS_ID_TR_INCIDENT_SLA", b."SYS_ID_TR_NOTIFICATION", b."SYS_ID_R_CONDITION
4. 0.053 2,993.938 ↓ 0.0 0 3 / 3

Sort (cost=66,933.93..66,937.78 rows=1,539 width=116) (actual time=2,993.938..2,993.938 rows=0 loops=3)

  • Sort Key: a."SYS_ID_TR_INCIDENT_SLA", b."SYS_ID_TR_NOTIFICATION", b."SYS_ID_R_CONDITION
  • Sort Method: quicksort Memory: 25kB
5. 2.720 2,993.885 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.97..66,852.46 rows=1,539 width=116) (actual time=2,993.885..2,993.885 rows=0 loops=3)

6. 31.593 31.593 ↑ 2.2 2,135 3 / 3

Parallel Index Scan using def on "TR_INCIDENT_SLA_NOTIFICATION" b (cost=0.41..27,812.84 rows=4,616 width=116) (actual time=0.072..31.593 rows=2,135 loops=3)

  • Index Cond: ("SYS_ID_TR_NOTIFICATION" IS NOT NULL)
  • Filter: ("STATUS" IS NULL)
  • Rows Removed by Filter: 862
7. 2,959.572 2,959.572 ↓ 0.0 0 6,406 / 3

Index Scan using "TR_INCIDENT_SLA_pkey" on "TR_INCIDENT_SLA" a (cost=0.56..8.45 rows=1 width=42) (actual time=1.386..1.386 rows=0 loops=6,406)

  • Index Cond: (("SYS_ID_TR_INCIDENT_SLA")::text = (b."SYS_ID_TR_INCIDENT_SLA")::text)
  • Filter: ("BUSINESS_ELAPSED_PERCENTAGE" > b."SLA_PERCENTAGE")
  • Rows Removed by Filter: 1