explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9CWd

Settings
# exclusive inclusive rows x rows loops node
1. 139.388 1,311.002 ↓ 1.1 703,831 1

Unique (cost=172,911.67..176,880.26 rows=648,621 width=12) (actual time=942.607..1,311.002 rows=703,831 loops=1)

2. 697.179 1,171.614 ↑ 1.0 793,506 1

Sort (cost=172,911.67..174,895.96 rows=793,718 width=12) (actual time=942.603..1,171.614 rows=793,506 loops=1)

  • Sort Key: cod_ger_emails_enviados, ema_con_quantidade DESC, ema_con_codigo
  • Sort Method: external merge Disk: 16984kB
3. 474.435 474.435 ↑ 1.0 793,506 1

Seq Scan on ger_emails_consulta c (cost=0.00..81,568.18 rows=793,718 width=12) (actual time=0.034..474.435 rows=793,506 loops=1)

Planning time : 0.115 ms
Execution time : 1,371.725 ms