explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N2VI

Settings
# exclusive inclusive rows x rows loops node
1. 6.805 65,244.736 ↓ 1.5 1,591 1

HashAggregate (cost=1,082,157.29..1,082,163.51 rows=1,038 width=32) (actual time=65,243.843..65,244.736 rows=1,591 loops=1)

  • Output: s_rt_zvk.store_id, s_rt_zvk.goods_id, sum(s_rt_zvk.items_count), sum(s_rt_zvk.transit), sum(s_rt_zvk.reserve), CASE WHEN (sum(((s_rt_zvk.items_count + s_rt_zvk.transit) - s_rt_zvk
  • Filter: (sum(s_rt_zvk.transit) >= 0::double precision)
  • Buffers: shared hit=318742 read=36823
2. 65,237.931 65,237.931 ↑ 3,128.9 6,932 1

Seq Scan on store.s_rt_zvk (cost=0.00..431,477.63 rows=21,689,322 width=32) (actual time=41,612.660..65,237.931 rows=6,932 loops=1)

  • Output: s_rt_zvk.goods_id, s_rt_zvk.store_id, s_rt_zvk.items_count, s_rt_zvk.date_purchase, s_rt_zvk.price, s_rt_zvk.invoice_id, s_rt_zvk.line_id, s_rt_zvk.supplier_id, s_rt_zvk.pro
  • Filter: (s_rt_zvk.program_id = 4)
  • Buffers: shared hit=318742 read=36823