explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VTCi

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.008 ↑ 1.0 1 1

Index Scan using project_pkey on fb67bdee232341d99db4f8254f170c51.project (cost=0.29..2.31 rows=1 width=8,228) (actual time=0.008..0.008 rows=1 loops=1)

  • Output: id, name, slug, code, clientid, projectleaderapproverid, projectstatuslabelid, isprojectleaderapprovalrequired, startdate, enddate, programid, billingtype, fixedbidamount, fixedbidcurrencyid, fixedbidfrequency, timeentrycappercent, costtype, description, percentcomplete, istimeentryallowed, estimatedhours, estimatedexpenses, estimatedexpensescurrencyid, estimatedcost, estimatedcostcurrencyid, timeandexpenseentrytype, estimationmode, billingratefrequencyid, billingratefrequencyduration, defaultbillingcurrencyid, info1, info2, info3, info4, info5, info6, info7, info8, info9, info10, info11, info12, info13, info14, info15, info16, info17, info18, info19, info20, clientbillingallocationmethod, billingcontractid, guidid, totalestimatedcontractamount, totalestimatedcontractcurrencyid, budgetedhours, budgetedcost, budgetedcostcurrencyid, projecthealthstateid, projecthealthstatedescription
  • Index Cond: (project.id = 14484)
  • Buffers: shared hit=3
Planning time : 1.380 ms
Execution time : 0.048 ms