explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uosG

Settings
# exclusive inclusive rows x rows loops node
1. 2,503.083 15,966.745 ↑ 3.4 5,642 1

HashAggregate (cost=68,776.54..69,013.05 rows=18,921 width=48) (actual time=15,963.714..15,966.745 rows=5,642 loops=1)

  • Group Key: c."Id
2. 1,633.747 13,463.662 ↓ 346.9 9,750,031 1

Hash Join (cost=6,658.07..68,636.01 rows=28,106 width=20) (actual time=3,607.840..13,463.662 rows=9,750,031 loops=1)

  • Hash Cond: (b."YearlyBalanceLookupId" = bt."BalanceTypeId")
3. 2,576.452 11,829.883 ↓ 346.9 9,750,031 1

Hash Join (cost=6,656.94..68,533.28 rows=28,106 width=36) (actual time=3,607.797..11,829.883 rows=9,750,031 loops=1)

  • Hash Cond: (c."Id" = b."CellId")
4. 2,025.846 9,245.171 ↓ 478.5 9,750,031 1

Hash Join (cost=5,762.42..67,177.82 rows=20,377 width=20) (actual time=3,599.461..9,245.171 rows=9,750,031 loops=1)

  • Hash Cond: (m."Id" = c."MappingId")
5. 0.000 7,214.725 ↓ 404.6 4,264,915 1

Gather (cost=5,082.70..66,137.37 rows=10,540 width=36) (actual time=3,594.757..7,214.725 rows=4,264,915 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 0.000 8,884.416 ↓ 323.7 1,421,638 3 / 3

Nested Loop (cost=4,082.70..64,083.37 rows=4,392 width=36) (actual time=3,565.067..8,884.416 rows=1,421,638 loops=3)

7. 2,741.104 6,307.424 ↓ 320.1 1,421,638 3 / 3

Hash Join (cost=4,082.28..56,616.70 rows=4,441 width=48) (actual time=3,564.893..6,307.424 rows=1,421,638 loops=3)

  • Hash Cond: (fti."ItemId" = mi."ItemMscoaId")
8. 20.208 21.904 ↑ 1.3 13,841 3 / 3

Parallel Bitmap Heap Scan on "FlattenedTransactions" fti (cost=1,163.68..53,566.79 rows=17,380 width=32) (actual time=1.994..21.904 rows=13,841 loops=3)

  • Recheck Cond: ("EntityId" = 'b787799f-4826-4f8a-9593-686999e54c9f'::uuid)
  • Heap Blocks: exact=600
9. 1.696 1.696 ↑ 1.0 41,522 1 / 3

Bitmap Index Scan on "IX_FlattenedTransactions_EntityId" (cost=0.00..1,153.25 rows=41,711 width=0) (actual time=5.089..5.089 rows=41,522 loops=1)

  • Index Cond: ("EntityId" = 'b787799f-4826-4f8a-9593-686999e54c9f'::uuid)
10. 2,052.860 3,544.416 ↓ 656.2 5,964,789 3 / 3

Hash (cost=2,804.97..2,804.97 rows=9,090 width=48) (actual time=3,544.416..3,544.416 rows=5,964,789 loops=3)

  • Buckets: 65536 (originally 16384) Batches: 256 (originally 1) Memory Usage: 4043kB
11. 494.297 1,491.556 ↓ 656.2 5,964,789 3 / 3

Nested Loop (cost=20.32..2,804.97 rows=9,090 width=48) (actual time=0.285..1,491.556 rows=5,964,789 loops=3)

12. 3.913 6.474 ↓ 455.5 6,833 3 / 3

Hash Join (cost=19.76..346.18 rows=15 width=16) (actual time=0.151..6.474 rows=6,833 loops=3)

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

Seq Scan on "Mapping" m (cost=0.00..300.42 rows=9,842 width=32) (actual time=0.070..2.504 rows=9,842 loops=3)

14. 0.008 0.057 ↑ 1.0 1 3 / 3

Hash (cost=19.75..19.75 rows=1 width=16) (actual time=0.057..0.057 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.049 0.049 ↑ 1.0 1 3 / 3

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

  • Filter: (("EntityId" = 'b787799f-4826-4f8a-9593-686999e54c9f'::uuid) AND ("Name" = 'AFS 2019.xlsx'::text))
  • Rows Removed by Filter: 2
16. 990.785 990.785 ↑ 6.0 873 20,499 / 3

Index Only Scan using "PK_MappingItem" on "MappingItem" mi (cost=0.56..111.55 rows=5,237 width=32) (actual time=0.006..0.145 rows=873 loops=20,499)

  • Index Cond: ("MappingId" = m."Id")
  • Heap Fetches: 816
17. 2,843.277 2,843.277 ↑ 1.0 1 4,264,915 / 3

Index Scan using "PK_FlattenedBalances" on "FlattenedBalances" fb (cost=0.42..1.68 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=4,264,915)

  • Index Cond: ("TransactionId" = fti."TransactionId")
18. 2.297 4.600 ↑ 1.0 18,921 1

Hash (cost=443.21..443.21 rows=18,921 width=32) (actual time=4.600..4.600 rows=18,921 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1439kB
19. 2.303 2.303 ↑ 1.0 18,921 1

Seq Scan on "Cell" c (cost=0.00..443.21 rows=18,921 width=32) (actual time=0.016..2.303 rows=18,921 loops=1)

20. 3.096 8.260 ↑ 1.0 26,245 1

Hash (cost=566.45..566.45 rows=26,245 width=32) (actual time=8.260..8.260 rows=26,245 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1706kB
21. 5.164 5.164 ↑ 1.0 26,245 1

Seq Scan on "Balance" b (cost=0.00..566.45 rows=26,245 width=32) (actual time=0.024..5.164 rows=26,245 loops=1)

22. 0.009 0.032 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=16) (actual time=0.031..0.032 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
23. 0.023 0.023 ↑ 1.0 6 1

Seq Scan on "LookupBalanceTypes" bt (cost=0.00..1.06 rows=6 width=16) (actual time=0.021..0.023 rows=6 loops=1)