explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i3UO

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 4.384 ↓ 0.0 0 1

Update on b827_diw766_sqlext_central.dss_metric_results dmr (cost=13.71..16.25 rows=1 width=630) (actual time=4.384..4.384 rows=0 loops=1)

  • Buffers: shared read=1
2.          

CTE source

3. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..8.75 rows=1 width=20) (never executed)

  • Output: source.metric_id, source.metric_value_index, source.metric_num_value, source_child.object_type_id
4. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..6.22 rows=1 width=20) (never executed)

  • Output: source_child.object_type_id, source.metric_id, source.metric_value_index, source.metric_num_value
5. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..4.95 rows=1 width=28) (never executed)

  • Output: source_child.object_type_id, source_child.object_id, source.metric_id, source.metric_value_index, source.metric_num_value, source.object_id
6. 0.000 0.000 ↓ 0.0 0

Index Scan using dss_metr_res_idx2 on b827_diw766_sqlext_central.dss_metric_results source (cost=0.00..2.47 rows=1 width=20) (never executed)

  • Output: source.metric_id, source.object_id, source.metric_value_index, source.metric_num_value, source.metric_char_value, source.metric_object_id, source.snapshot_id, source.position_id
  • Index Cond: ((source.snapshot_id = 7) AND (source.metric_value_index > (-1)))
7. 0.000 0.000 ↓ 0.0 0

Index Scan using dss_object_info_idx on b827_diw766_sqlext_central.dss_object_info source_child (cost=0.00..2.47 rows=1 width=8) (never executed)

  • Output: source_child.snapshot_id, source_child.object_id, source_child.object_type_id, source_child.object_checksum
  • Index Cond: ((source_child.object_id = source.object_id) AND (source_child.snapshot_id = 7))
8. 0.000 0.000 ↓ 0.0 0

Index Scan using dss_linkn_idx on b827_diw766_sqlext_central.dss_link_info source_link (cost=0.00..1.26 rows=1 width=4) (never executed)

  • Output: source_link.snapshot_id, source_link.previous_object_id, source_link.next_object_id, source_link.link_type_id
  • Index Cond: ((source_link.next_object_id = source_child.object_id) AND (source_link.snapshot_id = 7))
  • Filter: ((source_link.previous_object_id = 12) AND (source_link.link_type_id = 2))
9. 0.000 0.000 ↓ 0.0 0

Index Scan using dss_metr_typ_pk on b827_diw766_sqlext_central.dss_metric_types dmt (cost=0.00..2.53 rows=1 width=8) (never executed)

  • Output: dmt.metric_id, dmt.metric_name, dmt.metric_description, dmt.metric_type, dmt.metric_group, dmt.metric_depends_on, dmt.metric_options, dmt.scope_id, dmt.property_id
  • Index Cond: (dmt.metric_id = source.metric_id)
  • Filter: ((dmt.metric_group = ANY ('{0,1,4,5,10,13,15,99}'::integer[])) AND ((dmt.metric_group = ANY ('{1,4,5,10,13,15}'::integer[])) OR ((dmt.metric_group = ANY ('{0,99}'::integer[])) AND (source.metric_value_index <> 2) AND (source.metric_id >= 67010))) AND (((dmt.metric_group = ANY ('{1,4,5,10,13,15}'::integer[])) AND (dmt.metric_group = ANY ('{0,1,4,5,10,13,15,99}'::integer[]))) OR ((dmt.metric_group = ANY ('{0,99}'::integer[])) AND (dmt.metric_group = ANY ('{0,1,4,5,10,13,15,99}'::integer[])))))
10.          

CTE target

11. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..4.96 rows=1 width=8) (never executed)

  • Output: target_child.object_id, target_child.object_type_id
12. 0.000 0.000 ↓ 0.0 0

Index Only Scan using dss_linkall_idx on b827_diw766_sqlext_central.dss_link_info target_link (cost=0.00..2.47 rows=1 width=4) (never executed)

  • Output: target_link.snapshot_id, target_link.previous_object_id, target_link.next_object_id, target_link.link_type_id
  • Index Cond: ((target_link.snapshot_id = 7) AND (target_link.previous_object_id = 9) AND (target_link.link_type_id = 2))
  • Heap Fetches: 0
13. 0.000 0.000 ↓ 0.0 0

Index Scan using dss_object_info_idx on b827_diw766_sqlext_central.dss_object_info target_child (cost=0.00..2.47 rows=1 width=8) (never executed)

  • Output: target_child.snapshot_id, target_child.object_id, target_child.object_type_id, target_child.object_checksum
  • Index Cond: ((target_child.object_id = target_link.next_object_id) AND (target_child.snapshot_id = 7))
14. 0.004 4.375 ↓ 0.0 0 1

Nested Loop (cost=0.00..2.54 rows=1 width=630) (actual time=4.375..4.375 rows=0 loops=1)

  • Output: dmr.metric_id, dmr.object_id, dmr.metric_value_index, source.metric_num_value, dmr.metric_char_value, dmr.metric_object_id, dmr.snapshot_id, dmr.position_id, dmr.ctid, source.*, target.*
  • Join Filter: ((source.object_type_id = target.object_type_id) AND (dmr.object_id = target.object_id))
  • Buffers: shared read=1
15. 0.005 4.371 ↓ 0.0 0 1

Nested Loop (cost=0.00..2.51 rows=1 width=602) (actual time=4.371..4.371 rows=0 loops=1)

  • Output: dmr.metric_id, dmr.object_id, dmr.metric_value_index, dmr.metric_char_value, dmr.metric_object_id, dmr.snapshot_id, dmr.position_id, dmr.ctid, source.metric_num_value, source.*, source.object_type_id
  • Join Filter: ((dmr.metric_num_value <> source.metric_num_value) AND (dmr.metric_id = source.metric_id) AND (dmr.metric_value_index = source.metric_value_index))
  • Buffers: shared read=1
16. 4.366 4.366 ↓ 0.0 0 1

Index Scan using dss_metr_res_idx2 on b827_diw766_sqlext_central.dss_metric_results dmr (cost=0.00..2.47 rows=1 width=554) (actual time=4.366..4.366 rows=0 loops=1)

  • Output: dmr.metric_id, dmr.object_id, dmr.metric_value_index, dmr.metric_char_value, dmr.metric_object_id, dmr.snapshot_id, dmr.position_id, dmr.ctid, dmr.metric_num_value
  • Index Cond: (dmr.snapshot_id = 7)
  • Buffers: shared read=1
17. 0.000 0.000 ↓ 0.0 0

CTE Scan on source (cost=0.00..0.02 rows=1 width=64) (never executed)

  • Output: source.metric_num_value, source.*, source.object_type_id, source.metric_id, source.metric_value_index
18. 0.000 0.000 ↓ 0.0 0

CTE Scan on target (cost=0.00..0.02 rows=1 width=40) (never executed)

  • Output: target.*, target.object_type_id, target.object_id