explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e9xT

Settings
# exclusive inclusive rows x rows loops node
1. 0.406 19.953 ↓ 140.0 140 1

HashAggregate (cost=254.58..254.59 rows=1 width=16) (actual time=19.793..19.953 rows=140 loops=1)

  • Output: v.diag_id, v.object_id, count(r.metric_num_value)
  • Buffers: shared hit=2004 dirtied=1
2. 1.039 19.547 ↓ 140.0 140 1

Nested Loop (cost=102.73..254.57 rows=1 width=16) (actual time=14.698..19.547 rows=140 loops=1)

  • Output: v.diag_id, v.object_id, r.metric_num_value
  • Join Filter: (t.metric_id = r.metric_id)
  • Buffers: shared hit=2004 dirtied=1
3. 0.239 15.988 ↓ 70.0 140 1

Hash Join (cost=102.73..245.64 rows=2 width=16) (actual time=14.526..15.988 rows=140 loops=1)

  • Output: v.diag_id, v.object_id, v.snapshot_id, t.metric_id
  • Hash Cond: (t.metric_id = (v.diag_id + 1))
  • Buffers: shared hit=1441 dirtied=1
4. 2.006 2.006 ↑ 1.7 16 1

Seq Scan on endtoend_839_central.dss_metric_value_types t (cost=0.00..142.15 rows=27 width=4) (actual time=0.748..2.006 rows=16 loops=1)

  • Output: t.metric_id, t.metric_value_index, t.metric_value_name, t.metric_value_description, t.metric_value_procedure_name, t.metric_aggregate_operator, t.metric_value_procedure_name_2, t.metric_aggregate_operator_2, t.metric_value_type
  • Filter: (t.metric_value_type = ANY ('{7,8}'::integer[]))
  • Rows Removed by Filter: 3687
  • Buffers: shared hit=97
5. 6.228 13.743 ↓ 47.8 4,967 1

Hash (cost=101.43..101.43 rows=104 width=12) (actual time=13.743..13.743 rows=4,967 loops=1)

  • Output: v.diag_id, v.object_id, v.snapshot_id
  • Buckets: 1024 Batches: 1 Memory Usage: 214kB
  • Buffers: shared hit=1344 dirtied=1
6. 7.515 7.515 ↓ 47.8 4,967 1

Index Scan using dss_violation_status_idx1 on endtoend_839_central.dss_violation_statuses v (cost=0.00..101.43 rows=104 width=12) (actual time=0.128..7.515 rows=4,967 loops=1)

  • Output: v.diag_id, v.object_id, v.snapshot_id
  • Index Cond: ((v.snapshot_id = 7) AND (v.previous_snapshot_id = 1) AND (v.violation_status = 4))
  • Buffers: shared hit=1344 dirtied=1
7. 2.520 2.520 ↑ 1.0 1 140

Index Scan using dss_metr_res_idx2 on endtoend_839_central.dss_metric_results r (cost=0.00..4.45 rows=1 width=20) (actual time=0.017..0.018 rows=1 loops=140)

  • Output: r.metric_id, r.object_id, r.metric_value_index, r.metric_num_value, r.metric_char_value, r.metric_object_id, r.snapshot_id, r.position_id
  • Index Cond: ((r.snapshot_id = 7) AND (r.metric_id = (v.diag_id + 1)) AND (r.object_id = v.object_id))
  • Buffers: shared hit=563