explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jnyh : newa

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 2,715.296 ↑ 1.0 40 1

Limit (cost=594,384.31..594,384.41 rows=40 width=2,404) (actual time=2,715.262..2,715.296 rows=40 loops=1)

  • Buffers: shared hit=233096, temp read=19937 written=19840
2. 40.014 2,715.277 ↑ 1,163.2 40 1

Sort (cost=594,384.31..594,500.63 rows=46,528 width=2,404) (actual time=2,715.26..2,715.277 rows=40 loops=1)

  • Sort Key: c.created DESC
  • Sort Method: top-N heapsort Memory: 76kB
  • Buffers: shared hit=233096, temp read=19937 written=19840
3. 28.240 2,675.263 ↑ 1.1 41,514 1

Hash Join (cost=120,956.7..592,913.58 rows=46,528 width=2,404) (actual time=2,139.855..2,675.263 rows=41,514 loops=1)

  • Buffers: shared hit=233093, temp read=19937 written=19840
4. 53.530 2,646.856 ↑ 1.1 41,514 1

Nested Loop (cost=120,947.82..592,264.93 rows=46,528 width=2,338) (actual time=2,139.668..2,646.856 rows=41,514 loops=1)

  • Buffers: shared hit=233089, temp read=19937 written=19840
5. 23.018 2,510.298 ↑ 1.1 41,514 1

Nested Loop (cost=120,947.38..218,417.73 rows=46,528 width=1,048) (actual time=2,139.647..2,510.298 rows=41,514 loops=1)

  • Buffers: shared hit=66187, temp read=19937 written=19840
6. 0.005 0.048 ↑ 1.0 1 1

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

  • Buffers: shared hit=8
7. 0.022 0.022 ↑ 1.0 1 1

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

  • Index Cond: (c.conversation_id = '137134998004934'::bigint)
  • Filter: (c.created < '2019-09-06 08:03:39.71'::timestamp without time zone)
  • Buffers: shared hit=4
8. 0.021 0.021 ↑ 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.021 rows=1 loops=1)

  • Index Cond: (cp.conversation_id = '137134998004934'::bigint)
  • Buffers: shared hit=4
9. 284.397 2,487.232 ↑ 1.1 41,514 1

Hash Join (cost=120,946.52..217,935.54 rows=46,528 width=613) (actual time=2,139.599..2,487.232 rows=41,514 loops=1)

  • Buffers: shared hit=66179, temp read=19937 written=19840
10. 63.503 63.503 ↑ 1.1 41,514 1

Index Scan using message_conversation_id_idx on message m (cost=0.57..60,672.16 rows=46,528 width=572) (actual time=0.023..63.503 rows=41,514 loops=1)

  • Index Cond: (m.conversation_id = '137134998004934'::bigint)
  • Buffers: shared hit=35611
11. 1,138.299 2,139.332 ↓ 1.1 2,898,301 1

Hash (cost=57,753.42..57,753.42 rows=2,718,842 width=57) (actual time=2,139.332..2,139.332 rows=2,898,301 loops=1)

  • Buffers: shared hit=30565, temp written=19587
12. 1,001.033 1,001.033 ↓ 1.1 2,898,301 1

Seq Scan on csat_response cr (cost=0..57,753.42 rows=2,718,842 width=57) (actual time=0.003..1,001.033 rows=2,898,301 loops=1)

  • Buffers: shared hit=30565
13. 83.028 83.028 ↑ 1.0 1 41,514

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

  • Index Cond: (ku.user_id = m.message_user_id)
  • Buffers: shared hit=166902
14. 0.094 0.167 ↓ 1.0 227 1

Hash (cost=6.17..6.17 rows=217 width=42) (actual time=0.167..0.167 rows=227 loops=1)

  • Buffers: shared hit=4
15. 0.073 0.073 ↓ 1.0 227 1

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

  • Buffers: shared hit=4