explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ovPV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,541.538 ↑ 1.0 1 1

Finalize Aggregate (cost=6,096.65..6,096.66 rows=1 width=8) (actual time=2,541.538..2,541.538 rows=1 loops=1)

2. 59.201 2,563.786 ↓ 1.5 3 1

Gather (cost=6,096.44..6,096.65 rows=2 width=8) (actual time=2,533.584..2,563.786 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 234.171 2,504.585 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=5,096.44..5,096.45 rows=1 width=8) (actual time=2,504.585..2,504.585 rows=1 loops=3)

4. 218.497 2,270.414 ↓ 244.7 4,611,189 3 / 3

Nested Loop (cost=491.33..5,049.33 rows=18,842 width=32) (actual time=8.729..2,270.414 rows=4,611,189 loops=3)

5. 3.009 13.470 ↓ 220.6 2,647 3 / 3

Merge Join (cost=490.77..1,960.11 rows=12 width=64) (actual time=8.494..13.470 rows=2,647 loops=3)

  • Merge Cond: (c."MappingId" = m."Id")
6. 1.619 1.619 ↑ 1.3 6,307 3 / 3

Parallel Index Only Scan using "IX_Cell_MappingId" on "Cell" c (cost=0.29..1,449.73 rows=7,884 width=16) (actual time=0.190..1.619 rows=6,307 loops=3)

  • Heap Fetches: 0
7. 3.381 8.842 ↓ 477.9 7,168 3 / 3

Sort (cost=490.48..490.52 rows=15 width=48) (actual time=8.276..8.842 rows=7,168 loops=3)

  • Sort Key: m."Id
  • Sort Method: quicksort Memory: 726kB
  • Worker 0: Sort Method: quicksort Memory: 726kB
  • Worker 1: Sort Method: quicksort Memory: 726kB
8. 3.023 5.461 ↓ 455.5 6,833 3 / 3

Hash Join (cost=19.76..490.18 rows=15 width=48) (actual time=1.013..5.461 rows=6,833 loops=3)

  • Hash Cond: (m."WorkbookId" = wb."Id")
9. 1.943 1.943 ↑ 1.0 9,842 3 / 3

Seq Scan on "Mapping" m (cost=0.00..444.42 rows=9,842 width=32) (actual time=0.122..1.943 rows=9,842 loops=3)

10. 0.011 0.495 ↑ 1.0 1 3 / 3

Hash (cost=19.75..19.75 rows=1 width=48) (actual time=0.495..0.495 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.484 0.484 ↑ 1.0 1 3 / 3

Seq Scan on "Workbook" wb (cost=0.00..19.75 rows=1 width=48) (actual time=0.482..0.484 rows=1 loops=3)

  • Filter: (("EntityId" = 'b787799f-4826-4f8a-9593-686999e54c9f'::uuid) AND ("Name" = 'AFS 2019.xlsx'::text))
  • Rows Removed by Filter: 2
12. 2,038.447 2,038.447 ↑ 4.3 1,742 7,942 / 3

Index Only Scan using "PK_MappingItem" on "MappingItem" mi (cost=0.56..182.12 rows=7,531 width=16) (actual time=0.012..0.770 rows=1,742 loops=7,942)

  • Index Cond: ("MappingId" = c."MappingId")
  • Heap Fetches: 13833566
Planning time : 0.931 ms