explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Or9M

Settings
# exclusive inclusive rows x rows loops node
1. 193.697 10,062.876 ↑ 1.0 1 1

Unique (cost=4,945.30..6,041.79 rows=1 width=32) (actual time=3,071.549..10,062.876 rows=1 loops=1)

2. 6,823.367 9,869.179 ↓ 305.9 13,833,566 1

Hash Join (cost=4,945.30..6,041.79 rows=45,221 width=32) (actual time=3,071.548..9,869.179 rows=13,833,566 loops=1)

  • Hash Cond: (c."MappingId" = m."Id")
3. 3.086 3.086 ↑ 1.0 18,921 1

Seq Scan on "Cell" c (cost=0.00..552.21 rows=18,921 width=16) (actual time=0.027..3.086 rows=18,921 loops=1)

4. 1,327.394 3,042.726 ↓ 255.0 5,964,789 1

Hash (cost=4,652.93..4,652.93 rows=23,390 width=64) (actual time=3,042.726..3,042.726 rows=5,964,789 loops=1)

  • Buckets: 65536 (originally 32768) Batches: 2048 (originally 1) Memory Usage: 5034kB
5. 395.722 1,715.332 ↓ 255.0 5,964,789 1

Nested Loop (cost=20.32..4,652.93 rows=23,390 width=64) (actual time=0.247..1,715.332 rows=5,964,789 loops=1)

6. 3.592 7.674 ↓ 455.5 6,833 1

Hash Join (cost=19.76..490.18 rows=15 width=48) (actual time=0.205..7.674 rows=6,833 loops=1)

  • Hash Cond: (m."WorkbookId" = wb."Id")
7. 4.043 4.043 ↑ 1.0 9,842 1

Seq Scan on "Mapping" m (cost=0.00..444.42 rows=9,842 width=32) (actual time=0.028..4.043 rows=9,842 loops=1)

8. 0.004 0.039 ↑ 1.0 1 1

Hash (cost=19.75..19.75 rows=1 width=48) (actual time=0.038..0.039 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.035 0.035 ↑ 1.0 1 1

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

  • Filter: (("EntityId" = 'b787799f-4826-4f8a-9593-686999e54c9f'::uuid) AND ("Name" = 'AFS 2019.xlsx'::text))
  • Rows Removed by Filter: 2
10. 1,311.936 1,311.936 ↑ 8.6 873 6,833

Index Only Scan using "MappingItem_MappingId_idx" on "MappingItem" mi (cost=0.56..202.22 rows=7,530 width=16) (actual time=0.009..0.192 rows=873 loops=6,833)

  • Index Cond: ("MappingId" = m."Id")
  • Heap Fetches: 5964789
Planning time : 2.425 ms