explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.043 8.789 ↓ 100.0 200 1

Nested Loop (cost=0.85..4,958.44 rows=2 width=24) (actual time=8.624..8.789 rows=200 loops=1)

  • Output: ztcf.zoneid, ztcf.cloudfolderid, ztcf.version, dtz.deviceid, dtz.zoneid, dtz.version
2. 0.094 0.094 ↓ 1.3 103 1

Index Scan using deviceid_index on public.device_to_zone_edge dtz (cost=0.43..78.13 rows=79 width=12) (actual time=0.012..0.094 rows=103 loops=1)

  • Output: dtz.deviceid, dtz.zoneid, dtz.version
  • Index Cond: (dtz.deviceid = 1,234)
3. 8.652 8.652 ↑ 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.082..0.084 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