explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eKcW

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2,208.262 ↓ 0.0 0 1

Unique (cost=9,842,614.19..10,228,893.00 rows=770,142 width=111) (actual time=2,208.262..2,208.262 rows=0 loops=1)

  • Output: 'TAKSY'::text, fin.inst_partno, fin.harness, (concat(fin.fin_sequence_number, fin.fin_circuit, fin.fin_suffix, fin.fin_appendent, fin.fin_supplementary)), fin.partno, val.msn, val.msn
  • Buffers: shared hit=3 read=22262
2. 0.043 2,208.261 ↓ 0.0 0 1

Sort (cost=9,842,614.19..9,919,869.95 rows=30,902,305 width=111) (actual time=2,208.261..2,208.261 rows=0 loops=1)

  • Output: 'TAKSY'::text, fin.inst_partno, fin.harness, (concat(fin.fin_sequence_number, fin.fin_circuit, fin.fin_suffix, fin.fin_appendent, fin.fin_supplementary)), fin.partno, val.msn, val.msn
  • Sort Key: fin.inst_partno, fin.harness, (concat(fin.fin_sequence_number, fin.fin_circuit, fin.fin_suffix, fin.fin_appendent, fin.fin_supplementary)), fin.partno
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3 read=22262
3. 0.747 2,208.218 ↓ 0.0 0 1

Hash Join (cost=26,187.43..611,396.82 rows=30,902,305 width=111) (actual time=2,208.218..2,208.218 rows=0 loops=1)

  • Output: 'TAKSY'::text, fin.inst_partno, fin.harness, concat(fin.fin_sequence_number, fin.fin_circuit, fin.fin_suffix, fin.fin_appendent, fin.fin_supplementary), fin.partno, val.msn, val.msn
  • Hash Cond: ((fin.harness)::text = (tbl.harness)::text)
  • Buffers: shared read=22262
4. 0.000 1,494.769 ↑ 8,309.0 1 1

Gather (cost=1,000.00..75,337.59 rows=8,309 width=50) (actual time=1,494.676..1,494.769 rows=1 loops=1)

  • Output: fin.inst_partno, fin.harness, fin.fin_sequence_number, fin.fin_circuit, fin.fin_suffix, fin.fin_appendent, fin.fin_supplementary, fin.partno
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared read=48554
5. 1,545.049 1,545.049 ↑ 3,462.0 1 3

Parallel Seq Scan on import.taksy_tc31e_a320_ad fin (cost=0.00..73,506.69 rows=3,462 width=50) (actual time=1,542.536..1,545.049 rows=1 loops=3)

  • Output: fin.inst_partno, fin.harness, fin.fin_sequence_number, fin.fin_circuit, fin.fin_suffix, fin.fin_appendent, fin.fin_supplementary, fin.partno
  • Filter: (((fin.inst_partno)::text ~~ 'D929%'::text) AND ((fin.action)::text <> 'TO_BE_DELETED'::text) AND (btrim(concat(fin.fin_sequence_number, fin.fin_circuit, fin.fin_suffix, fin.fin_appendent, fin.fin_supplementary)) = '7113VCA'::text))
  • Rows Removed by Filter: 177435
  • Buffers: shared read=48554
  • Worker 0: actual time=1573.134..1573.134 rows=0 loops=1
  • Buffers: shared read=16973
  • Worker 1: actual time=1560.105..1567.644 rows=1 loops=1
  • Buffers: shared read=15997
6. 0.000 712.702 ↓ 0.0 0 1

Hash (cost=23,813.92..23,813.92 rows=79,001 width=11) (actual time=712.702..712.702 rows=0 loops=1)

  • Output: tbl.harness, val.msn
  • Buckets: 131072 Batches: 2 Memory Usage: 1028kB
  • Buffers: shared read=6678
7. 39.209 716.836 ↓ 0.0 0 1

Gather (cost=1,000.43..23,813.92 rows=79,001 width=11) (actual time=712.701..716.836 rows=0 loops=1)

  • Output: tbl.harness, val.msn
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared read=6678
8. 0.008 677.627 ↓ 0.0 0 3

