explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9LnDY : co

Settings
# exclusive inclusive rows x rows loops node
1. 0.041 43,205.174 ↑ 1.0 50 1

Limit (cost=1,092,008.02..1,092,008.14 rows=50 width=177) (actual time=43,205.123..43,205.174 rows=50 loops=1)

2. 2,829.341 43,205.133 ↑ 79,806.5 50 1

Sort (cost=1,092,008.02..1,101,983.83 rows=3,990,327 width=177) (actual time=43,205.122..43,205.133 rows=50 loops=1)

  • Sort Key: ((oext.gener)::timestamp(0) with time zone), o.id
  • Sort Method: top-N heapsort Memory: 32kB
3. 5,028.849 40,375.792 ↓ 1.0 4,005,303 1

Hash Left Join (cost=306,599.49..959,452.22 rows=3,990,327 width=177) (actual time=7,411.682..40,375.792 rows=4,005,303 loops=1)

  • Hash Cond: (o.size = slot_inf.id)
4. 5,183.567 35,346.932 ↓ 1.0 4,005,303 1

Hash Left Join (cost=306,598.38..855,735.15 rows=3,990,327 width=177) (actual time=7,411.638..35,346.932 rows=4,005,303 loops=1)

  • Hash Cond: (o.destin = uu.id)
5. 3,803.161 29,907.960 ↓ 1.0 4,005,303 1

Hash Left Join (cost=297,687.07..762,044.42 rows=3,990,327 width=166) (actual time=7,156.101..29,907.960 rows=4,005,303 loops=1)

  • Hash Cond: (o.client_id = c.id)
6. 5,046.920 25,847.065 ↓ 1.0 4,005,303 1

Hash Left Join (cost=284,168.39..693,658.73 rows=3,990,327 width=154) (actual time=6,898.241..25,847.065 rows=4,005,303 loops=1)

  • Hash Cond: (o.user_id = u.id)
7. 10,890.563 19,705.022 ↓ 1.0 4,005,303 1

Hash Left Join (cost=255,975.69..603,325.69 rows=3,990,327 width=142) (actual time=5,802.976..19,705.022 rows=4,005,303 loops=1)

  • Hash Cond: (o.id = oext.order_id)
8. 3,013.502 3,013.502 ↓ 1.0 4,005,303 1

Seq Scan on orders o (cost=0.00..125,474.27 rows=3,990,327 width=82) (actual time=0.007..3,013.502 rows=4,005,303 loops=1)

9. 2,776.629 5,800.957 ↓ 1.0 4,016,851 1

Hash (cost=163,084.53..163,084.53 rows=3,996,653 width=64) (actual time=5,800.957..5,800.957 rows=4,016,851 loops=1)

  • Buckets: 524288 Batches: 2 Memory Usage: 152531kB
10. 3,024.328 3,024.328 ↓ 1.0 4,016,851 1

Seq Scan on orders_ext oext (cost=0.00..163,084.53 rows=3,996,653 width=64) (actual time=0.020..3,024.328 rows=4,016,851 loops=1)

11. 150.679 1,095.123 ↓ 1.0 242,793 1

Hash (cost=25,158.64..25,158.64 rows=242,725 width=20) (actual time=1,095.123..1,095.123 rows=242,793 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 12488kB
12. 533.488 944.444 ↓ 1.0 242,793 1

Hash Left Join (cost=13,518.68..25,158.64 rows=242,725 width=20) (actual time=300.283..944.444 rows=242,793 loops=1)

  • Hash Cond: (u.client_id = cc.id)
13. 110.806 110.806 ↓ 1.0 242,793 1

Seq Scan on users u (cost=0.00..5,877.25 rows=242,725 width=8) (actual time=0.005..110.806 rows=242,793 loops=1)

14. 135.819 300.150 ↑ 1.3 233,634 1

Hash (cost=9,832.19..9,832.19 rows=294,919 width=20) (actual time=300.150..300.150 rows=233,634 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 12337kB
15. 164.331 164.331 ↑ 1.3 233,634 1

Seq Scan on clients cc (cost=0.00..9,832.19 rows=294,919 width=20) (actual time=0.019..164.331 rows=233,634 loops=1)

16. 130.607 257.734 ↑ 1.3 233,634 1

Hash (cost=9,832.19..9,832.19 rows=294,919 width=20) (actual time=257.734..257.734 rows=233,634 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 12337kB
17. 127.127 127.127 ↑ 1.3 233,634 1

Seq Scan on clients c (cost=0.00..9,832.19 rows=294,919 width=20) (actual time=0.007..127.127 rows=233,634 loops=1)

18. 134.820 255.405 ↓ 1.0 242,793 1

Hash (cost=5,877.25..5,877.25 rows=242,725 width=19) (actual time=255.405..255.405 rows=242,793 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 12606kB
19. 120.585 120.585 ↓ 1.0 242,793 1

Seq Scan on users uu (cost=0.00..5,877.25 rows=242,725 width=19) (actual time=0.004..120.585 rows=242,793 loops=1)

20. 0.004 0.011 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=4) (actual time=0.011..0.011 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
21. 0.007 0.007 ↑ 1.0 5 1

Seq Scan on slot_inf (cost=0.00..1.05 rows=5 width=4) (actual time=0.003..0.007 rows=5 loops=1)