explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OLhe

Settings
# exclusive inclusive rows x rows loops node
1. 62,510.262 122,966.928 ↑ 1.5 574 1

Nested Loop Anti Join (cost=0.00..227.77 rows=848 width=4) (actual time=580.817..122,966.928 rows=574 loops=1)

  • Output: m.metric_id
  • Join Filter: (r.metric_id = m.metric_id)
  • Rows Removed by Join Filter: 58583933
  • Buffers: shared hit=92303
  • Output: m.metric_id, m.metric_name, m.metric_description, m.metric_type, m.metric_group, m.metric_depends_on, m.metric_options, m.scope_id, m.property_id
  • Filter: (m.metric_group = 1)
  • Rows Removed by Filter: 1127
  • Buffers: shared hit=186
  • Output: r.metric_id
  • Buffers: shared hit=92117
  • Output: r.metric_id
  • Index Cond: (r.snapshot_id = 10)
  • Heap Fetches: 92388
  • Buffers: shared hit=92117
2. 5.680 5.680 ↑ 1.0 848 1

Seq Scan on endtoend_839_central.dss_metric_types m (cost=0.00..210.69 rows=848 width=4) (actual time=0.013..5.680 rows=848 loops=1)

3. 60,264.816 60,264.816 ↓ 69,085.0 69,085 848

Materialize (cost=0.00..4.36 rows=1 width=4) (actual time=0.002..71.067 rows=69,085 loops=848)

4. 186.170 186.170 ↓ 92,388.0 92,388 1

Index Only Scan using dss_metr_res_idx2 on endtoend_839_central.dss_metric_results r (cost=0.00..4.36 rows=1 width=4) (actual time=0.097..186.170 rows=92,388 loops=1)