explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pPTi

Settings
# exclusive inclusive rows x rows loops node
1. 134.036 5,100.625 ↑ 1.1 703,831 1

Unique (cost=427,628.07..431,596.66 rows=793,718 width=12) (actual time=4,813.488..5,100.625 rows=703,831 loops=1)

2. 935.374 4,966.589 ↑ 1.1 703,831 1

Sort (cost=427,628.07..429,612.37 rows=793,718 width=12) (actual time=4,813.486..4,966.589 rows=703,831 loops=1)

  • Sort Key: (max(ger_emails_consulta_1.ema_con_codigo))
  • Sort Method: external sort Disk: 15144kB
3. 305.851 4,031.215 ↑ 1.1 703,831 1

GroupAggregate (cost=320,410.23..336,284.59 rows=793,718 width=12) (actual time=3,296.470..4,031.215 rows=703,831 loops=1)

  • Group Key: ger_emails_consulta_1.cod_ger_emails_enviados, arq_rem_consumidores_1.cod_arq_rem_arquivo
4. 899.818 3,725.364 ↑ 1.0 793,506 1

Sort (cost=320,410.23..322,394.52 rows=793,718 width=12) (actual time=3,296.461..3,725.364 rows=793,506 loops=1)

  • Sort Key: ger_emails_consulta_1.cod_ger_emails_enviados, arq_rem_consumidores_1.cod_arq_rem_arquivo
  • Sort Method: external merge Disk: 16968kB
5. 746.570 2,825.546 ↑ 1.0 793,506 1

Hash Join (cost=127,632.94..229,066.74 rows=793,718 width=12) (actual time=1,604.709..2,825.546 rows=793,506 loops=1)

  • Hash Cond: (ger_emails_consulta_1.cod_ger_emails_enviados = ger_emails_enviados_1.ema_env_codigo)
6. 474.919 474.919 ↑ 1.0 793,506 1

Seq Scan on ger_emails_consulta ger_emails_consulta_1 (cost=0.00..81,568.18 rows=793,718 width=8) (actual time=0.067..474.919 rows=793,506 loops=1)

7. 171.722 1,604.057 ↓ 1.0 703,903 1

Hash (cost=116,084.18..116,084.18 rows=703,901 width=8) (actual time=1,604.057..1,604.057 rows=703,903 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 2747kB
8. 651.583 1,432.335 ↓ 1.0 703,903 1

Hash Join (cost=50,548.53..116,084.18 rows=703,901 width=8) (actual time=480.896..1,432.335 rows=703,903 loops=1)

  • Hash Cond: (ger_emails_enviados_1.cod_arq_rem_consumidores = arq_rem_consumidores_1.rem_com_codigo)
9. 300.307 300.307 ↓ 1.0 703,903 1

Seq Scan on ger_emails_enviados ger_emails_enviados_1 (cost=0.00..47,610.01 rows=703,901 width=8) (actual time=0.016..300.307 rows=703,903 loops=1)

10. 186.239 480.445 ↑ 1.0 703,176 1

Hash (cost=39,011.79..39,011.79 rows=703,179 width=8) (actual time=480.445..480.445 rows=703,176 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 2745kB
11. 294.206 294.206 ↑ 1.0 703,176 1

Seq Scan on arq_rem_consumidores arq_rem_consumidores_1 (cost=0.00..39,011.79 rows=703,179 width=8) (actual time=0.019..294.206 rows=703,176 loops=1)

Planning time : 0.932 ms
Execution time : 5,173.019 ms