explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.045 14.813 ↓ 100.0 200 1

Unique (cost=4,958.45..4,958.46 rows=2 width=4) (actual time=14.754..14.813 rows=200 loops=1)

  • Output: ztcf.cloudfolderid
2. 0.083 14.768 ↓ 100.0 200 1

Sort (cost=4,958.45..4,958.45 rows=2 width=4) (actual time=14.753..14.768 rows=200 loops=1)

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

Nested Loop (cost=0.85..4,958.44 rows=2 width=4) (actual time=10.304..14.685 rows=200 loops=1)

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

Index Scan using deviceid_index on public.device_to_zone_edge dtz (cost=0.43..78.13 rows=79 width=8) (actual time=0.011..0.119 rows=103 loops=1)

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

Index Scan using zone_to_cloudfolder_edge_index1 on public.zone_to_cloudfolder_edge ztcf (cost=0.42..61.45 rows=33 width=12) (actual time=0.098..0.141 rows=2 loops=103)

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