explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Gbr

Settings
# exclusive inclusive rows x rows loops node
1. 0.064 122.646 ↑ 1.0 7 1

WindowAgg (cost=140,651.54..140,654.47 rows=7 width=59) (actual time=122.629..122.646 rows=7 loops=1)

2. 0.000 122.582 ↑ 1.0 7 1

Finalize GroupAggregate (cost=140,651.54..140,654.20 rows=7 width=55) (actual time=122.569..122.582 rows=7 loops=1)

  • Group Key: pofat."Id
3. 0.000 129.681 ↓ 1.3 27 1

Gather Merge (cost=140,651.54..140,654.03 rows=21 width=55) (actual time=122.552..129.681 rows=27 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
4. 0.328 424.388 ↑ 1.0 7 4

Sort (cost=139,651.50..139,651.52 rows=7 width=55) (actual time=106.096..106.097 rows=7 loops=4)

  • Sort Key: pofat."Id
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
  • Worker 2: Sort Method: quicksort Memory: 25kB
5. 2.708 424.060 ↑ 1.0 7 4

Partial HashAggregate (cost=139,651.34..139,651.41 rows=7 width=55) (actual time=106.013..106.015 rows=7 loops=4)

  • Group Key: pofat."Id
6. 4.396 421.352 ↑ 32.2 856 4

Hash Join (cost=174.83..139,513.72 rows=27,524 width=47) (actual time=4.175..105.338 rows=856 loops=4)

  • Hash Cond: (aapof."POFAnomalyClassId" = pofat."Id")
7. 4.186 416.680 ↑ 13.0 2,120 4

Nested Loop (cost=173.67..139,403.05 rows=27,524 width=16) (actual time=0.902..104.170 rows=2,120 loops=4)

8. 10.774 259.836 ↑ 13.0 2,120 4

Nested Loop (cost=173.24..126,354.62 rows=27,547 width=16) (actual time=0.794..64.959 rows=2,120 loops=4)

9. 6.500 8.716 ↑ 1.3 3,534 4

Parallel Bitmap Heap Scan on "DiagnosticObject" obj (cost=172.80..10,958.31 rows=4,761 width=16) (actual time=0.645..2.179 rows=3,534 loops=4)

  • Recheck Cond: ("DiagnosticTargetId" = '4fdab16f-760f-4b6d-b610-e68451786a51'::uuid)
  • Heap Blocks: exact=75
10. 2.216 2.216 ↑ 1.0 14,138 1

Bitmap Index Scan on "IX_DiagnosticSection_DiagnosticTargetId" (cost=0.00..169.11 rows=14,758 width=0) (actual time=2.216..2.216 rows=14,138 loops=1)

  • Index Cond: ("DiagnosticTargetId" = '4fdab16f-760f-4b6d-b610-e68451786a51'::uuid)
11. 240.346 240.346 ↑ 44.0 1 14,138

Index Scan using "IX_DiagnosticArtifact_DiagnosticObjectId" on "Artifact" art (cost=0.43..23.80 rows=44 width=32) (actual time=0.016..0.017 rows=1 loops=14,138)

  • Index Cond: ("DiagnosticObjectId" = obj."Id")
12. 152.658 152.658 ↑ 1.0 1 8,481

Index Scan using "PK_ArtifactAddonPOF" on "ArtifactAddonPOF" aapof (cost=0.43..0.47 rows=1 width=32) (actual time=0.018..0.018 rows=1 loops=8,481)

  • Index Cond: ("Id" = art."Id")
13. 0.076 0.276 ↑ 1.0 7 4

Hash (cost=1.07..1.07 rows=7 width=47) (actual time=0.069..0.069 rows=7 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.200 0.200 ↑ 1.0 7 4

Seq Scan on "POFAnomalyClass" pofat (cost=0.00..1.07 rows=7 width=47) (actual time=0.046..0.050 rows=7 loops=4)

Planning time : 2.079 ms
Execution time : 130.008 ms