explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Je7l

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1,468.095 ↑ 1.0 8 1

Limit (cost=328,260.90..328,260.92 rows=8 width=1,708) (actual time=1,468.087..1,468.095 rows=8 loops=1)

2. 0.039 1,468.090 ↑ 1,028.8 8 1

Sort (cost=328,260.90..328,281.47 rows=8,230 width=1,708) (actual time=1,468.085..1,468.090 rows=8 loops=1)

  • Sort Key: t."timestamp" DESC
  • Sort Method: quicksort Memory: 39kB
3. 22.706 1,468.051 ↑ 914.4 9 1

Hash Left Join (cost=216,209.36..328,096.30 rows=8,230 width=1,708) (actual time=1,448.893..1,468.051 rows=9 loops=1)

  • Hash Cond: (t."blockId" = b.id)
4. 275.832 1,322.306 ↑ 914.4 9 1

Hash Right Join (cost=192,316.83..296,786.31 rows=8,230 width=1,771) (actual time=995.569..1,322.306 rows=9 loops=1)

  • Hash Cond: (v."transactionId" = t.id)
5. 112.402 112.402 ↑ 1.0 472,139 1

Seq Scan on votes v (cost=0.00..37,694.07 rows=472,207 width=524) (actual time=0.018..112.402 rows=472,139 loops=1)

6. 0.104 934.072 ↑ 914.4 9 1

Hash (cost=190,870.96..190,870.96 rows=8,230 width=1,312) (actual time=934.072..934.072 rows=9 loops=1)

  • Buckets: 4096 Batches: 4 Memory Usage: 34kB
7. 190.504 933.968 ↑ 914.4 9 1

Hash Right Join (cost=135,666.00..190,870.96 rows=8,230 width=1,312) (actual time=885.734..933.968 rows=9 loops=1)

  • Hash Cond: (so.id = t.id)
8. 95.015 95.015 ↑ 1.0 506,300 1

Seq Scan on stake_orders so (cost=0.00..19,537.00 rows=506,300 width=236) (actual time=0.013..95.015 rows=506,300 loops=1)

9. 0.081 648.449 ↑ 914.4 9 1

Hash (cost=134,453.13..134,453.13 rows=8,230 width=1,076) (actual time=648.449..648.449 rows=9 loops=1)

  • Buckets: 4096 Batches: 4 Memory Usage: 34kB
10. 23.104 648.368 ↑ 914.4 9 1

Merge Right Join (cost=113,510.71..134,453.13 rows=8,230 width=1,076) (actual time=634.765..648.368 rows=9 loops=1)

  • Merge Cond: ((ref.address)::text = (t."senderId")::text)
11. 67.261 67.261 ↑ 1.1 231,171 1

Index Scan using referals_pkey on referals ref (cost=0.42..20,183.97 rows=245,936 width=346) (actual time=0.013..67.261 rows=231,171 loops=1)

12. 0.006 558.003 ↑ 914.4 9 1

Materialize (cost=113,510.29..113,551.44 rows=8,230 width=753) (actual time=557.996..558.003 rows=9 loops=1)

13. 0.062 557.997 ↑ 914.4 9 1

Sort (cost=113,510.29..113,530.87 rows=8,230 width=753) (actual time=557.991..557.997 rows=9 loops=1)

  • Sort Key: t."senderId
  • Sort Method: quicksort Memory: 29kB
14. 557.935 557.935 ↑ 914.4 9 1

Seq Scan on trs t (cost=0.00..110,217.07 rows=8,230 width=753) (actual time=20.218..557.935 rows=9 loops=1)

  • Filter: ((("recipientId")::text = 'DDK6667006012675259983'::text) OR (encode("senderPublicKey", 'hex'::text) = '267781bbdd940395b93bf710d4cfa4505e31301c6bb97ac94dd5e9cc8da49981'::text))
  • Rows Removed by Filter: 1644917
15. 70.098 123.039 ↑ 1.0 307,490 1

Hash (cost=16,444.90..16,444.90 rows=307,490 width=69) (actual time=123.039..123.039 rows=307,490 loops=1)

  • Buckets: 65536 Batches: 16 Memory Usage: 2404kB
16. 52.941 52.941 ↑ 1.0 307,490 1

Seq Scan on blocks b (cost=0.00..16,444.90 rows=307,490 width=69) (actual time=0.009..52.941 rows=307,490 loops=1)