explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kv2Y : Optimization for: Evaluate and Select; plan #9dE

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.056 3.593 ↓ 100.0 200 1

Unique (cost=394.59..394.60 rows=2 width=4) (actual time=3.519..3.593 rows=200 loops=1)

  • Output: ztcf.cloudfolderid
2. 0.091 3.537 ↓ 100.0 200 1

Sort (cost=394.59..394.59 rows=2 width=4) (actual time=3.518..3.537 rows=200 loops=1)

  • Output: ztcf.cloudfolderid
  • Sort Key: ztcf.cloudfolderid
  • Sort Method: quicksort Memory: 34kB
3. 0.069 3.446 ↓ 100.0 200 1

Nested Loop (cost=0.85..394.58 rows=2 width=4) (actual time=3.360..3.446 rows=200 loops=1)

  • Output: ztcf.cloudfolderid
4. 0.184 0.184 ↓ 1.3 103 1

Index Scan using deviceid_index on public.device_to_zone_edge dtz (cost=0.43..78.18 rows=79 width=8) (actual time=0.014..0.184 rows=103 loops=1)

  • Output: dtz.deviceid, dtz.zoneid, dtz.version
  • Index Cond: (dtz.deviceid = 1,234)
5. 3.193 3.193 ↑ 16.5 2 103

Index Only Scan using zone_to_cloudfolder_edge_index1 on public.zone_to_cloudfolder_edge ztcf (cost=0.42..3.67 rows=33 width=12) (actual time=0.030..0.031 rows=2 loops=103)

  • Output: ztcf.zoneid, ztcf.version, ztcf.cloudfolderid
  • Index Cond: (ztcf.zoneid = dtz.zoneid)
  • Filter: ((dtz.version > 2100000) OR (ztcf.version > 2100000))
  • Rows Removed by Filter: 98
  • Heap Fetches: 0