explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TWvF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=353.95..354.41 rows=46 width=56) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Merge Join (cost=18.54..353.72 rows=46 width=56) (actual rows= loops=)

  • Merge Cond: (smw_di_number.p_id = smw_object_ids.smw_id)
3. 0.000 0.000 ↓ 0.0

Index Only Scan using smw_di_number_idx_sid_pid_osortkey on smw_di_number (cost=0.29..90.07 rows=46 width=4) (actual rows= loops=)

  • Index Cond: (s_id = 5098)
4. 0.000 0.000 ↓ 0.0

Index Scan using smw_object_ids_pkey on smw_object_ids (cost=0.28..719.85 rows=3,978 width=60) (actual rows= loops=)