explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3uik

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

Aggregate (cost=586.79..586.80 rows=1 width=8) (actual time=130.004..130.004 rows=1 loops=1)

2. 129.995 129.995 ↓ 3.9 39 1

Index Scan using checkin_checkout_time_idx on checkin checkin0_ (cost=0.44..586.76 rows=10 width=8) (actual time=0.100..129.995 rows=39 loops=1)

  • Index Cond: (checkout_time IS NULL)
  • Filter: ((checkin_time IS NOT NULL) AND (fk_organization_unit = 1,858,373,180))
  • Rows Removed by Filter: 3,968
Planning time : 0.076 ms
Execution time : 130.031 ms