explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u7Bq

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 0.078 ↓ 32.0 64 1

Nested Loop (cost=4.75..20.90 rows=2 width=16) (actual time=0.049..0.078 rows=64 loops=1)

  • Output: dtzf.device_id, zf.cloud_folder_id
2. 0.018 0.018 ↓ 2.0 2 1

Index Only Scan using device_to_zone_ref_pkey on public.device_to_zone_ref dtzf (cost=0.15..12.50 rows=1 width=16) (actual time=0.014..0.018 rows=2 loops=1)

  • Output: dtzf.version, dtzf.device_id, dtzf.zone_id
  • Index Cond: ((dtzf.version = 3) AND (dtzf.device_id = ANY ('{1600,1570,1550}'::bigint[])))
  • Heap Fetches: 2
3. 0.020 0.042 ↑ 1.0 32 2

Bitmap Heap Scan on public.zone_ref zf (cost=4.60..8.08 rows=32 width=16) (actual time=0.017..0.021 rows=32 loops=2)

  • Output: zf.version, zf.zone_id, zf.user_id, zf.cloud_folder_id, zf.is_excluded, zf.update_time
  • Recheck Cond: ((zf.version = 3) AND (zf.zone_id = dtzf.zone_id))
  • Filter: (NOT zf.is_excluded)
  • Heap Blocks: exact=3
4. 0.022 0.022 ↑ 1.0 32 2

Bitmap Index Scan on zone_ref_version_zone_cf_index (cost=0.00..4.59 rows=32 width=0) (actual time=0.011..0.011 rows=32 loops=2)

  • Index Cond: ((zf.version = 3) AND (zf.zone_id = dtzf.zone_id))
Planning time : 0.475 ms
Execution time : 0.156 ms