explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4e6e

Settings
# exclusive inclusive rows x rows loops node
1. 5,649.234 24,040.667 ↓ 201.5 4,533,025 1

Sort (cost=337,505.94..337,562.19 rows=22,500 width=4,290) (actual time=22,990.239..24,040.667 rows=4,533,025 loops=1)

  • Sort Key: program_guest_info.updated_at
  • Sort Method: external sort Disk: 1161632kB
  • Buffers: shared hit=18060331 read=75508, temp read=145204 written=145204
2. 3,571.728 18,391.433 ↓ 201.5 4,533,025 1

Nested Loop (cost=0.43..294,348.46 rows=22,500 width=4,290) (actual time=0.022..18,391.433 rows=4,533,025 loops=1)

  • Buffers: shared hit=18060328 read=75508
3. 1,319.627 1,319.627 ↓ 200.0 4,500,026 1

Seq Scan on program_guest_info (cost=0.00..147,790.46 rows=22,500 width=314) (actual time=0.008..1,319.627 rows=4,500,026 loops=1)

  • Filter: ((updated_at > '2018-11-04 16:27:38.56632+00'::timestamp with time zone) AND (updated_at < now()))
  • Buffers: shared hit=5 read=69035
4. 13,500.078 13,500.078 ↑ 1.0 1 4,500,026

Index Scan using idx_users_user_uuid on users (cost=0.43..6.50 rows=1 width=3,968) (actual time=0.003..0.003 rows=1 loops=4,500,026)

  • Index Cond: (user_uuid = program_guest_info.user_uuid)
  • Buffers: shared hit=18060323 read=6473
Planning time : 35.018 ms
Execution time : 24,414.037 ms