explain.depesz.com

PostgreSQL's explain analyze made readable

Result: flvs

Settings
# exclusive inclusive rows x rows loops node
1. 2.328 3.160 ↓ 0.0 0 1

Update on inventory_offline_sales (cost=0.00..2,157.98 rows=258 width=133) (actual time=3.160..3.160 rows=0 loops=1)

2. 0.316 0.832 ↑ 1.0 258 1

Seq Scan on inventory_offline_sales (cost=0.00..2,157.98 rows=258 width=133) (actual time=0.032..0.832 rows=258 loops=1)

3.          

SubPlan (for Seq Scan)

4. 0.516 0.516 ↑ 1.0 1 258

Index Scan using pk_inventory on inventory b (cost=0.28..8.30 rows=1 width=15) (actual time=0.002..0.002 rows=1 loops=258)

  • Index Cond: (inventory_offline_sales.fk_inventory = id)
Planning time : 0.125 ms
Execution time : 3.189 ms