explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iSGB

Settings
# exclusive inclusive rows x rows loops node
1. 30,578.870 30,578.870 ↓ 2.5 25 1

Function Scan on tf_appointment_search_v2 (cost=0.25..12.75 rows=10 width=524) (actual time=30,578.862..30,578.870 rows=25 loops=1)

  • Filter: (((patient_status_code)::text = 'A'::text) OR (patient_status_code IS NULL))