explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qWcG

Settings
# exclusive inclusive rows x rows loops node
1. 268,727.514 268,727.514 ↓ 1.8 1,774 1

Function Scan on spiedwh.test (cost=0.25..10.25 rows=1,000 width=308) (actual time=268,727.260..268,727.514 rows=1,774 loops=1)

  • Output: geo_union_europeenne, geo_pays, geo_code_region, geo_libelle_region, geo_code_departement, geo_libelle_departement, cag_libelle, rac_type_de_production, mvt_id_sexe, mvt_id_date, sum_mvt_present, count_all
  • Function Call: test('2017-10-01'::character varying, '2017-10-31'::character varying)