explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jToR

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

Aggregate (cost=42.65..42.66 rows=1 width=8) (actual time=0.280..0.280 rows=1 loops=1)

2. 0.272 0.272 ↓ 4.5 45 1

Index Scan using checkin_fk_organization_unit_checkout_time_null_idx on checkin checkin0_ (cost=0.28..42.62 rows=10 width=8) (actual time=0.060..0.272 rows=45 loops=1)

  • Index Cond: (fk_organization_unit = 1,858,373,180)
  • Filter: (checkin_time IS NOT NULL)
Planning time : 0.864 ms
Execution time : 0.367 ms