explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wpRz

Settings
# exclusive inclusive rows x rows loops node
1. 97,593.472 175,534.400 ↑ 1.4 5,269,502 1

Merge Join (cost=2,667,287.04..3,047,403.30 rows=7,152,620 width=81) (actual time=11,133.413..175,534.400 rows=5,269,502 loops=1)

  • Merge Cond: (hr.ip = hr_1.ip)
  • Join Filter: (hr.gamer_id < hr_1.gamer_id)
  • Rows Removed by Join Filter: 454830190
  • Buffers: shared hit=302936 read=580747 written=3785, temp read=2577485 written=21844
2. 1,995.947 9,663.576 ↓ 1.3 1,198,076 1

Sort (cost=2,059,983.49..2,062,285.35 rows=920,744 width=65) (actual time=9,337.937..9,663.576 rows=1,198,076 loops=1)

  • Sort Key: hr.ip
  • Sort Method: external merge Disk: 87960kB
  • Buffers: shared hit=2026 read=580718 written=3785, temp read=10995 written=10998
3. 7,308.820 7,667.629 ↓ 1.3 1,198,076 1

Bitmap Heap Scan on ip_history_record hr (cost=26,732.82..1,931,007.56 rows=920,744 width=65) (actual time=585.879..7,667.629 rows=1,198,076 loops=1)

  • Recheck Cond: (gamer_id = ANY ('{00000000-0000-0369-0000-000000f9e387,00000000-0000-01b9-0000-000000bf7f91,00000000-0000-008f-0000-000002c75dae,00000000-0000-0885-0000-000000a6accf,00000000-0000-0060-0000-000003b93455,00000000-0000-0885-0000-000019148d3}'::uuid[]))
  • Heap Blocks: exact=573548
  • Buffers: shared hit=2021 read=580718 written=3785
4. 358.809 358.809 ↓ 1.3 1,198,076 1

Bitmap Index Scan on ip_history_record_gamer_ip_idx (cost=0.00..26,502.63 rows=920,744 width=0) (actual time=354.423..358.809 rows=1,198,076 loops=1)

  • Index Cond: (gamer_id = ANY ('{00000000-0000-0369-0000-000000f9e387,00000000-0000-01b9-0000-000000bf7f91,00000000-0000-008f-0000-000002c75dae,00000000-0000-0885-0000-000000a6accf,00000000-0000-0060-0000-000003b93455,00000000-0000-0885-0000-0000191}'::uuid[]))
  • Buffers: shared hit=2021 read=7170
5. 67,755.511 68,277.352 ↓ 499.7 460,099,691 1

Sort (cost=607,303.56..609,605.42 rows=920,744 width=23) (actual time=1,705.980..68,277.352 rows=460,099,691 loops=1)

  • Sort Key: hr_1.ip
  • Sort Method: external sort Disk: 43384kB
  • Buffers: shared hit=300910 read=29, temp read=2092512 written=10846
6. 521.841 521.841 ↓ 1.3 1,198,076 1

Index Only Scan using ip_history_record_gamer_ip_idx on ip_history_record hr_1 (cost=0.56..516,092.63 rows=920,744 width=23) (actual time=0.366..521.841 rows=1,198,076 loops=1)

  • Index Cond: (gamer_id = ANY ('{00000000-0000-0369-0000-000000f9e387,00000000-0000-01b9-0000-000000bf7f91,00000000-0000-008f-0000-000002c75dae,00000000-0000-0885-0000-000000a6accf,00000000-0000-0060-0000-000003b93455,00000000-0000-0885-0000-000019148d3e}'::uuid[]))
  • Heap Fetches: 233002
  • Buffers: shared hit=300910 read=29