explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ALdf

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

Finalize Aggregate (cost=6,322.58..6,322.59 rows=1 width=8) (actual time=2,738.176..2,738.176 rows=1 loops=1)

2. 73.199 2,761.854 ↓ 1.5 3 1

Gather (cost=6,322.37..6,322.58 rows=2 width=8) (actual time=2,712.346..2,761.854 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 222.373 2,688.655 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=5,322.37..5,322.38 rows=1 width=8) (actual time=2,688.655..2,688.655 rows=1 loops=3)

4. 377.243 2,466.282 ↓ 244.7 4,611,189 3 / 3

Nested Loop (cost=491.33..5,275.26 rows=18,842 width=32) (actual time=8.788..2,466.282 rows=4,611,189 loops=3)

  • Join Filter: (m."Id" = mi."MappingId")
5. 3.006 13.530 ↓ 220.6 2,647 3 / 3

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

  • Merge Cond: (c."MappingId" = m."Id")
6. 1.502 1.502 ↑ 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.094..1.502 rows=6,307 loops=3)

  • Heap Fetches: 0
7. 3.524 9.022 ↓ 477.9 7,168 3 / 3

Sort (cost=490.48..490.52 rows=15 width=48) (actual time=8.451..9.022 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.069 5.498 ↓ 455.5 6,833 3 / 3

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

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

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

10. 0.007 0.054 ↑ 1.0 1 3 / 3

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

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

Seq Scan on "Workbook" wb (cost=0.00..19.75 rows=1 width=48) (actual time=0.046..0.047 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,075.509 2,075.509 ↑ 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.011..0.784 rows=1,742 loops=7,942)

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