explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vG1 : Optimization for: plan #hvgr

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 3.705 3.832 ↓ 0.0 0 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.082 0.127 ↓ 0.0 0 3

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

  • Hash Cond: (device_location_map.device_master_sl_no = device_master.device_master_sl_no)
3. 0.013 0.013 ↑ 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.013..0.013 rows=1 loops=3)

4. 0.000 0.032 ↓ 0.0 0 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
5. 0.032 0.032 ↓ 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.032..0.032 rows=0 loops=3)

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