explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u2u

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 20,305.519 ↑ 1.0 2 1

Limit (cost=1,481,805.47..1,481,805.55 rows=2 width=36) (actual time=20,305.482..20,305.519 rows=2 loops=1)

2. 0.034 20,305.518 ↑ 642,694.0 2 1

GroupAggregate (cost=1,481,805.47..1,533,220.99 rows=1,285,388 width=36) (actual time=20,305.482..20,305.518 rows=2 loops=1)

  • Filter: (count(*) > 1)
3. 7,017.767 20,305.484 ↑ 22,953.4 56 1

Sort (cost=1,481,805.47..1,485,018.94 rows=1,285,388 width=36) (actual time=20,305.463..20,305.484 rows=56 loops=1)

  • Sort Key: (((t.teldddtel)::text || (t.teltel)::text)), p.pescod, p.devcod
  • Sort Method: external merge Disk: 83712kB
4. 10,290.737 13,287.717 ↑ 1.0 1,262,420 1

Hash Join (cost=213,751.92..1,351,378.61 rows=1,285,388 width=36) (actual time=152.774..13,287.717 rows=1,262,420 loops=1)

  • Hash Cond: (t.pescod = p.pescod)
5. 2,844.286 2,844.286 ↓ 1.0 26,259,946 1

Seq Scan on telefone t (cost=0.00..827,045.28 rows=26,179,028 width=28) (actual time=0.005..2,844.286 rows=26,259,946 loops=1)

6. 37.503 152.694 ↑ 1.0 226,765 1

Hash (cost=210,904.88..210,904.88 rows=227,763 width=16) (actual time=152.694..152.694 rows=226,765 loops=1)

7. 91.937 115.191 ↑ 1.0 226,765 1

Bitmap Heap Scan on pessoa p (cost=5,398.15..210,904.88 rows=227,763 width=16) (actual time=34.531..115.191 rows=226,765 loops=1)

  • Recheck Cond: (carcod = 37)
8. 23.254 23.254 ↓ 1.1 243,449 1

Bitmap Index Scan on pessoa_iu0006 (cost=0.00..5,341.21 rows=227,763 width=0) (actual time=23.254..23.254 rows=243,449 loops=1)

  • Index Cond: (carcod = 37)
Total runtime : 20,323.673 ms