explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CIB4

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.837 ↑ 1.1 21 1

Limit (cost=82.14..82.20 rows=24 width=2,100) (actual time=0.832..0.837 rows=21 loops=1)

2. 0.124 0.831 ↑ 1.1 21 1

Sort (cost=82.14..82.20 rows=24 width=2,100) (actual time=0.828..0.831 rows=21 loops=1)

  • Sort Method: quicksort Memory: 83kB
  • Sort Key: "order".last_update DESC
3. 0.047 0.707 ↑ 1.1 21 1

Hash Right Join (cost=54.77..81.59 rows=24 width=2,100) (actual time=0.672..0.707 rows=21 loops=1)

  • Hash Cond: (order_type_1.id = "order".order_type_id)
4. 0.009 0.009 ↑ 44.3 23 1

Seq Scan on order_type order_type_1 (cost=0.00..20.20 rows=1,020 width=52) (actual time=0.006..0.009 rows=23 loops=1)

5. 0.058 0.651 ↑ 1.1 21 1

Hash (cost=54.47..54.47 rows=24 width=2,040) (actual time=0.651..0.651 rows=21 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
6. 0.046 0.593 ↑ 1.1 21 1

Hash Right Join (cost=37.08..54.47 rows=24 width=2,040) (actual time=0.556..0.593 rows=21 loops=1)

  • Hash Cond: (sales_rep_1.id = "order".sales_rep_id)
7. 0.013 0.013 ↑ 13.0 40 1

Seq Scan on sales_rep sales_rep_1 (cost=0.00..15.20 rows=520 width=128) (actual time=0.009..0.013 rows=40 loops=1)

8. 0.055 0.534 ↑ 1.1 21 1

Hash (cost=36.78..36.78 rows=24 width=1,912) (actual time=0.534..0.534 rows=21 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 48kB
9. 0.052 0.479 ↑ 1.1 21 1

Hash Right Join (cost=22.49..36.78 rows=24 width=1,912) (actual time=0.437..0.479 rows=21 loops=1)

  • Hash Cond: (company_1.id = "order".company_id)
10. 0.010 0.010 ↑ 18.0 15 1

Seq Scan on company company_1 (cost=0.00..12.70 rows=270 width=272) (actual time=0.008..0.010 rows=15 loops=1)

11. 0.039 0.417 ↑ 1.1 21 1

Hash (cost=22.19..22.19 rows=24 width=1,640) (actual time=0.417..0.417 rows=21 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
12. 0.053 0.378 ↑ 1.1 21 1

Hash Join (cost=14.96..22.19 rows=24 width=1,640) (actual time=0.295..0.378 rows=21 loops=1)

  • Hash Cond: (order_stage.id = "order".order_stage_id)
13. 0.060 0.060 ↑ 1.0 195 1

Seq Scan on order_stage (cost=0.00..6.01 rows=195 width=63) (actual time=0.016..0.060 rows=195 loops=1)

14. 0.064 0.265 ↑ 1.0 30 1

Hash (cost=14.59..14.59 rows=30 width=1,577) (actual time=0.265..0.265 rows=30 loops=1)

  • Rows Removed by Filter: 46
  • Filter: (status = 'open'::orderstatus)
  • Buckets: 1024 Batches: 1 Memory Usage: 56kB
15. 0.077 0.201 ↑ 1.0 30 1

Hash Right Join (cost=7.67..14.59 rows=30 width=1,577) (actual time=0.107..0.201 rows=30 loops=1)

  • Hash Cond: (order_stage_1.id = "order".order_stage_id)
16. 0.039 0.039 ↑ 1.0 241 1

Seq Scan on order_stage order_stage_1 (cost=0.00..5.41 rows=241 width=63) (actual time=0.005..0.039 rows=241 loops=1)

17. 0.045 0.085 ↑ 1.0 30 1

Hash (cost=7.30..7.30 rows=30 width=1,514) (actual time=0.085..0.085 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 54kB
18. 0.040 0.040 ↑ 1.0 30 1

Seq Scan on "order" (cost=0.00..7.30 rows=30 width=1,514) (actual time=0.006..0.040 rows=30 loops=1)

Execution time : 1.421 ms