explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Tcm

Settings
# exclusive inclusive rows x rows loops node
1. 0.047 6,556.269 ↑ 1.0 1 1

Sort (cost=15.26..15.27 rows=1 width=408) (actual time=6,556.269..6,556.269 rows=1 loops=1)

  • Sort Key: clinic_name, insurer_name_web
  • Sort Method: quicksort Memory: 25kB
2. 6,556.222 6,556.222 ↑ 1.0 1 1

Function Scan on tf_appointment_insurer_clinic_scan_room_availability_list (cost=0.25..15.25 rows=1 width=408) (actual time=6,556.217..6,556.222 rows=1 loops=1)

  • Filter: ((clinic_id = '7'::numeric) AND (insurer_id = '14303158859701000000014'::numeric))
  • Rows Removed by Filter: 47