explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 34Mf : new

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 5.783 ↓ 2.9 40 1

Limit (cost=909.86..909.9 rows=14 width=830) (actual time=5.73..5.783 rows=40 loops=1)

  • Buffers: shared hit=222
2. 0.109 5.744 ↓ 2.9 40 1

Sort (cost=909.86..909.9 rows=14 width=830) (actual time=5.728..5.744 rows=40 loops=1)

  • Sort Key: wow.m_created DESC
  • Sort Method: quicksort Memory: 76kB
  • Buffers: shared hit=222
3. 0.024 5.635 ↓ 2.9 40 1

Subquery Scan on wow (cost=908.67..909.6 rows=14 width=830) (actual time=5.586..5.635 rows=40 loops=1)

  • Filter: (wow.m_created < '2019-09-06 08:03:39.71'::timestamp without time zone)
  • Buffers: shared hit=219
4. 0.255 5.611 ↑ 1.0 40 1

Aggregate (cost=908.67..909.08 rows=41 width=830) (actual time=5.58..5.611 rows=40 loops=1)

  • Buffers: shared hit=219
5. 0.022 5.356 ↑ 1.0 40 1

Append (cost=2.3..901.81 rows=41 width=830) (actual time=0.58..5.356 rows=40 loops=1)

  • Buffers: shared hit=219
6. 0.016 5.304 ↑ 1.0 40 1

Limit (cost=2.3..873.82 rows=40 width=2,380) (actual time=0.579..5.304 rows=40 loops=1)

  • Buffers: shared hit=212
7. 2.391 5.288 ↑ 1,163.1 40 1

Nested Loop (cost=2.3..1,013,638.24 rows=46,523 width=2,380) (actual time=0.579..5.288 rows=40 loops=1)

  • Buffers: shared hit=212
8. 0.059 0.617 ↑ 1,163.1 40 1

Nested Loop (cost=2.3..862,199.16 rows=46,523 width=2,338) (actual time=0.136..0.617 rows=40 loops=1)

  • Buffers: shared hit=208
9. 0.083 0.558 ↑ 1,163.1 40 1

Nested Loop (cost=1.87..491,126.89 rows=46,523 width=2,297) (actual time=0.133..0.558 rows=40 loops=1)

  • Buffers: shared hit=208
10. 0.073 0.315 ↑ 1,163.1 40 1

Nested Loop (cost=1.44..117,318 rows=46,523 width=1,007) (actual time=0.111..0.315 rows=40 loops=1)

  • Buffers: shared hit=48
11. 0.162 0.162 ↑ 1,163.1 40 1

Index Scan using message_conversation_id_created_idx on message m (cost=0.57..116,719.55 rows=46,523 width=572) (actual time=0.051..0.162 rows=40 loops=1)

  • Index Cond: ((m.conversation_id = '137134998004934'::bigint) AND (m.created < '2019-09-06 08:03:39.71'::timestamp without time zone))
  • Buffers: shared hit=40
12. 0.028 0.080 ↑ 1.0 1 40

Materialize (cost=0.86..16.92 rows=1 width=435) (actual time=0.002..0.002 rows=1 loops=40)

  • Buffers: shared hit=8
13. 0.009 0.052 ↑ 1.0 1 1

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

  • Buffers: shared hit=8
14. 0.023 0.023 ↑ 1.0 1 1

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

  • Index Cond: (c.conversation_id = '137134998004934'::bigint)
  • Buffers: shared hit=4
15. 0.020 0.020 ↑ 1.0 1 1

Index Scan using conversation_participant_conversation_id_idx on conversation_participant cp (cost=0.43..8.45 rows=1 width=8) (actual time=0.019..0.02 rows=1 loops=1)

  • Index Cond: (cp.conversation_id = '137134998004934'::bigint)
  • Buffers: shared hit=4
16. 0.160 0.160 ↑ 1.0 1 40

Index Scan using user_pkey on konotor_user ku (cost=0.43..8.02 rows=1 width=1,298) (actual time=0.004..0.004 rows=1 loops=40)

  • Index Cond: (ku.user_id = m.message_user_id)
  • Buffers: shared hit=160
17. 0.000 0.000 ↓ 0.0 0 40

Index Scan using csat_response_pkey on csat_response cr (cost=0.43..7.97 rows=1 width=57) (actual time=0..0 rows=0 loops=40)

  • Index Cond: (cr.csat_response_id = m.csat_response_id)
18. 2.129 2.280 ↓ 1.0 227 40

Materialize (cost=0..7.25 rows=217 width=42) (actual time=0.001..0.057 rows=227 loops=40)

  • Buffers: shared hit=4
19. 0.151 0.151 ↓ 1.0 227 1

Seq Scan on csat cs (cost=0..6.17 rows=217 width=42) (actual time=0.01..0.151 rows=227 loops=1)

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

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

  • Buffers: shared hit=7
21. 0.013 0.028 ↓ 0.0 0 1

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

  • Sort Key: ma.created DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
22. 0.001 0.015 ↓ 0.0 0 1

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

  • Buffers: shared hit=7
23. 0.001 0.014 ↓ 0.0 0 1

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

  • Buffers: shared hit=7
24. 0.000 0.013 ↓ 0.0 0 1

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

  • Buffers: shared hit=7
25. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (c_1.conversation_id = '137134998004934'::bigint)
  • Buffers: shared hit=4
26. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (mu.user_id = c_1.user_id)
  • Buffers: shared hit=3
27. 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))
28. 0.000 0.000 ↓ 0.0 0 0

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

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