explain.depesz.com

PostgreSQL's explain analyze made readable

Result: irt1

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 14,753.865 ↑ 1.0 10 1

Limit (cost=1,524,903.52..1,524,903.72 rows=10 width=48) (actual time=14,753.843..14,753.865 rows=10 loops=1)

2. 545.272 14,753.863 ↑ 4,000.0 10 1

HashAggregate (cost=1,524,903.52..1,525,703.52 rows=40,000 width=48) (actual time=14,753.841..14,753.863 rows=10 loops=1)

  • Filter: (count(*) > 1)
3. 2,284.880 14,208.591 ↑ 1.1 1,262,420 1

Sort (cost=1,491,368.97..1,494,722.42 rows=1,341,382 width=28) (actual time=13,861.406..14,208.591 rows=1,262,420 loops=1)

  • Sort Key: p.pescod
  • Sort Method: external merge Disk: 59240kB
4. 9,103.423 11,923.711 ↑ 1.1 1,262,420 1

Hash Join (cost=214,646.58..1,354,847.88 rows=1,341,382 width=28) (actual time=144.119..11,923.711 rows=1,262,420 loops=1)

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

Seq Scan on telefone t (cost=0.00..827,927.48 rows=26,267,248 width=28) (actual time=0.004..2,684.683 rows=26,259,946 loops=1)

6. 31.896 135.605 ↑ 1.1 226,765 1

Hash (cost=211,664.31..211,664.31 rows=238,582 width=8) (actual time=135.605..135.605 rows=226,765 loops=1)

7. 83.017 103.709 ↑ 1.1 226,765 1

Bitmap Heap Scan on pessoa p (cost=5,626.00..211,664.31 rows=238,582 width=8) (actual time=30.891..103.709 rows=226,765 loops=1)

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

Bitmap Index Scan on pessoa_iu0006 (cost=0.00..5,566.35 rows=238,582 width=0) (actual time=20.692..20.692 rows=243,449 loops=1)

  • Index Cond: (carcod = 37)
Total runtime : 14,772.848 ms