explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HvcT

Settings
# exclusive inclusive rows x rows loops node
1. 1,119.408 2,326.883 ↑ 1.0 3 1

HashAggregate (cost=359,173.39..359,173.42 rows=3 width=4) (actual time=2,326.881..2,326.883 rows=3 loops=1)

  • Output: \"weekOfyear\
  • Group Key: \"CONS_AC_VARIATION\".\"weekOfyear\
  • Buffers: shared hit=239295
  • Output: \"weekOfyear\", \"compared_weekOfyear\", granularity, program, \"programDescription\", \"aircraftId\", \"mrpController\", \"plantMaterial\", \"requirementType\", \"requirementType_label\", base_custo_id, base_custo_label, change_horizon, rating, rating_label, total_scoring, nb_modif_new, nb_modif_cancelation, nb_modif_anticipated, nb_modif_postponed, nb_modif_quantity_increase, nb_modif_quantity_decrease, \"max_compared_weekOfyear\", nb_total_variation, plant
  • Buffers: shared hit=239295
2. 1,207.475 1,207.475 ↓ 1.0 9,590,403 1

Seq Scan on sync.\"CONS_AC_VARIATION\" (cost=0.00..335,197.71 rows=9,590,271 width=4) (actual time=0.006..1,207.475 rows=9,590,403 loops=1)