explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6oP

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 161,100.104 ↓ 0.0 0 1

Delete on endtoend_839_central.dss_metric_results target (cost=1.97..41.15 rows=1 width=30) (actual time=161,100.104..161,100.104 rows=0 loops=1)

  • Buffers: shared hit=21892
2. 0.002 161,100.102 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1.97..41.15 rows=1 width=30) (actual time=161,100.102..161,100.102 rows=0 loops=1)

  • Output: target.ctid, source.ctid, dss_metric_types.ctid, dss_link_info.ctid, dss_link_info_1.ctid
  • Join Filter: (target.object_id = dss_link_info.next_object_id)
  • Buffers: shared hit=21892
3. 53.793 161,100.100 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1.55..34.94 rows=1 width=28) (actual time=161,100.100..161,100.100 rows=0 loops=1)

  • Output: target.ctid, target.object_id, source.ctid, dss_link_info_1.ctid, dss_metric_types.ctid
  • Buffers: shared hit=21892
4. 83,250.191 160,968.197 ↓ 7,811.0 7,811 1

Nested Loop Anti Join (cost=1.27..18.62 rows=1 width=26) (actual time=579.896..160,968.197 rows=7,811 loops=1)

  • Output: target.ctid, target.metric_id, target.object_id, source.ctid, dss_link_info_1.ctid
  • Join Filter: (source.metric_id = target.metric_id)
  • Rows Removed by Join Filter: 74616591
  • Buffers: shared hit=6270
5. 180.278 180.278 ↓ 45,718.0 45,718 1

Index Scan using dss_metr_res_idx2 on endtoend_839_central.dss_metric_results target (cost=0.42..6.19 rows=1 width=14) (actual time=0.016..180.278 rows=45,718 loops=1)

  • Output: target.ctid, target.metric_id, target.object_id
  • Index Cond: (target.snapshot_id = 7)
  • Buffers: shared hit=3133
6. 76,967.400 77,537.728 ↓ 1,633.0 1,633 45,718

Materialize (cost=0.84..12.41 rows=1 width=16) (actual time=0.001..1.696 rows=1,633 loops=45,718)

  • Output: source.ctid, source.metric_id, dss_link_info_1.ctid
  • Buffers: shared hit=3137
7. 326.004 570.328 ↓ 2,651.0 2,651 1

Nested Loop Semi Join (cost=0.84..12.40 rows=1 width=16) (actual time=0.542..570.328 rows=2,651 loops=1)

  • Output: source.ctid, source.metric_id, dss_link_info_1.ctid
  • Join Filter: (source.object_id = dss_link_info_1.next_object_id)
  • Rows Removed by Join Filter: 131356
  • Buffers: shared hit=3137
8. 61.452 61.452 ↓ 45,718.0 45,718 1

Index Scan using dss_metr_res_idx2 on endtoend_839_central.dss_metric_results source (cost=0.42..6.19 rows=1 width=14) (actual time=0.008..61.452 rows=45,718 loops=1)

  • Output: source.ctid, source.object_id, source.metric_id
  • Index Cond: (source.snapshot_id = 7)
  • Buffers: shared hit=3133
9. 182.857 182.872 ↓ 3.0 3 45,718

Materialize (cost=0.42..6.20 rows=1 width=10) (actual time=0.001..0.004 rows=3 loops=45,718)

  • Output: dss_link_info_1.ctid, dss_link_info_1.next_object_id
  • Buffers: shared hit=4
10. 0.015 0.015 ↓ 3.0 3 1

Index Scan using dss_linkall_idx on endtoend_839_central.dss_link_info dss_link_info_1 (cost=0.42..6.19 rows=1 width=10) (actual time=0.011..0.015 rows=3 loops=1)

  • Output: dss_link_info_1.ctid, dss_link_info_1.next_object_id
  • Index Cond: ((dss_link_info_1.snapshot_id = 7) AND (dss_link_info_1.previous_object_id = 12) AND (dss_link_info_1.link_type_id = 2))
  • Buffers: shared hit=4
11. 78.110 78.110 ↓ 0.0 0 7,811

Index Scan using dss_met_typ_idx2 on endtoend_839_central.dss_metric_types (cost=0.28..8.30 rows=1 width=10) (actual time=0.010..0.010 rows=0 loops=7,811)

  • Output: dss_metric_types.ctid, dss_metric_types.metric_id
  • Index Cond: ((dss_metric_types.metric_group = 15) AND (dss_metric_types.metric_id = target.metric_id))
  • Buffers: shared hit=15622
12. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.42..6.20 rows=1 width=10) (never executed)

  • Output: dss_link_info.ctid, dss_link_info.next_object_id
13. 0.000 0.000 ↓ 0.0 0

Index Scan using dss_linkall_idx on endtoend_839_central.dss_link_info (cost=0.42..6.19 rows=1 width=10) (never executed)

  • Output: dss_link_info.ctid, dss_link_info.next_object_id
  • Index Cond: ((dss_link_info.snapshot_id = 7) AND (dss_link_info.previous_object_id = 9) AND (dss_link_info.link_type_id = 2))