explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bqX5 : newb

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.058 ↓ 0.0 0 1

Limit (cost=27.57..27.58 rows=1 width=1,918) (actual time=0.058..0.058 rows=0 loops=1)

  • Buffers: shared hit=10
2. 0.020 0.058 ↓ 0.0 0 1

Sort (cost=27.57..27.58 rows=1 width=1,918) (actual time=0.058..0.058 rows=0 loops=1)

  • Sort Key: ma.created DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=10
3. 0.001 0.038 ↓ 0.0 0 1

Nested Loop (cost=1.43..27.56 rows=1 width=1,918) (actual time=0.038..0.038 rows=0 loops=1)

  • Buffers: shared hit=7
4. 0.000 0.037 ↓ 0.0 0 1

Nested Loop (cost=1..22.04 rows=1 width=790) (actual time=0.037..0.037 rows=0 loops=1)

  • Buffers: shared hit=7
5. 0.003 0.037 ↓ 0.0 0 1

Nested Loop (cost=0.85..21.85 rows=1 width=425) (actual time=0.037..0.037 rows=0 loops=1)

  • Buffers: shared hit=7
6. 0.020 0.020 ↑ 1.0 1 1

Index Scan using conversation_pkey on conversation c (cost=0.43..8.45 rows=1 width=417) (actual time=0.02..0.02 rows=1 loops=1)

  • Index Cond: (c.conversation_id = '137134998004934'::bigint)
  • Buffers: shared hit=4
7. 0.014 0.014 ↓ 0.0 0 1

Index Scan using marketing_user_user_id_idx on marketing_user mu (cost=0.42..13.37 rows=3 width=16) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (mu.user_id = c.user_id)
  • Buffers: shared hit=3
8. 0.000 0.000 ↓ 0.0 0 0

Index Scan using marketing_pkey on marketing ma (cost=0.14..0.17 rows=1 width=389) (never executed)

  • Index Cond: (ma.marketing_id = mu.marketing_id)
  • Filter: ((ma.created > '1969-12-31 23:59:59.999'::timestamp without time zone) AND (ma.created < '2019-09-06 08:03:39.71'::timestamp without time zone))
9. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using user_pkey on konotor_user ku (cost=0.43..5.52 rows=1 width=8) (never executed)

  • Index Cond: (ku.user_id = ma.started_by_user_id)