explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ClZd

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 34,177.206 ↑ 1.0 10 1

Limit (cost=533,413.09..533,414.26 rows=10 width=239) (actual time=34,166.274..34,177.206 rows=10 loops=1)

2. 17.352 34,177.195 ↑ 4,079.2 10 1

Gather Merge (cost=533,413.09..538,172.49 rows=40,792 width=239) (actual time=34,166.272..34,177.195 rows=10 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 54.496 34,159.843 ↑ 167.2 122 3 / 3

Sort (cost=532,413.07..532,464.06 rows=20,396 width=239) (actual time=34,159.822..34,159.843 rows=122 loops=3)

  • Sort Key: feedback.updated_at DESC
  • Sort Method: external merge Disk: 4824kB
4. 56.538 34,105.347 ↓ 1.0 20,781 3 / 3

Nested Loop (cost=112,967.09..528,650.12 rows=20,396 width=239) (actual time=3,684.449..34,105.347 rows=20,781 loops=3)

5. 14.111 33,363.025 ↓ 1.0 20,781 3 / 3

Hash Join (cost=112,966.53..438,712.39 rows=20,396 width=207) (actual time=3,682.687..33,363.025 rows=20,781 loops=3)

  • Hash Cond: (crypto_trades_completed.payment_method_id = payment_methods.id)
6. 25.704 33,346.629 ↓ 1.0 20,781 3 / 3

Hash Join (cost=112,704.65..438,396.90 rows=20,396 width=172) (actual time=3,680.306..33,346.629 rows=20,781 loops=3)

  • Hash Cond: (crypto_trades_completed.offer_id = offers.id)
7. 20.885 29,673.198 ↓ 1.0 20,781 3 / 3

Hash Join (cost=927.85..321,042.56 rows=20,396 width=159) (actual time=31.881..29,673.198 rows=20,781 loops=3)

  • Hash Cond: (crypto_trades_completed.fiat_currency_id = fiat_currencies.id)
8. 47.037 29,652.219 ↓ 1.0 20,781 3 / 3

Nested Loop (cost=920.55..320,980.53 rows=20,396 width=157) (actual time=31.756..29,652.219 rows=20,781 loops=3)

9. 6,655.540 6,662.590 ↓ 1.0 20,781 3 / 3

Parallel Bitmap Heap Scan on feedback (cost=919.98..149,210.83 rows=20,396 width=102) (actual time=30.259..6,662.590 rows=20,781 loops=3)

  • Recheck Cond: (feedback_receiver_id = '282186'::bigint)
  • Filter: (deleted_at IS NULL)
  • Heap Blocks: exact=18197
10. 7.050 7.050 ↓ 1.3 62,344 1 / 3

Bitmap Index Scan on feedback_feedback_receiver_id_index (cost=0.00..907.74 rows=48,957 width=0) (actual time=21.151..21.151 rows=62,344 loops=1)

  • Index Cond: (feedback_receiver_id = '282186'::bigint)
11. 22,942.592 22,942.592 ↑ 1.0 1 62,344 / 3

Index Scan using crypto_trades_completed_pkey on crypto_trades_completed (cost=0.57..8.42 rows=1 width=71) (actual time=1.104..1.104 rows=1 loops=62,344)

  • Index Cond: (id = feedback.trade_id)
12. 0.042 0.094 ↑ 1.0 191 3 / 3

Hash (cost=4.91..4.91 rows=191 width=10) (actual time=0.094..0.094 rows=191 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
13. 0.052 0.052 ↑ 1.0 191 3 / 3

Seq Scan on fiat_currencies (cost=0.00..4.91 rows=191 width=10) (actual time=0.016..0.052 rows=191 loops=3)

14. 226.769 3,647.727 ↑ 1.0 673,769 3 / 3

Hash (cost=98,748.69..98,748.69 rows=673,769 width=29) (actual time=3,647.727..3,647.727 rows=673,769 loops=3)

  • Buckets: 65536 Batches: 16 Memory Usage: 2914kB
15. 3,420.958 3,420.958 ↑ 1.0 673,769 3 / 3

Seq Scan on offers (cost=0.00..98,748.69 rows=673,769 width=29) (actual time=0.136..3,420.958 rows=673,769 loops=3)

16. 1.002 2.285 ↑ 1.0 3,506 3 / 3

Hash (cost=218.06..218.06 rows=3,506 width=47) (actual time=2.285..2.285 rows=3,506 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 316kB
17. 1.283 1.283 ↑ 1.0 3,506 3 / 3

Seq Scan on payment_methods (cost=0.00..218.06 rows=3,506 width=47) (actual time=0.016..1.283 rows=3,506 loops=3)

18. 685.784 685.784 ↑ 1.0 1 62,344 / 3

Index Only Scan using user_accounts_id_username_avatarurl_idx on user_accounts (cost=0.56..4.40 rows=1 width=58) (actual time=0.033..0.033 rows=1 loops=62,344)

  • Index Cond: (id = feedback.feedback_leaver_id)
  • Heap Fetches: 9
Planning time : 65.091 ms
Execution time : 34,178.461 ms