explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eEAE

Settings
# exclusive inclusive rows x rows loops node
1. 0.072 3.781 ↑ 1.0 43 1

HashAggregate (cost=355.63..356.06 rows=43 width=56) (actual time=3.770..3.781 rows=43 loops=1)

2. 0.441 3.709 ↑ 1.0 43 1

Merge Join (cost=19.19..355.42 rows=43 width=56) (actual time=3.448..3.709 rows=43 loops=1)

  • Merge Cond: (smw_di_number.p_id = smw_object_ids.smw_id)
3. 0.297 0.297 ↑ 1.0 43 1

Index Only Scan using smw_di_number_idx_sid_pid_osortkey on smw_di_number (cost=0.29..84.09 rows=43 width=4) (actual time=0.252..0.297 rows=43 loops=1)

  • Index Cond: (s_id = 5098)
  • Heap Fetches: 43
4. 2.971 2.971 ↑ 2.8 1,354 1

Index Scan using smw_object_ids_pkey on smw_object_ids (cost=0.28..711.00 rows=3,829 width=60) (actual time=0.041..2.971 rows=1,354 loops=1)