explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5uPj : Optimization for: Optimization for: plan #hvgr; plan #vG1

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 3.377 3.474 ↓ 0.0 0 1

Gather (cost=1,008.46..11,899.25 rows=1 width=8) (actual time=2.623..3.474 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.065 0.097 ↓ 0.0 0 3

Hash Join (cost=8.46..10,899.15 rows=1 width=8) (actual time=0.097..0.097 rows=0 loops=3)

  • Hash Cond: (device_location_map.device_master_sl_no = device_master.device_master_sl_no)
3. 0.007 0.007 ↑ 375,031.0 1 3

Parallel Seq Scan on device_location_map (cost=0.00..9,484.31 rows=375,031 width=16) (actual time=0.007..0.007 rows=1 loops=3)

4. 0.001 0.025 ↓ 0.0 0 3

Hash (cost=8.45..8.45 rows=1 width=8) (actual time=0.025..0.025 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
5. 0.024 0.024 ↓ 0.0 0 3

Index Scan using "uc_device_master_MAC_ID" on device_master (cost=0.42..8.45 rows=1 width=8) (actual time=0.024..0.024 rows=0 loops=3)

  • Index Cond: ((mac_id)::text = 'AVC'::text)
  • Filter: (is_active = 'Y'::bpchar)
Planning time : 0.236 ms