explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kC4y

Settings
# exclusive inclusive rows x rows loops node
1. 4,824.284 7,273.203 ↓ 0.0 0 1

Insert on delta_romeo (cost=2,730.530..2,819.140 rows=124,154 width=706) (actual time=7,273.203..7,273.203 rows=0 loops=1)

  • Buffers: shared hit=3365425 read=187184 dirtied=67725 written=56942, local hit=743
2. 145.191 2,448.919 ↓ 1.4 167,816 1

Nested Loop (cost=2,730.530..2,819.140 rows=124,154 width=706) (actual time=57.595..2,448.919 rows=167,816 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_papa, 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=548290 read=123887 written=30469, local hit=743
3. 109.151 122.120 ↓ 839.1 167,816 1

HashAggregate (cost=2,730.530..2,732.530 rows=200 width=8) (actual time=57.508..122.120 rows=167,816 loops=1)

  • Output: echo_kilo.golf
  • Buffers: local hit=743
4. 12.969 12.969 ↓ 1.1 167,816 1

Seq Scan on zulu_charlie (cost=0.000..2,333.020 rows=159,002 width=8) (actual time=0.005..12.969 rows=167,816 loops=1)

  • Output: echo_kilo.golf
  • Buffers: local hit=743
5. 2,181.608 2,181.608 ↑ 1.0 1 167,816

Index Scan using echo_victor on five (cost=0.000..0.420 rows=1 width=706) (actual time=0.013..0.013 rows=1 loops=167,816)

  • 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_papa, 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=548290 read=123887 written=30469
Trigger times:
Trigger Name:Total time:Calls:Average time:
RI_ConstraintTrigger_c_1285123 for constraint ins_int_mensaje_ins_hist_int_codigo_error_fk 298.945 ms 167816 0.002 ms
RI_ConstraintTrigger_c_1285128 for constraint ins_int_mensaje_hist_ins_int_estado_mensaje_fk 1,539.742 ms 167816 0.009 ms
RI_ConstraintTrigger_c_1285133 for constraint ins_int_mensaje_hist_ins_int_tipo_mensaje_fk 1,821.469 ms 167816 0.011 ms