explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QSoH

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 2,722.894 ↑ 1.0 10 1

Limit (cost=755,146.26..755,146.48 rows=10 width=28) (actual time=2,722.875..2,722.894 rows=10 loops=1)

2. 629.127 2,722.891 ↑ 11,349.4 10 1

HashAggregate (cost=755,146.26..757,699.87 rows=113,494 width=28) (actual time=2,722.874..2,722.891 rows=10 loops=1)

  • Filter: (count(*) > 1)
3. 462.510 2,093.764 ↓ 11.1 1,262,420 1

Nested Loop (cost=206,820.03..753,727.58 rows=113,494 width=28) (actual time=199.428..2,093.764 rows=1,262,420 loops=1)

4. 219.216 497.429 ↓ 11.2 226,765 1

Hash Join (cost=206,820.03..415,744.30 rows=20,192 width=16) (actual time=199.407..497.429 rows=226,765 loops=1)

  • Hash Cond: (p.devcod = dev.devcod)
5. 89.577 111.152 ↑ 1.1 226,765 1

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

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

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

  • Index Cond: (carcod = 37)
7. 34.145 167.061 ↑ 1.0 226,765 1

Hash (cost=198,329.68..198,329.68 rows=229,148 width=12) (actual time=167.061..167.061 rows=226,765 loops=1)

8. 109.310 132.916 ↑ 1.0 226,765 1

Bitmap Heap Scan on devedor dev (cost=4,996.53..198,329.68 rows=229,148 width=12) (actual time=37.254..132.916 rows=226,765 loops=1)

  • Recheck Cond: (carcod = 37)
9. 23.606 23.606 ↑ 1.0 227,311 1

Bitmap Index Scan on idevedor3 (cost=0.00..4,939.24 rows=229,148 width=0) (actual time=23.606..23.606 rows=227,311 loops=1)

  • Index Cond: (carcod = 37)
10. 1,133.825 1,133.825 ↑ 22.3 6 226,765

Index Scan using telefone_iu_002 on telefone t (cost=0.00..15.05 rows=134 width=28) (actual time=0.003..0.005 rows=6 loops=226,765)

  • Index Cond: (t.pescod = p.pescod)
Total runtime : 2,723.063 ms