explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3QmU

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 18,733.604 ↓ 5.0 5 1

Limit (cost=1,096.33..1,096.34 rows=1 width=101) (actual time=18,733.597..18,733.604 rows=5 loops=1)

2. 11.571 18,733.597 ↓ 5.0 5 1

Sort (cost=1,096.33..1,096.34 rows=1 width=101) (actual time=18,733.595..18,733.597 rows=5 loops=1)

  • Sort Key: feedback.id DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 21.902 18,722.026 ↓ 4,924.0 4,924 1

Nested Loop (cost=1.56..1,096.32 rows=1 width=101) (actual time=6.267..18,722.026 rows=4,924 loops=1)

4. 29.206 18,650.884 ↓ 4,924.0 4,924 1

Nested Loop (cost=1.13..1,094.02 rows=1 width=101) (actual time=6.252..18,650.884 rows=4,924 loops=1)

5. 10,995.318 10,995.318 ↓ 29.3 5,880 1

Index Scan using feedback_feedback_receiver_id_index on feedback (cost=0.56..494.03 rows=201 width=101) (actual time=5.183..10,995.318 rows=5,880 loops=1)

  • Index Cond: (feedback_receiver_id = 865803)
  • Filter: ((comment IS NOT NULL) AND (deleted_at IS NULL) AND (comment <> ''::text))
  • Rows Removed by Filter: 7039
6. 7,626.360 7,626.360 ↑ 1.0 1 5,880

Index Scan using crypto_trades_completed_id_created_at_completed_at_idx on crypto_trades_completed ctc (cost=0.56..2.98 rows=1 width=8) (actual time=1.297..1.297 rows=1 loops=5,880)

  • Index Cond: (id = feedback.trade_id)
  • Filter: (offer_id = 360651)
  • Rows Removed by Filter: 0
7. 49.240 49.240 ↑ 1.0 1 4,924

Index Only Scan using user_accounts_pkey on user_accounts ua (cost=0.43..2.30 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=4,924)

  • Index Cond: (id = feedback.feedback_leaver_id)
  • Heap Fetches: 4392
Planning time : 0.710 ms
Execution time : 18,733.663 ms