explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZObi

Settings
# exclusive inclusive rows x rows loops node
1. 0.077 1,000.389 ↑ 1.0 7 1

WindowAgg (cost=371,849.31..372,107.85 rows=7 width=59) (actual time=1,000.375..1,000.389 rows=7 loops=1)

2. 0.000 1,000.312 ↑ 1.0 7 1

Finalize GroupAggregate (cost=371,849.31..372,107.58 rows=7 width=55) (actual time=999.974..1,000.312 rows=7 loops=1)

  • Group Key: pofat."Id
3. 0.000 1,067.393 ↓ 1.0 43 1

Gather Merge (cost=371,849.31..372,107.30 rows=42 width=55) (actual time=999.945..1,067.393 rows=43 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
4. 0.483 6,887.867 ↑ 1.2 6 7

Partial GroupAggregate (cost=370,849.22..371,102.10 rows=7 width=55) (actual time=983.799..983.981 rows=6 loops=7)

  • Group Key: pofat."Id
5. 0.770 6,887.384 ↑ 29.1 489 7

Merge Join (cost=370,849.22..371,030.93 rows=14,220 width=47) (actual time=983.781..983.912 rows=489 loops=7)

  • Merge Cond: (aapof."POFAnomalyClassId" = pofat."Id")
6. 5.068 6,885.977 ↑ 29.0 490 7

Sort (cost=370,848.05..370,883.60 rows=14,220 width=16) (actual time=983.675..983.711 rows=490 loops=7)

  • Sort Key: aapof."POFAnomalyClassId
  • Sort Method: quicksort Memory: 175kB
  • Worker 0: Sort Method: quicksort Memory: 89kB
  • Worker 1: Sort Method: quicksort Memory: 88kB
  • Worker 2: Sort Method: quicksort Memory: 88kB
  • Worker 3: Sort Method: quicksort Memory: 88kB
  • Worker 4: Sort Method: quicksort Memory: 89kB
  • Worker 5: Sort Method: quicksort Memory: 89kB
7. 2.824 6,880.909 ↑ 11.7 1,212 7

Nested Loop (cost=19,582.03..369,867.18 rows=14,220 width=16) (actual time=640.310..982.987 rows=1,212 loops=7)

8. 3,847.130 6,750.870 ↑ 11.7 1,212 7

Parallel Hash Join (cost=19,581.60..362,221.49 rows=14,232 width=16) (actual time=640.220..964.410 rows=1,212 loops=7)

  • Hash Cond: (art."DiagnosticObjectId" = obj."Id")
9. 2,887.101 2,887.101 ↑ 1.2 1,470,398 7

Parallel Seq Scan on "Artifact" art (cost=0.00..338,136.97 rows=1,715,396 width=32) (actual time=0.034..412.443 rows=1,470,398 loops=7)

10. 7.539 16.639 ↑ 2.4 2,020 7

Parallel Hash (cost=19,522.08..19,522.08 rows=4,761 width=16) (actual time=2.377..2.377 rows=2,020 loops=7)

  • Buckets: 16384 Batches: 1 Memory Usage: 832kB
11. 7.538 9.100 ↓ 1.5 7,069 2

Parallel Bitmap Heap Scan on "DiagnosticObject" obj (cost=346.80..19,522.08 rows=4,761 width=16) (actual time=0.877..4.550 rows=7,069 loops=2)

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

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

  • Index Cond: ("DiagnosticTargetId" = '4fdab16f-760f-4b6d-b610-e68451786a51'::uuid)
13. 127.215 127.215 ↑ 1.0 1 8,481

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

  • Index Cond: ("Id" = art."Id")
14. 0.231 0.637 ↑ 1.0 7 7

Sort (cost=1.17..1.19 rows=7 width=47) (actual time=0.090..0.091 rows=7 loops=7)

  • 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
  • Worker 3: Sort Method: quicksort Memory: 25kB
  • Worker 4: Sort Method: quicksort Memory: 25kB
  • Worker 5: Sort Method: quicksort Memory: 25kB
15. 0.406 0.406 ↑ 1.0 7 7

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