explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5JuI

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

Limit (cost=754,862.92..754,863.10 rows=10 width=28) (actual time=2,797.937..2,797.943 rows=10 loops=1)

2. 720.301 2,797.940 ↑ 11,352.6 10 1

HashAggregate (cost=754,862.92..756,849.63 rows=113,526 width=28) (actual time=2,797.936..2,797.940 rows=10 loops=1)

3. 448.666 2,077.639 ↓ 11.1 1,262,420 1

Nested Loop (cost=206,820.03..753,727.66 rows=113,526 width=28) (actual time=199.249..2,077.639 rows=1,262,420 loops=1)

4. 218.423 495.148 ↓ 11.2 226,765 1

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

  • Hash Cond: (p.devcod = dev.devcod)
5. 88.376 111.057 ↑ 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=33.469..111.057 rows=226,765 loops=1)

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

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

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

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

8. 108.392 132.084 ↑ 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.425..132.084 rows=226,765 loops=1)

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

Bitmap Index Scan on idevedor3 (cost=0.00..4,939.24 rows=229,148 width=0) (actual time=23.692..23.692 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.002..0.005 rows=6 loops=226,765)

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