explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dNRh

Settings
# exclusive inclusive rows x rows loops node
1. 65,919.083 130,618.116 ↑ 1.5 576 1

Nested Loop Anti Join (cost=0.00..254.58 rows=848 width=4) (actual time=555.394..130,618.116 rows=576 loops=1)

  • Output: m.metric_id
  • Join Filter: (r.metric_id = m.metric_id)
  • Rows Removed by Join Filter: 58755118
  • Buffers: shared hit=91949
2. 5.961 5.961 ↑ 1.0 848 1

Seq Scan on endtoend_839_central.dss_metric_types m (cost=0.00..238.69 rows=848 width=4) (actual time=0.057..5.961 rows=848 loops=1)

  • 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=214
3. 64,461.346 64,693.072 ↓ 69,287.0 69,287 848

Materialize (cost=0.00..3.17 rows=1 width=4) (actual time=0.002..76.289 rows=69,287 loops=848)

  • Output: r.metric_id
  • Buffers: shared hit=91735
4. 231.726 231.726 ↓ 92,437.0 92,437 1

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

  • Output: r.metric_id
  • Index Cond: (r.snapshot_id = 3)
  • Heap Fetches: 92437
  • Buffers: shared hit=91735