explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nCfW

Settings
# exclusive inclusive rows x rows loops node
1. 1,433.078 8,733.761 ↓ 0.0 0 1

Update on inventory_lot il (cost=99,567.81..117,087.55 rows=87,044 width=338) (actual time=8,733.761..8,733.761 rows=0 loops=1)

2.          

CTE leaf_info

3. 14.265 3,683.736 ↑ 1.8 48,653 1

Unique (cost=35,063.00..36,215.51 rows=87,044 width=33) (actual time=3,597.760..3,683.736 rows=48,653 loops=1)

4. 28.807 3,669.471 ↑ 1.8 48,954 1

Group (cost=35,063.00..35,997.90 rows=87,044 width=33) (actual time=3,597.758..3,669.471 rows=48,954 loops=1)

  • Group Key: lii.global_id, lii.global_inventory_type_id
5. 1,504.286 3,640.664 ↓ 1.0 125,571 1

Sort (cost=35,063.00..35,374.63 rows=124,653 width=33) (actual time=3,597.756..3,640.664 rows=125,571 loops=1)

  • Sort Key: lii.global_id, lii.global_inventory_type_id
  • Sort Method: external merge Disk: 5528kB
6. 2,009.787 2,136.378 ↓ 1.0 125,571 1

Bitmap Heap Scan on lf_inventory_item lii (cost=2,890.48..21,103.65 rows=124,653 width=33) (actual time=128.577..2,136.378 rows=125,571 loops=1)

  • Recheck Cond: (seller_id = 'd7ca2754-eced-11e7-941d-42010a800008'::uuid)
  • Heap Blocks: exact=8915
7. 126.591 126.591 ↓ 1.0 125,571 1

Bitmap Index Scan on idx_lf_inventory_item_seller (cost=0.00..2,859.32 rows=124,653 width=0) (actual time=126.591..126.591 rows=125,571 loops=1)

  • Index Cond: (seller_id = 'd7ca2754-eced-11e7-941d-42010a800008'::uuid)
8. 474.262 7,300.683 ↑ 1.8 48,303 1

Hash Join (cost=63,352.31..80,872.04 rows=87,044 width=338) (actual time=6,680.842..7,300.683 rows=48,303 loops=1)

  • Hash Cond: (li.lii_global_id = il.external_id)
9. 3,750.969 3,750.969 ↑ 1.8 48,653 1

CTE Scan on leaf_info li (cost=0.00..1,740.88 rows=87,044 width=152) (actual time=3,597.767..3,750.969 rows=48,653 loops=1)

10. 2,172.774 3,075.452 ↑ 1.0 358,058 1

Hash (cost=48,036.58..48,036.58 rows=358,058 width=218) (actual time=3,075.452..3,075.452 rows=358,058 loops=1)

  • Buckets: 16384 Batches: 32 Memory Usage: 2667kB
11. 902.678 902.678 ↑ 1.0 358,058 1

Seq Scan on inventory_lot il (cost=0.00..48,036.58 rows=358,058 width=218) (actual time=0.292..902.678 rows=358,058 loops=1)