explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vHI9

Settings
# exclusive inclusive rows x rows loops node
1. 1,145,705.292 1,145,705.292 ↑ 100.0 10 1

Function Scan on dharani.fn_get_notional_and_company_asset_report_khatawise (cost=0.25..30.25 rows=1,000 width=356) (actual time=1,145,705.291..1,145,705.292 rows=10 loops=1)

  • Output: district_name, division_name, mandal_name, village_name, khata_number, survey_number, total_extent, land_nature, land_classification, asset_type, asset_subtype, sno
  • Function Call: dharani.fn_get_notional_and_company_asset_report_khatawise(0, 0, 0, 0, 5, 0, 1, 10)
  • Buffers: shared hit=369734947 dirtied=6140
Planning time : 0.116 ms
Execution time : 1,145,705.360 ms