explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ds7r

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 17,468.789 ↑ 1.0 1 1

Finalize Aggregate (cost=63,610.55..63,610.56 rows=1 width=8) (actual time=17,468.788..17,468.789 rows=1 loops=1)

2. 2,070.210 19,507.241 ↓ 1.5 3 1

Gather (cost=63,610.33..63,610.54 rows=2 width=8) (actual time=17,464.841..19,507.241 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,380.997 17,437.031 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=62,610.33..62,610.34 rows=1 width=8) (actual time=17,437.031..17,437.031 rows=1 loops=3)

4. 6,021.810 16,056.034 ↓ 152.2 31,312,946 3 / 3

Parallel Hash Join (cost=5,510.79..62,095.93 rows=205,761 width=32) (actual time=11,971.711..16,056.034 rows=31,312,946 loops=3)

  • Hash Cond: (fti."ItemId" = mi."ItemMscoaId")
5. 2,980.854 2,980.854 ↑ 1.2 119,928 3 / 3

Parallel Seq Scan on "FlattenedTransactions" fti (cost=0.00..54,416.10 rows=149,910 width=16) (actual time=36.998..2,980.854 rows=119,928 loops=3)

6. 4,162.639 7,053.370 ↓ 244.7 4,611,189 3 / 3

Parallel Hash (cost=5,275.26..5,275.26 rows=18,842 width=48) (actual time=7,053.370..7,053.370 rows=4,611,189 loops=3)

  • Buckets: 65536 (originally 65536) Batches: 512 (originally 1) Memory Usage: 3008kB
7. 583.543 2,890.731 ↓ 244.7 4,611,189 3 / 3

Nested Loop (cost=491.33..5,275.26 rows=18,842 width=48) (actual time=6.454..2,890.731 rows=4,611,189 loops=3)

  • Join Filter: (m."Id" = mi."MappingId")
8. 3.407 11.950 ↓ 220.6 2,647 3 / 3

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

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

  • Heap Fetches: 0
10. 2.919 6.840 ↓ 473.1 7,097 3 / 3

Sort (cost=490.48..490.52 rows=15 width=48) (actual time=6.126..6.840 rows=7,097 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
11. 2.256 3.921 ↓ 455.5 6,833 3 / 3

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

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

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

13. 0.007 0.045 ↑ 1.0 1 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.038 0.038 ↑ 1.0 1 3 / 3

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

  • Filter: (("EntityId" = 'b787799f-4826-4f8a-9593-686999e54c9f'::uuid) AND ("Name" = 'AFS 2019.xlsx'::text))
  • Rows Removed by Filter: 2
15. 2,295.238 2,295.238 ↑ 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=32) (actual time=0.013..0.867 rows=1,742 loops=7,942)

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