explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DqM1

Settings
# exclusive inclusive rows x rows loops node
1. 818.096 1,222.854 ↓ 0.0 0 1

Delete on five (cost=977.550..1,101.770 rows=100,000 width=12) (actual time=1,222.854..1,222.854 rows=0 loops=1)

  • Buffers: shared hit=350609 read=10035 dirtied=11987 written=6799, local hit=266
2. 5.191 404.758 ↑ 1.7 60,052 1

Nested Loop (cost=977.550..1,101.770 rows=100,000 width=12) (actual time=21.253..404.758 rows=60,052 loops=1)

  • Output: three.foxtrot, echo_kilo.foxtrot
  • Buffers: shared hit=230505 read=10035 written=6799, local hit=266
3. 32.112 39.255 ↓ 300.3 60,052 1

HashAggregate (cost=977.550..979.550 rows=200 width=14) (actual time=21.193..39.255 rows=60,052 loops=1)

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

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

  • Output: echo_kilo.foxtrot, 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=14) (actual time=0.006..0.006 rows=1 loops=60,052)

  • Output: three.foxtrot, three.golf
  • Index Cond: (three.golf = echo_kilo.golf)
  • Buffers: shared hit=230505 read=10035 written=6799
Trigger times:
Trigger Name:Total time:Calls:Average time:
RI_ConstraintTrigger_a_1398371 for constraint ins_int_enviado_mensaje_suscriptor_ins_int_mensaje_fk 1,484.751 ms 60052 0.025 ms