explain.depesz.com

A tool for finding a real cause for slow queries.

Result: tpj

options
# exclusive inclusive rows x rows loops node
1. 35.752 84882.499 ↑ 1.8 4795 1
→

Sort (cost=288142.74..288164.45 rows=8681 width=24) (actual time=84866.156..84882.499 rows=4795 loops=1)

  • Sort Key: (sum(logs.nu_acessos))
  • Sort Method: quicksort Memory: 416kB
  • Buffers: shared hit=1141 read=120019, temp read=128 written=128
2. 175.815 84846.747 ↑ 1.8 4795 1
→

GroupAggregate (cost=287346.03..287574.85 rows=8681 width=24) (actual time=84559.309..84846.747 rows=4795 loops=1)

  • Buffers: shared hit=1138 read=120019, temp read=128 written=128
3. 290.118 84670.932 ↓ 2.7 30524 1
→

Sort (cost=287346.03..287374.43 rows=11361 width=24) (actual time=84551.636..84670.932 rows=30524 loops=1)

  • Sort Key: logs.cd_url
  • Sort Method: external merge Disk: 1008kB
  • Buffers: shared hit=1138 read=120019, temp read=128 written=128
4. 39882.317 84380.814 ↓ 2.7 30524 1
→

Hash Join (cost=47.74..286580.76 rows=11361 width=24) (actual time=50.033..84380.814 rows=30524 loops=1)

  • Hash Cond: (logs.cd_usuario = usrs.cd_usuario)
  • Buffers: shared hit=1134 read=120019
5. 44497.239 44497.239 ↑ 1.1 11290509 1
→

Seq Scan on "TFW001_LOG" logs (cost=0.00..241337.21 rows=12021921 width=28) (actual time=0.034..44497.239 rows=11290509 loops=1)

  • Buffers: shared hit=1099 read=120019
6. 0.190 1.258 ↓ 1.3 21 1
→

Hash (cost=47.54..47.54 rows=16 width=4) (actual time=1.258..1.258 rows=21 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=35
7. 0.417 1.068 ↓ 1.3 21 1
→

Bitmap Heap Scan on "TFW002_USUARIO" usrs (cost=22.67..47.54 rows=16 width=4) (actual time=0.687..1.068 rows=21 loops=1)

  • Recheck Cond: (((lg_usuario)::text = 'arthur'::text) OR ((lg_usuario)::text = 'bfaria'::text) OR ((lg_usuario)::text = 'eliandro'::text) OR ((lg_usuario)::text = 'emersonb'::text) OR ((lg_usuario)::text = 'jackson'::text) OR ((lg_usuario)::text = 'guille'::text) OR ((lg_usuario)::text = 'marceloh'::text) OR ((lg_usuario)::text = 'pedrozo'::text) OR ((lg_usuario)::text = 'tomasv'::text) OR ((lg_usuario)::text = 'thiel'::text))
  • Buffers: shared hit=35
8. 0.080 0.651 ↓ 0.0 0 1
→

BitmapOr (cost=22.67..22.67 rows=16 width=0) (actual time=0.651..0.651 rows=0 loops=1)

  • Buffers: shared hit=21
9. 0.080 0.080 ↑ 1.0 1 1
→

Bitmap Index Scan on usuario_lg_usuario (cost=0.00..2.26 rows=1 width=0) (actual time=0.080..0.080 rows=1 loops=1)

  • Index Cond: ((lg_usuario)::text = 'arthur'::text)
  • Buffers: shared hit=3
10. 0.075 0.075 ↑ 1.0 3 1
→

Bitmap Index Scan on usuario_lg_usuario (cost=0.00..2.27 rows=3 width=0) (actual time=0.075..0.075 rows=3 loops=1)

  • Index Cond: ((lg_usuario)::text = 'bfaria'::text)
  • Buffers: shared hit=2
11. 0.064 0.064 ↓ 2.0 2 1
→

Bitmap Index Scan on usuario_lg_usuario (cost=0.00..2.26 rows=1 width=0) (actual time=0.064..0.064 rows=2 loops=1)

  • Index Cond: ((lg_usuario)::text = 'eliandro'::text)
  • Buffers: shared hit=2
12. 0.030 0.030 ↓ 3.0 3 1
→

Bitmap Index Scan on usuario_lg_usuario (cost=0.00..2.26 rows=1 width=0) (actual time=0.030..0.030 rows=3 loops=1)

  • Index Cond: ((lg_usuario)::text = 'emersonb'::text)
  • Buffers: shared hit=2
13. 0.074 0.074 ↑ 1.0 1 1
→

Bitmap Index Scan on usuario_lg_usuario (cost=0.00..2.26 rows=1 width=0) (actual time=0.074..0.074 rows=1 loops=1)

  • Index Cond: ((lg_usuario)::text = 'jackson'::text)
  • Buffers: shared hit=2
14. 0.048 0.048 ↓ 2.0 2 1
→

Bitmap Index Scan on usuario_lg_usuario (cost=0.00..2.26 rows=1 width=0) (actual time=0.048..0.048 rows=2 loops=1)

  • Index Cond: ((lg_usuario)::text = 'guille'::text)
  • Buffers: shared hit=2
15. 0.044 0.044 ↑ 1.0 5 1
→

Bitmap Index Scan on usuario_lg_usuario (cost=0.00..2.29 rows=5 width=0) (actual time=0.044..0.044 rows=5 loops=1)

  • Index Cond: ((lg_usuario)::text = 'marceloh'::text)
  • Buffers: shared hit=2
16. 0.063 0.063 ↓ 2.0 2 1
→

Bitmap Index Scan on usuario_lg_usuario (cost=0.00..2.26 rows=1 width=0) (actual time=0.063..0.063 rows=2 loops=1)

  • Index Cond: ((lg_usuario)::text = 'pedrozo'::text)
  • Buffers: shared hit=2
17. 0.069 0.069 ↑ 1.0 1 1
→

Bitmap Index Scan on usuario_lg_usuario (cost=0.00..2.26 rows=1 width=0) (actual time=0.069..0.069 rows=1 loops=1)

  • Index Cond: ((lg_usuario)::text = 'tomasv'::text)
  • Buffers: shared hit=2
18. 0.024 0.024 ↑ 1.0 1 1
→

Bitmap Index Scan on usuario_lg_usuario (cost=0.00..2.26 rows=1 width=0) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((lg_usuario)::text = 'thiel'::text)
  • Buffers: shared hit=2