explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vwBS

Settings
# exclusive inclusive rows x rows loops node
1. 164,715.206 182,758.426 ↓ 0.0 0 1

Insert on public.prices (cost=2,688,403.20..2,835,489.39 rows=4,114,896 width=94) (actual time=182,758.426..182,758.426 rows=0 loops=1)

  • Buffers: shared hit=1367641 read=5781 dirtied=21106, local read=92992, temp read=86844 written=86858
  • I/O Timings: read=156.573
2. 2,276.370 18,043.220 ↑ 27.0 152,574 1

Merge Anti Join (cost=2,688,403.20..2,835,489.39 rows=4,114,896 width=94) (actual time=13,384.380..18,043.220 rows=152,574 loops=1)

  • Output: np."productId", np."pharmacyId", np.price, np.quantity, np."externalId", np."partNumber", np.pickup, np.delivery
  • Merge Cond: ((np."pharmacyId" = p."pharmacyId") AND (np."productId" = p."productId"))
  • Buffers: shared hit=97663, local read=92992, temp read=86844 written=86858
  • I/O Timings: read=142.909
3. 6,205.326 7,681.086 ↓ 1.9 10,278,688 1

Sort (cost=1,080,801.97..1,094,518.29 rows=5,486,528 width=110) (actual time=6,597.454..7,681.086 rows=10,278,688 loops=1)

  • Output: np."productId", np."pharmacyId", np.price, np.quantity, np."externalId", np."partNumber", np.pickup, np.delivery
  • Sort Key: np."pharmacyId", np."productId
  • Sort Method: external merge Disk: 514360kB
  • Buffers: local read=92992, temp read=64295 written=64304
  • I/O Timings: read=142.909
4. 1,475.760 1,475.760 ↓ 1.9 10,278,688 1

Seq Scan on pg_temp_10."tmpLoadPrices" np (cost=0.00..147,857.28 rows=5,486,528 width=110) (actual time=0.008..1,475.760 rows=10,278,688 loops=1)

  • Output: np."productId", np."pharmacyId", np.price, np.quantity, np."externalId", np."partNumber", np.pickup, np.delivery
  • Buffers: local read=92992
  • I/O Timings: read=142.909
5. 7,143.092 8,085.764 ↑ 1.1 10,240,361 1

Sort (cost=1,607,601.24..1,634,483.93 rows=10,753,076 width=8) (actual time=6,786.877..8,085.764 rows=10,240,361 loops=1)

  • Output: p."pharmacyId", p."productId
  • Sort Key: p."pharmacyId", p."productId
  • Sort Method: external merge Disk: 180392kB
  • Buffers: shared hit=97663, temp read=22549 written=22554
6. 942.672 942.672 ↑ 1.1 10,240,361 1

Seq Scan on public.prices p (cost=0.00..204,718.76 rows=10,753,076 width=8) (actual time=0.008..942.672 rows=10,240,361 loops=1)

  • Output: p."pharmacyId", p."productId
  • Buffers: shared hit=97663
Trigger times:
Trigger Name:Total time:Calls:Average time:
RI_ConstraintTrigger_c_18060 for constraint prices_productid_fkey 1,706.845 ms 152574 0.011 ms