Nested Loop (cost=0.43..14,913.82 rows=32,917 width=11) (actual time=677.626..677.627 rows=0 loops=3)

  • Output: tbl.harness, val.msn
  • Buffers: shared read=6678
  • Worker 0: actual time=658.389..658.390 rows=0 loops=1
  • Buffers: shared read=2071
  • Worker 1: actual time=662.435..662.435 rows=0 loops=1
  • Buffers: shared read=2015
9. 677.619 677.619 ↓ 0.0 0 3

Parallel Seq Scan on api.view_import_taksy_tc39s_929_a320_ad val (cost=0.00..8,393.17 rows=40 width=22) (actual time=677.619..677.619 rows=0 loops=3)

  • Output: val.action, val."createdAt", val."updatedAt", val."seenAt", val.project, val.partnumber, val.identnumber, val.msn, val.adaptedsolution, val.quantity, val.topnode, val.identnumber_tl, val.next_assy, val.identnumber_next_assy, val.identnumber_na_pk, val.current_release_state, val.ac_alloc_state, val.update_ts
  • Filter: (((val.partnumber)::text ~~ 'D929%'::text) AND (val.msn = 8156))
  • Rows Removed by Filter: 91476
  • Buffers: shared read=6678
  • Worker 0: actual time=658.379..658.379 rows=0 loops=1
  • Buffers: shared read=2071
  • Worker 1: actual time=662.424..662.424 rows=0 loops=1
  • Buffers: shared read=2015
10. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_taksy_tc21e_a320_ad_doc_no on import.taksy_tc21e_a320_ad tbl (cost=0.43..154.54 rows=848 width=25) (never executed)

  • Output: tbl.action, tbl."createdAt", tbl."updatedAt", tbl."seenAt", tbl.project, tbl.document_number, tbl.release_status, tbl.issue, tbl.harness, tbl.wire_type, tbl.item, tbl.wire_type_ident_number, tbl.wire_type_part_number, tbl.conn_means_sleeve, tbl.wire_type_total_length, tbl.wire_ata, tbl.wire_subata, tbl.wire_separator, tbl.wire_number, tbl.wire_vu, tbl.wire_color, tbl.wire_phase, tbl.wire_length, tbl.wire_twist, tbl.route, tbl.from_fin_sequence_number, tbl.from_fin_circuit, tbl.from_fin_suffix, tbl.from_fin_appendent, tbl.from_fin_supplementary, tbl.from_pin, tbl.from_shunt, tbl.from_shielding, tbl.from_skydrol_sleeve, tbl.to_fin_sequence_number, tbl.to_fin_circuit, tbl.to_fin_suffix, tbl.to_fin_appendent, tbl.to_fin_supplementary, tbl.to_pin, tbl.to_shunt, tbl.to_shielding, tbl.to_skydrol_sleeve, tbl.from_fin_quad_cable_direction, tbl.to_fin_quad_cable_direction, tbl.seal_1, tbl.seal_2, tbl.seal_3, tbl.seal_4, tbl.seal_5, tbl.t_1, tbl.t_2, tbl.t_3, tbl.t_4, tbl.t_5, tbl.conn_means_special_sleeve, tbl.conn_means_circuit, tbl.conn_means_ce_1_from_eq, tbl.conn_means_ce_2_from_eq, tbl.conn_means_ce_1_to_eq, tbl.conn_means_ce_2_to_eq, tbl.taksy_change_date, tbl.sensitive_wire, tbl.short_wire, tbl.kz_huelse_1, tbl.kz_huelse_star, tbl.wirematic_routing, tbl.flighttest_manufacturing, tbl.kz_huelse_2, tbl.not_used, tbl.ata_ref_shield
  • Index Cond: ((tbl.document_number)::text = (val.partnumber)::text)
  • Filter: ((tbl.action)::text <> 'TO_BE_DELETED'::text)
Planning time : 168.896 ms