explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xP0B

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 3,034.245 ↑ 1.0 2 1

Limit (cost=733,888.85..733,888.89 rows=2 width=28) (actual time=3,034.243..3,034.245 rows=2 loops=1)

2. 838.748 3,034.244 ↑ 51,122.0 2 1

HashAggregate (cost=733,888.85..736,189.34 rows=102,244 width=28) (actual time=3,034.242..3,034.244 rows=2 loops=1)

  • Filter: (count(*) <> 1)
3. 291.813 2,195.496 ↓ 12.3 1,262,427 1

Nested Loop (cost=206,019.32..732,610.80 rows=102,244 width=28) (actual time=212.846..2,195.496 rows=1,262,427 loops=1)

4. 242.329 543.093 ↓ 12.5 226,765 1

Hash Join (cost=206,019.32..413,022.05 rows=18,097 width=16) (actual time=212.831..543.093 rows=226,765 loops=1)

  • Hash Cond: (p.devcod = dev.devcod)
5. 99.040 123.024 ↓ 1.1 226,765 1

Bitmap Heap Scan on pessoa p (cost=5,085.54..209,502.63 rows=213,748 width=20) (actual time=34.971..123.024 rows=226,765 loops=1)

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

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

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

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

8. 116.200 140.697 ↑ 1.0 226,765 1

Bitmap Heap Scan on devedor dev (cost=4,729.80..198,067.33 rows=229,316 width=12) (actual time=38.807..140.697 rows=226,765 loops=1)

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

Bitmap Index Scan on idevedor3 (cost=0.00..4,672.47 rows=229,316 width=0) (actual time=24.497..24.497 rows=226,848 loops=1)

  • Index Cond: (carcod = 37)
10. 1,360.590 1,360.590 ↑ 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.003..0.006 rows=6 loops=226,765)

  • Index Cond: (t.pescod = p.pescod)
Total runtime : 3,034.715 ms