explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cymt : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.039 ↓ 0.0 0 1

Limit (cost=33,695.77..33,695.87 rows=40 width=830) (actual time=0.039..0.039 rows=0 loops=1)

  • Buffers: shared hit=9
2. 0.016 0.038 ↓ 0.0 0 1

Sort (cost=33,695.77..33,700.39 rows=1,848 width=830) (actual time=0.038..0.038 rows=0 loops=1)

  • Sort Key: m.created DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=9
3. 0.003 0.022 ↓ 0.0 0 1

Aggregate (cost=33,600.4..33,618.88 rows=1,848 width=830) (actual time=0.022..0.022 rows=0 loops=1)

  • Buffers: shared hit=6
4. 0.001 0.019 ↓ 0.0 0 1

Append (cost=11.19..33,290.86 rows=1,848 width=830) (actual time=0.019..0.019 rows=0 loops=1)

  • Buffers: shared hit=6
5. 0.001 0.015 ↓ 0.0 0 1

Hash Join (cost=11.19..33,244.82 rows=1,847 width=2,380) (actual time=0.015..0.015 rows=0 loops=1)

  • Buffers: shared hit=3
6. 0.000 0.014 ↓ 0.0 0 1

Nested Loop (cost=2.3..33,210.54 rows=1,847 width=2,338) (actual time=0.014..0.014 rows=0 loops=1)

  • Buffers: shared hit=3
7. 0.000 0.014 ↓ 0.0 0 1

Nested Loop (cost=1.87..18,193.54 rows=1,847 width=2,297) (actual time=0.014..0.014 rows=0 loops=1)

  • Buffers: shared hit=3
8. 0.001 0.014 ↓ 0.0 0 1

Nested Loop (cost=1.44..2,819.3 rows=1,847 width=1,007) (actual time=0.014..0.014 rows=0 loops=1)

  • Buffers: shared hit=3
9. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.86..16.91 rows=1 width=435) (actual time=0.013..0.013 rows=0 loops=1)

  • Buffers: shared hit=3
10. 0.012 0.012 ↓ 0.0 0 1

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

  • Index Cond: (c.conversation_id = '253832102452462'::bigint)
  • Buffers: shared hit=3
11. 0.000 0.000 ↓ 0.0 0 0

Index Scan using conversation_participant_conversation_id_idx on conversation_participant cp (cost=0.43..8.45 rows=1 width=8) (never executed)

  • Index Cond: (cp.conversation_id = '253832102452462'::bigint)
12. 0.000 0.000 ↓ 0.0 0 0

Index Scan using message_conversation_id_idx on message m (cost=0.57..2,783.92 rows=1,847 width=572) (never executed)

  • Index Cond: (m.conversation_id = '253832102452462'::bigint)
  • Filter: (m.created < '2019-08-04 17:51:54.892'::timestamp without time zone)
13. 0.000 0.000 ↓ 0.0 0 0

Index Scan using user_pkey on konotor_user ku (cost=0.43..8.31 rows=1 width=1,298) (never executed)

  • Index Cond: (ku.user_id = m.message_user_id)
14. 0.000 0.000 ↓ 0.0 0 0

Index Scan using csat_response_pkey on csat_response cr (cost=0.43..8.12 rows=1 width=57) (never executed)

  • Index Cond: (cr.csat_response_id = m.csat_response_id)
15. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=6.17..6.17 rows=217 width=42) (never executed)

16. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on csat cs (cost=0..6.17 rows=217 width=42) (never executed)

17. 0.000 0.003 ↓ 0.0 0 1

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

  • Buffers: shared hit=3
18. 0.001 0.003 ↓ 0.0 0 1

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

  • Buffers: shared hit=3
19. 0.000 0.002 ↓ 0.0 0 1

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

  • Buffers: shared hit=3
20. 0.002 0.002 ↓ 0.0 0 1

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

  • Index Cond: (c_1.conversation_id = '253832102452462'::bigint)
  • Buffers: shared hit=3
21. 0.000 0.000 ↓ 0.0 0 0

Index Scan using marketing_user_user_id_idx on marketing_user mu (cost=0.42..13.37 rows=3 width=16) (never executed)

  • Index Cond: (mu.user_id = c_1.user_id)
22. 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-08-04 17:51:54.892'::timestamp without time zone))
23. 0.000 0.000 ↓ 0.0 0 0

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

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