explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8jd1

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 36,328.716 ↑ 1.0 2 1

Limit (cost=733,821.84..733,821.89 rows=2 width=28) (actual time=36,328.713..36,328.716 rows=2 loops=1)

2. 1,130.008 36,328.714 ↑ 51,122.0 2 1

HashAggregate (cost=733,821.84..736,122.33 rows=102,244 width=28) (actual time=36,328.712..36,328.714 rows=2 loops=1)

  • Filter: (count(*) > 1)
3. 528.414 35,198.706 ↓ 12.3 1,262,427 1

Nested Loop (cost=206,003.32..732,543.79 rows=102,244 width=28) (actual time=210.552..35,198.706 rows=1,262,427 loops=1)

4. 254.444 7,912.022 ↓ 12.5 226,765 1

Hash Join (cost=206,003.32..413,006.04 rows=18,097 width=16) (actual time=210.536..7,912.022 rows=226,765 loops=1)

  • Hash Cond: (p.devcod = dev.devcod)
5. 7,459.262 7,486.023 ↓ 1.1 226,765 1

Bitmap Heap Scan on pessoa p (cost=5,081.54..209,498.63 rows=213,748 width=20) (actual time=38.885..7,486.023 rows=226,765 loops=1)

  • Recheck Cond: (carcod = 37)
6. 26.761 26.761 ↓ 1.1 244,650 1

Bitmap Index Scan on pessoa_iu0006 (cost=0.00..5,028.10 rows=213,748 width=0) (actual time=26.761..26.761 rows=244,650 loops=1)

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

Hash (cost=198,055.33..198,055.33 rows=229,316 width=12) (actual time=171.555..171.555 rows=226,765 loops=1)

8. 111.439 136.543 ↑ 1.0 226,765 1

Bitmap Heap Scan on devedor dev (cost=4,717.80..198,055.33 rows=229,316 width=12) (actual time=39.956..136.543 rows=226,765 loops=1)

  • Recheck Cond: (carcod = 37)
9. 25.104 25.104 ↑ 1.0 226,840 1

Bitmap Index Scan on idevedor3 (cost=0.00..4,660.47 rows=229,316 width=0) (actual time=25.104..25.104 rows=226,840 loops=1)

  • Index Cond: (carcod = 37)
10. 26,758.270 26,758.270 ↑ 22.8 6 226,765

Index Scan using telefone_iu_002 on telefone t (cost=0.00..15.93 rows=137 width=28) (actual time=0.040..0.118 rows=6 loops=226,765)

  • Index Cond: (t.pescod = p.pescod)
Total runtime : 36,329.243 ms