explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jFFh

Settings
# exclusive inclusive rows x rows loops node
1. 939.492 1,371.754 ↓ 0.0 0 1

Insert on delta_romeo (cost=977.550..1,101.770 rows=100,000 width=797) (actual time=1,371.754..1,371.754 rows=0 loops=1)

  • Buffers: shared hit=947226 read=19462 dirtied=2329 written=830, local hit=266
2. 34.171 432.262 ↑ 1.7 60,052 1

Nested Loop (cost=977.550..1,101.770 rows=100,000 width=797) (actual time=18.336..432.262 rows=60,052 loops=1)

  • Output: three_four.golf, three_four.november_foxtrot, three_four.delta_xray, three_four.mike_november, three_four.juliet_golf, three_four.mike_india, three_four.papa_papa, three_four.three_kilo, three_four.juliet_delta, three_four.zulu, three_four.whiskey2, three_four.two, three_four.india, three_four.kilo, three_four.papa_tango, three_four.yankee, three_four.hotel, three_four.oscar, three_four.november_uniform
  • Buffers: shared hit=223135 read=17406 written=745, local hit=266
3. 33.331 37.779 ↓ 300.3 60,052 1

HashAggregate (cost=977.550..979.550 rows=200 width=8) (actual time=18.255..37.779 rows=60,052 loops=1)

  • Output: echo_kilo.golf
  • Buffers: local hit=266
4. 4.448 4.448 ↓ 1.1 60,052 1

Seq Scan on tango (cost=0.000..835.240 rows=56,924 width=8) (actual time=0.005..4.448 rows=60,052 loops=1)

  • Output: echo_kilo.golf
  • Buffers: local hit=266
5. 360.312 360.312 ↑ 1.0 1 60,052

Index Scan using echo_victor on five (cost=0.000..0.600 rows=1 width=797) (actual time=0.006..0.006 rows=1 loops=60,052)

  • Output: three_four.golf, three_four.november_foxtrot, three_four.delta_xray, three_four.mike_november, three_four.juliet_golf, three_four.mike_india, three_four.papa_papa, three_four.three_kilo, three_four.juliet_delta, three_four.zulu, three_four.whiskey2, three_four.two, three_four.india, three_four.kilo, three_four.papa_tango, three_four.yankee, three_four.hotel, three_four.oscar, three_four.november_uniform
  • Index Cond: (three_four.golf = echo_kilo.golf)
  • Buffers: shared hit=223135 read=17406 written=745
Trigger times:
Trigger Name:Total time:Calls:Average time:
RI_ConstraintTrigger_c_1398170 for constraint ins_int_mensaje_hist_ins_int_estado_mensaje_fk 560.523 ms 60052 0.009 ms
RI_ConstraintTrigger_c_1398175 for constraint ins_int_mensaje_hist_ins_int_tipo_mensaje_fk 660.354 ms 60052 0.011 ms
RI_ConstraintTrigger_c_1398180 for constraint ins_int_mensaje_ins_hist_int_codigo_error_fk 96.227 ms 60052 0.002 ms