explain.depesz.com

A tool for finding a real cause for slow queries.

Result: xaHJ

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 31.187 2,092.669 ↑ 1.0 1 1

Aggregate (cost=89,582.94..89,582.95 rows=1 width=0) (actual time=2,092.669..2,092.669 rows=1 loops=1)

  • Buffers: shared hit=201 read=27306, temp read=7667 written=7577
2. 86.240 2,061.482 ↓ 1.0 275,428 1

Hash Join (cost=63,587.50..88,920.86 rows=264,833 width=0) (actual time=1,469.199..2,061.482 rows=275,428 loops=1)

  • Hash Cond: (cp.contestid = c.id)
  • Buffers: shared hit=201 read=27306, temp read=7667 written=7577
3. 337.563 1,974.463 ↓ 1.0 275,428 1

Hash Right Join (cost=63,501.13..85,193.04 rows=264,833 width=8) (actual time=1,468.402..1,974.463 rows=275,428 loops=1)

  • Hash Cond: (tm.contestparticipantid = cp.id)
  • Buffers: shared hit=139 read=27306, temp read=7667 written=7577
4. 168.712 168.712 ↑ 1.0 479,481 1

Seq Scan on teammember tm (cost=0.00..10,428.81 rows=479,481 width=8) (actual time=0.056..168.712 rows=479,481 loops=1)

  • Buffers: shared hit=34 read=5600
5. 67.111 1,468.188 ↓ 1.0 267,278 1

Hash (cost=58,896.72..58,896.72 rows=264,833 width=16) (actual time=1,468.188..1,468.188 rows=267,278 loops=1)

  • Buckets: 4096 Batches: 16 Memory Usage: 796kB
  • Buffers: shared hit=105 read=21706, temp read=4984 written=6018
6. 107.168 1,401.077 ↓ 1.0 267,278 1

Hash Right Join (cost=56,818.86..58,896.72 rows=264,833 width=16) (actual time=1,282.725..1,401.077 rows=267,278 loops=1)

  • Hash Cond: (sm.contestparticipantid = cp.id)
  • Buffers: shared hit=105 read=21706, temp read=4984 written=4924
7. 11.419 11.419 ↑ 1.0 16,742 1

Seq Scan on staffmember sm (cost=0.00..476.42 rows=16,742 width=8) (actual time=0.047..11.419 rows=16,742 loops=1)

  • Buffers: shared hit=34 read=275
8. 83.284 1,282.490 ↓ 1.0 267,258 1

Hash (cost=52,214.45..52,214.45 rows=264,833 width=16) (actual time=1,282.490..1,282.490 rows=267,258 loops=1)

  • Buckets: 4096 Batches: 16 Memory Usage: 796kB
  • Buffers: shared hit=71 read=21431, temp read=3786 written=4849
9. 441.616 1,199.206 ↓ 1.0 267,258 1

Hash Join (cost=28,690.03..52,214.45 rows=264,833 width=16) (actual time=606.796..1,199.206 rows=267,258 loops=1)

  • Hash Cond: (cp.personinfoid = pi.id)
  • Buffers: shared hit=71 read=21431, temp read=3786 written=3756
10. 151.736 151.736 ↑ 1.0 483,376 1

Seq Scan on contestparticipant cp (cost=0.00..9,575.76 rows=483,376 width=32) (actual time=0.015..151.736 rows=483,376 loops=1)

  • Buffers: shared hit=37 read=4705
11. 100.682 605.854 ↓ 1.0 278,282 1

Hash (cost=24,219.33..24,219.33 rows=272,456 width=8) (actual time=605.854..605.854 rows=278,282 loops=1)

  • Buckets: 4096 Batches: 16 Memory Usage: 689kB
  • Buffers: shared hit=34 read=16726, temp written=883
12. 505.172 505.172 ↓ 1.0 278,282 1

Seq Scan on personinfo pi (cost=0.00..24,219.33 rows=272,456 width=8) (actual time=0.010..505.172 rows=278,282 loops=1)

  • Filter: (((lastname)::text ~~ '%b%'::text) OR ((firstname)::text ~~ '%a%'::text))
  • Rows Removed by Filter: 219007
  • Buffers: shared hit=34 read=16726
13. 0.411 0.779 ↑ 1.0 1,083 1

Hash (cost=72.83..72.83 rows=1,083 width=8) (actual time=0.779..0.779 rows=1,083 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
  • Buffers: shared hit=62
14. 0.368 0.368 ↑ 1.0 1,083 1

Seq Scan on contest c (cost=0.00..72.83 rows=1,083 width=8) (actual time=0.007..0.368 rows=1,083 loops=1)

  • Buffers: shared hit=62