explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qUZ6

Settings
# exclusive inclusive rows x rows loops node
1. 4.867 93,326.402 ↓ 0.0 0 1

Insert on pg_temp_3.tmp_artifact_status (cost=35.57..35.59 rows=1 width=20) (actual time=93,326.402..93,326.402 rows=0 loops=1)

  • Buffers: shared hit=147709875, local hit=564 read=6 dirtied=4
2. 0.204 93,321.535 ↓ 561.0 561 1

Unique (cost=35.57..35.58 rows=1 width=20) (actual time=93,321.233..93,321.535 rows=561 loops=1)

  • Output: dmr.object_id, dmr.metric_id, dmr.metric_num_value, 2
  • Buffers: shared hit=147709875
3. 3.598 93,321.331 ↓ 926.0 926 1

Sort (cost=35.57..35.58 rows=1 width=20) (actual time=93,321.231..93,321.331 rows=926 loops=1)

  • Output: dmr.object_id, dmr.metric_id, dmr.metric_num_value, 2
  • Sort Key: dmr.object_id, dmr.metric_id, dmr.metric_num_value
  • Sort Method: quicksort Memory: 97kB
  • Buffers: shared hit=147709875
4. 1.973 93,317.733 ↓ 926.0 926 1

Nested Loop Anti Join (cost=5.18..35.56 rows=1 width=20) (actual time=853.014..93,317.733 rows=926 loops=1)

  • Output: dmr.object_id, dmr.metric_id, dmr.metric_num_value, 2
  • Join Filter: (e.object_id = dmr.object_id)
  • Buffers: shared hit=147709875
5. 21.791 93,314.834 ↓ 926.0 926 1

Nested Loop (cost=1.00..22.84 rows=1 width=16) (actual time=853.000..93,314.834 rows=926 loops=1)

  • Output: dmr.object_id, dmr.metric_id, dmr.metric_num_value
  • Join Filter: (l.previous_object_id = t.object_id)
  • Rows Removed by Join Filter: 150225
  • Buffers: shared hit=147709874
6. 977.624 93,110.484 ↓ 1,963.0 1,963 1

Nested Loop (cost=0.72..14.53 rows=1 width=24) (actual time=852.904..93,110.484 rows=1,963 loops=1)

  • Output: dmr.object_id, dmr.metric_id, dmr.metric_num_value, l.snapshot_id, l.previous_object_id
  • Join Filter: (dmr.object_id = l.next_object_id)
  • Rows Removed by Join Filter: 9844557
  • Buffers: shared hit=147474314
7. 23.720 23.720 ↓ 3,980.0 3,980 1

Index Scan using fp_link_nxt_idx on tstmaint_8324_central.fp_link_info l (cost=0.29..8.32 rows=1 width=12) (actual time=0.022..23.720 rows=3,980 loops=1)

  • Output: l.snapshot_id, l.previous_object_id, l.next_object_id, l.link_type_id
  • Index Cond: (l.snapshot_id = 16)
  • Filter: ((l.link_type_id >= 11003) AND (l.link_type_id <= 11007))
  • Rows Removed by Filter: 259
  • Buffers: shared hit=3374
8. 92,109.140 92,109.140 ↓ 2,474.0 2,474 3,980

Index Scan using dss_metr_res_idx2 on tstmaint_8324_central.dss_metric_results dmr (cost=0.43..6.20 rows=1 width=20) (actual time=12.242..23.143 rows=2,474 loops=3,980)

  • Output: dmr.metric_id, dmr.object_id, dmr.metric_value_index, dmr.metric_num_value, dmr.metric_char_value, dmr.metric_object_id, dmr.snapshot_id, dmr.position_id
  • Index Cond: ((dmr.snapshot_id = 16) AND (dmr.metric_value_index = 1))
  • Filter: (dmr.metric_id = ANY ('{10351,10353,10354}'::integer[]))
  • Rows Removed by Filter: 38075
  • Buffers: shared hit=147470940
9. 182.559 182.559 ↓ 77.0 77 1,963

Index Scan using efp_traninf_idx on tstmaint_8324_central.efp_tran_info t (cost=0.28..8.30 rows=1 width=8) (actual time=0.050..0.093 rows=77 loops=1,963)

  • Output: t.snapshot_id, t.previous_snapshot_id, t.object_id, t.object_checksum, t.impact_factor, t.status, t.fp_source, t.prev_object_checksum
  • Index Cond: ((t.snapshot_id = 16) AND (t.previous_snapshot_id = 10))
  • Filter: (t.status IS NOT NULL)
  • Rows Removed by Filter: 166
  • Buffers: shared hit=235560
10. 0.921 0.926 ↓ 0.0 0 926

Materialize (cost=4.18..12.66 rows=4 width=4) (actual time=0.001..0.001 rows=0 loops=926)

  • Output: e.object_id
  • Buffers: shared hit=1
11. 0.002 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on tstmaint_8324_central.efp_tran_exclusion e (cost=4.18..12.64 rows=4 width=4) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: e.object_id
  • Recheck Cond: (e.snapshot_id = 16)
  • Buffers: shared hit=1
12. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on efp_tranex_idx (cost=0.00..4.18 rows=4 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (e.snapshot_id = 16)
  • Buffers: shared hit=1