explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xunb

Settings
# exclusive inclusive rows x rows loops node
1. 30.511 610.699 ↓ 0.0 0 1

Insert on rtsepecoav (cost=74,609.07..74,692.30 rows=3,699 width=64) (actual time=610.699..610.699 rows=0 loops=1)

2. 1.494 580.188 ↓ 1.0 3,815 1

Subquery Scan on "*SELECT*" (cost=74,609.07..74,692.30 rows=3,699 width=64) (actual time=577.952..580.188 rows=3,815 loops=1)

3. 578.694 578.694 ↓ 1.0 3,815 1

HashAggregate (cost=74,609.07..74,646.06 rows=3,699 width=24) (actual time=577.943..578.694 rows=3,815 loops=1)

  • Group Key: rtsepezocoav_1_4_1199.se_id, rtsepezocoav_1_4_1199.pe_id, rtsepezocoav_1_4_1199.co_id, 1200
  • -> Seq Scan on rtsepezocoav_1_4_1199 (cost=0.00..44362.92 rows=2,419,692 width=24) (actual time=0.006..223.274 rows=2,419,692 loops=1)",,,,,"SQL statement "
  • insert into rtsepecoav (se_id,pe_id,co_id,ad_id,value_num)
  • select se_id,pe_id,co_id,1200,sum(value_num) as value_num from rtsepezocoav_1_4_1199 group by 1,2,3,4;