explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cBfE

Settings
# exclusive inclusive rows x rows loops node
1. 317,399.652 317,399.652 ↓ 4.8 71,751 1

Index Scan using clin_item_prov_provider_fki on clinical_item_provider (cost=0.57..36,077.78 rows=14,814 width=45) (actual time=47.884..317,399.652 rows=71,751 loops=1)

  • Index Cond: (provider_key = 152765::numeric)