explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eFv1

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.033 ↑ 1.0 1 1

Limit (cost=1.01..75.74 rows=1 width=8) (actual time=0.033..0.033 rows=1 loops=1)

  • Buffers: shared hit=11
2. 0.001 0.032 ↑ 1.0 1 1

Nested Loop (cost=1.01..75.74 rows=1 width=8) (actual time=0.032..0.032 rows=1 loops=1)

  • Buffers: shared hit=11
3. 0.023 0.023 ↑ 6.0 1 1

Index Scan Backward using message_conversation_id_app_id_created_idx on message m (cost=0.57..24.92 rows=6 width=24) (actual time=0.023..0.023 rows=1 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=7
4. 0.008 0.008 ↑ 1.0 1 1

Index Scan using user_pkey on konotor_user ku (cost=0.44..8.46 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (user_id = m.message_user_id)
  • Filter: ((app_id = '16413863317506'::bigint) AND (user_type = 0))
  • Buffers: shared hit=4
Planning time : 0.391 ms
Execution time : 0.073 ms