explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FnSS

Settings
# exclusive inclusive rows x rows loops node
1. 12,809.679 13,761.821 ↓ 0.0 0 1

Update on nomenclature (cost=104,039.43..213,414.01 rows=16,358 width=1,460) (actual time=13,761.821..13,761.821 rows=0 loops=1)

2.          

CTE nom

3. 226.710 245.070 ↓ 3.4 110,947 1

Bitmap Heap Scan on nomenclature nomenclature_1 (cost=1,545.17..104,030.67 rows=32,715 width=34) (actual time=19.186..245.070 rows=110,947 loops=1)

  • Recheck Cond: ((owner_id = 6919) AND ((source_system)::text = 'RKEEPER'::text))
  • Filter: active
  • Heap Blocks: exact=6255
4. 18.360 18.360 ↓ 6.0 221,894 1

Bitmap Index Scan on idx_nomenclature_iiko_rkeeper_unique (cost=0.00..1,536.99 rows=37,243 width=0) (actual time=18.360..18.360 rows=221,894 loops=1)

  • Index Cond: ((owner_id = 6919) AND ((source_system)::text = 'RKEEPER'::text))
5. 185.495 952.142 ↓ 6.8 110,947 1

Nested Loop (cost=8.76..109,383.34 rows=16,358 width=1,460) (actual time=19.256..952.142 rows=110,947 loops=1)

6. 60.955 433.806 ↓ 6.8 110,947 1

Hash Anti Join (cost=8.32..930.47 rows=16,358 width=562) (actual time=19.234..433.806 rows=110,947 loops=1)

  • Hash Cond: ((nom.system_guid)::text = (uniform_nomenclature.system_guid)::text)
7. 372.831 372.831 ↓ 3.4 110,947 1

CTE Scan on nom (cost=0.00..654.30 rows=32,715 width=1,072) (actual time=19.204..372.831 rows=110,947 loops=1)

8. 0.001 0.020 ↓ 0.0 0 1

Hash (cost=8.31..8.31 rows=1 width=12) (actual time=0.019..0.020 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
9. 0.019 0.019 ↓ 0.0 0 1

Index Scan using uniform_nomenclature_pkey on uniform_nomenclature (cost=0.29..8.31 rows=1 width=12) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (id = 1)
10. 332.841 332.841 ↑ 1.0 1 110,947

Index Scan using nomenclature_pkey on nomenclature (cost=0.43..6.62 rows=1 width=885) (actual time=0.003..0.003 rows=1 loops=110,947)

  • Index Cond: (id = nom.id)
Planning time : 0.949 ms
Execution time : 13,762.463 ms