explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ah6H

Settings
# exclusive inclusive rows x rows loops node
1. 110.270 221.684 ↑ 1.5 35,870 1

Hash Join (cost=7,631.79..19,584.38 rows=55,337 width=622) (actual time=98.843..221.684 rows=35,870 loops=1)

  • Hash Cond: ((t1."ServiceID")::text = (t2."ServiceID")::text)
  • Join Filter: (((t1."ID_Ticket")::text <> (t2."ID_Ticket")::text) AND (t2."Data_Criacao" >= t1."Data_Criacao"))
  • Rows Removed by Join Filter: 137,105
2. 12.698 12.698 ↑ 1.0 101,235 1

Seq Scan on tb_xtts_abertas t1 (cost=0.00..6,366.35 rows=101,235 width=439) (actual time=0.008..12.698 rows=101,235 loops=1)

3. 40.618 98.716 ↑ 1.0 101,235 1

Hash (cost=6,366.35..6,366.35 rows=101,235 width=145) (actual time=98.716..98.716 rows=101,235 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 15,720kB
4. 58.098 58.098 ↑ 1.0 101,235 1

Seq Scan on tb_xtts_abertas t2 (cost=0.00..6,366.35 rows=101,235 width=145) (actual time=0.005..58.098 rows=101,235 loops=1)

Planning time : 0.585 ms
Execution time : 222.925 ms