explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AZ6E

Settings
# exclusive inclusive rows x rows loops node
1. 1.092 1,352.661 ↑ 1.0 1 1

Aggregate (cost=75.74..75.75 rows=1 width=8) (actual time=1,352.660..1,352.661 rows=1 loops=1)

  • Buffers: shared hit=12596 read=2843
2. 6.365 1,351.569 ↓ 303.5 1,821 1

Nested Loop (cost=1.01..75.72 rows=6 width=8) (actual time=1.795..1,351.569 rows=1,821 loops=1)

  • Buffers: shared hit=12596 read=2843
3. 1,329.689 1,329.689 ↓ 517.2 3,103 1

Index Scan using message_conversation_id_app_id_created_idx on message m (cost=0.57..24.92 rows=6 width=16) (actual time=1.762..1,329.689 rows=3,103 loops=1)

  • Index Cond: ((conversation_id = '234085846685034'::bigint) AND (app_id = '16413863317506'::bigint))
  • Filter: (read_by_user = 1)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=195 read=2832
4. 15.515 15.515 ↑ 1.0 1 3,103

Index Scan using user_pkey on konotor_user ku (cost=0.44..8.46 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=3,103)

  • Index Cond: (user_id = m.message_user_id)
  • Filter: (user_type = 0)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=12401 read=11
Planning time : 1.982 ms
Execution time : 1,352.735 ms