explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wyRA

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 533.742 ↓ 0.0 0 1

GroupAggregate (cost=217,649.27..217,649.30 rows=1 width=44) (actual time=533.741..533.742 rows=0 loops=1)

  • Group Key: "Order"."TaskID", "Tasks"."UserID", "Tasks"."StartTime", "Order"."OldTaskId
2. 0.020 533.740 ↓ 0.0 0 1

Sort (cost=217,649.27..217,649.28 rows=1 width=28) (actual time=533.740..533.740 rows=0 loops=1)

  • Sort Key: "Order"."TaskID", "Tasks"."UserID", "Tasks"."StartTime
  • Sort Method: quicksort Memory: 25kB
3. 0.000 533.720 ↓ 0.0 0 1

Nested Loop (cost=1,000.43..217,649.26 rows=1 width=28) (actual time=533.720..533.720 rows=0 loops=1)

4. 3.781 535.238 ↑ 1.0 1 1

Gather (cost=1,000.00..217,640.19 rows=1 width=16) (actual time=0.245..535.238 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 531.457 531.457 ↓ 0.0 0 3

Parallel Seq Scan on "Order" (cost=0.00..216,640.09 rows=1 width=16) (actual time=353.657..531.457 rows=0 loops=3)

  • Filter: ("OldTaskId" = 24166691)
  • Rows Removed by Filter: 795373
6. 0.014 0.014 ↓ 0.0 0 1

Index Scan using "PK_Tasks" on "Tasks" (cost=0.43..8.45 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ("Id" = "Order"."TaskID")
  • Filter: ("Status" <> 3)
  • Rows Removed by Filter: 1
Planning time : 0.319 ms
Execution time : 535.334 ms