explain.depesz.com

PostgreSQL's explain analyze made readable

Result: difu : test2

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.053 ↓ 0.0 0 1

Limit (cost=37,832.21..37,832.24 rows=14 width=830) (actual time=0.053..0.053 rows=0 loops=1)

  • Buffers: shared hit=9
2. 0.021 0.051 ↓ 0.0 0 1

Sort (cost=37,832.21..37,832.24 rows=14 width=830) (actual time=0.051..0.051 rows=0 loops=1)

  • Sort Key: wow.m_created DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=9
3. 0.001 0.030 ↓ 0.0 0 1

Subquery Scan on wow (cost=37,831.02..37,831.94 rows=14 width=830) (actual time=0.03..0.03 rows=0 loops=1)

  • Filter: (wow.m_created < '2019-08-04 17:51:54.892'::timestamp without time zone)
  • Buffers: shared hit=6
4. 0.001 0.029 ↓ 0.0 0 1

Aggregate (cost=37,831.02..37,831.43 rows=41 width=830) (actual time=0.029..0.029 rows=0 loops=1)

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

Append (cost=37,796.07..37,824.15 rows=41 width=830) (actual time=0.028..0.028 rows=0 loops=1)

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

Limit (cost=37,796.07..37,796.17 rows=40 width=2,380) (actual time=0.019..0.019 rows=0 loops=1)

  • Buffers: shared hit=3
7. 0.004 0.019 ↓ 0.0 0 1

Sort (cost=37,796.07..37,801.38 rows=2,124 width=2,380) (actual time=0.019..0.019 rows=0 loops=1)

  • Sort Key: c.created DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
8. 0.001 0.015 ↓ 0.0 0 1

Hash Join (cost=11.19..37,728.93 rows=2,124 width=2,380) (actual time=0.015..0.015 rows=0 loops=1)

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

Nested Loop (cost=2.3..37,690.84 rows=2,124 width=2,338) (actual time=0.014..0.014 rows=0 loops=1)

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

Nested Loop (cost=1.87..20,463.11 rows=2,124 width=2,297) (actual time=0.013..0.013 rows=0 loops=1)

  • Buffers: shared hit=3
11. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=1.44..2,816.76 rows=2,124 width=1,007) (actual time=0.013..0.013 rows=0 loops=1)

  • Buffers: shared hit=3
12. 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
13. 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)
  • Filter: (c.created < '2019-08-04 17:51:54.892'::timestamp without time zone)
  • Buffers: shared hit=3
14. 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)
15. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

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

19. 0.000 0.000 ↓ 0.0 0 0

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

20. 0.001 0.008 ↓ 0.0 0 1

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

  • Buffers: shared hit=3
21. 0.003 0.007 ↓ 0.0 0 1

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

  • Sort Key: ma.created DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
22. 0.002 0.004 ↓ 0.0 0 1

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

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

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

  • Buffers: shared hit=3
24. 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
25. 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
26. 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)
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-08-04 17:51:54.892'::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.51 rows=1 width=8) (never executed)

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