explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IHO6 : new2c

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

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

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

Sort (cost=594,384.31..594,500.63 rows=46,528 width=2,404) (actual time=2,741.586..2,741.603 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. 29.713 2,700.509 ↑ 1.1 41,514 1

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

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

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

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

Nested Loop (cost=120,947.38..218,417.73 rows=46,528 width=1,048) (actual time=2,158.15..2,530.002 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.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.021..0.023 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.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.018..0.02 rows=1 loops=1)

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

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

  • Buffers: shared hit=66179, temp read=19937 written=19840
10. 64.288 64.288 ↑ 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.022..64.288 rows=41,514 loops=1)

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

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

  • Buffers: shared hit=30565, temp written=19587
12. 1,007.342 1,007.342 ↓ 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,007.342 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.083 0.159 ↓ 1.0 227 1

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

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

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

  • Buffers: shared hit=4